At the end of the financial year, you can view sales and tax data for accounting and tax-reporting purposes through Invoices and Sales Activity reports. This guide explains how to extract your sales information.
View Tax through Invoices
Go to the backend of Abacus, and navigate to Sales > Invoices.
Choose the desired time period by entering the From and To dates. For tax returns, select the financial year range (e.g., from 1st of July to 30th of June)
3. The invoice table will display various details, including Tax included in each invoice.
4. To export the data, click Export and select the desired file format:
PDF: Lists each invoice amount.
CSV: Lists each invoice amount.
Detailed CSV: Lists each product separately for each invoice.
PDF File
Lists each invoice amount
CSV file
Lists each invoice amount
Note: if you see "######" under any column in a CSV file, that means that there is too much text to fit in the column; expand the column to display the text.
Detailed CSV file
Lists each product separately for each invoice
View Tax through Sales Activity
Go to Reports > Sales > Sales Activity
For financial year reporting, go to the Range tab and filter the dates (e.g., from 1st of July of the previous year to 30th of June of the current year).
3. Scroll down to view Sales By Date with included tax. Totals are displayed at the bottom of the page.
Totals are displayed at the bottom of the page.
4. To export detailed sales data, click Export Order Items to download a CSV file of the items ordered within the specified date range.
