Your Cart
Loading

Bookkeeper Client Tracker Kit - Excel Spreadsheet

On Sale
$8.00
$8.00
Added to cart

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.

You will get a ZIP (16KB) file