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.
The Journal Report page keeps a history of journal exports created in Wisenet. Use the history to see what has been exported, download a report again, or create a new export containing transactions that have not been exported before.
Required Knowledge: Finances
Required LRM Access: Owner, Admin, Finance Admin and Finance User
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 Success team.
Getting Started with Journal Reporting
1
Set up Account Details
- Navigate to LRM > Finance > Settings > Reporting
- 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:
- 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. - 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. - 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
- Navigate to LRM > Finance > Journal Reports.
- 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).
- 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
- Select the desired Filter By option and click Apply Filter.
- Click Action > Export
- Choose the destination format (e.g., Finance Journal Export, Xero, MYOB).
- Click Export
A new export includes only transactions that are not already linked to an existing journal export. Each transaction can be linked to one journal export at most, so a transaction that has already been exported is excluded from future new exports.
When you reverse a credit note, payment, refund, or write-off, the reversal is included in the Journal Export as a separate entry from the original transaction. The reversal entry uses the reversal date, retains the original account and tax details, reverses the original debit and credit values, and adds R to the original transaction reference. For example, CRN-0626 becomes CRN-0626R.
3
View and Re-Export Journal History
The Export History tab shows the journal exports created in Wisenet. For each export, you can view:
- The creator’s name.
- The date and time it was created.
- The start and end dates for the period covered.
- The number of records in the export.
To download an earlier export again, click the download icon under Actions. The re-export is exactly the same as the original file, even if the transactions have since changed.
Journal exports cannot be deleted. They no longer appear in the Data Exports page.
