End of year procedures for Strata Master Users (Excluding WA Users)

The following process should be followed prior to entering any financial transactions for July.

The procedures below are determined based on your banking setup, depending on if you use a single bank account for your portfolio, or an individual bank account for each property. Make sure to follow the correct procedure for your business. 

Clients Operating Multiple Trust Accounts

Note:  Steps 1 to 6 must be completed before any financial transactions are entered in July. Steps 7 to 9 may be done after July transactions have commenced however a backup must be completed at 30 June.

  1. Download (or manually enter) all bank transactions up to and including 30 June for all Owners Corporations.
  2. From Formatted Reports produce the Bank Reconciliation Summary.
    • Ensure that all bank accounts are reconciled – if not identify where the differences are and correct these differences before proceeding.
    • The Bank Reconciliation Summary must show that all bank accounts are reconciled. That is, there is a nil difference for each corporation’s bank account.
  3. From Formatted Reports print the Outstanding Deposits Report and Unpresented Withdrawals Report (set the days to "0").  These reports should agree with any unpresented amounts shown on the Bank Reconciliation Summary.
  4. If required produce an Individual Manual Bank Reconciliation for each plan.
    Bank Reconciliation reports can be produced in bulk via Wizards > Bulk Bank Reconciliations. These reports can then be printed and/or saved and attached to the Bank Statements as at 30 June.
  5. For clients using Macquarie Bank the Operating Bank Statements and Investment Bank Statements can be downloaded and saved into fileSMART or the document register for each corporation using Wizards > Bank Statement Filing.
  6. Using Accounting > Investment Reconciliation update all investment accounts with interest, fees and the closing bank statement balances as at 30 June.
    Note: This is only required where your investment accounts are not processed in your daily download.
  7. From Formatted Reports produce the Investment Reconciliation Summary to show that all investment accounts are reconciled.
  8. Once all accounts are reconciled and reports are produced/saved, create a backup of your data and clearly identify as the end of year backup
    e.g. FYE_30Jun20XX.bak.
  9. You are now ready to proceed to enter July 20XX transactions.

Clients Operating a Single / General Trust Account

Note: Steps 1 to 5 must be completed before any financial transactions are entered in July. Steps 6 to 10 may be done after July transactions have commenced however a backup must be completed at 30 June.

  1. Download (or manually enter) all bank transactions up to and including 30 June for all owners corporations.
  2. From Accounting > Manual Bank Reconciliation produce the Manual Bank Reconciliation report.
    • This report will list all the un-presented deposits and withdrawals.
    • Ensure that the bank account is reconciled – if not identify where the differences are and correct these differences before proceeding.
  3. From Formatted Reports produce;
    • the Strata Bank Balances Report (select "Trust Account Reconciliation")
    • the Trust Ledger Trial Balance Report 
  4. Check;
    • That the balance of the Strata Control (on the Trust Ledger Trial Balance) equals the total on the Strata Bank Balances report, and; 
    • that the balance of Cash at Bank (on the Trust Ledger Trial Balance) reconciles with the Manual Bank Reconciliation report.
  5. Where possible identify any Unidentified, Unclaimed or Agency Money for audit purposes.
  6. For clients using Macquarie Bank the Investment Bank Statements can be downloaded and saved into File Smart or the internal document register for each corporation using Wizards > Bank Statement Filing.
  7. Using Accounting > Investment Reconciliation update all investment accounts with interest, fees and the closing bank statement balances as at 30 June
    Note: This is only required where your investment accounts are not processed in your daily download.
  8. From Formatted Reports produce the Investment Reconciliation Summary to show that all investment accounts are reconciled.
  9. Once all accounts are reconciled and reports are printed/saved backup your data and clearly identify as the end of year backup e.g. FYE_30Jun20XX.bak.
  10. You are now ready to proceed to enter July transactions.


21/06/2022 4:42 pm AEST

Still need help?

Request a New Article

Popular Articles

New Articles

Updated Articles