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.
- 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
- Invoice Register: Due Dates, Days Overdue and StatusFree
- AR Aging Report: Buckets with IFS and Totals with SUMIFS Locked
- AP Payment Run: Selecting the Invoices Due This Week Locked
- Early-Payment Discounts: Is 2/10 Net 30 Worth Taking? Locked
- Duplicate Invoice Check: COUNTIFS and Highlighting Locked
- Three-Way Match: Purchase Order, Goods Receipt and Invoice Locked
- Customer Statement: Running Balance for October Locked
- DSO and DPO: How Fast Cash Comes In and Goes Out Locked
- Collections Priority List: Who to Call First Locked
- Vendor Spend Summary: SUMIF, COUNTIF and Shares Locked
- Cash Receipts Matching: XLOOKUP Against Open Invoices Locked
- AP/AR Dashboard: Overdue Share, Chart and Alerts Locked
- Approval Limits: Routing Supplier Invoices to the Right Approver Locked
- Reading Payment References: Invoice Numbers from Bank Text with SEARCH and MID Locked
- Customer Credit Balances: Overpayments, Credit Notes, Refund or Offset Locked
- Recurring Invoices: Pro-Rata First Months, the Monthly Billing Run & Renewals Locked
- AR Roll-Forward per Customer: Opening, Invoiced, Received, Credited & Closing Locked
- Cash In, Cash Out: The Next Four Weeks from Open Invoices Locked
- The AP Inbox: Working Days Waiting, Urgent Invoices & the Next Payment Run Locked
- Final Project: The Month-End AP/AR Pack for a Second Wholesaler Locked
Learner reviews
Be the first to review this course.