Small Business
Make a Free Copy in Google Sheets →
Free Small Business Bookkeeping Spreadsheet (Google Sheets & Excel)
Single-entry income & expense ledger with IRS Schedule C friendly categories and automated monthly P&L.
Ready-to-Use Google Sheets Workbook
Private copy in your Google Drive • Compatible with Excel (.xlsx)
Included Columns Structure
| Date | Invoice / Receipt # | Client or Vendor | Tax Category | Gross Income ($) | Expense ($) | Net Cash Flow ($) |
|---|---|---|---|---|---|---|
| Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry | Auto-calculated / Entry |
Ad Slot (In-Content Responsive Ad)
How to Set Up This Template
- Make a private copy in Google Drive and rename it with your business name and tax year.
- Review the Category List tab (Advertising, Software, Contractors, Home Office, Travel) and customize if needed.
- Record every client payment and business receipt weekly to keep your quarterly tax estimates accurate.
Built-In Formulas Explained
-
SUMIFSGroups revenue and deductible expenses by both month and IRS-aligned tax category.
-
QUERYGenerates a live Profit & Loss (P&L) summary table by quarter for estimated tax payments.
Frequently Asked Questions
Is this bookkeeping spreadsheet suitable for sole proprietors and single-member LLCs?
Yes, it is built around simple cash-basis income and expense tracking ideal for freelancers, consultants, and micro-businesses.
Does it calculate quarterly estimated taxes?
The P&L tab displays net profit per quarter so you or your CPA can apply your federal and state tax rate.