Use this Accounts Receivable – Aging excel spreadsheet to track invoices and accounts receivable.
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.
Accounts Receivables with Gradients indicators
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.
Accounts Receivables with Traffic Light indicators