Keeps record of outstanding invoices owed by customers with due dates and payment status.
Accounts Receivable Tracker | ||||||||
This spreadsheet is designed to monitor and manage outstanding invoices owed by customers. It tracks invoice details, due dates, amounts owed, payments made, and outstanding balances. | ||||||||
Customer Name | Contact Email | Invoice Number | Invoice Date | Due Date | Invoice Amount | Amount Paid | Balance Due | Payment Status |
{#invoices.customerName} | {#invoices.contactEmail} | {#invoices.invoiceNumber} | {#invoices.invoiceDate} | {#invoices.dueDate} | {#invoices.invoiceAmount} | {#invoices.amountPaid} | {#invoices.balanceDue} | {#invoices.paymentStatus} |
Total Invoiced | =SUM(invoices[Invoice Amount]) | |||||||
Total Paid | =SUM(invoices[Amount Paid]) | |||||||
Total Outstanding | =SUM(invoices[Balance Due]) |
This document template includes dynamic placeholders for automated document generation with Documentero.com. Excel Template - Free download
Download Excel Template (.XLSX)Download the Accounts Receivable Tracker template in .XLSX format. Customize it to suit your needs using your preferred editor (Excel, Google Sheets...).
Upload the template to Documentero - Document Generation Service, then map and configure template fields for your automated workflow.
Populate templates with your data and generate Excel (XLSX) documents using data collected from shareable web Forms, APIs, or Integrations.
DocumentDOCX
SpreadsheetXLSX
DocumentDOCX
SpreadsheetXLSX