How do I convert my books into Kontuly from another package?
In Kontuly, set up a new, empty business, then open Import & export → Convert from another package and work through the steps: choose your old package and conversion date, add the files you exported, check the review and click Import…. Nothing is saved until that last click.
- Set up a new business with New business in the business switcher. Converting into a business that already has transactions adds opening balances alongside them.
- Open Import & export in the sidebar, under Settings, and choose the Convert from another package tab.
- Choose Converting from and the Conversion date. What to export from … then lists the five files to export from your old package, with the menu path for each. Run every report as at the day before the conversion date. Click Next.
- Add each file. For accounts, contacts, the trial balance, open invoices and open bills, click Choose file…. Kontuly matches the columns; check the Header row and each Column in the file, and change any that are wrong. Only the trial balance is required.
- Check the accounts. For each account, check its Type, Report group and Tax code. Archive unused starter accounts (ticked to begin with) tidies away the accounts Kontuly set up that your old chart doesn't use.
- Check the totals. The trial balance should balance, and the open invoices and bills should equal accounts receivable and payable in the trial balance.
- Review. Under Balances without an account, pick the account for any line that didn't match. Read the Issues; errors must be fixed, warnings needn't be.
- Decide on the lock. Lock the books on and before the day before the conversion date is ticked to begin with, so nothing is posted into the period your old package covers.
- Click Import…, then Import to confirm. Kontuly takes a backup first.
You'll see Conversion complete, with buttons for the Trial Balance, Aged Receivables and Aged Payables reports. Check them against the same reports from your old package.
What does the import post?
One conversion journal, dated the day before the conversion date, holding every opening balance; each unpaid invoice, bill or credit note as an approved document for its unpaid amount; and a starting reconciliation for each bank account at its converted balance.
Why does it ask about tax in unpaid invoices and bills?
If you report GST on the cash basis, the GST in unpaid invoices and bills hasn't been reported yet, so Tax included in unpaid invoices and bills splits it out. It then reaches your BAS when the payment is recorded. On the accruals basis it was already reported, so they come in without tax.
The totals don't agree
Anything that doesn't agree goes to an equity account called Historical Adjustment. See What is the Historical Adjustment account?
My Excel file won't open
Older .xls files can't be read. Open them in Excel and save as .xlsx or .csv. Files can be up to 25 MB and 50,000 rows.
Related questions
- Can I switch to Kontuly from MYOB, Xero, QuickBooks, Reckon or Sage?Yes. Kontuly converts your chart of accounts, contacts, opening balances and unpaid invoices and bills from MYOB, Xero, QuickBooks, Reckon or Sage.
- What is the Historical Adjustment account in Kontuly?Historical Adjustment holds anything that doesn't agree when you convert your books into Kontuly. When everything agrees, it ends at zero.
- How do I undo or redo a conversion in Kontuly?A Kontuly business can be converted once, and the conversion journal can't be voided. Restore the backup taken before the import to start again.
- How do I reconcile a bank account in Kontuly?Reconcile a bank account in Kontuly by entering the statement date and closing balance, then ticking entries until the difference is zero.
More about switching and your accountant
- How do I import contacts or a chart of accounts into Kontuly?Bring contacts or a chart of accounts into a running Kontuly business from another package's export. Nothing is posted and no trial balance is needed.
- How do I send my Kontuly books to my accountant?Export your books from Kontuly in your accountant's package format (Xero, MYOB, QuickBooks, Reckon, HandiLedger) or as CSV. They don't need Kontuly.
- Which export formats does Kontuly have for accountants?Kontuly exports for Xero, MYOB, QuickBooks Online, Reckon Accounts, MYOB AO, MYOB AE, Reckon APS, HandiLedger and generic CSV. What each contains.
- Can my bookkeeper and I both use Kontuly?Kontuly is one person on one computer at a time. Share your books with a bookkeeper by sending a backup file they restore, or an export for their own package.