An accounts payable and receivable template tracks both sides of your cash: the money customers owe you (receivables) and the money you owe suppliers (payables), in one workbook. Seeing both together shows your net cash position at a glance.
This free template has a Receivables tab and a Payables tab, each tracking invoices or bills with due dates, amounts, outstanding balances and status, plus a Cash position tab that subtracts total payables from total receivables. It works in Excel or Google Sheets. For deeper receivables tracking, pair it with our AR tracker.
For a small business, watching money in against money out is the simplest early-warning system for a cash squeeze.
What is inside the template
| Tab | What it tracks |
|---|---|
| Receivables | Money in: customer invoices, due dates, outstanding, status |
| Payables | Money out: supplier bills, due dates, outstanding, status |
| Cash position | Total receivables minus total payables, your net position |
Outstanding and status (Open, Overdue, Settled) calculate automatically on both tabs from today's date.
How do I track accounts payable and receivable together?
Use one workbook with a tab for each: receivables for money customers owe you and payables for money you owe suppliers. Track each invoice or bill with a due date and amount, let outstanding and status calculate, then compare the totals to see your net cash position. The template does this for you.What is the net cash position?
It is your total receivables minus your total payables: a quick view of whether more money is due in than is due out. A positive figure is reassuring, but timing matters, so watch due dates on both sides.Should the same person handle AP and AR?
Best practice is to separate them where possible, because one person controlling both incoming and outgoing cash weakens segregation of duties. Small teams that cannot separate them should add manager review of payments and receipts.Is a combined template enough for a small business?
For a small business with a manageable number of invoices and bills, yes. As volumes grow, automated reminders and reconciliation save time, which is when dedicated software helps. See our AR software guide.Does it work in Google Sheets?
Yes. Import the Excel file into Google Sheets; the SUM, IF and TODAY formulas across the tabs work the same.Last updated June 9, 2026. This guide is general information, not accounting, tax, or financial advice.