The AP Inbox: Working Days Waiting, Urgent Invoices & the Next Payment Run
Lessons in this course
- 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