Canonical page: https://bokeping.com/solutions/switching/spreadsheets/

Markdown page: https://bokeping.com/solutions/switching/spreadsheets.md

Text version of the public page. Check the canonical page for current terms and interactive features.

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.

[Start for free](<https://app.bokeping.com/auth/signup>)[See the setup guide](<https://bokeping.com/resources/guides/>)

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.  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.  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.  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.  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.  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](<https://bokeping.com/solutions/integrations/import/>)
    
6.  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](<https://bokeping.com/products/reports/financial-statements/>)
    
7.  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](<https://bokeping.com/products/banking/bank-feeds/>)
    

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 import](<https://bokeping.com/solutions/integrations/import/>)[Set up your books in an afternoon The step-by-step for everything after the import: fiscal year, sales tax, first invoice, first close. Guides](<https://bokeping.com/resources/guides/>)[Give your accountant real books Double-entry, an audit trail and period lock — 2 free accountant seats on every plan. For accountants](<https://bokeping.com/solutions/accountants/>)

FAQs

## Fair questions about leaving the sheet

### Can I keep the spreadsheet running in parallel?

Keep it as a read-only fallback for a quarter, yes. Keep updating it, no — this is the one parallel run that reliably goes wrong, because a sheet is easy enough to edit that you will keep doing it, and then you have two records that disagree and no way to tell which one is right. Enter the next transaction here, and let the old file go quiet.

### What if I switch mid-year?

Perfectly normal, and easier from a spreadsheet than from anywhere else. Pick the first of a month and import the year to date so one place reports the whole year. If the earlier months are messy, import from the cut-over date only and keep the sheet as the record for the stub period — your accountant will simply add the two halves at year end.

### Who checks the opening balances?

You or your accountant should compare bank balances with statements, unpaid customer invoices with your records, and vendor balances with the bills you owe. Review other opening accounts and check that imported history has not also been entered as an opening balance. Each plan includes 2 free external accountant seats. Take the time needed to resolve differences before relying on the reports.

### What does it cost to move?

CSV import is included on every plan at no extra cost. Each account gets one Pro trial, starting when you create your first company. Other companies you create during that trial share the same end date. When the trial ends, each company moves to Free unless you choose a paid plan for it. Companies created after your trial ends start on Free. Free is $0, with 20 of each kind of sales and purchase record a month. Each company is billed separately. Standard is $29 a month ($290 a year) for automatic bank feeds, unlimited records, inventory, purchase orders, and up to 3 users. Pro is $59 a month ($590 a year) for up to 10 users, roles and permissions, and multiple locations within one company.

### Can I upload any bookkeeping spreadsheet unchanged?

No. Prepare separate files for supported record types and match their required fields and document-line structure. Formulas, formatting, attachments, and unsupported columns do not become working Bokeping features. Preview the file, review the results, and retain your original workbook.

Switching from something else?[From QuickBooks](<https://bokeping.com/solutions/switching/quickbooks/>) ·[From Xero](<https://bokeping.com/solutions/switching/xero/>) ·[Switching overview](<https://bokeping.com/solutions/switching/>) ·[Ask us first](<https://bokeping.com/resources/contact/>)

## Bring the spreadsheet in

File import has no additional fee. Prepare supported records, review the preview and results, and keep your original workbook.

[Start for free](<https://app.bokeping.com/auth/signup>)

## 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.

[Start for free →](<https://app.bokeping.com/auth/signup>)
