This Report show sales on a cash basis. It should only be used if you use Cash Accounting and need the Cash sales total for your BAS.
This report does not refer to sales paid by cash. The sales transaction log can be used for this purpose, learn more HERE.
The Monthly GST Cash Accounting report will show the sales on a cash basis for the period selected broken down by department.
As Retailer works on accrual this report manually calculates the sales as if they were cash. This means the report can take a long time to run compared to other reports.
Generating the Report
-
On the top menu bar of Retailer, click on Reports > Sales Reports > Takings Reports > GST Cash Accounting reports > Monthly GST Cash Accounting report
- In Report Date Range:
- Select the Start Date - This will be the Start Date of the report
- Select the End Date - This will be the End Date of the report
- Click Preview or Print
Reading the Report
- Department - Lists all the departments you have
- Sale and GST - Shows the sales broken up by month with Sale ex GST then GST separate.
- The Sale and GST will repeat for up to 4 months at once and then the last two is the total for the date range selected.
- The bottom will show a total of each column.
Exporting the Report
You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:
- PDF - Click on the red PDF button at the top of the report and choose your save destination.
- Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.