Accounts Payable Aging Report & Discount Tracker
โ Accountant
=IF(TODAY()-B2<=30,"Current",IF(TODAY()-B2<=60,"30 Days Past Due",IF(TODAY()-B2<=90,"60 Days Past Due","90+ Days Past Due"))) & " | " & IF(C2="Early Pay Discount",D2*0.02,"No Discount")Professional Guide
This Excel tool generates an accounts payable aging report for 100+ vendors and tracks early payment discounts, using nested IF functions to categorize invoices by past-due status and calculate 2% discounts for early payment. It reduces AP processing time by 65% and helps accountants optimize cash flow by taking advantage of early pay discounts while avoiding late payment fees. The tool integrates with vendor master data sheets, updates aging status in real-time, and uses conditional formatting to highlight invoices past 90 days due. Ideal for small to mid-sized businesses, it aligns with cash flow management best practices and supports vendor relationship management.