Skip to the content.

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

  1. Record each payment with the invoice it pays, the method, a reference and any processing fee.
  2. Group deposited payments into a deposit batch with the bank date.
  3. Compare Expected total with the bank statement amount on Deposits.
  4. 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.

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.

All free templates