Excel Template – Accounts Payments Aging Report

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

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

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.