Description
Full Walkthrough
Time entries, engagement billing, invoices, A/R aging and a client retainer ledger with reconciliation for consultants and CPA firms.
Who it’s for
Consultants, CPA firms and small professional firms billing hourly, flat fee or on retainer.
What’s inside
- Dashboard: Billable hours, value, billed, collected, realization, WIP, A/R, A/R over 90, retainer balance, utilization, overdraw alerts, timekeeper scorecard and charts
- Engagements: Per engagement: hours, value, billed, collected, WIP, A/R, realization, budget used, retainer balance
- Time Entries: Time log with rate, value, cost and WIP / billed status
- Invoices: Invoices with paid amount, balance, days outstanding and aging bucket
- Retainer Ledger: Client retainer (retainer) transactions with a running balance per engagement and overdraw alert
- Retainer Reconciliation: Three-way check: adjusted bank balance vs retainer ledger vs sum of client balances, plus every client's balance
- Monthly: 12 months of hours, value, billed, collected, realization and retainer activity
- Settings: Rates, targets, dates and lists
What you get
- The .xlsx workbook with sample data that’s easy to clear
- Setup Guide PDF, with every tab explained
- A video walkthrough
FAQ
Does it work in Google Sheets?
Yes. Upload it to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
Which Excel version do I need?
Excel 2019 or newer, Microsoft 365 or Excel for Mac.
Is this a subscription?
No. You pay once and keep the file. No macros, no add-ons.
An organizing tool, not legal or accounting advice.
This is a digital product. No physical item will be shipped.
Also on Gumroad: Consulting & CPA Firm Billable Hours, Billing & Client Retainer Ledger on Gumroad
Build your own store: Hostinger WordPress hosting (affiliate link: I may earn a commission at no extra cost to you)
