Accounts Payable & Purchase-to-Pay: Three-Way Match, Duplicates & Payment Runs

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Age the open invoice register of Kestrel Outdoor Gear Inc. at 30 June 2026: days past due, an ageing bucket for every invoice, the bucket totals and an ageing chart.
• Match ten Kestrel purchase-order lines against goods receipts and supplier invoices, flag quantity and price holds with tolerances and work out the value that can be released for payment.
• Clean the invoice numbers of 14 Kestrel invoices, mark every repeat of an invoice already in the list, find near-duplicates with ROUND and LEFT and total the value to stop.
• Annualise eight early-payment discount offers, compare them with Kestrel’s 12.5 % credit line, decide take or skip and total the discount captured.
• Build Kestrel’s weekly payment proposal for Friday 3 July 2026: which invoices to pay now, the amount after discount, the running total and what fits into USD 30,000 of cash.
• Calculate average payables, AP turnover and days payable outstanding (DPO) for five years and translate the FY2026 DPO change into cash.
• Review Kestrel’s vendor master: tax-ID completeness, recent bank-detail changes without a call-back, bank accounts shared by two vendors, and the vendors that must be blocked.
• Value the goods and services Kestrel received in June but has not been invoiced for, total the accrual by account, book the month-end entries and chart the accrual.