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.
You can search the relevant debit and credit account from the 'Account Name' dropbox, and the account number & classification will be populated automatically.
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:
EMPS Employee Summary
F12 Cashbook
F15 Stock on Hand
F20 Livestock
G05 Borrowing Costs
G16 Amortisation of Long Term Assets
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.
Additional worksheets will be supported soon, including:
G31 Div 7A Calculator
M35 Sales Trading Account
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.
