Free Self-Employment Ledger Template for Google Sheets
Minimal books for a one-person business — income and expenses in one ledger.
- Who it’s for
- Sole proprietors and self-employed people who want a simple ledger without full accounting software.
- Problem it solves
- Freelancers bounce between invoice PDFs, bank apps, and random sheets. A single self-employment ledger is the classic fix — until data entry kills it.
We’ll email you a copy. No spam.
Key benefits
- Running income and expense register
- Category tags aligned to Schedule C language
- Period totals for month and YTD
- Bridge to P&L and tax prep
- Avery bookkeeping trial so the ledger stays live
The self-employment ledger is a single running book for a one-person business: every business deposit and every business expense, in date order, with categories you can total by month and year-to-date. Copy the free Google Sheet, record the rows yourself, or connect Avery so bank transactions land in the same ledger without a Sunday paste session.
This page is general information, not tax advice. Confirm Schedule C treatment with a qualified tax professional.
Who it's for
- Sole proprietors and single-member LLCs who want one book, not a full accounting suite.
- Freelancers and 1099 workers whose income and expenses currently live in invoice PDFs, a bank app, and a half-finished sheet.
- Side businesses that need a clean record before the year is big enough to justify bookkeeping software.
What's inside
- A running register for business income and business expenses — date, payee, category, and amount on every row.
- Category tags written in Schedule C language, so period totals can transfer to income and Part II expense lines.
- Monthly and year-to-date totals you can close without rebuilding the sheet.
- A straight bridge to a self-employed profit and loss statement and a Schedule C expenses worksheet.
- Room to keep a freelancer expense tracker beside the ledger when you want deduction detail the register does not carry.
The honest part
A ledger only works if the rows are in it. Most self-employment books die the week invoicing gets busy, because nobody wants to retype the bank export. The sheet stays free either way. When the paste-from-bank habit is the thing you skip, Avery Plus ($29.99) keeps the same book live from your bank feed — the ledger, the expense categories, and the P&L stop being three separate chores.
Go deeper
Read the freelance bookkeeping system for one-person businesses, or jump to the self-employment ledger questions for direct answers on setup, Schedule C totals, and when to automate. If you are comparing tools, the accounting software for freelancers guide covers the Avery trial next to spreadsheet books. Pair the ledger with the freelance invoice template when client billing is still happening outside the book.
More Templates
See All Templates- BookkeepingFree
Self-Employed Profit & Loss
A free self-employed profit and loss template for Google Sheets — track freelance and sole-prop income, expenses, and net profit with monthly and year-to-date totals ready for Schedule C and lenders.
- self-employed
- profit-and-loss
- FreelanceFree
Schedule C Expenses Worksheet
A free Schedule C expenses worksheet for Google Sheets — categorize freelancer and sole-prop spending by Schedule C lines so Part II totals are ready for tax prep.
- schedule-c
- expenses
- FreelanceFree
Freelance Invoice Template
A free freelance invoice template for Google Sheets — clean line items, tax and late-fee fields, and a layout you can duplicate per client, then track payment in Avery.
- freelance
- invoice
Frequently Asked Questions
What is a self-employment ledger?
Is this ledger free?
How is a ledger different from a P&L?
Can ledger totals feed Schedule C?
Do I need Avery to copy the ledger?
Helpful next steps
Related guides
Questions & answers
12 answers on setup, deductions, categories, and taxes — written for answer engines and people in a hurry.
Browse all 12 Q&As →