As another End of the financial year (EOFY) looms, this can mean a long list of time-consuming tasks for most firms. Thankfully, FilePro allows you to continue to function following EOFY without having to carry out any specific end-of-year process.
Finalising the 2023 financial year in System Control
The profit and loss balance will automatically start from zero on 1 July. At some point, however, you will want to go into System Control and finalise the 2023 financial year. This will roll forward your Balance Sheet balances and consolidate your 2023 profit and loss balance to the retained earnings account.
To do this, navigate to System, then System Control. After 1 July, the following message will appear:
Finalising the financial year will not lock 2023 – you can still go back and view, edit or add entries prior to the 1 July.
However, at some point (once you have finished with 2023 and printed your reports for the accountant) you should go back to the System Control screen and turn your ‘locking’ on for that period. This will ensure that nothing can be changed.
Other EOFY FilePro checks
As part of your general end-of-year practices, there are checks that you can also do within FilePro.
First, check that your subsidiary ledgers (Disbursements, Debtors, Creditors and Cashbooks) equal the closing balance of the control accounts in the general ledger. Do this by running the following reports as at 30 June 2023.
- Debtors Aged Trial Balance (Debtors>Reports)
- Creditors Aged Trial Balance (Creditors>Reports)
- Outstanding Disbursements (Disbursements>Reports)
- Bank Reconciliation Report (General>Reports)
- Trial Balance (General>Reports)
The total figures shown on each of the four reports listed should agree with the figures outlined on the trial balance. If a discrepancy is noticed, contact the FilePro Support Team who can assist with investigating any issues.
You do not need to wait until EOFY to perform these checks. This can also be a monthly procedure.
Your trust account at EOFY
The end of a trust year is very different to the end of the financial year and each state will have specific dates and procedures for the end of their trust year.
One ruling, however, does remain the same for all states. A trust account statement is to be furnished as soon as practical after the 30 June, unless:
- The account has been opened for a period of less than six months
- The balance of the account is zero and no transactions affecting the account have taken place within the previous 12 months
- A trust account statement has been furnished within the preceding 12 months and there have been no additional transactions since the date of generating that statement.
You’ll need to refer to your state’s legal governing body for further details.
FilePro has made it easy to send out your yearly trust statements. From the Trust Report menu you will have a Yearly Statements option. If you do not see this option, log into the system as System Administrator and you will be able to run the reports.
In case you missed it: Alternatively, as a client of FilePro, watch the video in our Online Learning Hub in the ‘Recent Features & Versions’ Topic. The Version 22.2 video covers the latest features in relation to Yearly Trust statements.
Saving EOFY financial reports
Reports generated by FilePro can not only be previewed or printed, but are also able to be saved as a file or emailed directly as a PDF. When saving, there are a few options to choose from, including Excel format. This allows you to easily send data to your accountant at EOFY and create specialised Excel reports from the reports within FilePro.
From the FilePro Ribbon, click “Save As” to save the report in Excel format to the relevant folder. Alternatively, use the “Attach to Email” option to easily email a PDF to your accountant.
Managing account codes and general ledger budgets
EOFY is often the perfect time to clean up any unused account codes.
We often see account codes labelled in the following way: “Provision for Rounding – DO NOT USE”. Rather than having to do this, did you know you can deactivate account codes you no longer use? These items will still be referenced in reports if they have data associated with them, however they will no longer be available when entering new data.
To deactivate account codes navigate to General, then E/M General Ledger, then E/M Account Codes. Select your account code, then uncheck the box as shown below.
If you want to completely remove account codes from your system, contact the FilePro Support Team.
Budgets for general ledger account codes will often need to be updated with new figures for the new financial year. When using this feature you can then generate a Profit and Loss report to include budget figures, either with “Year to Date” or “Month to Date”. This allows for a comparison of the firm’s actuals to budget.
Budgets are handled on the same screen shown above. Navigate to the relevant account codes and enter the monthly budgets as shown. If using branches, ensure you are on the correct branch.
In case you missed it: As a client of FilePro, you have free access to our Online Learning Hub which includes a video in the “Best practice features” topic. The video “Budgeting and performance reporting features” covers the resetting of fee earners’ budgets as well as general ledger budgets.
Need more help?
Please contact the FilePro Support Team if you would like more information on any of these topics.