Article Objective: To assist users in navigating Active Ledger & Reporting to reconcile opening balances with the practice ledger file. Context: Active Ledger & Reporting relies on the client's accounting file being the source of truth. You may find that when you connect your client's source file (such as Xero, MYOB or QBO) to a dataset, that your closing balances per your clients accounts as at the last finalised year may not agree to what you have in your comparative year dataset from your practice ledger (where the financial statements are issued from). This would occur due to not having pushed balancing/alignment entries to the client file in the past, or if the client has backdated transactions to previous financial years. Please refer to the Glossary for definitions of key terms used in this article. TABLE OF CONTENTS
|
How to correct opening balances to reconcile with practice ledger file
Example
The client has a MYOB Accountright Live accounting file. The last finalised year in your practice ledger, XPA, is 30 June 2022. You notice that the balances that your client has in their accounting file as at 30 June 2022 do not agree to what you have in your practice ledger file. You remember that you have never performed balancing/alignment journals within your clients file to align it to your practice ledger. When you have added your 2023 MYOB dataset to Active Ledger & Reporting, your opening account balances do not agree to the closing balances you had within your XPA comparative dataset.
What do you need to do to set yourself up for success within Active Ledger & Reporting?
You will first need to have added datasets to your clients Active Ledger & Reporting file. If you have not yet added datasets, see this knowledge article: Datasets - overview.
To align your 2023 MYOB dataset opening balances with the 2022 XPA dataset closing balances, there are a few options:
Option 1 - perform an alignment entry in the clients accounting file (Recommended)
Perform an alignment entry in the clients accounting file as at the end of the last finalised year, in this case 30 June 2022. Take the trial balance from XPA and MYOB as at 30 June 2022 in Excel, compare the two and prepare a balancing journal in the MYOB account names and numbers. Post this balancing journal into the MYOB file as at 30 June 2022. Once done, come back to Active Ledger & Reporting and press Load Data on the dataset.
Option 2 - perform an alignment entry in the Active Ledger & Reporting file with the 'Export Journal to Client File' ticked
Perform an alignment entry in the Active Ledger & Reporting file for the client as an 'Opening Balance Adjustment Journal'. Take the trial balance from XPA and MYOB as at 30 June 2022, compare the two and prepare a balancing journal in the MYOB account names and numbers.
Select the 2023 MYOB dataset.
Select the journals tab, then + New Journal.
Select the journal type as Opening Balance Adjustment Journal, date at 1 July 2022 and provide a memo.
Type your journal. Ensure that the Export Journal to Client File button is ticked to ensure that this adjustment journal will get sent back to the client file with the other balancing journals for the 30 June 2023 year.
Click Add Journal.
Your opening balance adjustment journal is now within Active Ledger & Reporting and your opening balances within the 2023 MYOB dataset will agree to the closing balances per the 2022 XPA dataset.
Option 3 - perform an alignment entry in Active Ledger & Reporting with 'Export Journal to Client File' not ticked (only where the client will not allow any alignment journals to their accounting file)
Perform an alignment entry in the Active Ledger & Reporting file for the client as an 'Opening Balance Adjustment Journal'. Take the trial balance from XPA and MYOB as at 30 June 2022, compare the two and prepare a balancing journal in the MYOB account names and numbers.
Select the 2023 MYOB dataset.
Select the journals tab, then + New Journal.
Select the journal type as Opening Balance Adjustment Journal, date at 1 July 2022 and provide a memo.
Type your journal. Ensure that the Export Journal to Client File button is NOT ticked to ensure that this adjustment journal does not get sent back to the client file with the other balancing journals for the 30 June 2023 year.
Click Add Journal.
Your opening balance adjustment journal is now within Active Ledger & Reporting and your opening balances within the 2023 MYOB dataset will agree to the closing balances per the 2022 XPA dataset.
When you create your 2024 MYOB dataset (and every future year MYOB dataset) within Active Ledger & Reporting, ensure to tick the Roll over opening balances checkbox and rollover from the last completed MYOB dataset in Active, in this example you would roll over from 2023.
This will mean that your 2024 MYOB Dataset will use the closing balances from your 2023 MYOB dataset, rather than the closing balances from the MYOB file itself.