Accounts Payable & Purchase-to-Pay: Three-Way Match, Duplicates & Payment Runs
Age the invoice register, run a three-way match with tolerances, catch duplicate invoices, price early-payment discounts, build a payment run, measure DPO, check the vendor master and accrue GRNI: 8 labs on one company.
The first lesson is free — no account needed.
About this course
An accounts payable course that runs the purchase-to-pay controls of one fictional outdoor-gear company in a spreadsheet, for AP clerks, accountants, auditors and finance students. You age the open invoice register into due-date buckets and chart it, run a three-way match of purchase orders, goods receipts and invoices with price and quantity tolerances, catch duplicate invoices with cleaned keys, running counts and near-duplicate checks, annualise 2/10 net 30 discounts and decide whether to take them against the credit line, build a weekly payment run within a cash limit, measure AP turnover and days payable outstanding over five years, review the vendor master for missing tax IDs, unverified bank-detail changes and shared bank accounts, and accrue goods received not invoiced at month end. The first lab is free.
Lessons
- The Invoice Register & AP Ageing: Due Dates, Days Past Due & BucketsFree
- Three-Way Match with Price & Quantity Tolerances Pro
- Duplicate Invoice Detection: Clean Keys, Running Counts & Near-Duplicates Pro
- Early-Payment Discounts: 2/10 Net 30, Annualised Cost & Take or Skip Pro
- The Payment Run: Due-Date Window, Discounts, Holds & the Cash Limit Pro
- DPO & AP Turnover: How Long Kestrel Takes to Pay Pro
- Vendor Master Checks: Missing Tax IDs, Bank-Detail Changes & Shared Accounts Pro
- Month-End: Accruing Goods Received Not Invoiced (GRNI) Pro