Page tree

 

 


 

 

Article ID: 38166

Accountants Office Suite
Accountants Enterprise Suite
Australia
AO Statutory Reporter (AU)
AE Workpapers (AU)
AE Statutory Reporter (AU)

ARTICLE LAST UPDATED: 19/01/2018 11:48:00 AM

In MYOB Client Accounting version 5.4.27, you're able to import transactions from QuickBooks Online into MYOB Ledger.

To meet the specifications for the file to be imported, the CSV file exported from QuickBooks Online needs to be modified and when performing the import, the QuickBooks Online Template should be selected.

In this article we'll step you through creating the export (.CSV) file in QuickBooks Online and importing the file into MYOB Ledger.

If you're having issues importing into AE/AO ledger, make sure that the sum of all transactions are $0 in the .CSV file, and that your debits and credits balance.

To create the CSV file
  1. Log into your QuickBooks Online client and open the Intuit QuickBooks homepage.
  2. Ensure the client's QuickBooks Online file has the Enable account codes option selected in the configuration.
  3. From the navigation bar, click Reports.
  4. In All Reports under Accountants Reports produce the Transaction Lists with splits report in Excel and click Customize report.
  5. Uncheck include all the Headers & Footers and ensure that following columns are selected at a minimum.
    • Date
    • Memo
    • Description
    • Account
    • Amount
  6. Populate the Date column for each row with data in it. All records having non zero amount and account must have have a date.

    Excel has a function that can be used to get data populated correctly for the non-contiguous rows, such as the date that is missing from some of the rows in the file.

    1. In Excel, select the column range that needs to be filled for non-contiguous range of blank cells. For example B3:B2000.
    2. Press the F5 key on the keyboard to open the Goto dialog.
    3. In the Goto dialog, click Special and select Blanks and click OK.
    4. With only the noncontiguous range of blank cells selected, type = and then cell that is the start of the range. For example =B3. Then press CTRL + ENTER on the keyboard.
    5. Save the file in the format .CSV.

    While you're in excel, check that the sum of all transactions are $0, and that your debits and credits balance.

To import the CSV file
  1. From your client's Client Accounting > Trial Balance (Workpapers) tab, click Manage Client File Imports located on the TASKS bar.
  2. In the Import Wizard, select the option .CSV under Choose file type.
  3. In the Select file to import field, click the ellipses button () to browse and select the .CSV file to import. Then click OK.
  4. Select the mapping Quickbooks Online Template from the Select template dropdown menu.
  5. Click Next, then proceed to mapping your accounts.

For further details on how to import the CSV file into AE/AO Ledger, refer to the MYOB Help Centre: Importing data.

If you're having issues importing into AE/AO ledger, make sure that the sum of all transactions are $0 in the .CSV file, and that your debits and credits balance.

MYOB INTERNAL STAFF ONLY

Insert PR# 135379673034

SR# 135158300376 

Clients may experience an error with the .CSV import file being out of balance where transactions include GST. See SR# 157125361087 for further details. (CAT-28378).