● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Invoices Clients & CRM›Small Business Payment Log
Small Business Payment Log spreadsheet, hero view of the installment payment tracker
INVOICES CLIENTS & CRM

Small Business Payment Log

Letting clients pay over time wins sales, but remembering who paid what, and when, gets messy fast. This installment payment tracker holds every plan, due date and part payment in one calm spreadsheet, so collected, outstanding and overdue amounts are never a guessing game again.

$1.60$3.9960% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Never chase a payment from memory again

Plenty of small businesses let customers pay over time, because it wins sales that a single upfront price would lose. The trouble starts a month later, when three clients are on three different schedules and nobody can say who has paid what. This tracker was built for exactly that gap. You set up each plan once, with the client, the item, the total amount and how many installments it splits into, and the amount per installment calculates itself.

From there, the daily work takes seconds. Each payment goes on the Payments tab with its plan picked from a dropdown, its due date and its amount, and the status looks after itself, flipping between Paid, Pending and Overdue as dates pass. The client list you keep on its own tab feeds every dropdown in the file, so names stay spelled one way and nothing needs typing twice.

The dashboard is the page you will actually open. It shows how many plans you are running, how much has been collected, how much is still outstanding and how many payments are overdue, with a monthly chart beside the numbers. Retailers, freelancers, coaches, studios and service businesses use it the same way: a quick morning glance tells you exactly who needs a friendly reminder today, and who is fully paid up.

Inside the workbook: 5 tabs

What you receive

  • Google Sheets Access PDF with a 1-click link that copies the tracker into your own Google Sheets
  • BLANK Excel workbook, clean and ready, with every formula live
  • EXAMPLE Excel workbook filled with sample plans and payments so you can see how it works
  • Quick Start Guide PDF with the setup steps in plain language
  • Four separate files, no ZIP to unpack

Good to know

  • Works in Microsoft Excel 2021 or Microsoft 365
  • Works in Google Sheets with a free Google account
  • Pay once: no subscription and no add-ons
  • Every plan can have its own number of installments
  • Questions? Message us on Etsy and we reply within 24 hours

Questions about this template

The things buyers ask us most.

Is this a subscription?

No. You pay once and the files are yours to keep and use for as long as you like. There is no monthly fee, no add-on to buy and no account to keep open. Download the files after checkout, store them somewhere safe, and open your tracker whenever a payment needs logging or checking.

Should I use the Excel version or Google Sheets?

Both are included, and both carry the same five tabs and the same working formulas. The Access PDF gives you a Google Sheets copy in one click, which suits anyone who likes working in a browser. The BLANK workbook opens in Excel 2021 or Microsoft 365 if you prefer a desktop file. Pick whichever app you already open every day.

Can different plans have different numbers of installments?

Yes. Every plan is set up on its own, with its own total amount and its own installment count, so one client can split a purchase into four payments while another spreads theirs over ten. The per-installment amount is worked out from whatever you enter, and each payment you log is tied to its own plan through the dropdown.

What if I get stuck while setting it up?

Start with the Start Here tab inside the file and the Quick Start Guide PDF, which walk through setup step by step in plain language. If something still looks off, message us through Etsy and we will help you sort it out. We reply within 24 hours, and we would much rather fix a small confusion early than leave you guessing.

More in Invoices Clients & CRM

All templates in this category →

Three more workbooks from the same shelf.

Small Business Lead Tracker

Every lead, stage and follow-up in one place, with pipeline value and win rate automatic.

$3.99 $1.60
View on Etsy
Coach Client Onboarding Tracker

Give every new client the same smooth start, with a checklist and progress dashboard.

$4.99 $2.00
View on Etsy
Freelancer Quote Tracker

Log every quote, follow its status and watch your win rate climb.

$3.99 $1.60
View on Etsy
View on Etsy · $1.60