Excel Template – Aging of Accounts Receivable

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

1. Enter values in each of the cells.
2. Right-click on the chart.
3. Refresh the data.

Accounts Receivables with Gradients indicators

How to change conditional formatting

1. Select the cells you want to change.
2. On the Home tab, click Conditional Formatting. (It’s in the Styles section)
3. Click Manage Rule from the drop-down menu.

Accounts Receivables with Traffic Light indicators