Tax Report
Languages: |
English | Translate this article... |
How To Localize |
|
Contents |
Introduction
This document explains how Openbravo generates tax reports. A tax report is quite similar to an accounting report. You can build and customize tax reports by using this tool.
The information contained in a tax report is taken from the invoices, not from accounting. So any information regarding taxes contained in accounting – but not in invoices – will not be shown.
Tax Reports
Go to Financial Management > Accounting > Analysis Tools > Tax Report Setup.
Click on New.
Each new element created in this screen will be a node of a Tax Report. The options of this screen are:
- Organization
- Name
- Tax:
- Sales Transaction:
- if checked, the amount of this node will be obtained from the lines of all the sales invoices including the selected tax rate. If it is not checked, the amount will be obtained from the lines of all the purchase invoices including the selected tax rate
- Report:
- if a node is marked as Report, it will be the root node of the tax report. A report must have one Report node; there can only be one report node in each report.
- Shown
- Summary Level:
- as the tax report is organized hierarchically, this option allows the node to have child nodes.
- Negative:
- if checked, the positive amounts will be listed in the credit column. If not checked, it will be in the debit column.
- Active
Click Save when you are done creating each node.
Once you've create all the nodes of your report, you can access it by clicking on: Financial Management > Accounting > Analysis Tools > Create Tax Report
Select the date range and the report. Click 'OK' to generate the report.
Tax Report example
This example shows how to create a VAT tax report called "Tax Report" with two nodes: "Sales Taxes" and "Purchases Taxes".
Report structure
Creation of the Tax Report
1. Go to Financial Management > Accounting > Analysis Tools > Tax Report Setup.
2. Click on either Create a new record in a form or
Insert Row.
3. Select an Organization.
4. Give the report a Name: "Tax Report".
5. Verify that Active checkbox is selected
6. Check Report, Shown and Summary Level checkbox.
7. Leave the Tax field blank.
Creation of the "Sales Taxes" node
1. Click on either Create a new record in a form or
Insert Row.
2. Select an Organization.
3. Give the node a Name: "Sales Taxes".
4. Verify that Active checkbox is selected
5. Check the box for: Shown, Sales Transaction and Negative.
6. Select a Sales Tax rate.
Creation of the "Purchases Taxes" node
1. Click on either Create a new record in a form or
Insert Row.
2. Select an Organization.
3. Give the node a Name : "Purchases Taxes".
4. Verify that Active checkbox is selected
5. Check the box Shown.
6. Select a Purchase Tax rate.
Now that all the nodes are created click on the Tree button:
Drag and drop the nodes to create the following tree:
Tax Report launch
To Launch the report go to: Financial Management > Accounting > Analysis Tools > Create Tax Report:
Choose the tax report, and click on Ok.
The report looks like this: