DP DeskPrintly
Small Business

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)
Make a Free Copy in Google Sheets →
Included Columns Structure
DateInvoice / Receipt #Client or VendorTax CategoryGross Income ($)Expense ($)Net Cash Flow ($)
Auto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / EntryAuto-calculated / Entry
Ad Slot (In-Content Responsive Ad)

How to Set Up This Template

  1. Make a private copy in Google Drive and rename it with your business name and tax year.
  2. Review the Category List tab (Advertising, Software, Contractors, Home Office, Travel) and customize if needed.
  3. Record every client payment and business receipt weekly to keep your quarterly tax estimates accurate.

Built-In Formulas Explained

  • SUMIFS

    Groups revenue and deductible expenses by both month and IRS-aligned tax category.

  • QUERY

    Generates 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.