Tabellab
Accounting Beginner

Excel for Accounts Payable & Receivable Clerks: Invoices, Aging & Payments

20 hands-on labs for AP and AR clerks: invoice register with due dates, aging buckets, weekly payment runs, early-payment discounts, duplicate checks, three-way match, customer statements, DSO and DPO, collection calls, vendor spend, cash receipts matching, an AP/AR dashboard, approval limits, invoice numbers from bank text, customer credit balances, recurring billing runs, AR roll-forwards, a four-week cash view, the AP inbox and a month-end pack.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course covers the daily Excel work of accounts payable and receivable clerks in 20 hands-on labs for a fictional supplies wholesaler. You calculate due dates and days overdue, build an aging report, select a weekly payment run, judge early-payment discounts, catch duplicate invoices, run a three-way match, prepare a customer statement, calculate DSO and DPO, rank collection calls, summarise vendor spend, match cash receipts and build a dashboard. Then you go further: route invoices by approval limits, pull invoice numbers out of bank text, find customer credit balances, prepare a recurring billing run, roll customer balances forward to the ledger, forecast cash in and out for four weeks, clear the AP inbox before a payment run and finish with a month-end pack for a second company.

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy