The Journal Reporting feature forms part of Wisenet Finance, allowing for the effortless export of financial transaction data into formats compatible with major finance systems, including Xero and MYOB AccountRight

This feature generates a comprehensive transactional list based on the selected date range, drawing data from the Invoices, Credit Notes, Payments, and Refunds. The data is presented in a traditional T-account format (Debit and Credit), with one key difference: the tax component is not displayed on a separate row. Instead, it is shown under the Tax Type column (e.g., GST or GST Free), simplifying the report layout.

This process follows the same pathway as other financial data exports, accessible via the Data Export feature, ensuring consistency and ease of use for financial reporting and system integration.

Getting Started with Journal Reporting

1

Navigate to LRM > Finance > Settings

• Click on the Reporting tab

2

Reporting Settings for General Ledger (GL) Account Details

To ensure accurate financial tracking and integration, transfer the GL Account Details from Wisenet into your finance system for the following control accounts:

1. Wisenet Accounts Receivable Account:
   Set up a dedicated Accounts Receivable account specifically for Wisenet, allowing a clear distinction between transactions processed in your finance system versus those handled by Wisenet.
   Note: The Aged Receivable report can only be generated within Wisenet, as the Wisenet debtor transactional data will not be duplicated in your finance system. Some finance systems do not support posting General Journals against control accounts i.e. Accounts Receivable.
2. Bank Clearance Account:
   Use this account to transfer data related to funds received and recorded in Wisenet. It’s essential for bank account reconciliation within your finance system, ensuring that all Wisenet-captured transactions align with your bank’s records.
3. Processing Fees Account:
   For users processing payments through Stripe or PayGate, this account transfers payment gateway fees into your finance system, allowing these expenses to be recorded and reconciled accurately.

By transferring these control account details into Wisenet, you will enable seamless financial data flow and reconciliation between Wisenet and your finance system.

3

Reporting Settings for General Ledger (GL) Account Details

To ensure accurate financial tracking and integration, transfer the GL Account Details from Wisenet into your finance system for the following control accounts:

1. Wisenet Accounts Receivable Account:
   Set up a dedicated Accounts Receivable account specifically for Wisenet, allowing a clear distinction between transactions processed in your finance system versus those handled by Wisenet.
   • Note: The Aged Receivable report can only be generated within Wisenet, as the Wisenet debtor transactional data will not be duplicated in your finance system. Some finance systems do not support posting General Journals against control accounts i.e. Accounts Receivable.
2. Bank Clearance Account:
   Use this account to transfer data related to funds received and recorded in Wisenet. It’s essential for bank account reconciliation within your finance system, ensuring that all Wisenet-captured transactions align with your bank’s records.
3. Processing Fees Account:
   For users processing payments through Stripe or PayGate, this account transfers payment gateway fees into your finance system, allowing these expenses to be recorded and reconciled accurately.

By transferring these control account details into Wisenet, you will enable seamless financial data flow and reconciliation between Wisenet and your finance system.

How to View Journal Reporting

1

View Journal Reports

1. Navigate to LRM > Finance > Journal Reports.
2. By default, the Last Week filter is applied. To change the date range:
   • Click the Dropdown > Apply Filter.
   • (See below for definitions of each date filter option).
3. All transactions that are not in Draft or Scheduled status will display in the table.
   • Note: Use the page navigation options at the bottom to view more entries, or adjust the view to show more than the default 20 entries per page.

1a

Filter By Options Explained

• • Today: Transactions dated today or later.
  • Yesterday: Transactions from yesterday only.
  • Week to Date: Transactions from this Monday onward.
  • Last Week: Transactions from Monday last week to before this Monday.
  • Month to Date: Transactions from the first of this month up to today.
  • Last Month: Transactions from the first of last month until the start of this month.
  • Custom Date Range: Define a From and To date range.
  • Custom Range: Define a range based on a specified number of previous days, weeks, or months.

2

Export Journal Reports

1. Select the desired Filter By option and click Apply Filter.
2. Open the Action Menu and click on Export.
3. From the Export Journal Transactions pop-up, choose the destination format (e.g., Xero, MYOB).
4. You’ll be redirected to the Reports > CSV Export progress screen.
5. Click Download CSV to save the file.

Next Step

Getting Started with Xero Journal Data Import

Getting Started with MYOB AccountsRight (AR) Data Import