End Of Financial Year Procedures

End Of Financial Year Procedures

This article explains how to perform procedures that should be run at the End of Financial Year.
InfoFor EOFY Marketing Ideas, See HERE

Preparing for the End of the Financial Year

Perform a stocktake

  1. This ensures that the quantity-on-hand of stock is accurate.
  2. This may not be necessary if you maintain accurate stock on hand in Retailer and perform rolling stocktakes throughout the year. See Best Practice for Stocktaking
  3. For more information about performing a stocktake, click HERE.

Write Off Stock

Write off any old stock which will never sell. See HERE

Clear up customer/subagent debts - Accounts receivable are a taxable asset

Use Reports -> Customer -> General Debtors Report to find customers who have outstanding balances. See HERE

Clear up uncollectable debts

  1. Using the General Debtors Report, identify debts that are uncollectable.
  2. For Cash Accounting, perform a Balance Adjustment to clear the debts. See HERE
  3. For Accrual Accounting, perform an Invoice Credit using an item with GST to clear the debts. See HERE

The week-ending-date should be within the current financial year.
  1. In the Customer and Subagent Billing screens, tick the Print Full Audit and Preview Audit tick-boxes.
  2. In the preview, click on the printer icon to print out the report.
  3. Then, click on the red PDF icon to save the report as a PDF file.

On the Final Day of the Financial Year (30 June)

Reports -> Customer -> General Debtors
  1. In aging Types Tick all periods
  2. Under Customer Categories Select All Categories
  3. Under Customer Account Categories Select All Acc Categories
  4. In End Date choose the last date of the Financial year that is ending eg 30/06/2024
  5. For more detailed options see HERE

Reports -> Stock Reports -> Stock Listing Reports -> General Stock Listing
  1. Select All Departments
  2. In Quantity on Hand Level, select Greater then 0
  3. To hide individual stock items from the report, tick Show Totals Only
  4. For more detailed options see HERE

Add these items to the stock quantities in the Stock Listing Report.

Reports -> Sales Reports -> Gift Voucher Report
  1. In Date range, enter a date range that covers all outstanding vouchers. (The default voucher expiry is 3 years, so set from 3 years prior to current date until EOFY)
  2. In Voucher to Show, select Voucher Liabilities
  3. For more detailed options see HERE

Reports -> Sales Reports -> Layby Report
  1. In options select All Customers
  2. In Date Range, select Shows All Laybys regardless of date
  3. Select Only Show Outstanding Laybys
  4. For more detailed options see HERE

Print a Monthly Sales Comparison Report to compare the performance of the ending financial year to the previous.
Reports -> Sales Reports -> Monthly Sales Comparison
  1. Set First Date Range to be the Financial Year that is ending
  2. Set Second Date Range to be the previous Financial Year
  3. For more detailed options see HERE

Perform a backup on a USB drive

  1. Rename the backup file to something easy to identify for future reference eg. EOFY2024 in both the USB drive and C:\Tower\Retailer\AutoBackup.
  2. Take the USB off-site or keep it somewhere safe.
  3. For more information on backing up Retailer data, click HERE.

    • Related Articles

    • End of Financial Year Marketing Opportunities

      Here are some sales and marketing tips small and independent retailers could consider in the lead up to the end of the financial year on June 30: ▪ End of Financial Year Sale. Nothing too special or complex in this idea. Get together items which are ...

    • EOFY Reports

      In Retailer 3.3.0.5, a new EOFY Reporting feature has been added which automatically backs up a copy of your End of Financial Year reports. You must have the latest version of Retailer installed at End of Financial Year for this process to run. You ...

    • End of Shift Sales not transferred

      The final step of the End of Shift process is to transfer the sales. This closes off the shift so these sales are not included in future End of Shift reports. If the End of Shift is closed before the final step, the following message will appear: ...

    • ANCOL Mid Year 2024 Catalogue

      Save the Catalogue File Download the attached file. Import the Catalogue File On the top menu bar of Retailer, click on Utilities -> Import/Export Files -> Import Catalogue Files. In Catalogue Name, press the [Insert] button to access the Catalogue ...

    • End Of Shift Setup

      We have a video guide on the End of Shift settings - End Of Shift Before you start to setup your end of shift, you should ensure that your float values are all set up correctly - click HERE for more information. End of Shift Settings From the main ...