Home Care Billing Spreadsheet Excel Google Sheets, Client Invoice Template, Accounts Receivable Aging Tracker, Private Pay and LTC Insurance
Item highlights
Seller's description
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.
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.
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.
- Long-term care insurers and other third-party payers often have their own claim forms and rules. This file tracks what you billed and collected; send whatever each payer asks for.
- A billing and record-keeping tool, 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. Sample names, addresses and policy numbers are invented.
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 AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.
Copyright UnitAndLedger.
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
NowPrice:$21.75
Original Price: $29.00
25% off
Sale ends in 6 days
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
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.
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.
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.
- Long-term care insurers and other third-party payers often have their own claim forms and rules. This file tracks what you billed and collected; send whatever each payer asks for.
- A billing and record-keeping tool, 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. Sample names, addresses and policy numbers are invented.
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 AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.
Copyright UnitAndLedger.
-
Item typeDigital download
-
Digital file type(s)1 PDF, 1 other file
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Med Spa Operations and Safety Bundle, Aesthetic Clinic Policy Manual, OSHA Safety Manual, Intake Forms, Privacy Kit, Handbook, Excel
Sale Price $111.75
Original Price $149.00
-
Digital download
Med Spa Employee Handbook and Hiring Packet, Aesthetic Clinic Job Descriptions, Job Application, Offer Letter, Onboarding Forms, Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Privacy Kit, Notice of Privacy Practices Template, HIPAA Worksheet, Breach Log, Aesthetic Clinic Privacy Forms and Policies, Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Intake Forms, Health History Questionnaire, General Consent Form, Aesthetic Clinic Client Forms, Financial Policy, Editable Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Policy and Procedure Manual, Aesthetic Clinic Operations Policies Template, 49 Policies, Medical Spa Business, Editable Word PDF
Sale Price $44.25
Original Price $59.00
-
Digital download
Med Spa OSHA Safety Manual, Bloodborne Pathogens Exposure Control Plan, Hazard Communication Program, Aesthetic Clinic Template, Word
Sale Price $44.25
Original Price $59.00