Tax per Line, a Tax Summary per Rate & the Rounding Difference
This lesson is part of the subscription
The first 2 lessons of this course are free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Line Items: Quantity × Price, Line Discounts & Net AmountsFree
- Product Lookup from a Price List: Descriptions, Bulk Prices & Unknown SKUsFree
- Tax per Line, a Tax Summary per Rate & the Rounding Difference Pro
- Invoice Numbering: Prefix + Year + Padded Counter with TEXT Pro
- Due Dates & Payment Terms: Net Days, WORKDAY and EDATE Pro
- From Quote to Invoice: Validity, Accepted Lines & the Deposit Invoice Pro
- Payment Log & Open Balance per Invoice with SUMIFS (and a Chart) Pro
- Customer Statement & Ageing Summary (with Overdue Highlighting) Pro