Viewing the Taxes Report
The Taxes Report shows all taxes recorded on your transactions in a specific period: sales invoices, purchase invoices, refunds, notes, expenses, incomes, and journal entries. It is also used to view tax sales invoices and tax purchase invoices with their numbers, clients, suppliers, taxable amount, and tax value.
๐
Note: You need permission to view the Taxes Report. It is set from Roles.
Table of Contents
Viewing the Taxes Report
- From the main menu, click Reports, then Accounting Reports.
- On the Taxes Report card, click Details to view every invoice and item, or Summary to view the totals only.
- Set the filters, then click Show Report.
Report Filters
| Filter | Description |
|---|---|
| Tax | All Taxes or a specific tax (such as VAT 15%). |
| Revenue Type | Issued (Accrual), Fully Paid, or Partially Paid. Details. |
| Date Range | The report period, with quick options such as Last month and Year to date. |
| Group By | In Details only: Item (a row for each item, the default) or Invoice (a row for each invoice). |
| Currency | All In the account currency (converting all amounts), or a specific currency. |
| Branch | Appears when branches are enabled, and you can choose more than one branch. |
| Show Non Taxed Item | Adds a group named Non Taxed at the end of the report showing the items with no tax selected. Details. |
๐
Note: There is no filter for the document type, client, or supplier; the report is automatically divided into sections for sales, purchases, and others.
Report Sections
The report shows a group for each tax with its name and rate, containing the following sections:
| Section | Documents | Effect on the total |
|---|---|---|
| Sales Invoices | Sales invoices, including POS invoices, and shipping tax. | Positive (tax you owe) |
| Advance Payment | Advance payment invoices (when enabled). | Positive |
| Sales Debit Note | Sales debit notes. | Positive |
| Sales Returns | Refund invoices and credit notes. | Negative |
| Purchase Invoices | Purchase invoices (with the purchase order number, if any). | Negative (tax in your favor) |
| Purchases Returns | Purchase refunds and purchase debit notes. | Positive |
| Purchases Credit Note | Purchase credit notes. | Negative |
| Other Income / Expenses | Receipt and payment vouchers with tax. | Incomes are positive, and expenses are negative |
| Other | Journal entries recorded on tax accounts, such as manual entries, tax settlement entries, and fixed assets. | According to the entry |
At the end of each section, the Subtotal appears, and at the end of each tax, the Total (net tax). With more than one tax, the NET appears.
๐
Note: Purchase sections appear when the Inventory and Purchases app is enabled, and income and expense sections when the Expenses app is enabled. Each sales and purchases section appears even if it is empty with a total of 0.00, while Other Income, Expenses, and Other appear only if they contain documents.
Summary and Details
| View | Columns |
|---|---|
| Summary | Tax Name, Taxable Amount, and Taxes for each section. |
| Details | No. of the document (a link that opens in a new tab), Taxpayer (the client or supplier), VAT Number, C.R / Unified Number, Date, Item, Description, Taxable Amount, and Taxes. |
You can switch between the two views with the Summary and Details buttons at the top of the report while keeping the filters.
How do I view tax sales invoices?
- Open Taxes Report – Details.
- In Tax, choose the tax (or All Taxes), and in Revenue Type, choose Issued (Accrual).
- Set the period, and in Group By, choose Invoice to view a row for each invoice.
- Click Show Report, and review the Sales Invoices section: the number of each invoice, the client and their VAT number, the date, the taxable amount, and the tax value.
- Review Sales Returns to know the tax deducted by refunds and credit notes.
Click any invoice number to open it. To save the list, export it to Excel from Export Options.
How do I view tax purchase invoices?
- Open Taxes Report – Details.
- Choose the tax and the period, and in Group By, choose Invoice.
- Click Show Report, and review the Purchase Invoices section: the number of each purchase invoice, the supplier and their VAT number, the date, the taxable amount, and the tax value.
- Review Purchases Returns for refunds, and Expenses for expenses with tax.
๐
Note: A purchase invoice appears in the report only if you chose a Tax on its items; the supplier VAT number appears if you recorded it in the supplier details.
๐
Note: The sales invoices and purchase invoices lists have no tax filter; so the Taxes Report (Details) is the suitable way to view tax invoices.
How do I show non-taxed items?
By default, the report shows only the items with tax. To show the items with no tax calculated:
- Open Taxes Report – Details.
- In Tax, choose All Taxes, and set the period and the Revenue Type.
- Enable Show Non Taxed Item.
- Click Show Report.
- Go to the Non Taxed group at the end of the report.
The group is divided into the same report sections, such as Sales Invoices and Purchase Invoices, and shows each item without tax with the document number, date, and amount, and its tax value is zero.
๐
Note: The Non Taxed group also appears when you choose a specific tax in the Tax filter, and it appears after that tax group.
What Is Included in the Report?
- Only the items with the selected tax (except when Show Non Taxed Item is enabled; Details).
- Not included: drafts (invoices, purchase invoices, expenses, and journal entries that are not issued), and deleted documents.
- When you choose All In, amounts in other currencies are converted to the account currency at the document exchange rate.
- Without choosing a branch, only the data of the branches you are allowed to access appears.
Revenue Type and Invoice Dates
| Revenue Type | Sales invoices shown | Date used |
|---|---|---|
| Issued (Accrual) | All issued invoices, paid or unpaid. | The invoice date. |
| Fully Paid | Fully paid invoices only. | The last payment date. |
| Partially Paid | Partially paid invoices only (with their full value). | The last payment date. |
๐
Note: The revenue type affects sales documents only (invoices, advance payments, notes, and refunds). Purchase invoices, expenses, incomes, and journal entries always appear by their date.
So the report may differ between Issued and Fully Paid even if all invoices are paid; because the first uses the invoice date, and the second uses the payment date.
Printing, Exporting, and the Tax Declaration
- Print to print the report.
- Export Options: Export to CSV, Export to Excel, or Export to PDF.
- View Tax Declaration: opens the Tax Declaration with the same filters and shows it directly. From the declaration, the View Tax Report button returns to the report.
FAQs
How do I view tax purchase invoices?
From Taxes Report – Details with Group By: Invoice, the Purchase Invoices section.
How do I view tax sales invoices?
From the same report, the Sales Invoices section, with Revenue Type: Issued (Accrual).
Why doesn’t an invoice appear in the Taxes Report?
- The invoice is a draft.
- No tax was chosen on its items (enable Show Non Taxed Item to show them).
- Its date is outside the period, or it is unpaid while Fully Paid is selected.
- The tax, branch, or currency filter excludes it.
How do I show the transactions or items with no tax calculated?
From Taxes Report – Details, enable Show Non Taxed Item, then click Show Report. These items appear in the Non Taxed group at the end of the report. Details.
Why does the purchase tax appear as negative?
Because it is paid tax deducted from the sales tax; the total is the net tax due.
What is the difference between the Taxes Report and the Tax Declaration?
The Taxes Report shows taxes in detail by each document and item. The Tax Declaration shows them in the declaration format required for submitting it to the tax authority.