All Collections
Puzzle FAQs
FAQ: Historical Books Migration
FAQ: Historical Books Migration
Arash Ahmadi avatar
Written by Arash Ahmadi
Updated over a week ago

Q: Would I use both Puzzle and QuickBooks?

A: No. Puzzle is a modern alternative to QuickBooks. You can connect to QuickBooks in order to 1) start the data migration process and 2) maintain your historical QuickBooks reports, even after canceling your QuickBooks subscription.

Q: Will my general ledger and financial statements in Puzzle sync QuickBooks?

A: No. Puzzle is a modern alternative to QuickBooks. The QuickBooks integration imports your QuickBooks reports and enables us to migrate your historical books, but it does not sync the journal entries in QuickBooks to Puzzle or the other way around.

Q: What does connecting my QuickBooks Online account do?

A: Connecting your QBO account enables you to:

  1. View your historical financial statements (in their original format) within Puzzle's “Reports” page to maintain your historical records within Puzzle, even after you cancel your Quickbooks subscription

  2. Migrate your historical financial statements to Puzzle's format by requesting migration services.

Q: How do I start the migration process?

A: You can start the process by indicating that you have historical books you would like to migrate over during sign-up. If you've already signed up, you can start the process from the Settings page. If you have any questions, email us at [email protected]

Q: When my QuickBooks financial statements are migrated to Puzzle, what financial statement detail should I expect to actually see in Puzzle??

A: There are three options when migrating to Puzzle. Which you choose depends on the level of detail you wish to migrate over:

  1. Point-in-time opening balances: A journal entry is used to set up your balance sheet as of a particular date (e.g. 12/31/2023). This is typically used when you want to start a new year in Puzzle with a clean slate and you have a separate system of record (e.g. Excel files) with your financials before that date.

  2. Monthly summary totals: The totals for your balance sheet and income statement accounts are entered into Puzzle based on your historical trial balance. This option enables you to see all of your financial statements in Puzzle, including those from before using Puzzle.

  3. General ledger migration: All the journal entries from your historical general ledger are entered into Puzzle as “historical journal entries.” This option provides the greatest amount of detail of your historical books in your Puzzle account.

Q: Is there anything you do not migrate over?

A: We currently do not bring over your full custom chart of accounts (yet!). We do create specific accounts, when requested. Otherwise, everything will be mapped to Puzzle’s standard chart of accounts. We do not bring over historical data for:

  • Invoices (AR)

  • Bills (AP)

  • Vendor and customer information

Q: If I’m on QuickBooks Desktop, Xero, or another accounting software, can you migrate me to Puzzle?

A: Yes! We use the same technique to migrate data to Puzzle as we use for QuickBooks Online. If we are transferring over files from an accounting system outside of QuickBooks Online, we will require a copy of your financial files in Excel, CSV, or PDF format.

Q: If my financials are in Excel, can you migrate me to Puzzle?

A: Yes! We use the same technique to migrate data to Puzzle as we use for QuickBooks Online. We will require a copy of your financial files in Excel, CSV, or PDF format.

Q: I have multiple years of financial history in another system. Does this matter?

A: Nope - We can migrate as many years of financial history as needed.

Q: Do you support migration for multi-entity books or entities with multiple currencies?

A: We currently migrate single-entity books from Xero or QuickBooks that use the US dollar as the only reporting currency. We currently do not support migration for foreign subsidiaries, entities with multi-currencies, or entities that require consolidated financials in Puzzle. However, all these things and more are on our roadmap! We encourage you to send us your feature requests by emailing [email protected]

Q: How do I ensure my QuickBooks transfer was successful?

A: Our team will check that all historical monthly balances in Puzzle match your balances in QuickBooks. We will also perform any reconciliations needed (at the time of your migration date) to ensure accounts are balanced. We will also email you the mapped accounts so you can review the migration balances.

Q: What happens after migration?

A: You can start autonomous accounting in Puzzle!

Note: You can start using Puzzle before the migration too! This is common for users who want to maintain their current books while their historical books are being prepared. However, the data from before the "cutover date" will be removed and replaced with the imported data.

Q: Can I cancel my QBO account once I’ve migrated to Puzzle?

Yes. If you cancel your QBO account, your reports will still be saved in Puzzle. Changes in QBO subsequent to the Puzzle migration will not update your general ledger in Puzzle. Upon request, we can adjust balances and mappings to make sure everything is updated for you.

If you’ve connected your QuickBooks account to Puzzle, your Quickbooks balance sheet, profit & loss, and trial balance will also be available in Puzzle on the “Reports” page. We recommend downloading and retaining your QuickBooks files, including your general ledger export, before closing your account.

Did this answer your question?