Top tips for end of financial year
Our team has compiled a quick list of must-do items, reports and checks for end of financial year, to ensure you don’t look back in coming months and realise you missed an important step!
Things you can do NOW
Run AR & AP Reconciliation Reports
Check these against the GL balance and ensure that your sub-ledgers are in balance. If there is an imbalance between AR/AP and your General Ledger control accounts, seek assistance straight away. You can contact your accountant for advice, or book some consultancy time with our specialists.
Run AR & AP Sub Ledger Verification Reports
This is located in General Ledger | Reports and ensures that all batches posted from AP and AR have made it into your General Ledger. As above, if you find a discrepancy here, seek advice asap or book a consultancy session.
Run Trial Balance and ensure the movement columns balance
If an end of year close hasn’t been performed for the previous year, there can be an imbalance in the total columns – but your debit and credit movement columns should always balance. Seek specialist advise if this is not the case.
Perform a Stocktake
Most businesses will perform a full stocktake at or around end of financial year. This is necessary in order to provide your accountant with an accurate stock valuation, and to report movement in stock value from the prior year. Your StockMate mobile scanner will be a necessity at this time of year!
Check Stock Valuation matches the GL Stock Accounts
Run your Stock Valuation report and compare this to the value of stock in your General Ledger accounts. This provides two different views of the net value of your stock on hand. It is not unusual to have small differences due to timing, but generally the two numbers should remain relatively closely aligned. It’s best to check this early – don’t wait until after year end.
One reason why you might find an imbalance is if you have made manual adjustments to the Average Cost of any products throughout the year and not adjusted the General Ledger to reflect this. You may need to do some end of year journals to bring this valuation back in line. This is best done after a full stocktake, unless you have been performing regular rolling stocktakes – in which case you might do smaller monthly journals throughout the year. Contact your Accountant and/or your Foresiight Consultant if you are unsure.
Catch up on your Purchase Invoices
Ensure that all Purchase Invoices and Delivery Dockets have been entered, wherever possible. Enter your stock Invoices via Stock & Purchasing and your non-stock Invoices via Accounts Payable. You’ll want to have your stock and accounts all up to date when end of year comes around.
Tasks to complete on June 30
Post all Sales Invoices and Purchase Invoices
At the close of business, post all Sales Invoices and Purchase Invoices where possible. If your system is configured for overnight posting, ensure that you are able to take a backup after posting and before trade starts for July 1. You can manually post in Sales Orders & Invoicing | Sales | Update Sales & Payments.
Run your AR and AP Aged Balances Reports
These reports can’t be printed retrospectively so if you need these reports for your accountant, run them now. Note that you can save them to PDF, Excel or Text for future use. It is a good idea to be doing this on a monthly basis in case you need to refer to previous months’ reports.
Run a Stock Valuation Report
At close of business on June 30, run your Stock Valuation report and save it to PDF or Excel. Again, this cannot be run retrospectively, so it is a good idea to run this report at the end of each month and save a copy.
Open the new Financial Year
To open the upcoming financial year, go to General Ledger | Periods | Open/Close Financial Periods and in the box in the lower-right corner, type in the year and click OK. This step can actually be done at any time in the lead up to the new year.
Update your AP Period
If most or all of your Purchase Invoices have been entered for June, you can now update your AP period. Note that you can still manually change the period on individual Invoices during stock receipting if you need to back-date or forward-date an Invoice.
Update your AR Period
As per your normal end of month process, you’ll want to update your AR period ready for trading the next day.
Take a Backup
It is best to take a full backup of your data as at 30 June, in case this is needed down the track. It may also be a good time to copy to the Training system. This can be handy in the coming days if you’ve forgotten to run any reports. You can copy to training via Administration | Other | Copy to Training System.
You’re all ready for EOFY!
Following these steps will help make your End of Financial Year as smooth as possible. Every business is different, so there are sure to be other things that you’ll want to include in your own end of year process.
If you’d like a refresher on any of these processes, or if this is your first EOFY, you can book in a training session with a Foresiight Consultant.