--- type: Template title: Accounts Payable and Receivable Template (Free Excel) description: A free accounts payable and receivable template for Excel. Track money in and money out on two tabs, with an automatic net cash position. For small business. resource: https://accounting.events/resources/accounts-payable-and-receivable-template/ tags: [accounts payable and receivable template, accounts payable and receivable template excel, ap ar tracker, money in money out template] timestamp: 2026-10-19 --- AP and AR Template # Accounts payable and receivable template A free Excel template that tracks both receivables (money in) and payables (money out), with an automatic net cash position. By [**Accounting.Events editorial team**](/about/)Updated **September 28, 2026****5 min read** Quick answer **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](/resources/accounts-receivable-excel-template/). Preview Xaccounts-payable-and-receivable-template.xlsxAccounts Payable and ReceivableRECEIVABLES (IN)$18,260PAYABLES (OUT)$11,540NET POSITION$6,720Customer / SupplierDue dateAmountOutstandingStatusNorthwind Trading (AR)2026-06-014,2000SettledHarbor Logistics (AR)2026-05-153,2002,200OverdueApex Supplies (AP)2026-06-105,0005,000OpenTwo tabs (Receivables, Payables) plus an automatic net cash position. Free AP and AR template Excel (.xlsx) with Receivables and Payables tabs and an automatic net cash position. No sign-up. [Download Excel](/resources/accounts-payable-and-receivable-template/accounts-payable-and-receivable-template.xlsx) For a small business, watching money in against money out is the simplest early-warning system for a cash squeeze. **Video:** [Accounts Payable and Receivable Template (Free Excel)](https://www.youtube.com/watch?v=ZN_aL9AvKKk) ## What should an AP and AR template include? An AP and AR template needs one place for money in, one place for money out, and a total that nets them off. Each line needs a due date and a status so you can see what is overdue on both sides. Five parts cover it: - **Receivables tab:** customer invoices, amounts and outstanding balances. - **Payables tab:** supplier bills, amounts and outstanding balances. - **Due dates:** on every invoice and bill, so timing is visible. - **Status:** Open, Overdue or Settled, calculated from the due date. - **Net cash position:** total receivables minus total payables. ## What is inside the accounts payable and receivable template? The workbook has 3 tabs: Receivables for money in, Payables for money out, and Cash position, which subtracts total payables from total receivables to show the net position. | 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 2 tabs, one for each side: 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? The net cash position 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. Intuit QuickBooks' 2025 Late Payments Report puts the amount the average US small business is owed in unpaid invoices at $17,500. ## Should the same person handle AP and AR? Different people should handle accounts payable and accounts receivable 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? A combined template is enough for a small business with a manageable number of invoices and bills. As volumes grow, automated reminders and reconciliation save time, which is when dedicated software helps. See our [AR software guide](/reviews/best-accounts-receivable-software/). ## Does it work in Google Sheets? The template works in Google Sheets: import the Excel file, and the SUM, IF and TODAY formulas across the 3 tabs calculate the same way as in Excel. ## Related reading Independent software reviews and guides from Accounting.Events. [Template ### AR tracking spreadsheet A deeper receivables-only tracker. Read more →](/resources/accounts-receivable-excel-template/)[Guide ### AR vs accounts payable How the two sides of the ledger differ. Read more →](/resources/accounts-receivable-vs-accounts-payable/)[All resources ### Resources, templates and calculators Every free AR guide, template and calculator we publish. Read more →](/resources/) AE [Accounting.Events editorial team](/about/) The Accounting.Events editorial team researches and maintains the software comparisons on this site. Comparisons are built from published vendor pricing, verified third-party reviews on the Xero App Store, G2 and Capterra, and primary-source statistics. Every guide carries the date it was last checked. Figures here are drawn from public sources; always confirm with your accountant or the linked source before acting. Last updated September 28, 2026. This guide is general information, not accounting, tax, or financial advice.