Tax per Line, a Tax Summary per Rate & the Rounding Difference
This lesson is part of the course
In this lesson
You look up the tax rate for each line, calculate the tax per line, summarise net and tax per rate and see why the tax per line and the tax on the total can differ by a cent.
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