Tabellab

Customer Statement: Running Balance for October

Lesson 7 of 20 Lab 🔒 Locked

Lessons in this course

  1. Invoice Register: Due Dates, Days Overdue and StatusLabFree
  2. AR Aging Report: Buckets with IFS and Totals with SUMIFSLab Locked
  3. AP Payment Run: Selecting the Invoices Due This WeekLab Locked
  4. Early-Payment Discounts: Is 2/10 Net 30 Worth Taking?Lab Locked
  5. Duplicate Invoice Check: COUNTIFS and HighlightingLab Locked
  6. Three-Way Match: Purchase Order, Goods Receipt and InvoiceLab Locked
  7. Customer Statement: Running Balance for OctoberLab Locked
  8. DSO and DPO: How Fast Cash Comes In and Goes OutLab Locked
  9. Collections Priority List: Who to Call FirstLab Locked
  10. Vendor Spend Summary: SUMIF, COUNTIF and SharesLab Locked
  11. Cash Receipts Matching: XLOOKUP Against Open InvoicesLab Locked
  12. AP/AR Dashboard: Overdue Share, Chart and AlertsLab Locked
  13. Approval Limits: Routing Supplier Invoices to the Right ApproverLab Locked
  14. Reading Payment References: Invoice Numbers from Bank Text with SEARCH and MIDLab Locked
  15. Customer Credit Balances: Overpayments, Credit Notes, Refund or OffsetLab Locked
  16. Recurring Invoices: Pro-Rata First Months, the Monthly Billing Run & RenewalsLab Locked
  17. AR Roll-Forward per Customer: Opening, Invoiced, Received, Credited & ClosingLab Locked
  18. Cash In, Cash Out: The Next Four Weeks from Open InvoicesLab Locked
  19. The AP Inbox: Working Days Waiting, Urgent Invoices & the Next Payment RunLab Locked
  20. Final Project: The Month-End AP/AR Pack for a Second WholesalerLab Locked