Sparta Labs

← All products

Private Practice Money Ledger cover: a laptop showing the Money Dashboard with sample data, labelled Excel + Google Sheets.

Private Practice Money Ledger

For Excel and Google Sheets

Practice income, unpaid claims, monthly profit and quarterly tax set-asides in one workbook.

$24Buy — $24

Also on Etsy

Delivery: instant digital download after purchase. No physical product is shipped.

See your practice income, unpaid claims, monthly profit and quarterly tax set-asides in one place. The Private Practice Money Ledger is a protected, formula-driven workbook with nine tabs, built for solo therapists who take insurance and private pay.

  • Income log: copays, self-pay and other income, by payer and method
  • Paid claims count as income automatically: no double entry
  • Claims aging: days outstanding, 0–30/31–60/61–90/90+ buckets, follow-up and denial alerts, underpayment flags
  • Expenses mapped to Schedule C lines, with a deductible yes/no
  • Quarterly tax set-aside: IRS periods and due dates, suggested vs. actual, with shortfall alerts
  • Monthly P&L: pick any month for income by source, expenses by category and net profit, plus a 12-month summary
  • Bank reconciliation: mark items cleared, enter your statement balance and date, and see the difference with a green/red Reconciled indicator
  • Dashboard: YTD profit, denial rate, top payers, 12-month income vs. expenses chart, next tax due date
  • Works with our Therapist Caseload Tracker: same client IDs and payers
  • IDs only, no client names. No macros. Sample and blank versions plus a setup guide PDF

Works in Excel (Windows & Mac), Google Sheets and, on Linux, Google Sheets or LibreOffice Calc. Instant digital download. Not tax, legal or accounting advice; consult a CPA.

These are spreadsheet templates. They are not an EHR, and they are not a HIPAA compliance solution. You are responsible for how you store and protect client information.

One license per buyer; for use in your own practice.

What's included: the nine tab names, plus a SAMPLE workbook, a BLANK workbook and a Setup Guide & FAQ PDF.
What's included
Insurance Claims tab with sample data: one row per claim, with days outstanding, aging buckets and follow-up and denial flags.
Claims aging, shown with sample data
Quarterly Estimated Tax Set-Aside tab with sample data: IRS periods and due dates, suggested and actual set-aside, and an on-track or short status.
Quarterly tax set-aside, shown with sample data
Bank Reconciliation tab with sample data: statement balance, cleared items and a green Reconciled indicator.
Bank reconciliation, shown with sample data
$24Buy — $24

Also on Etsy