Invoice Numbering: Prefix + Year + Padded Counter with TEXT
This lesson is part of the course
In this lesson
You build invoice numbers like BW-2026-0148: a running counter, the prefix and year joined with &, the counter padded to four digits with TEXT, a counter that restarts every year and the next free number for a new invoice.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Line Items: Quantity × Price, Line Discounts & Net Amounts Locked
- Product Lookup from a Price List: Descriptions, Bulk Prices & Unknown SKUs Locked
- Tax per Line, a Tax Summary per Rate & the Rounding Difference Locked
- Invoice Numbering: Prefix + Year + Padded Counter with TEXT Locked
- Due Dates & Payment Terms: Net Days, WORKDAY and EDATE Locked
- From Quote to Invoice: Validity, Accepted Lines & the Deposit Invoice Locked
- Payment Log & Open Balance per Invoice with SUMIFS (and a Chart) Locked
- Customer Statement & Ageing Summary (with Overdue Highlighting) Locked