Moving to FreshBooks: data export, opening balances, and accountant review

Affiliate disclosure: This article contains affiliate links. I may earn a commission if you buy through them, at no additional cost to you.

Research checked October 5, 2026. This is a documentary guide based on the official sources linked below. It does not claim personal product testing.

Moving to FreshBooks should preserve accurate records and a clear starting point. The goal is a controlled accounting transition, not just a successful contact import. Choose a cutover date, keep source evidence, and have your accountant approve the opening position.

If this fits your requirements, check FreshBooks’s current offer while you work through this guide.

This guide gives you a migration checklist. It does not prescribe journal entries for every business. The accountant should determine the treatment of balances and historical transactions for your actual circumstances.

Define the migration scope

List clients, invoices, payments, expenses, receipts, bills, bank accounts, items, projects, and reports. Identify which data must move into the new system and which can remain in a secure historical archive.

Do not assume every attachment, custom field, or relationship transfers through a CSV. Test the destination’s supported import method and inspect a sample. An imported client name does not prove its invoice history and payment records arrived correctly.

Record the current software version, account owner, subscription expiry, and export access. Keep the old service available until the agreed migration tests pass.

Choose a cutover date with the accountant

A clean period boundary can make reconciliation easier, but the right date depends on the business. Decide how transactions before and after that date will be recorded.

Write who issues invoices during the transition and which system receives payments. Without a rule, both systems can create income for the same transaction.

Keep a list of transactions in progress: unpaid invoices, partially paid projects, refunds, processor balances, and bank transactions that have not cleared. Those items need deliberate treatment.

Export and preserve source records

Use the old provider’s official export process and save relevant reports and transaction detail. FreshBooks’s export guide is useful for understanding later data access from the new system too.

Keep original exports separate from transformed import files. Label the source, date range, accounting basis, currency, and export date. A file named final.csv is not enough context for a future reconciliation.

Preserve invoice PDFs, receipts, agreements, and other evidence required by your record-retention obligations. Store them securely with appropriate access. A summary report does not replace every underlying document.

Clean a sample before importing everything

Standardize client names, email addresses, currencies, tax identifiers, and field formats. Resolve obvious duplicates with a documented rule rather than deleting records casually.

Read the client guide and inspect the destination’s structure. Map secondary contacts appropriately rather than creating a separate client for every person at one organization without considering the billing relationship.

Import a small appropriate sample and review the resulting records. Check amounts, dates, currency, status, and links. Fix the mapping before the full import.

Agree the chart of accounts

Review the FreshBooks chart-of-accounts guidance with the accountant. Decide how existing categories map to the new structure.

Do not create dozens of new accounts merely because the old system had them. Preserve the necessary financial meaning while keeping the structure appropriate to the business and supported software.

Document differences so later comparisons remain understandable. A change in category naming should not make the team think spending disappeared.

Opening balances need evidence

Obtain the accountant-approved closing position from the old system and the supporting statements. Opening balances should connect to that evidence, not a number entered to make the new dashboard look right.

For bank reconciliation, follow the official setup instructions for dates and balances. Check whether outstanding transactions need separate treatment.

Ask the accountant how unpaid invoices, accounts payable, inventory, taxes, loans, and equity should be represented. Do not use an unexplained balancing adjustment to conceal an unresolved difference.

Prevent duplicate bank-feed activity

When connecting a bank, check the transaction import range. Compare it with the period already imported or entered. A feed can contain transactions that the migration has already recorded.

Define how imported invoices and their later deposits will be matched. A bank deposit should not become duplicate revenue simply because it arrives after the cutover.

Test one invoice paid before cutover, one paid afterward, and one partially paid. Confirm that reports and balances reflect the intended treatment.

Configure payments and customer communication

Read the invoice guide and verify available payment methods for your region and provider. Set business details, invoice numbering, terms, and payment instructions carefully.

Tell customers which outstanding invoices still use old instructions and which new invoices use the new system. Avoid sending replacement invoices that look like duplicate demands.

Test an ordinary invoice, a credit or correction where supported, and a payment. Check what the customer receives and what the accounting record shows.

Reconcile before declaring the migration finished

Compare client balances, unpaid invoices, bank balances, and the agreed financial reports between the approved source position and the new setup. Investigate each difference.

Keep a discrepancy log with item, amount, cause, owner, and resolution. A total matching by coincidence is not enough if the underlying records differ materially.

Ask the accountant to approve the opening position and initial reporting. Save that signoff with the mapping and source files. It gives the business a clear point from which ongoing bookkeeping begins.

Retire the old service deliberately

Verify required data access, retention, recurring payments, integration removal, and customer instructions before cancellation. Save the cancellation confirmation and any remaining billing obligation.

Keep an operating guide for the new system: who sends invoices, categorizes expenses, reconciles, exports reports, and grants access. A migration is complete when the business can maintain the records accurately.

Review FreshBooks’s current plans and supported migration options. Move with a documented cutover and accountant-reviewed balances rather than trying to reconstruct the evidence afterward.

Official sources and next steps

• support.freshbooks.com/hc/en-us/articles/360032628152-How-do-I-export-my-data
• support.freshbooks.com/hc/en-us/articles/217181797-What-are-clients
• support.freshbooks.com/hc/en-us/articles/360006976571-What-is-the-Chart-of-Accounts
• support.freshbooks.com/hc/en-us/articles/360040117691-How-do-I-set-up-bank-reconciliation
• support.freshbooks.com/hc/en-us/articles/216631328-How-do-I-create-an-invoice

Compare the requirements above with your business before buying. You can find the tools covered on this site on the Resources page.

Build the business behind the tools

The tools in this guide are part of a bigger picture. At Ecommerce Paradise, I teach how to build and run a high-ticket ecommerce business. Start with a clear business model, then choose the tools that help you execute it.

If you are still figuring out the model, read my high-ticket dropshipping guide. You will understand the relationship between your store, suppliers, customers, and profit before spending money on software.

For product research, use my high-ticket niches list to explore categories and narrow down your ideas. Go deep before you go wide.

Next, work through my supplier sourcing guide so you know how to research manufacturers and approach them about becoming an authorized dealer.

My business formation checklist helps you organize the legal and financial setup. Use it to prepare your questions and confirm the requirements that apply to your business.

Get help putting the pieces together

If you want me to help you work through your next decisions, check out my private coaching. Bring your actual questions so we can focus on what is holding you up.

If you want a complete business build, take a look at the done-for-you store service. Review the scope and choose the support that fits your situation.