An invoice record in one row
Keep invoice number, customer, issue date, due date, currency, amounts, status and last follow-up note in one row. Excel has formulas to calculate outstanding balance and days overdue. You enter the total.
Use one reporting currency per workbook; this tool does not convert currencies. Store the source invoices and payment evidence by invoice number, rather than just the numbers in this sheet. There is a minimum balance of zero. Review overpayments, refunds and credits in the source records.
- Invoice number and customer
- Issue date and due date
- Subtotal, tax and total
- Amount paid and outstanding balance
- Status, days overdue and follow-up note