How to Set Up a Freelance Bookkeeping System That Takes 15 Minutes Per Week
Most freelancers avoid bookkeeping. It's boring. They don't track expenses.
They have no idea if they're actually profitable. When taxes are due, they panic and scramble to piece together a year of receipts.
A proper bookkeeping system prevents this panic and takes only 15 minutes per week. That's one cup of coffee's worth of time to stay organized for tax time.
Track Only These Three Things
Income: what you invoiced, when, and whether it's been paid.
Expenses: money spent on business - software, equipment, education, supplies, anything related to your work.
Mileage: miles driven for business purposes (vehicle expenses are deductible).
That's it. You don't need complex accounting with multiple ledgers. These three categories cover your actual needs.
Set Up a Simple Spreadsheet
Use Google Sheets or Excel. Or use free accounting software like Wave if you want automatic categorization.
Create three sheets: Income, Expenses, Mileage.
Income sheet has columns: Date, Client, Invoice Amount, Paid (Yes/No), Date Paid.
Expense sheet has columns: Date, Category, Amount, Description, Receipt (yes/no).
Mileage sheet has columns: Date, Destination, Miles Driven, Business Purpose.
That's your entire system.
Spend 15 Minutes Every Friday
Set a calendar reminder. Every Friday before leaving work, spend 15 minutes on bookkeeping.
Add any invoices you sent this week to the income sheet. Mark previous invoices as paid if you received payment.
Log any business expenses from the week. Keep receipts or photos of receipts.
Add business miles driven during the week.
That's it. Fifteen minutes, every Friday. At the end of 52 weeks, you have a complete financial record.
Organize Expenses Into Simple Categories
Software: tools, subscriptions, software licenses.
Equipment: computer, monitor, chair, tools you use for work.
Office: supplies, paper, pens, desk furniture.
Education: courses, books, training materials.
Travel: gas, flights, hotels for business trips.
Meals and entertainment: meals with clients (50 percent is deductible).
Professional services: accountant, lawyer, contractor fees.
Marketing: ads, website hosting, promotional materials.
Don't overthink it. If it's a business expense, track it. The IRS definitions are broad.
When in doubt, include it. Your accountant can sort it out.
Income Tracking Shows Your Real Numbers
When you invoice a client, log it immediately. Date, client name, amount.
When they pay, mark it as paid and note the date.
This shows you two numbers: gross invoiced (what you earned) and actual cash received (what you got paid). There's usually a gap - money you're owed but haven't received.
At year-end, total invoiced tells your accountant how much revenue to report. Total received tells you actual cash flow.
One Hour Annual Review for Tax Time
Once a year, before taxes are due, spend one hour organizing your year's data.
Sum all paid invoices for total income.
Sum expenses by category for total deductions.
Total business miles for mileage deductions.
Create a simple summary: "Total income: $X. Total expenses: $Y. Business miles: Z."
Hand this to a tax professional or use tax software. You're done.
Good bookkeeping data saves you hundreds in tax prep costs. Accountants spend less time figuring out your finances when you've already organized them.
Tools That Make This Easier
Wave (free): connects to your bank, auto-categorizes expenses, generates reports.
Square Online (free): invoicing plus simple expense tracking.
Google Sheets: free, simple, no learning curve.
Stripe or PayPal dashboards: track income automatically if all clients pay via those platforms.
The tool matters less than consistency. Use whatever you'll actually maintain.
FAQ
What if I'm missing receipts? Do your best with what you have. You can deduct amounts even without receipts for certain categories (business meals, auto mileage). Your accountant will advise.
Should I track every single small expense? Track anything over $25-50. Small expenses add up, and proper tracking makes a difference at tax time. Small cash purchases under $20 usually aren't worth the effort.
Do I need to separate personal and business expenses? Absolutely. Only business expenses are deductible. Personal expenses don't go in this system.
What if I pay quarterly taxes? Use your income sheet to calculate quarterly tax payments. Add up invoiced income from the quarter and pay estimated taxes. Your accountant can help with the exact amount.
Should I track time too, not just money? For freelancers, no. You're not doing billable hour tracking like consultants. Track income and expenses. That's enough.
Can I use Huddle for bookkeeping? Huddle isn't designed for financial tracking. Use actual accounting software or spreadsheets for bookkeeping. Huddle is better for managing work and projects.
When should I hire a tax accountant? Once you're making over $50,000 per year, a good accountant pays for themselves in tax savings and reduced audit risk. Start earlier if you're worried about compliance.
Should I use an accounting software or a spreadsheet? Either works. Spreadsheet is free. Software is $10-30/month and does some automation. Start with a spreadsheet.
What counts as an expense? Anything you spend on your business. Your desk, the software you use, education that helps your work, half your internet bill if you have a home office.
Do I need receipts? Yes. Keep them. The IRS wants proof. A photo of the receipt is fine. Store them digitally.
What about estimated taxes? If you're making good money, set aside 25-30% of your income for taxes. Some freelancers put aside 30% as soon as they're paid, then pay estimated taxes quarterly. Others just save it and pay at year-end. Ask your tax person.
Should I have a business bank account? Yes. Makes it easy to separate business income from personal. You'll write your bookkeeping in minutes.
What if I'm losing money some months? That's fine. You're building. But track it. If you're always losing money, something's wrong.
Do I need to pay sales tax? Depends on your location and clients. If you sell to other businesses or software companies, usually no. If you sell to consumers in your state, maybe. Ask your tax person.
Should I hire a bookkeeper? At $10K+ revenue per year, consider it. A bookkeeper costs $100-300/month and saves you time. But you can do it yourself if you're disciplined about the 15 minutes per week.