When to stop using spreadsheets for bookkeeping, and how to move
Stop using a spreadsheet for bookkeeping when any of these is true: you have more than about 100 transactions a month, more than one bank or card, a CPA or investor asking for a balance sheet, more than one company, or a month you cannot prove against the bank. The IRS accepts any system that clearly shows income and expenses, so the trigger is reliability, not law. Moving takes one general ledger file.
Updated · 5 min read · By the Accountable team
The short version
- The IRS lets you choose any recordkeeping system that clearly shows your income and expenses, so a spreadsheet is legal.
- Six signs mean it is time: volume, several accounts, investor or CPA requests, several companies, a month that will not match the bank, and errors you find late.
- Accounting software balances every entry, matches accounts to bank statements and locks closed months; a spreadsheet does none of that unless you build it.
- Free plans exist: Accountable Free, Kick Free and Mercury Books through 2026, and paid entry starts at $25 a month on Xero Early.
- A general ledger file with a date, an account, and debit and credit columns moves your history in; every month is checked against your own numbers.
The IRS allows spreadsheets, so the real test is whether you can prove the numbers
The IRS says you may choose any recordkeeping system suited to your business that clearly shows your income and expenses, and that the law does not require a special kind of records. A spreadsheet can meet that standard.
What a spreadsheet cannot do alone is prove itself. Nothing checks that every entry balances, that a total matches a bank statement, or that last quarter stayed unchanged after you closed it. That is what you outgrow.
Six signs a spreadsheet has stopped working
- Volume: you have more than about 100 transactions a month. That is our rule of thumb, and it is also the size of Accountable's free tier, which categorizes the first 100 a month.
- Several accounts: you keep more than one bank, card or payment processor, and matching each takes an evening.
- Requests: a CPA, lender or investor asks for a balance sheet or cash flow statement you cannot produce without rebuilding.
- More than one company: you copy the same tabs for each entity and move money between them.
- A month that does not match: your cash figure differs from the bank and you cannot find the gap.
- Late errors: you find a mistake in a closed month, fix it, and cannot say what else changed.
Two signs are enough. One sign means plan the move before your next tax season.
What accounting software does that a spreadsheet does not
| Job | Spreadsheet | Accounting software |
|---|---|---|
| Every entry balances | You check each total by hand | Debits must equal credits before an entry posts |
| Bank transactions | You paste or retype them | Feeds bring them in and skip duplicates |
| Match to the statement | A formula you build and maintain | Each account reconciled to its statement |
| Closed months | Anyone can overwrite a cell | A closed month is locked, and reopening is logged |
| Who changed what | Version history if you remember to look | A change log on every entry, with undo |
| Reports | Formulas you write | Profit and loss, balance sheet and cash flow from the same entries |
Moving costs $0 to $140 a month, and the move itself is free on Accountable
| Option | Price per month | Limit worth knowing |
|---|---|---|
| Accountable Free | $0 | 1 company; the first 100 transactions a month are categorized automatically |
| Kick Free | $0 | 1 entity; 250 transactions categorized a year |
| Mercury Books | $0 for all of 2026, then $35 | Needs a Mercury account |
| Xero Early | $25 | 20 invoices and 5 bills |
| Puzzle Starter | $30 | 1 seat, 25 lifetime AI credits |
| QuickBooks Simple Start | $38 | 1 user plus 2 accountant seats |
| Kick Basic | $40 | 1 entity, unlimited categorization |
| Accountable Pro | $149 | 2 companies, every transaction categorized, continuous close |
A $25 to $149 monthly subscription replaces the evening a month most founders spend matching a spreadsheet to their bank.
Move a spreadsheet in five steps
Step 1: Choose a cutover month-end, such as the last day of last month, and decide whether to bring all history or start from opening balances.
Step 2: Shape the sheet as a general ledger: one row per line, with date, account, description, and debit and credit (or one signed amount). A payment is two lines.
Step 3: List your accounts in a chart of accounts, and gather a bank and card statement for each month-end.
Step 4: Load the file. In Accountable, press ⌘K, choose Move books from Digits, QuickBooks or a spreadsheet, pick Move my books and Spreadsheet, then drop the file. Files can be .csv, .xlsx or .txt up to 30 MB.
Step 5: Read the proof, answer the questions for any month that does not tie, then press Go live. You can undo the whole move for 30 days.
Spreadsheet row: May 3, Figma, -$1,200.00, Software.
Ledger line 1: May 3, Software expense, debit $1,200.00.
Ledger line 2: May 3, Checking, credit $1,200.00.
The two lines balance, so the entry posts. A row that does not balance is the first thing the proof finds.
Keep the spreadsheet as a record after you move
The IRS says keep records for 3 years from filing in the usual case, 4 years for employment tax records, 6 years if you leave out income above 25% of gross income, and 7 years for a bad debt claim. Save the final spreadsheet with your bank statements and receipts. Accountable checks every month-end against the file's own numbers, so the spreadsheet stays the answer key for the move.
Questions founders ask
Can I do my bookkeeping in Excel or Google Sheets?
Yes. The IRS accepts any recordkeeping system that clearly shows income and expenses. The risk is accuracy, not legality.
When should a startup stop using a spreadsheet?
When volume passes about 100 transactions a month, you add a second bank or company, or a CPA or investor asks for a balance sheet. Plan the move before tax season.
How much does accounting software cost to replace a spreadsheet?
From $0 on Accountable Free, Kick Free or Mercury Books (through 2026), to $25 to $149 a month on paid plans.
Can I import a spreadsheet into accounting software?
Yes. Any general ledger with a date, an account, and debit and credit columns loads into Accountable as CSV or Excel up to 30 MB, and each month-end is checked against your file.
Do I need to keep my spreadsheet?
Yes, with your statements and receipts. Keep records at least 3 years from filing in the usual case.
Bring your spreadsheet in and have every month checked to the cent
Accountable moves books from Google Sheets, Excel or a general ledger export for free. It rebuilds every month and checks it against your file's numbers, and Free covers one company.
Move my spreadsheet for freeSources, checked September 30, 2026: