Freelance Bookkeeping: Simple Excel Spreadsheet System

Bookkeeping sounds complicated — but for freelancers, it boils down to two simple tasks: recording what you earn and what you spend. That's it. You don't need QuickBooks, Xero, or any paid software. A well-structured Excel spreadsheet handles everything most freelancers will ever need.

This guide shows you exactly how to set up your bookkeeping system, what records to keep, and how to build a weekly routine that takes less than 15 minutes.

Why Freelancers Need Bookkeeping

Three practical reasons:

• Tax compliance. The IRS requires you to report all income, even if you don't receive a 1099. Accurate records make filing much easier and protect you in an audit.
• Quarterly tax estimates. Self-employed freelancers must pay estimated taxes four times per year. Without tracking your income, you'll either overpay or get hit with penalties.
• Understanding your business. Knowing your net profit, your most profitable clients, and where your money is going lets you make better decisions about rates, expenses, and growth.

The 3 Core Records Every Freelancer Needs

1. Income Log

Record every payment you receive. Each row should capture:

Column	What to Enter
Date	Date payment was received
Client	Client name
Project / Description	Brief description of the work
Invoice #	Your invoice number for reference
Amount	Gross payment received
Payment method	Bank transfer, PayPal, check, etc.

2. Expense Log

Record every business expense. Each row should capture:

Column	What to Enter
Date	Date of purchase
Vendor	Who you paid
Description	What you bought and why it's business-related
Category	IRS Schedule C category (see below)
Amount	Amount paid
Receipt?	Yes / No — have you saved the receipt?

3. Summary Sheet

A monthly summary that totals income and expenses and shows your net profit. This feeds directly into your tax return and quarterly estimates. The free spreadsheet above includes this automatically.

Expense Categories for Freelancers (IRS Schedule C)

Using proper categories makes tax filing much simpler. The main deductible categories for freelancers:

Category	Examples
Software & Subscriptions	Adobe Creative Cloud, Figma, Notion, Slack
Home Office	Dedicated workspace (percentage of rent/utilities)
Equipment	Computer, monitor, headset, camera
Phone & Internet	Business-use portion of your phone bill and internet
Professional Development	Online courses, books, certifications
Marketing & Advertising	Website hosting, domain, ads
Professional Services	Accountant fees, lawyer fees
Office Supplies	Desk supplies, printer ink, paper
Travel	Client meetings, conferences (flights, hotels)
Meals (50%)	Business meals with clients (only 50% deductible)
Bank & Payment Fees	PayPal fees, Stripe fees, wire transfer fees

Setting Up Your Excel Bookkeeping Spreadsheet

Structure your workbook with three sheets:

• Income Log — all payments received, with the columns listed above
• Expense Log — all business expenses, categorized
• Summary — monthly totals pulled from the other two sheets with SUMIF formulas

The free download at the top of this page has this structure pre-built with formulas. Just start entering data.

The Weekly Bookkeeping Routine (10 Minutes)

The biggest mistake freelancers make is letting bookkeeping pile up. Set a recurring 10-minute block — Friday afternoon works well — and do the following:

1. Open your bank statement and check for any income received this week. Add each payment to your Income Log.
2. Check your email and receipts folder for business expenses. Add each to your Expense Log with the correct category.
3. Save any receipts to a folder named by month (e.g., 2026-03-receipts).
4. Glance at your monthly summary to confirm the numbers look right.

That's it. 10 minutes per week prevents the 10-hour scramble in April.

How Long to Keep Records

Record Type	How Long to Keep
Tax returns	7 years
Income records (invoices, 1099s)	7 years
Expense receipts	3 years minimum, 7 to be safe
Home office records	7 years after you stop using the deduction
Asset purchases (equipment)	7 years after you dispose of the asset

Store digital copies in a cloud folder. Google Drive or Dropbox with a clear folder structure (year → month) is reliable and free.

When to Hire an Accountant vs. DIY

DIY with Excel is fine if: your income comes from a handful of clients, you have no employees, your expenses are straightforward, and your income is under ~$100,000/year.

Consider hiring an accountant if: you have complex depreciation (expensive equipment), you're considering forming an LLC or S-Corp, your income is growing significantly, or you had a year with unusual events (sold business assets, large one-time income).

Even if you DIY throughout the year, having an accountant review your return once every few years is worth the cost.

Common Freelance Bookkeeping Mistakes

• Mixing personal and business expenses. Open a dedicated business bank account — it makes bookkeeping dramatically simpler.
• Forgetting to record cash or PayPal income. All income is taxable regardless of how it's paid. Record it all.
• Ignoring mileage. If you drive for business (client meetings, supply runs), keep a mileage log. The 2025 standard rate is 70 cents per mile.
• Waiting until tax season. Monthly reconciliation takes 10 minutes. Annual catch-up takes days.
• Not saving receipts. Without receipts, you can't prove an expense in an audit. Keep digital copies organized by month.