Private Practice Bookkeeping Spreadsheet

There is no shared link to expire. You import the file into your own Google Drive, so the spreadsheet is yours and cannot break.

• Bookkeeping-Template.xlsx - the 12-tab workbook, works offline in Excel
• Google-Sheets-Setup.pdf - import it into your own Google Drive in three clicks
• READ-ME-FIRST.pdf - the setup steps and what every tab does

Seven plain-English setup steps are built into the first tab. No tutorial to sit through, nothing to install and no account to make with me.

• Annual Dashboard - income, expenses, net profit, money owed, tax set-aside, miles, your best month, a profit-goal ring and charts of where the money comes from and goes
• Monthly Dashboard - pick any month from a dropdown: profit, change vs last month, progress to your monthly goal and every category
• Quarterly - pick Q1 to Q4 for totals, the months inside it and the tax to put aside for quarterly payments
• Income - date, client, invoice number, category, amount, paid yes/no
• Expenses - date, paid to, category, amount, receipt link; business or personal fills itself in from the category
• Mileage - from, to and miles; the deduction is worked out with your own rate
• Unpaid Invoices - every unpaid invoice, oldest first, flagged at 30 and 60 days
• Top Clients - ranked by what they paid this year, with invoices and amounts still owed
• Monthly Summary - income, expenses, profit, margin, unpaid and miles for every month
• Tax Summary - totals by category, deductible amounts, mileage deduction and a suggested tax set-aside
• Settings - business name, financial year, currency symbol, mileage rate, tax %, profit goal and your categories
• Start Here - the seven setup steps

• Your financial year can start in any month, and every tab follows it
• Any currency: set your symbol once on Settings
• Every formula is locked so it cannot be broken by accident
• Categories are dropdowns already set up for therapists and counselors, and you can rename them
• Owner draw and personal spending are kept out of profit and tax
• Room for 1,000 income rows, 1,000 expenses and 500 trips a year

Therapists, counselors and psychologists in private practice, solo or in a small group.

Microsoft Excel 2010 or newer (Windows or Mac), or a free Google account for Google Sheets. Nothing else. The Excel file works with no internet connection.

Nothing is posted to you. Your files are ready the moment your order goes through - find them under You, then Purchases and reviews, then Download Files.

Because the files are delivered instantly and cannot be returned, all sales are final. But if a file will not open, will not calculate, or is not what was described, message me and I will fix it or refund you. I would always rather solve the problem than leave you with something you cannot use.

This is a spreadsheet, not tax advice. The tax summary adds up your categories so you have clean figures to give your accountant. It does not file anything for you.

The images show the spreadsheet filled with sample data. Your copy arrives with five example rows per tab that you clear before you start.

Your purchase is for your own business use. Please do not resell or redistribute the files.

I reply to every message within 24 hours.

Yes. Import it into your own Google Drive in a few clicks (the guide shows how), or open it in Excel.

No. You type in your numbers; every total, chart and dashboard updates by itself.

Straight after payment you get a download link, and it is emailed to you too.

Contact us. We fix it, swap it or refund you.