Export from QuickBooks Online

From QuickBooks Online you export your lists and run the trial balance and the open invoice reports for the day before your start date.

In DIANO you pick your start date first. The reports are for the day before it.

1. What it must include

• ✓ Customers, suppliers, products and the chart of accounts
• ✓ The trial balance on the day before your start date
• ✓ Open invoices (customers) and unpaid bills (suppliers) on the same date
• ✗ Do not export as PDF
• ✗ Do not change the files before you upload them

2. Step by step in QuickBooks Online

1. Your trial balance on the day before your start date. Click Settings › Export data › Reports › Trial Balance. Save it as Excel (.xlsx), not PDF.

   1. Settings
   2. Export data
   3. Reports
   4. Trial Balance

   A picture of the real screen comes here.

2. Unpaid customer invoices on the day before your start date. Click Reports › Standard reports › Who owes you › Accounts receivable aging detail. Save it as Excel (.xlsx), not PDF.

   1. Reports
   2. Standard reports
   3. Who owes you
   4. Accounts receivable aging detail

   A picture of the real screen comes here.

3. Unpaid supplier invoices on the day before your start date. Click Reports › Standard reports › What you owe › Unpaid Bills. Save it as Excel (.xlsx), not PDF. (skip it if it does not apply)

   1. Reports
   2. Standard reports
   3. What you owe
   4. Unpaid Bills

   A picture of the real screen comes here.

4. Your customer list. Click Reports › Standard reports › Sales and Customers › Customer Contact List › Export › Export to Excel. Save it as Excel (.xlsx) or CSV, not PDF.

   1. Reports
   2. Standard reports
   3. Sales and Customers
   4. Customer Contact List
   5. Export
   6. Export to Excel

   A picture of the real screen comes here.

5. Your supplier list. Click Reports › Standard reports › Vendor Contact List › Export › Export to Excel. Save it as Excel (.xlsx) or CSV, not PDF.

   1. Reports
   2. Standard reports
   3. Vendor Contact List
   4. Export
   5. Export to Excel

   A picture of the real screen comes here.

6. Your item list. Click Sales & Get Paid › Products & services › More › Run reports › Export to Excel. Save it as Excel (.xlsx), not PDF. (skip it if it does not apply)

   1. Sales & Get Paid
   2. Products & services
   3. More
   4. Run reports
   5. Export to Excel

   A picture of the real screen comes here.

7. Your chart of accounts. Click Reports › Standard reports › Account List › Export › Export to Excel. Save it as Excel (.xlsx), not PDF. (skip it if it does not apply)

   1. Reports
   2. Standard reports
   3. Account List
   4. Export
   5. Export to Excel

   A picture of the real screen comes here.

3. The file you get

The contact lists, the account list and the reports, each an Excel file

DIANO recognises a file by its columns, not by its name.

4. Where it lands

On a laptop: Your Downloads folder.

On a phone: iPhone: Files › Downloads. Android: Files › Downloads.

5. Check before you upload

• ☐ The company name on each report is yours
• ☐ The report date is the day before your start date
• ☐ Every file ends in .xlsx, .xls or .csv

6. Common problems

7. The best time to move

The best time to move is just after you finish a month: your VAT return (and payroll, if you pay staff) for last month is done, and your start date is the 1st of this month.

On the day:

• Make the backup or the reports on the day you move, not earlier.
• From your start date, capture new invoices and payments in DIANO only. Stop capturing in the old program.
• Keep the old program for a few months so you can look things up. Do not delete it.

Start my move Print or save as PDF

Still stuck? In DIANO, every step has "Get help" and "Call me back". Or e-mail info@diale.co.za · +27 87 265 3889.