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
- Works with manual entry; optional Avery plans for bank imports and app features
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.
When to add Avery
Avery Pro brings accounts, expenses, invoices and reports together in the mobile and web apps. Business adds recurring invoices, payment reminders and advanced bookkeeping tools. If you prefer a spreadsheet workflow, Avery for Google Sheets imports transactions from supported accounts, with categories and rules for you to review. Compare the plans. The free template also works with manual entry.
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 — clear answers for your next review.
Browse all 12 Q&As →Bring your business finances together.
Use Avery Pro for accounts, expenses, invoices and reports. Prefer spreadsheets? Explore Avery for Google Sheets.