The Financial Summary Report shows a detailed view of an account-level verification of data imported from Retail Express to your accounting package. In this report, transactions are broken down by Income, Payment Method, Sales (type of sales, both taxable and tax-free), Freight, Surcharges, Gift Vouchers Sold, Layby Movement, Accounts Receivable Movement, Inventory Movement, Direct Costs and Purchases.
Back to top
Using the Financial Summary Report
To access the Financial Summary Report:
- Open Retail Express
- Navigate to Reports > Accounting Reports > Financial Summary Report
- Select from the Filters as required (see below for a detailed explanation)
- Click the Search button
- The Results will be displayed matching the filters
- Click the Export button to export the report in an Excel spreadsheet
Back to top
Filters
| Filter | Details |
| Date From/ Date To |
The date the transaction applies to your accounts. These are inclusive dates, meaning if you select from 24/12/2022 to 24/01/2023 it will include transactions on those dates
Note: If you entered a payment on the 1st of Feb, but backdated the payment to the 30th of Jan, the payment will appear on this report on the 30th of Jan.
|
| Accounting Method | Only the Accrual Method is supported; you must confirm this method with your bookkeeper or accountant. |
| Country | Used to limit the report to locations within that Country only. Countries are configured via Settings > Locations/Outlets > Countries |
| Store Type | A categorisation method used to separate your individual outlets. Refer to the Outlets - Store Types article for more information |
| Outlet | The individual Outlets in the database |
Back to top
Results
The Results tab displays detailed information on products included in the Financial Summary Report.
Back to top
Troubleshooting Discrepancies
If you've found discrepancies, use the Accounting Reports for a detailed review of transactions and to assist with reconciliation.