Free bookkeeping spreadsheet for freelancers.
It's built from the bookkeeping sheet an accountant runs his own business on, minus the parts that fill themselves in. Works in Excel and Google Sheets.
Download the spreadsheetFree, no sign-up. In Google Sheets: File, then Import, then Upload.
What's inside
- Dashboard
- Money in, money out, profit and cash at a glance, with charts and a plain-English summary of the year.
- Transactions
- Paste your bank and card rows in and pick a category. Rows still to categorize turn yellow.
- Profit & loss and balance sheet
- Real double-entry reports for any dates you pick, and the balance sheet tells you when it balances.
- Reconciliations
- Type each statement's ending balance. It says Reconciled when the books match the bank.
- Mileage & home office
- A trip log at the IRS rate for each date, plus the simplified home office deduction.
- Chart of accounts
- Numbered accounts with every expense mapped to its Schedule C line, plus journal entries for anything not in the bank.
Rather not type it in?
Sheetkeep is the full version of this sheet, kept for you. Your bank feeds it every morning, AI picks the categories, and the books are checked against the bank every day. You only look at the few it isn't sure about. Free for a week, no card needed.
Start my free week