Tax Report

How To Localize

Creating Accounts Files Tax Report

Contents 1 Introduction 2 Tax Reports 3 Tax Report example 3.1 Creation of the Tax Report 3.2 Creation of the "Sales Taxes" node 3.3 Creation of the "Purchases Taxes" node 3.4 Tax Report launch

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.

8. Click Save.

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.

7. Click Save.

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.

7. Click Save.

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:

Category: Localization ERP