Generating Extended Tax Reports: Germany, Spain and UK

You can generate and save extended tax reports to be submitted to the tax authorities. Extended tax reporting enables you to mark reported transactions and thus prevent duplicate transaction reporting.

Recommendation

We recommend that, before starting to use extended tax reporting, you save a mock report with previously reported transactions from earlier periods. This prevents irrelevant documents being offered by SAP Business One for reporting.

End of the recommendation.

Extended tax reporting lets you do the following:

Track which items were claimed from or paid to the tax authorities in specified periods
Claim from, or pay to, tax authorities any items missing from the original report for the specified period and added later
Post tax liabilities and receivables to G/L accounts

Depending on your company setup, you can generate up to three different types of reports:

Original — a new tax report
Adjusted — an existing report updated with missing items

Note
Not available in UK.

End of the note.
Replacement — an existing report updated with changes

Note Note

Extended tax reporting does not affect the following reports:

Withholding tax report – the report relates to income tax (not VAT).
EU sales report – the report relates to EU statistical purposes (relevant for sales total amounts).

End of the note.

Prerequisites

You have activated extended tax reporting.

Note Note

You can deactivate extended tax reporting at any time. If you reactivate extended tax reporting afterwards, previously saved reports will still be in the system.

End of the note.

To activate extended tax reporting, follow the steps below:

Choose Administration System Initialization Company Details , and on the Accounting Data tab, select the Extended Tax Reporting checkbox.

Procedure

From the SAP Business One Main Menu, choose Financials Financial Reports Accounting Tax Tax Report Generation . Alternatively, choose it from the Reports module.
In the Tax Report Generation — Selection Criteria window, specify parameters for generating a tax report for a given period, and choose the OK button.
In the Tax Report — Generation window, specify parameters for generating a tax report for given tax codes and tax groups, and choose the Add button.

Note
To see any errors in tax calculation, choose the Error Report button.

End of the note.
Choose Financials Financial Reports Accounting Tax Tax Report . Alternatively, choose it from the Reports module.
In the Tax Report — Selection Criteria window, specify parameters for generating a tax report for the given period and tax codes, and choose the OK button.

Result

The tax report is displayed according to your selection criteria in the Tax Report window.

Example

In January 2009, you entered the following transactions into SAP Business One:

Document	Posting Date	Net Amount	Tax Amount	Tax Group/Tax Account
IN1	5/1/2009	100	10	A1/111
IN2	6/1/2009	150	15	A2/112
PU1	6/1/2009	-50	-5	B1/211
Total		200	20

You prepared and submitted a tax report to the tax authorities for January 2009. Since you are obliged to pay 20 to the tax authorities, you posted the following from the tax account to the liability account:

Account	Debit	Credit
111	10
112	15
333 (tax payable)		25
211		5
444 (tax receivable)	5

In February 2009, you entered the following transactions:

Document	Posting Date	Net Amount	Tax Amount	Tax Group/Tax Account
IN3	5/2/2009	1000	100	A1/111
IN4	10/1/2009	500	50	A2/112
PU2	1/2/2009	-900	-90	B1/211
Total		600	60

Although your total liability in February 2009 is 60, IN4 should be submitted in January 2009 (the invoice has been posted in February 2009 with a January 2009 posting date). You have the following options:

Create a Replacement type report for January 2009 including all items with a January 2009 posting date.
Create an Adjusted type report, containing only items with a January 2009 posting date that were not included in the January 2009 report

Note
Not available in UK.

End of the note.
Create a Original type report for February 2009 including all items posted in February 2009, even if they contain posting dates earlier than February 2009.