Bookkeeper Client Tracker Kit - Excel Spreadsheet
On Sale
$8.00
$8.00
Client and invoice tracker for bookkeepers. Keep your client list with monthly fees, log invoices, and see what is outstanding.
TRACKS
- Clients: name, monthly fee, status (Active / Inactive)
- - Invoices: date, client (dropdown), amount (auto from their monthly fee, with an optional Amount override), the month the invoice covers, status (Sent, Paid, Cancelled)
- - Month rollups for any months you type (no hardcoded years)
CALCULATES
- Active client count and total monthly fees
- - Invoiced, collected, and outstanding amounts, overall and per month
- - A check column flags any invoice on an Inactive client, plus a second invoice for the same client and month
- - Cancelled invoices are ignored, and month rollups exclude them
No tax or filing features.
WHAT'S INSIDE
- Bookkeeper Client Tracker.xlsx with Clients, Invoices, Dashboard, Monthly, Instructions
- - Fictional sample rows you can delete to start with your own data
- - Quick-start README with step-by-step instructions
INSTANT DOWNLOAD
One ZIP file: the spreadsheet (xlsx) and a README (txt). Standard .xlsx file; tested in LibreOffice, should open in Excel and Google Sheets.
Created with AI assistance and reviewed before publication.