Skip to product information
1 of 3

Papertrails Print

Small-Business Bookkeeping Spreadsheet

Small-Business Bookkeeping Spreadsheet

Regular price $22.00 USD
Regular price Sale price $22.00 USD
Sale Sold out
Instant digital download.
Quantity

A simple bookkeeping spreadsheet for US sole proprietors, freelancers and small businesses who want clear numbers without accounting software.

Type each sale on the Income tab and each purchase on the Expenses tab. Categories are aligned to common IRS Schedule C lines (advertising, contract labor, office expense, supplies, travel, meals and more), and you can rename or add your own. The Monthly P&L shows income, expenses and net profit for every month. Category Totals ranks your top expense categories with a chart and rolls everything up by Schedule C line, a handy starting point for your tax preparer. The Yearly Summary shows total income, expenses, net profit, profit margin, your best month, charts and a comparison with last year.

Anything entered without a valid category shows as Uncategorized, so nothing slips through. Owner draws can be tracked but kept off the P&L, and a 'Receipt saved?' column helps you catch missing receipts before tax time.

Includes a copy with a fictional sample year and a blank copy. This is a record-keeping tool, not tax advice; check deductions with a tax professional.

What's included

  • Bookkeeping workbook (.xlsx) with a fictional sample year
  • Blank copy (.xlsx)
  • Tabs: Start Here, Settings, Income, Expenses, Monthly P&L, Category Totals (with Schedule C roll-up), Yearly Summary, Categories
  • Quick-start guide (PDF, 4 pages)
  • README

Compatibility

  • Microsoft Excel 2010 or newer (Windows and Mac) and Microsoft 365
  • Google Sheets (upload the .xlsx to Google Drive, then Open with > Google Sheets)
  • No macros or add-ons. Tested in LibreOffice Calc; uses functions available in both Excel and Google Sheets.

File format

  • .xlsx workbook (sample copy + blank copy) and a PDF quick-start guide, delivered as an instant download.

Digital download, no physical item shipped.

View full details