Move your books from other accounting software
Export the general ledger and a trial balance by month from any tool, as CSV or Excel up to 30 MB, and upload them under Spreadsheet. Every month-end is checked.
Before you start
- A general ledger export with one row per line: date, account, description, and debit and credit (or one signed amount). A journal number column keeps each entry's lines together.
- A trial balance with one column per month-end, or one trial balance per month-end. This is what every month is checked against.
Steps
Step 1: In your old tool, export the general ledger for your whole history as CSV or Excel.
Step 2: Export the trial balance by month for the same months. If your tool prints one month at a time, export one per month-end with the date in its title or file name.
Step 3: Export the chart of accounts too, so account types come across exactly.
Step 4: In Accountable, press ⌘K and choose Move books from Digits, QuickBooks or a spreadsheet. Pick Move my books, choose Spreadsheet under From and press Continue.
Step 5: Drop the files on Drop your general ledger here, or choose a file. They show as General ledger · N rows, Chart of accounts · N rows and Trial balance · N month-ends.
Step 6: Press Start the move, answer the questions, then press Continue and Go live.
Why the trial balance matters
A general ledger without a running balance has no month-end numbers of its own. Without a trial balance, Accountable rebuilds your history and says Nothing to check against for each month, instead of claiming it ties. With one, every account is checked at every month-end.
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
- Files can be .csv, .xlsx or .txt, up to 30 MB each. Split a bigger ledger by year and upload every part: lines two files share are read once.
- Put Cash Basis or Accrual Basis in a title row and Accountable uses that basis.
- If it says None of these is a general ledger yet, check the file has date, account and amount columns, then upload it again.