Before beginning the data import process from Wisenet into Xero, ensure you have the Advisor or Standard + Reports user role in Xero. This access allows you to navigate Xero’s Manual Journals feature and manage journal entries. Familiarise yourself with the Xero journal import process and verify that your general ledger (GL) accounts are correctly set up to support seamless integration.

GL Account Setup in Xero and Data Entry in Wisenet

When creating or adjusting GL accounts in Xero, remember that Xero supports both alphanumeric and numeric codes. Avoid using account codes with decimal endings of zero, as these may be dropped if files are saved in a different format. This helps prevent errors during data import and ensures all GL codes remain intact across systems.

In Wisenet, enter the GL account codes and ensure they align with those set up in Xero’s Chart of Accounts under Accounting > Advanced > Chart of Accounts. This alignment is essential for the accurate mapping of financial data during import.

Supported Tax Rates

Wisenet supports a subset of Xero’s default tax rates, and any unsupported rates will not transfer correctly. Ensure that your data uses one of these Xero-supported rates:

• BAS Excluded (AU) / No GST (NZ)
• GST on Income (AU) / 15% GST on Income (NZ)
• GST Free on Income (AU) / Zero Rated (NZ)

Importing Financial Data from Wisenet to Xero

Step-by-Step Guide for Importing Wisenet Financial Data

1

Open Xero and Navigate to Settings

• Open your Xero account, click on the company name in the top navigation bar, and select Settings from the dropdown menu.

2

Access Manual Journal Import

• Under Organisation settings, locate and click on Looking for advanced Settings? to open additional options.
• Select Manual Journals to proceed with the data import.

3

Begin Import Process

• In the Manual Journals section, click on the Import button located at the top of the screen.
• A pop-up will prompt you to upload a file. Select Browse to locate the CSV file exported from Wisenet, then click Import.

4

Validate Imported Draft Records

• Xero will display the number of draft records that will be imported. Ensure this number matches the number of journal entries from your Wisenet data export to confirm accuracy.
• If the records are correct, click Complete Import to finalise the import.

5

Review and Post Entries

• After the import, navigate to the Manual Journals screen under the Draft tab to review each entry.
• Follow your organisation’s internal processes for verification and final review.
• Once all details are verified, click Post to finalise the entries.

Additional Notes

• Testing in Sandbox Environment: If available, consider running a test import in a Xero Demo Company or sandbox environment before importing into the live production account.
• Validation Check: Ensure that any discrepancies in record counts or tax codes are resolved before completing the import to prevent reconciliation issues.

By carefully following these steps, you’ll ensure accurate and efficient integration of Wisenet data with Xero, keeping your financial records up to date.