Use this Accounts Payable (Aging) excel spreadsheet to categorize payables to suppliers based on time buckets. The report is typically set up with 30-day time buckets. Track invoices and accounts receivable with this accounts payment template.
Download Excel template
Download: Accounts Payable – Aging
File format: Excel
How to update charts
- Enter values in each of the cells.
- Right-click on the chart.
- Refresh the data.
How to change conditional formatting
- Select the cells you want to change.
- On the Home tab, click Conditional Formatting. (It’s in the Styles section)
- Click Manage Rule from the drop-down menu.