Accounts Payable & Receivable Tracker Excel Template
A dual-purpose spreadsheet tracking money owed TO you (AR) and money owed BY you (AP) with 30/60/90 day aging buckets.
Download Free Spreadsheet (.xlsx)
Direct client-side generation. Compatible with Microsoft Excel 2016+, Office 365, Google Sheets, and LibreOffice Calc.
Interactive Spreadsheet Preview
Live view of the pre-formatted columns and automated cell formulas included in your download file.
| Type | Name | Invoice # | Due Date | Balance ($) | Aging Bucket |
|---|---|---|---|---|---|
| Receivable (AR) | Acme Corp | INV-101 | 2026-07-15 | $4,500 | 31-60 Days Overdue |
| Payable (AP) | Office Supplier | BILL-992 | 2026-08-30 | $1,200 | Current |
Key Template Features
Chart Data Source: AR distribution by aging bucket (Current, 0-30, 31-60, 90+)
Visual In-Cell Bars: Total receivables vs. total payables per month
Trend Indicators: Top 5 customers with highest outstanding AR balance
KPI Cards: Total AR, Total AP, Net Position, Overdue Amount
Historical Data Ledger: 6-month AR vs. AP history
Heatmap Data Source: 12 weeks × AR/AP matrix of expected cash flow
Pre-Configured Excel Formulas
=Invoice_Amount - Paid_Amount — Invoice Balance=IF(Days<=30, "0-30", IF(Days<=60, "31-60", "90+")) — Aging Bucket=Total_AR - Total_AP — Net Working CapitalWho Uses This Template & Why
🎯 Target Users
Bookkeepers and billing departments managing cash conversion cycles.
🚀 Real Problem Solved
Losing track of who owes you money. The aging buckets immediately highlight overdue invoices.
How to Use with Google Sheets
- Click Download Excel File to save the
.xlsxfile to your computer. - Open Google Drive in your web browser.
- Click + New → File Upload and choose the downloaded file.
- Double-click the uploaded file in Google Drive to open it directly as a native Google Sheets document with all formulas intact.