Small Business Bookkeeping Spreadsheet

For freelancers and small businesses in the US who want their records in order without accounting software. Add invoices and receipts as they happen; the monthly profit and the year summary fill in by themselves, with each expense category named after its Schedule C line.

What is inside

• Income: one row per invoice or sale, marked Paid or Owed.
• Expenses: one row per receipt, in 20 categories, each matched to a Schedule C line.
• Mileage: business trips valued at the rate you enter, with a per-trip rate if it changes during the year.
• Monthly P&L: income received, expenses, mileage, profit, the share you set aside for tax, and what is still owed.
• Year Summary: expenses by category with the Schedule C line for each.
• A sample copy and a blank copy.

Monthly profit and loss

Income and what is still owed

Expenses by category

Year summary

Record-keeping tool, not tax, legal or accounting advice. The tax set-aside is the share you choose, not a tax calculation. Sample numbers are examples.

The spreadsheet

$7

One payment, instant download of the sample and blank workbooks. Checkout is handled by Polar, our merchant of record. If it does not work for you, write within 14 days and we will refund it.

See two months worked through: a small business bookkeeping example.

How to use: in Google Sheets choose File, Import, Upload and pick the .xlsx file, or open it in Excel. Cream cells are for typing; green cells calculate.