Overview: The 'Post Journal' feature allows you to create and review journal entries from within Active worksheets. Once the journals are created, they can be saved and exported to your accounting system.
Please refer to the Glossary for definitions of key terms used in this article.
Generate a draft journal entry
After completing the relevant Excel worksheet, click Post Journal to create a draft journal entry. When you do this, the draft journal will automatically appear in the Active Workpapers taskpane, ready for review and posting.
Note: The account number and account name must exactly match the ledger account number and account name. This is critical to ensure the journal can be successfully posted to your accounting system.
This 'Post Journal' feature is currently only available for the following worksheets:
F12 Cashbook
EMPS Employee Summary
H39 Provisions - Long Service Leave
H40 Provisions - Annual Leave
Note: The 'Post Journal' feature for the H39 & H40 worksheets are only available for binders created for FY2025 and onwards.
Review the draft journal entry
In the draft journal entry, ensure the following:
Debit and credit amounts are balanced and correct;
Classifications (e.g. Expense, liability) are accurately assigned;
Add memo if needed; and
Tick or untick the 'Flag as Pending Export to Client File' checkbox if you wish to post the journal to the client's accounting file or not.
Note: You are able to draft the journal in the Excel taskpane or in the web.
Post the journal entry
Once reviewed and confirmed, click Save and Close to finalise the journal entry.
For this particular cashbook worksheet example, the journal will appear under the 'Not Exporting' tag of the Journals page as we unticked the 'Flag as Pending Export to Client File' checkbox.
For most other automatic journals that are posted from the worksheets, the 'Flag as Pending Export to Client File' will be ticked and therefore, the journal will appear under the 'Pending Export' tag. This confirms that the journal entry is saved and ready for export to your accounting software as part of the balancing journal.
Refer to the support article: How to post & export journals and compare & reinstate import runs for more information relating to balancing journals.