Before you begin importing data from Wisenet to MYOB AccountsRight, ensure you have the MYOB AccountsRight desktop app and the correct user roles to set up new GL accounts and import journal entries. Testing in a sandbox environment, like Clearwater, is recommended before importing data into the live system to familiarise yourself with the process.

Setting Up Wisenet Control Accounts in MYOB AccountsRight

For integration to work smoothly, you’ll need to ensure the control accounts are set up accurately. MYOB requires specific GL account numbers based on account type:

• 1 for Assets
• 2 for Liabilities
• 3 for Equity
• 4 for Income
• 5 for Cost of Sales
• 6 for Expenses
• etc

For each control account, create a Detail Account without any spaces or dashes (e.g., “11701” instead of “1-1701”) and transfer the GL account details to Wisenet > Settings > Reporting page.

Supported MYOB Tax Codes

Wisenet supports a subset of MYOB’s default tax codes. Ensure that your data uses only the following codes for proper integration:

• N-T: GST Free (AU) / N-T: No Tax (NZ)
• GST: Goods & Services Tax (AU) / S15: GST at 15% (NZ)
• FRE: GST Free (AU) / Z: Zero-Rated (NZ)

Importing Financial Data from Wisenet into MYOB AccountsRight

To import Wisenet data as a journal entry, follow these steps:

1

Open MYOB AccountsRight and Start Import Process

• Go to File > Import/Export Assistant in MYOB and select Import data.
• Click Next to proceed.

2

Select File Type for Import

• In the File Type dropdown, select General Journal Entries, and click Browse
• Change the file format to All files to display the Wisenet CSV export, select the file, and click Next.

3

Choose Format and Match Headers

• In the Format screen, ensure Data is separated by: Commas is selected, then click Next.
• Click Auto Match to align headers in the CSV with MYOB’s fields, then click Next.

4

Backup Option (Optional) and Complete Import

• Choose Back Up if desired, then click Import.
• Confirm the import by checking the Data Import Log to verify zero skipped or errored records.
  • Once verified, click on Close to return to the main screen.
  • If additional journals need to be processed, select Import more data.

5

Review Imported Journal in MYOB

• Navigate to Accounts > Transaction Journal in MYOB to review the imported journal entries.

Additional Notes

• Single vs. Separate Journals: MYOB imports data as a single journal entry by default. To separate them, insert a blank line between each journal in the CSV file.
• Testing Environment: Always test the import in a sandbox or test company file before the final live import to prevent any issues with your primary financial data.

Following these steps ensures your Wisenet financial data integrates correctly with MYOB AccountsRight, providing accurate journal entries in your accounting system.