View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:Multitaxreport30/User Documentation

Contents

Introduction

This document describes the “Multi-dimensional Tax Report” module for Openbravo 2.50.

The “Multi-dimensional Tax Report” is a new report which allows the end-user to easily get a list of all the transactions posted in the system having tax implications.

The tax information provided by the multi-dimensional tax report is key for the companies to manually fill-in and submit the corresponding tax reports to the tax authorities.

Installation

There are two different module versions of the Multi-dimensional Tax Report which are described in the section “Module Description”:

Any of these module versions can be installed from the Central Repository at the application path “General Setup || Application || Module Management
by just following the steps described in this "Installation tutorial"

This is a commercial module which requires a commercial license free to Professional Edition subscribers.

Module Description

As described above, there are two different module versions of the Multi-dimensional Tax Report:

Taxes and GL items setup

There are several ways of setting up taxes in Openbravo.

End-user can setup taxes such as value added tax (VAT) and withholding taxes at the application path:
Financial Management // Accounting // Setup // Tax Rates”.
These kind of taxes can be used in the purchase and sales invoice lines as well as in the GL items to be later on used in manual settlements, bank statements or cash journals document types.

Besides, end-user can setup withholdings at the application path:
Master Data Management // Business Partner Setup”.
This kind of withholdings can be used in the purchase invoice header window as well as in the GL items to be later on used in manual settlements, bank statements or cash journals document types.

It is important to remark that “Advanced Payables and Receivables Management“ module does not require nor support anymore:

Use cases

The companies must account for transactions containing taxes and withholdings as a result of business and later on submit the tax/withholding information to the tax authorities.
The Multi-dimensional tax report helps the end-user to get relevant tax information and sort it out according to the needs.

This tax report can be run at the application path: “Financial Management // Receivables & Payables // Analysis Tools”. It looks like shown in the screen attached below:

Mtr 1.png

End-user can accomplish below described scenarios by entering or filtering by specific data depending on the tax type.


Taxes such as value added tax (VAT)

For getting a list of transactions containing taxes such as VAT, end-user can:

Scenario 1 - VAT liabilities, no details

PDF report of the posted transactions including VAT Liabilities dated on November 2010,
without transactions details and regardless business partner information.
For this scenario, end-user must filter by the options shown in the screen below.

Mtr 3.png

As a result, the multi-dimensional tax report will look like:


Note: documents where is not possible to set Business Partner (such as GL Journal...) will be indetified with Business Partner "#"

Mtr 2.png

As shown in the screen above, the output of the report contains:


Scenario 2 - VAT liabilities, showing details

Excel report of the posted transactions including VAT Liabilities dated on November 2010,
showing the transactions details and grouping by business partner information.
For this scenario end-user must filter by the options shown in the screen below.

Mtr 4.png

As a result, the multi-dimensional tax report will look like:

Mtr 5.png

Scenario 3 - VAT Payables, showing details

Excel report of the posted transactions including VAT Payable dated on November 2010,
showing the transactions details and do not grouping by business partner information.
For this scenario end-user must filter by the options shown in the screen below.

Mtr 10.png

As a result, the multi-dimensional tax report will look like:

Mtr 11.png

Withholdings

For getting a list of transactions containing withholdings, end-user can:


Scenario 1 - Withholding taxes

PDF report of the posted transactions including withholdings tax rates dated on November 2010 for a specific business partner.
For this scenario end-user must filter by the options shown in the screen below:

Mtr 6 1.png

As a result, the multi-dimensional tax report will look like:

Mtr 7 1.png

Scenario 2 - Withholdings paid

PDF report of the posted transactions including withholdings already paid by using a bank statement, dated on November 2010,
including transactions details grouped by business partner.
For this scenario end-user must filter by the options shown in the screen below:

Mtr 8.png

As a result, the multi-dimensional tax report will look like:

Mtr 9.png

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Multitaxreport30/User_Documentation"

This page has been accessed 3,170 times. This page was last modified on 8 June 2012, at 05:32. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.