Free Google Sheets Payment Tracker
For businesses that take card, bank, cash and check payments and need to match what customers paid against what actually reached the bank.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Payments, Invoices and Deposits, no typing needed. |
| Payments | Columns Payment ID, Date received, Customer, Invoice number, Type, Amount (positive), Method, Reference, Processing fee and 6 more. |
| Invoices | Columns Invoice number, Customer, Invoice date, Invoice total, Paid to date, Balance, Status and Notes. |
| Deposits | Columns Deposit batch ID, Deposit date, Bank statement amount, Expected total, Difference (bank minus expected), Matched and Notes. |
| Settings | Your own dropdown lists (payment method and type), so the choices match how you work. |
How to fill it in
- Record each payment with the invoice it pays, the method, a reference and any processing fee.
- Group deposited payments into a deposit batch with the bank date.
- Compare Expected total with the bank statement amount on Deposits.
- Use Invoices to spot overpayments and balances still open.
A tip from the field
Cash and checks that were never deposited show in the deposit alert, the usual reason the bank comes up short.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
Related templates
- Free Google Sheets Invoice Tracker
- Free Google Docs Receipt Template
- Free Profit and Loss Statement Template
When you outgrow it
Smarfle takes card and bank payments online, records cash and checks in the field and marks invoices paid. See how it works on smarfle.com.