A pressure washing accounts receivable spreadsheet is a list of the invoices customers still owe you and the next action required to collect those balances. It should answer three questions at a glance: Which invoices are open? How much remains unpaid? Which customers need a follow-up?
You do not need a paid CRM to get started. A properly maintained spreadsheet may be enough for a small operator, provided it is kept accurate and secured appropriately.
Free accounts receivable spreadsheet layout
Create a table with one row per invoice. The following columns are a practical starting point:
| Column | Purpose |
|---|---|
| Invoice ID | Unique invoice number, such as INV-001 |
| Customer | Customer or billing company |
| Job ID / location | Links the bill to the correct completed job |
| Invoice date | Date sent or issued |
| Due date | Agreed date payment is due |
| Original invoice total | Amount billed, including correctly determined tax |
| Payments applied | Total cleared payments credited to that invoice |
| Credits / adjustments | Approved credits recorded separately |
| Balance outstanding | Original total minus payments and credits |
| Status | Open, partially paid, paid, overdue or disputed |
| Last contact | Date of latest billing communication |
| Next follow-up | Specific reminder or review date |
| Notes | Short factual record of disputed items or agreed next steps |
Example spreadsheet rows
These invented records demonstrate the math; they are not real SGL customer or payment data.
| Invoice | Total | Payments | Credits | Open balance | Status |
|---|---|---|---|---|---|
| INV-001 | $500 | $500 | $0 | $0 | Paid |
| INV-002 | $700 | $250 | $0 | $450 | Partially paid |
| INV-003 | $300 | $0 | $50 | $250 | Open |
Illustrative total outstanding: $700. This is the sum of the unpaid balances: $0 + $450 + $250.
Useful spreadsheet formulas
Suppose column F holds the invoice total, G holds payments, H holds credits and I holds the outstanding balance, beginning on row 2.
-
Open balance in I2:
=MAX(0,F2-G2-H2) -
Total open balances:
=SUM(I2:I1000), adjusted for the rows you use. -
Days past due:
=IF(I2=0,0,MAX(0,TODAY()-E2)), where E2 is the due date.
These formulas assume your dates are valid spreadsheet dates, amounts are entered consistently, and any overpayments, refunds or disputed credits are handled correctly. Do not silently erase a negative balance without reviewing why it occurred.
How to manage accounts receivable each week
- Enter new invoices. Use the actual invoice number and agreed due date.
- Reconcile payments. Apply cleared receipts to the correct invoices, including partial payments.
- Review overdue balances. Look at invoice status and customer communication before contacting anyone.
- Follow up professionally. Confirm receipt and ask whether the customer has questions. Use previously agreed terms and lawful collection practices.
- Record the next action. Set a specific date or task instead of trusting memory.
- Resolve disputes. Investigate incorrect line items, missing credits or incomplete work before treating the issue as simple nonpayment.
Accounts receivable vs. revenue and profit
Money owed is not the same as cash received, and neither tells you job profitability by itself. Use separate views for expenses, actual job costs, payment receipts and any accounting reports. The correct recognition of revenue for your accounting method is a separate matter.
Common tracking mistakes
- Using a customer's name instead of a unique invoice ID.
- Marking an invoice paid after a promise instead of applying an actual cleared payment.
- Forgetting partial payments or approved credits.
- Mixing two separate jobs in one unexplained balance.
- Failing to store customer and payment records securely.
- Sending reminders automatically without checking disputes or contact permissions.
Frequently asked questions
Can I use Excel or Google Sheets?
Yes. Both can track the fields above. Check formula compatibility and data handling for your particular file.
Do I need accounting software instead?
Use the tools appropriate to your business complexity and obligations. A spreadsheet is an operational tracker, not a substitute for professional bookkeeping, tax compliance or financial controls.
Does SGL automatically send payment reminders?
No. The Business OS workbook tracks follow-up tasks and dates; it does not automatically send messages or process payments.
When one simple AR sheet is no longer enough
The Pressure Washing Business OS is a $49 one-time Excel operating workbook that connects accounts-receivable tracking with leads, customer history, quote stages, jobs and follow-ups. The downloadable workbook uses Microsoft Excel (.xlsx); open it with Excel or another compatible spreadsheet app on your chosen device. For one or two open invoices, start with the free layout above. For overdue-invoice communication, see the SGL unpaid-invoice follow-up guide.
Illustrative operational guidance only, not accounting, legal, tax or financial advice. Protect customer data and verify obligations for your business.