Loading...

Journal Reporting

Use Wisenet Journal Reporting to export financial transaction data effortlessly into formats compatible with major finance systems.

Journal Reporting generates a comprehensive transactional list based on the selected date range, drawing data from 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 shown under the Tax Type column (e.g., GST or GST Free) instead of a separate row, simplifying the layout.

Required Knowledge: Finances

Note: The journal reporting export feature only exports data captured within Wisenet Finance, including data integrated with our payment gateway partners, such as Stripe or PayGate.

Wisenet currently supports journal exports for MYOB and Xero. If you need a journal export for another finance system, please get in touch with our Customer Engagement team.

Getting Started with Journal Reporting

1

Set up Account Details

  1. Navigate to LRM > Finance > Settings > Reporting
  2. Enter an Account Code and Account Description for:
    • Wisenet Accounts Receivable Account
    • Bank Clearance Account
    • Processing Fees Account

2

Update your financial system with Wisenet General Ledger Account Details

Transfer the General Ledger (GL) Account Details from Wisenet into your finance system:

  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.

The Account Codes in Wisenet MUST match the corresponding account codes in your finance system.

We recommend matching the Account Descriptions as well.

How to View and Export Journal Reports

Prerequisite: You must set up the control accounts in your finance system and complete the setup in Wisenet before running the Journal Reporting export.

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.

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. Click Action > Export
  3. 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.

Note: For another pathway to access the exported data, see How to Find Data Exports