Google Sheets + Excel spreadsheet

Home Care Billing, Invoice and Receivables Tracker

Track every invoice from the day you send it to the day it is paid. Log invoices in one place, print a clean one-page invoice from any invoice number, and see each client's balance by how long it is past due, as of today or any date you pick.

  • Start Here + 5 tabs
  • 2-page PDF guide
  • Formulas only, no macros
$29Buy on Etsy: Billing, Invoice and Receivables Tracker

Price shown on Etsy at checkout may differ during a sale.

Instant download from Etsy.

Who it is for

Small agencies that bill private-pay clients and other payers from a spreadsheet and want to see what was billed, what was paid and who still owes what.

What it does

  • Invoice log for up to 1,500 invoices: number, date, client, service period, hours, rate and other charges
  • Each client's bill rate fills in unless you type a different rate for that invoice
  • Due date from your payment terms, with separate terms for any client (an insurer that pays in 30 days, for example)
  • Amount paid and date paid give the balance, days outstanding and a status: open, part paid, overdue, paid or credit
  • Printable one-page invoice: pick an invoice number and it fills in your agency details, bill-to, client, payer, service dates, hours, rate, payments and balance, plus any other unpaid invoices on the account
  • Aging per client and per payer type: current, 1-30, 31-60, 61-90 and over 90 days past due, as of today or any date you choose
  • Dashboard: billed, collected and still owed by month, the 10 largest balances, and average days to pay

Tabs

  • Invoice Log: One line per invoice. Totals, due dates, balances and status fill in.
  • Invoice: A one-page printable invoice from the number you pick.
  • Aging: Each client's balance: current, 1-30, 31-60, 61-90 and over 90 days.
  • Dashboard: Billed, collected and owed by month, and the largest balances.
  • Settings: Agency details, payment terms, payer types and clients.

What you get

Instant download, 2 files.

  • UnitAndLedger-Home-Care-Billing-Invoice-Receivables-Tracker.xlsx: one spreadsheet file for Google Sheets and Excel. Formulas only, no macros, no add-ons, no subscription.
  • UnitAndLedger-Home-Care-Billing-Tracker-Quick-Start-Guide.pdf: PDF quick-start guide (2 pages): how to open it in Google Sheets or Excel, the three steps to set up, and what each tab does.

What it is not

  • Not a claim form. Long-term care insurers and other third-party payers often have their own claim forms and rules; send whatever each payer asks for.
  • Not legal, tax or accounting advice. Check what your service agreement and your state ask for on an invoice.
  • Not affiliated with any insurer, government program or billing software.
  • Built for Google Sheets and Excel on a computer; not tested in Apple Numbers.

Good to know

  • Room for 60 clients and 1,500 invoices. Payer types (private pay, long-term care insurance, veterans program, other) can be renamed.
  • Partial payments: type the total received so far and the date of the latest payment.

How it works

  1. Buy and download instantly (Etsy emails a link; the files are also under Purchases and Reviews on etsy.com, not in the app).
  2. Google Sheets: upload the .xlsx file to Google Drive, open it, then choose File > Save as Google Sheets. Excel: open it in Excel 2016 or newer on Windows or Mac.
  3. Follow the Start Here tab or the PDF quick-start guide. The file opens with sample data so you can see how it works; clear it and type your own.

License

For use in your own business. Not for resale or redistribution. Because this is a digital item, returns are not accepted; if something does not work, message the shop on Etsy.

A look inside

Free tools and guides

Works with

Price shown on Etsy at checkout may differ during a sale.

Complete Start-Up Bundle

All ten products in one download

Seven document packs (263 pages of Word and PDF) and three spreadsheets, in one ZIP. The same files as the ten products sold separately. Bought one by one, the ten products are $350.

Price shown on Etsy at checkout may differ during a sale.