Switching / From Spreadsheets
Turn supported spreadsheet records into books.
Prepare a separate CSV/XLSX file for each supported record type, review the mapping and preview, then reconcile the imported records. Keep your original workbook for formulas and unsupported detail. Timing depends on file quality and the records you need to bring.
Before you start
Three decisions before you import
This is the friendliest switch there is — no export screens, no file formats, no account to close. It goes wrong in only one way: an unclear starting point. Settle these three first.
Pick a clean cut-over date
The first of a month is good; the first of your tax year is better. Your sheet probably already has a natural break — the last month you totaled up and felt finished with. Use that one.
Decide how much history you actually need
Decide which supported records and periods you need in Bokeping, and what will remain in your archive. Check the import templates before preparing the data, especially if your workbook mixes record types or years.
Keep the sheet read-only for a quarter
Do not delete it — but stop typing into it. Save a copy, rename it something you would never open by accident, and keep it as a fallback while you build trust in the new numbers. The risk here is not losing the file; it is quietly maintaining two.
The sequence
Seven steps, and four of them are tidying
Check the required fields, document lines, numbers, and dates before uploading. File-level errors can stop an import; review the final result before correcting failed records.
- 1
Work on a copy, never the original
Duplicate the file first and clean the duplicate. Everything below is destructive — deleting header art, unmerging cells, flattening formulas — and you want the original sitting untouched next to it while you do it.
- 2
Use the template for each record type
Keep one header row and remove decorative headings, blank spacer rows, and merged cells. Separate customers, vendors, items, and transaction types into the appropriate files. Follow the template for document lines: an invoice or bill may occupy several rows, which must stay together.
- 3
One idea per column — and no subtotals
Date, description, who it was with, amount, category. Delete monthly subtotal rows and running-balance columns; those are outputs, and Bokeping computes them from the transactions. If money in and money out live in two columns, that is fine — just keep it consistent all the way down.
- 4
Amounts as numbers, dates in one format
Strip currency symbols, thousands separators typed by hand, trailing spaces and footnote asterisks — a cell holding “$1,234.00 ” is text, not money. Write negatives with a minus sign rather than brackets. Then pick one date format, 2026-03-14 or 03/14/2026, and make the whole column match: a column mixing “4/5” with “April 5” is the single biggest source of flagged rows.
- 5
Export each tab as its own CSV, then import in order
Prepare one file per supported record type: customers and vendors first, then items, then the documents that use them. Review the suggested mappings and preview before confirming. Check the final result and retry corrected failed records, keeping all lines of each affected document together. Do not assume that re-running a changed file will skip every record already imported.
How column mapping works - 6
Set your opening balance from a bank statement
An opening balance is what was true on the morning of your cut-over date. Take the bank statement covering that date and use the closing balance from the last line before it — the statement figure, not today’s app balance and not the available balance. Then list the invoices customers still owed you on that date, and the bills you still owed. Those three figures are the floor everything else is measured from, which is why they come from a statement rather than from the sheet you are replacing.
Financial statements in Bokeping - 7
Close the spreadsheet for good
Shadow copies die of a thousand “just this ones”. Two things end it: enter the next transaction only in Bokeping, and connect the bank feed — Plaid, read-only, included from Standard up — so most entries appear without you typing them. Then rename the file to something ugly, move it out of your working folder, and set yourself a date after your first clean reconciliation when you stop opening it.
How bank feeds work
The honest inventory
What comes across, and what doesn’t
What comes across
Supported records and fields. Customers, vendors, items, invoices, bills, and bank activity use their respective imports. A table must match the supported fields and required values; an arbitrary worksheet is not automatically an importable accounting record.
History prepared in manageable batches. The web upload accepts files up to 5 MB. Split larger exports without splitting a document’s lines across files. Track successful records and check for overlaps; duplicate checks depend on the record type and identifiers.
Open invoices with what is still owed. Import the supported invoice fields, then review the payments and allocations needed to establish the balance due. A “paid” label or an outstanding-amount column alone does not recreate the full payment history.
Bank history straight from the bank. Your bank’s own CSV export is a better source than your sheet for the bank side: it has every line, in the bank’s wording, with no typos. Import that rather than retyping.
Your description column. Map notes to a supported description or reference field where one is available, respecting its length limit. Unmapped columns and spreadsheet comments are not automatically preserved as transaction notes.
Opening balances to reconcile. Prepare the remaining opening balances from reliable records at the cut-over date. Account for imported history so the same receivable or payable is not entered twice, then compare reports and reconcile bank balances.
What doesn’t
Formulas, and the reasoning inside them. Values import; formulas do not. A cell showing 1,240 that is really a SUM arrives as 1,240 and nothing else. Where a column was doing your accounting for you — allocating, prorating, accruing — that job now belongs to the ledger, so check the numbers those columns produced before you rely on them.
Color coding and highlighting. Yellow means “chase this” to you and nothing at all to a computer. Before you export, turn the colors into an actual column — a Status or Category value — or accept that the meaning stays behind with the fill.
Cell comments, notes and merged title rows. Anything living outside the grid is invisible to a CSV. If a comment holds something you need, move it into the description column first.
Pivot tables, charts and running balances. These are reports, not records. Bokeping regenerates the equivalents from the transactions themselves, which is the point — they can never disagree with the ledger the way a stale pivot can.
Receipts in the folder next to the sheet. Scans and PDFs stored alongside the file are not part of it. Attach the ones that matter to their transactions here, or keep the folder as your archive.
Whatever your side tabs were quietly doing. A payroll tab, a job-costing tab. Those are the ones to check before you assume the sheet is finished — see the note below. A tab per company is the exception: one login can hold several companies, each with its own books, so those tabs become separate sets of accounts rather than a problem.
Bokeping does not sell payroll, file tax returns, or do project and job costing. It also does not consolidate several companies into one set of accounts — you can run more than one company from a single login, each with its own books and its own plan, but the group roll-up still happens outside. If one of your tabs was doing that work, keep doing it where it is — a payroll provider such as Gusto or ADP, your filing agent, a consolidation sheet at group level — and post the resulting figures into Bokeping so the ledger stays complete.
Suggested sequence
Prepare, import, verify, then begin daily work.
Step 1
Clean the copy
Separate record types, use the matching templates, unmerge cells, and check numbers and dates.
Step 2
Import and map
Confirm mappings and preview each file. Read the final result and retry corrected failed records without repeating successful ones.
Step 3
Opening balance, bank connected
Compare bank balances and unpaid documents with source records at the cut-over date, accounting for history already imported.
Step 4
First invoice out
Numbered, taxed and tracked as a document you can chase — rather than a row you remember to look at.
Step 5
First reconciliation
The week’s feed against the bank. This is the moment the spreadsheet stops being necessary.
Then keep the old file read-only for a quarter — and notice, somewhere around week three, that you have not opened it once.
While you are here
The three things people check next
What the importer actually does
The mapping preview, duplicate detection, and the report that gives every row a verdict with its row number.
CSV & QBO importSet up your books in an afternoon
The step-by-step for everything after the import: fiscal year, sales tax, first invoice, first close.
GuidesGive your accountant real books
Double-entry, an audit trail and period lock — 2 free accountant seats on every plan.
For accountantsFAQs
Fair questions about leaving the sheet
Switching from something else?From QuickBooks ·From Xero ·Switching overview ·Ask us first
Bring the spreadsheet in
File import has no additional fee. Prepare supported records, review the preview and results, and keep your original workbook.
Ready to know your money?
Free plan, no card needed. Bring your QuickBooks or spreadsheet history, invite your accountant, and start reading your own books today.