Move your books from Xero

Steps

1. 1

   Step 1: In Accountable, press ⌘K and choose Move books from Digits, QuickBooks or a spreadsheet. Pick Move my books, choose Xero under From and press Continue.

2. 2

   Step 2: On Connect your old books, press Connect Xero and sign in to Xero.

3. 3

   Step 3: If you have several organisations, pick this company's under Which Xero organisation is this company?, then press Use this organisation.

   Tap to enlarge

4. 4

   Step 4: Press Start the move. Accountable reads the accounts, journals, contacts, attachments and tracking categories, and each month's trial balance.

5. 5

   Step 5: Read the proof, answer any question, then press Continue and Go live. Months before Xero's lock date arrive closed.

Or upload Xero's files

1. 1

   Step 1: In Xero, go to Reporting › All reports and open General Ledger Detail. Pick all Accounts and a Date range from your first transaction to the last month-end, then click Update.

2. 2

   Step 2: Under Columns, add Account code and Account Type, set Grouping/Summarizing to None, then click Export › Excel.

3. 3

   Step 3: For the proof, open Reporting › All reports › Trial Balance for the last month-end, use Compare with to add every earlier month, and export it to Excel. It shows as Trial balance · N month-ends.

4. 4

   Step 4: For the chart of accounts, go to Accounting › Chart of accounts and click Export.

5. 5

   Step 5: In Accountable, press ⌘K and choose Move books from Digits, QuickBooks or a spreadsheet. Pick Move my books, choose Xero under From and press Continue.

6. 6

   Step 6: On Connect your old books, press Upload a Xero export instead, drop the files, and press Start the move.

What moves from Xero

• Every account, every journal, every contact, attachments, and tracking categories as tags.
• Months before your lock date arrive closed.
• Not moved: bank rules, repeating invoices and budgets.

What Accountable does with the files

• Reads every entry, account and vendor, and rebuilds your chart of accounts and history in a draft. Nothing is in your books until you press Go live.
• Checks every month-end, account by account, against your old tool's own numbers and your bank and card statements. A month ties only when the difference is exactly $0.00.
• Asks you about each month that doesn't tie, one question at a time, with the fix it suggests.
• Lets you undo the whole move for 30 days after you go live.

How long it takes

• Reading and checking takes seconds: 1,842 Digits transactions took 5 seconds, and 20,000 transactions from a general ledger file took 7 seconds.
• Going live posts the history in batches of 5,000: 20,000 transactions took about 7 seconds.
• You can leave the page while it works. The move keeps going, and the page shows where it got to when you come back.

Good to know

• You need the administrator, standard + reports or viewer role in Xero to run these reports.
• Xero lets an app make 5,000 requests a day. A long history can pause and pick up the next day by itself; the move says when.

Related articles

• Move your books to Accountable
• How the month-end proof works
• What moves to Accountable, and what doesn't
• Go live with your moved books, or undo the move