Solo Business Records Free Sampler: Invoice Tracker for Excel and Google Sheets
Free. Instant download. Excel and Google Sheets.
You need your invoices and expenses in one place before tax time. This free sampler shows the first half of that job: your clients and your invoices.
It comes with sample data and is built for Excel and Google Sheets.
Free and complete. The full Solo Business Records Workbook adds Income, Expenses and Mileage logs, Projects, Invoice lines, a Monthly summary, a Year pack for your accountant and a Dashboard: https://theverastandard.gumroad.com/l/solo-business-records-workbook
Every row you type checks itself and says OK or what to fix. 5 test scenarios, 22 checks, 0 failed.
Free means no subscription and no bank login. Your records stay in your file.
A Start here sheet gives five steps in plain words, about ten minutes; you type only in the shaded cells.
Pick an invoice and the Invoice sheet prints a clean invoice to send to a client, on US Letter or A4.
$0. Pay more only if you wish.
Gumroad asks for an email to send the file. We send one follow-up asking for an honest rating, and nothing else unless you opt in.
What it does
- Start here: five steps, and how to open the file in Excel or Google Sheets.
- Clients: 10 rows with status and next follow-up date.
- Invoices: 10 rows with balance, status and days overdue. Here you type the amount paid and the paid date.
- Invoice: pick an invoice and print it.
What the full workbook adds. Clients up to 100 and Invoices up to 600; Projects; Invoice lines; Income, Expenses and Mileage logs, where the amount paid comes from Income by itself; a Monthly summary; a Year pack to share with your accountant; and a Dashboard with a chart. It is a separate paid product. The sampler is complete as it is and works without it.
How it works
- Open the .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Clear the sample clients and invoices (shaded cells), then type your own.
- Pick an invoice on the Invoice sheet and print it.
See it first
Real screens. Sample data is fictional.
Who it is for
Freelancers and other one-person businesses that send invoices and want to try the records first.
It is not the right fit if you need:
- sales tax, VAT or GST on your invoices.
- sending invoices or taking payments from the file.
- employees, payroll, stock or cost of goods.
- double-entry accounts, bank feeds or tax worked out for you.
What you need
Excel (Microsoft 365, Windows) or Google Sheets (free). Tested in Microsoft Excel (Microsoft 365, Windows) and Google Sheets (in Google Sheets, cell protection is not kept).
FAQ
Is it really free? Yes. $0, nothing hidden, and the file is yours to keep.
Where is my download? Press View content, then Download all. The link is in your receipt email too.
I cannot open it. Write to [email protected] with your app. We send another file.
It looks different from the pictures. The pictures show the sample data. Clear the shaded cells to start your own.
Can I add VAT or sales tax? Not as a separate line; the invoice total is the amount you type.
Help and refunds
Free file. There is nothing to pay, so there is nothing to refund. If a file will not open or is not as shown, write to [email protected] and we send another file.
Files
- solo-business-sampler.xlsx
License: for your own use. You may print it and keep copies. Please do not resell it or share it as your own.
About
The Vera Standard is a small independent studio in Hyderabad, India. We make plain, tested templates for small makers. Write to [email protected]. We reply within two working days.
We design these templates with the help of AI tools. Every formula and total is then tested by us with sample data before release.
Arithmetic on the numbers you type. Not advice of any kind.
Google Sheets is a trademark of Google LLC. Excel is a trademark of the Microsoft group of companies. The Vera Standard is independent and is not affiliated with or endorsed by them.
Next step
More from The Vera Standard are on the same profile.