The following reports are commonly used at the End of Financial Year (EOFY) or when entering manual journal entries into your accounting package. It's important you confirm with your Accountant or Bookkeeper exactly what information they require so you can determine the most appropriate report to be used.
Important: You must run your EOFY reports directly after close of business on June 30, or before opening of business on July 1. Discuss with your bookkeeper the best date for your business.
Balances at a Specific Date vs Live Data
Balances at a Specific Date
Typically Retail Express operates on live reporting - information within the reports is obtained up to the exact moment a report is run (more on that in the next section).
However, Retail Express has a full suite of accounting reports built on immutable data i.e. data that cannot be changed in the future. This data can be used to get balances from a specific point in time, for example as at the end of the Financial Year.
Details of these reports and the data they contain are available in the following articles:
In addition to these reports you may also wish to run an Inventory Valuation. Please bear in mind there are currently no "point-in-time" Inventory Valuation reports in Retail Express, so this report report will need to be run at the specific time required to get accurate end-of-year figures. This process is covered in the next section.
Live Data
If the Accounting Reports do not provide the data required by your Accountant or Bookkeeper, or you wish to run additional reporting for the End of Financial Year, it's important to remember that most reporting in Retail Express runs on live data i.e. the data is accurate to the minute the report is run.
It is vital (particularly for inventory valuation reporting) that you run your required reports after close of business on June 30 or before opening of business on July 1. This ensures that you capture the data as it stands at that point in time for EOFY reporting. You should discuss the date you choose with your accountant or bookkeeper, bearing in mind that any integrated webstore may be trading 24 hours a day.
Important: You must run your EOFY reports directly after close of business on June 30, or before opening of business on July 1. Discuss with your bookkeeper the best date for your business.
Trying to calculate the stock at a historical point in time is complex and has a high risk of error. Refer to the How to find a historical Stock Valuation article for more information.
Reports
Income-related reports
| Report | Reports Menu Path | Description |
| End of Day Report | Finance Reports > End of Day Report |
Displays the actual income received as per the End of Day (Cash Up) procedure performed at each Register.
If the End of Day report shows a variance between Expected and Received amounts, use the Income Report (mentioned below) to review all payments accepted on that Register for the day to assist in identifying the cause of the variance.
|
| Income Report | Finance Reports > Income Report |
Used to review all payments per register for the date range specified. Typically used to assist in identifying variances in the End of Day
|
| Voucher Creation | Finance Reports > Voucher Creation |
Displays individual Vouchers created during a specific date range, including the initial amount, value redeemed and the balance remaining.
|
| Voucher Redemption Report | Finance Reports > Voucher Redemption Report |
Displays the value of Vouchers redeemed during the selected date rate.
|
Back to top
Reports - Purchasing, Inventory Valuation and Sales related
Important: These reports use live data and may change at any time. To retrieve EOFY figures these reports must be run directly after close of business on June 30, or before opening of business on July 1, to ensure you have captured accurate data at that point in time.
| Report | Reports Menu Path | Description |
| Stock Value vs Sales Report | Stock Reports > Stock Value vs Sales |
Number 1 report for Inventory Valuation.
The report will simultaneously display Current Stock Value (as at the time of running the report), Value of Sales (over a specified date range) and the value of Purchase Orders (over a specified date range).
The Stock Value vs Sales Report can be grouped by either Product Type or Outlet.
|
| Sales Report | Sales Reports > Sales Report |
Used when you require more detailed information on sales not covered or available in the Stock Value vs Sales report.
The Sales Report is designed as a supplement to the Stock Value vs Sales, and used to give detailed information about individual sales/transactions. The Sales Report should not be used for overall sales information.
Tip: Click "Filter by Processed Date" to disable the Sales Status option and view Processed sales only (excluding cancelled, incomplete sales etc).
|
Back to top
Want more information? Find related articles here: