Sparta LabsWhat should a therapy insurance claims tracker include?
One row per claim with the date of service, a client ID (not a name), the payer, CPT code, amount billed, amount you expect under your contract, amount paid, date submitted, date paid, status, and denial reason if there is one. From those you can work out how many days each claim has been open and how much is still owed, which tells you which claims to follow up on first.
How to use it week to week
- Add the claim the day you submit it. Fill in the date of service, client ID, payer, CPT code, billed amount, expected amount and date submitted, and set the status to Submitted.
- Use a short, fixed list of statuses, such as Submitted, Paid, Denied, Resubmitted and Written off. Free-typed statuses are hard to sort.
- Update the row when the EOB or ERA arrives: amount paid, date paid, and the denial reason if it was denied.
- Compare paid to expected, not to billed. Your full fee and your contracted rate are often different. Paid below expected is the gap worth asking about.
- Once a week, sort by days outstanding. Pick a follow-up point, such as 30 days, and call or check the portal on anything older. Grouping claims into 0–30, 31–60, 61–90 and 90+ days shows where the money is stuck.
- Write down why claims were denied. Over a few months you'll see whether the same reason keeps coming back, like an eligibility issue or a missing authorization, and can fix it at the source.
Timely filing limits, appeal deadlines and what you can bill vary by payer and contract. Check your contracts or your payer's provider manual. A spreadsheet tracks claims, but it isn't billing advice.
A template that does this
Our Private Practice Money Ledger ($24, Excel and Google Sheets) has a Claims tab with these columns. It works out days outstanding, the aging bucket and the open balance, and shows an alert such as “Denied: reason”, “Follow up: N days outstanding” or “Underpaid by $X”. Paid claims count as income automatically, and the Dashboard shows open claims and your denial rate. If you also want authorizations and session balances, the Private Practice Bundle includes the ledger and the caseload tracker.
Common follow-up questions
Should client names go in a claims spreadsheet?
We suggest using a client ID or initials code instead of a full name, and keeping the key that links codes to names somewhere separate and secure. Any file with client information still needs careful storage.
How often should I follow up on unpaid claims?
Pick a set number of days and stick to it. Many practices check weekly and follow up on anything past their threshold. Your payers' timely filing and appeal deadlines tell you how much room you have.
What's the difference between billed, expected and paid?
Billed is your full fee. Expected is what your contract says the payer should allow. Paid is what actually arrived. The gap between expected and paid is how you spot underpayments.
Related questions
- How do I track how many insurance authorization visits a client has left?
- How do I track no-show and late-cancel fees in private practice?
Sparta Labs templates are spreadsheets for organizing your practice. They aren't an EHR, billing or clinical advice, or a HIPAA compliance solution.