BPM Country Reports

Germany

This section describes the Germany reports appendix.

UStVA Report Mapping

This report utilizes the Tax Settlement universe. The following objects are identified as part of the queries.xml.

Report Field Name Maconomy Mapping & Description
<Elster>
<TransferHeader>
Important: Transfer header is only used for when the integration to Elster is done. The same goes for all elements under this group.

Optional.

<DatenArt> This field shows the Data Type.

Optional.

Hardcoded: "USTVA"

<Vorgang> This field shows the Process.

Optional.

Hardcoded: "send-Auth"

<Testmerker> Test notator, whether the file is a test or not.

Optional.

Code: If Testmerker checkbox = true "Ja"

Else map NULL

<VersionClient> This is the Maconomy version.

Optional.

Code: "21.0.104.0"

</TransferHeader>
<DatenTeil> This field block shows the data part of USTVA.

Optional.

<Nutzdatenblock>

Optional.

<NutzdatenHeader version="11" > Attribute Code.

Optional.

Hardcoded: version = "11"

<Empfaenger id="F"> This field shows the Receiver information with ID. This has a static value of "F".

Optional.

Code: id = Hardcoded "F".

</NutzdatenHeader>
<Nutzdaten>

Optional.

<Anmeldungssteuern xmlns="" version="" > This field shows specific information for USTVA.

Version attribute is derived from current year and a hardcode "01".

Optional.

Attribute Code:

xmlns="http://finkonsens.de/elster/elsteranmeldung/ustva/v2021"

Attribute Code: version = Current year

Both Mandatory.

Data Type: String

Note: We did not change anything from the schema.
<Erstellungsdatum> This field shows the start date of the report.

Optional.

Values either:

  • Start date of the month or the quarter in the Selection criteria (YYYYMMDD) if period.

    Or

  • Start date in the Selection criteria (YYYYMMDD) if entry date.

Data Type: String

<DatenLieferant> This field shows the Company Information for single company transactions or Tax Reporting Unit information for multiple company transactions.

Optional.

Condition: IF Tax Reporting Unit is Entered in Selection Criteria.

(IF Company > 1

Tax Reporting Unit Information (see field values below)

ELSE

Company Information (see field values below)

)

<Name> This fields shows the Tax Reporting Unit Name for multiple companies or Company Name for single company.

Optional.

Values either:

  • Tax Reporting Unit \ TaxReportingUnitName

    Or

  • Company \ Company Name

Length: Minimum = 1 Maximum = 45

Data Type: String

Data Type: String

<Strasse> This fields shows the Tax Reporting Unit Tax Office 1 for multiple companies or Company Address 1 for single company.

Optional.

Values either:

  • Tax Reporting Unit \ Tax Office 1

    Or

  • Company \ Contact Information \ Name2

Length:

Minimum = 1

Maximum = 30

Data Type: String

<PLZ> This fields shows the Tax Reporting Unit Tax Office 2 for multiple companies or Company ZipCode for single company.

Optional.

Values either:

  • Tax Reporting Unit \ Tax Office 2

    Or

  • Company \ Contact Information\ ZipCode

Length:

Minimum = 1

Maximum = 12

Data Type: String

<Ort> Description: This fields shows the Tax Reporting Unit Tax Office 3 for multiple companies or Company Postal District for single company.

Optional.

Values either:

  • Tax Reporting Unit \ Tax Office 3

    Or

  • Company \ Contact Information \ Postal District

Length:

Minimum = 1

Maximum = 30

Data Type: String

<Telefon> This fields shows the Tax Reporting Unit Tax Office 4 for multiple companies or Company Telephone for single company.

Optional.

Values either:

  • Tax Reporting Unit \ Tax Office 4

    Or

  • Company \ Contact Information \ Telephone

Length:

Minimum = 1

Maximum = 20

Data Type: String

<Email> This fields shows the email specified from the Selection Criteria.

Optional.

From Selection Criteria

Length:

Minimum = 1

Maximum = 70

Data Type: String

</DatenLieferant>
<Steuerfall> This field block shows the Tax related information.

Optional.

<Umsatzsteuervoranmeldung> This field block shows information for USTVA.

Optional.

<Jahr> This field shows the Start Year used in the Selection criteria.

Optional.

Value: Start year based on Selection criteria (YYYY)

Data Type: String

<Zeitraum> This field shows the two-digit integer code for Monthly Period or Quarterly Period.

Optional.

Value: 01-12 for monthly period or 41-44 for quarterly period

Optional.

Data Type: String

<SteuerNummer> This fields shows the Company Tax No. (Optional).

Value: Company/Tax No.

Data Type: String

<Kz09> 5-digit manufacturer ID assigned to Deltek Germany.

Value: hardcode "21651"

Mandatory Length:

Minimum = 5

Maximum = 95

Data Type: String

<Kz10> Corrected registration.

Value: Selection Criteria

Code: IF checkbox Corrected Registration is marked THEN map "1" otherwise no xml tag for the kzline.

Data Type: String

<Kz21> Non-taxable services rendered to businesses in other EU-Member States (18b sent. 1 no. 2 German VAT Act).

Kz 21 relates to non-taxable supplies of services to entrepreneurs established in the European Union solely. Therefore, domestic German non-taxable transactions are not to be reported in Kz 21.

As the transactions are non-taxable, there is no reporting obligation in the preliminary German VAT return and thus, no non-taxable domestic German transactions are covered in the preliminary German VAT return.

Optional.

Code: IF VATPopup1 = Services

AND VATRate = 0%

AND BillTo Customer Country != Germany

AND BillTo Customer EU Member = Yes

THEN Settlement\ Basis Amounts\ Tax Basis\ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz22> Vouchers will be submitted separately (from 2006). Documents (invoices, contracts, etc.) are attached or are being provided separately (if yes, please enter "1").

Mandatory.

Value: Selection Criteria

Condition: IF checkbox kz22 is marked

THEN map "1" otherwise no xml tag for the kzline.

Data Type: String

<Kz23> In addition to the information in the tax return, other or different information or facts must be taken into account (if yes, please enter a "1").

This fields shows the Needs additional Information field in the Selection criteria.

Value: Selection Criteria

Condition: IF checkbox Needs Additional Information is marked

THEN map "1" otherwise no xml tag for the kzline.

Data Type: String

<Kz23_Begruendung> This fields shows the Additional Information on Tax Registration field in the Selection criteria.

Optional.

Value: Manually entered in Selection criteria

Length:

Minimum = 1

Maximum = 180

Note: When Needs additional Information checkbox in the selection criteria is not ticked, this field will not populate.

Data Type: String

<Kz26> The SEPA Direct Debit Mandate shall be revoked by way of exception (for example, due to offsetting requests) for this reporting period.

Mandatory.

Value: Selection Criteria

Condition: IF checkbox SEPA-Direct Debit Mandate Payment is marked

THEN map "1" otherwise no xml tag for the kzline.

Data Type: String

<Kz29> A refund amount is transferred to the account provided to the tax authorities, insofar as the amount is not offset against outstanding tax liabilities.

Amount to be refunded is to be offset / amount to be refunded is assigned (if yes, please enter "1").

Mandatory.

Settlement of the refund amount desired / Refund amount is assigned.

Value: Selection Criteria

Condition: IF checkbox Settlement of the refund amount desired / Refund amount is assigned is marked

THEN map "1" otherwise no xml tag for the kzline.

Data Type: String

<Kz39> Deduction of the assessed prepayment for the application of a permanent filing and payment extension (usually only to be considered in the last periodic VAT return of the tax period).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz41> Intra-Community supplies of goods (section 4 no. 1 letter b German VAT Act) to customer with VAT-ID No.

Optional.

Condition: IF BillToCustomerEUMember = Yes

AND VATPopup1 = Goods

AND VATRate = 0.0%

AND Bill to Customer Tax No > 0

AND Bill To Customer <>Germany THEN

Settlement\ Basis Amounts \ Tax Basis \ Tax Basis - Company

Note: When Bill To Customer Tax No is empty, kz41 will not populate.

Data Type: BigInteger

Max Length: 13

<Kz42> Supplementary information on sales. Supplies of the first customer in an intra-Community triangular transaction (section 25b German VAT Act).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz43> Further tax-exempt sales with input tax deduction (for example, export deliveries, sales according to 4 Nos. 2 to 7 UStG).

The domestic German transactions which are zero-rated/tax exempt are either declared in Kz 43 or 48 depending on the paragraph for the zero-rating/tax exemption.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz44> Intra-Community deliveries of new vehicles to customers without VAT ID.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz45> Other non-taxable sales (place of supply not in Germany).

Optional.

Condition: IF BillToCustomer Country <> Germany

AND VATPopup1 = Goods/Services/Blank and VATRate = 0%

AND TaxCountry <> Germany

AND BillToCustomer EU Member <> Yes THEN

Settlement\ Basis Amounts\ Tax Basis\ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz46> Taxable services rendered by businesses in other EU-Member States (section 13b (1) German VAT Act).

Optional.

Condition: IF TaxCountry <> Germany

AND VATPopup1 = Services

AND EUAcquisition = Yes

AND Vendor EU Member = Yes THEN

Settlement\ Basis Amounts\ Tax Basis\ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz47> Tax Deductible amount of Kz46.

Optional.

19% VAT rate.

Condition: IF TaxCountry <> Germany

AND VATPopup1 = Services

AND EUAcquisition = Yes

AND Vendor EU Member = Yes THEN

Settlement\Tax Amounts\Tax Deductible\Tax Deductible - Company

Data Type: BigDecimal

<Kz48> Tax-free sales without input tax deduction according to 4 Nos. 8 to 28 UStG.

The domestic German transactions which are zero-rated/tax exempt are either declared in Kz 43 or 48 depending on the paragraph for the zero-rating/tax exemption.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz49> Intra-Community deliveries of new vehicles outside a company (2a UStG).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz59> Deduction of input tax for intra-Community deliveries of new vehicles outside a company (2a UStG) as well as of small businesses within the meaning of 19 Abs. 1 UStG (15 Abs. 4a UStG).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz60> Other sales for which the recipient of goods and services owes VAT incurred pursuant to the German Reverse Charge provisions (section 13b (5) German VAT Act).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz61> Input VAT arising from intra-Community acquisition of goods.

This line should include the VAT on intra-community acquisitions of goods (calculated from Boxes 89, 93 and 96, 98, or lines 33-35) that can be reclaimed by the filing company/taxpayer as input VAT.

VAT ONLY.

Optional.

Condition: VAT of Kz89 + VAT of Kz93 + Kz98 + Kz96

Where:

  • Kz89 and kz93 have calculated VAT does not display in the xml file
  • Kz98 and kz96 are manually entered in the selection criteria

Data Type: BigDecimal

<Kz62> Import VAT paid (section 15 (1) sent. 1 no. 2 German VAT Act).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz63> Input VAT amounts calculated according to general average rates (sections 23 and 23a German VAT Act).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz64> Adjustment of input VAT deduction (section 15a German VAT Act).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz65> Tax due to change of taxation type and form as well as after tax on taxed down payments due to tax rate increase.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz66> Input VAT as shown on purchase invoices issued by other businesses (section 15 (1) sent. 1 no. 1 German VAT Act), from supplies in the meaning of section 13a (1) no. 6 German VAT Act (section 15 (1) sent. 1 no. 5 German VAT Act) and arising from intra-Community triangular transactions (section 25b (5) German VAT Act).

This box should include input VAT that can be reclaimed from invoices received from other entrepreneurs as well as from the second supply of goods in an intra-Community triangular trade (for which the transport ended in Germany).

Optional.

Condition: IF EUAcquisition <> Yes

AND VATPopup1 = Goods/Services/Blank

AND TaxSettlementType =Tax Receivable THEN

Settlement \ Tax Amounts\ Tax Amount - Company

Data Type: BigDecimal

<Kz67> Input VAT incurred due to Reverse Charge provisions (section 15 (1) sent. 1 no. 4 German VAT Act).

Optional.

Same as Kz47.

Data Type: BigDecimal

<Kz69> VAT amounts shown incorrectly or unjustifiably in invoices (section 14c German VAT Act) 8 customer as trade consignor or the warehouses' owner respectively pursuant to section 13a (1) no. 6 German VAT Act.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz76> Turnover for which a tax is payable under 24 UStG (sawmill products, beverages and alcohol, for example, wine).

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz77> Deliveries of agricultural and forestry enterprises to US $ 24 VAT to customers with VAT ID up to 2009: Sales of agricultural and forestry enterprises according to 24 UStG deliveries to the rest of the Community to customers with VAT ID.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz80> VAT amount of kz76.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz81> Taxable sales (supplies and other services incl. benefits in kind) subject to 19 % VAT. In Box 81, the net amount of sales generated by the filing company/taxpayer that are subject to German VAT at the regular rate of 19% must be entered.

VAT on this amount is calculated automatically by the form and entered into the adjacent field (column "Steuer"). This VAT amount is principally owed by the filing company/taxpayer, that is, it is a payable.

Optional.

Condition: IF VatRate = 19% AND TaxCountry = Germany AND Tax Settlement Type = Tax Payable AND VATPopup1 = Blank/Goods/Services THEN

Settlement \ Basis Amounts \ Tax Basis\ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz83> Total VAT payable.

Mandatory.

Condition: (((kz47+VAT OF kz81+VAT OF kz86+VAT OF kz89+VAT OF kz93+kz80+kz98+kz96) minus kz66+kz61+kz62+kz67+kz63+kz64+kz59) plus kz65+kz69) minus kz39.

Where:

  • Kz81, kz86, kz89, kz93 have calculated VAT that are not displayed in the xml file.
  • Kz36, kz80, kz98, kz96, kz61,kz62 kz63. Kz64, kz59, kz65. Kz69 and kz39 are manually entered on selection criteria.

Data Type: BigDecimal

Note: This field can be either be calculated in the xml output or calculated by the Elster site. However, the total amount provided in the xml output may differ by a little than when the amounts are manually entered in the elster site because there kz fields that are being rounded off when shown in the xml output.

(Considering that you will use the same entry from the xml output.)

<Kz86> Taxable sales (supplies and other services incl. benefits in kind) subject to 7 % VAT.

This box relates to sales generated by the filing company/taxpayer that are subject to German VAT at the reduced rate of 7%. The net amount of these sales is entered in Box 86. VAT on this amount is calculated automatically by the form and entered into the adjacent field (column "Steuer").

This VAT amount is principally owed by the filing company/taxpayer, that is, it is a payable.

Optional.

Condition: IF VatRate = 7%

AND Tax Country = Germany

AND TaxSettlementType = Tax Payable

AND VATPopup1 =Blank/Goods/Services THEN

Settlement \ Basis Amounts \ Tax Basis \ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz87> Relates to invoices sent (AR). Note that the German VAT rate of 0% only applies to supplies of solar modules to the operator of a photovoltaic system (including main components) on certain objects (for example, private homes or public buildings).

The corresponding Free ad valorem taxes relate to supplies without a consideration if input VAT has been deducted before.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz89> Taxable intra-Community acquisition of goods subject to 19 % VAT.

This box relates to intra-Community acquisitions of goods carried out by the filing company/taxpayer that are subject to German VAT at the regular rate of 19%. The net amount of these purchases is entered into box 89. VAT on this amount is calculated automatically by the form and entered into the adjacent field (column "Steuer").

This VAT amount is principally owed by the filing company/taxpayer, that is, it is a payable.

Optional.

Condition: IF EUVATRate = 19%

AND Vendor EU Member= Yes

AND Tax Settlement Type = Tax Receivable

AND VATPopup1 = Goods

AND EUAcquisition = Yes

Settlement \ Basis Amounts \ Tax Basis \ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz90> Zero rated VAT for the sale of solar items similar to kz87.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigDecimal

<Kz91> Intra-Community acquisition of goods.

Zero-rated intra-Community acquisition of goods acquisition of goods pursuant to sections 4b and 25c German VAT Act.

This box relates to intra-Community acquisitions of goods carried out by the filing company/taxpayer that are zero-rated, that is, no German VAT is due on them. The net amount of these purchases is entered into box 91.

Optional.

Condition: IF AND Tax Settlement Type = Tax Receivable and VATRate = 0%

AND VATPopup1 = Goods

AND EUAcquisition = Yes

AND Vendor EU Member = Yes THEN

Settlement \ Basis Amounts \ Tax Basis \ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz93> Taxable intra-Community acquisition of goods subject to 7% VAT.

This box relates to intra-Community acquisitions of goods carried out by the filing company/taxpayer that are subject to German VAT at the reduced rate of 7%. The net amount of these purchases is entered into box 93. VAT on this amount is calculated automatically by the form and entered into the adjacent field (column "Steuer").

This VAT amount is principally owed by the filing company/taxpayer, that is, it is a payable.

Optional.

Condition: IF EUVATRate=7%

AND Tax Settlement Type = Tax Receivable

AND VATPopup1 = Goods

AND EUAcquisition = Yes

AND Vendor EU Member = Yes THEN

Settlement \ Basis Amounts \ Tax Basis \ Tax Basis - Company

Data Type: BigInteger

Max Length: 13

<Kz94> Intra-Community acquisitions of new vehicles from suppliers without VAT ID. to the general tax rate.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz95> Intra-Community acquisitions at different tax rates.

Optional.

Value: Manually entered via Selection criteria.

Data Type: BigInteger

Max Length: 13

<Kz96> VAT amount of kz94.

Optional.

Value: Manually entered via Selection criteria

Data Type: BigDecimal

<Kz98> Description: VAT amount of kz95.

Optional.

Value: Manually entered via Selection criteria

Data Type: BigDecimal

</Umsatzsteuervoranmeldung>
</Steuerfall>
</Anmeldungssteuern>
</Nutzdaten>
</Nutzdatenblock>
</DatenTeil>
</Elster>

Special Filing Extension

Copy to follow.

Special Filing Extension Mappings

Report Field Name Maconomy Mapping & Description
<Elster>
<TransferHeader>
Important: Transfer header is only used for when the integration to Elster is done. The same goes for all elements under this group.

Optional.

<DatenArt> This field shows the Data Type.

Optional.

Hardcode: "USTVA"

<Vorgang> This field shows the Process

Optional.

Hardcode:"send-Auth"

<Testmerker> Test notator, whether the file is a test or not.

Optional.

Condition: If Testmerker checkbox = true, "Ja"

Else map NULL

<VersionClient> This is the Maconomy version.

Condition: "21.0.04.0"

Optional.

</TransferHeader>
<DatenTeil> Description: This field block shows the data part of USTVA.

Optional.

<Nutzdatenblock>

Optional.

<NutzdatenHeader version="11" > Attribute Code:

Hardcode: version = "11"

Optional.

<Empfaenger id="F"> This field shows the Receiver information with ID.

This has a static value of "F".

Optional.

Condition: id = Hardcode "F"

</NutzdatenHeader>
<Nutzdaten> Optional
<Anmeldungssteuern xmlns ="" version="" > This field shows specific information for USTVA.

Version attribute is derived from current year and a hardcode "01".

Optional.

Attribute Code:

xmlns= http://finkonsens.de/elster/elsteranmeldung/ustva/v2021

Data Type: String

Attribute Code: version = Current year

Data Type: String

Both Mandatory

Note: We did not change anything from the schema.
<Erstellungsdatum> This field shows the start date of the report

Optional.

Values either:

  • Start date of the period in the Selection criteria (YYYYMMDD) if period

    Or

  • Start date in the Selection criteria (YYYYMMDD) if entry date

Data Type: String

<DatenLieferant> This field shows the Company Information for single company transactions or Tax Reporting Unit information for multiple company transactions

Optional.

Condition: IF Tax Reporting Unit is Entered in Selection Criteria

(IF Company > 1

Tax Reporting Unit Information (see field values below)

ELSE

Company Information (see field values below)

)

<Name> This fields shows the Tax Reporting Unit Name for multiple companies or Company Name for single company

Optional.

Values either:

  • Tax Reporting Unit\TaxReportingUnitName

    Or

  • Company\Company Name

Length:

Minimum = 1

Maximum = 45

Data Type: String

<Strasse> This fields shows the Tax Reporting Unit Tax Office 1 for multiple companies or Company Address 1 for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 1

    Or

  • Company\Contact Information\Name2

Length:

Minimum = 1

Maximum = 30

Data Type: String

<PLZ> This fields shows the Tax Reporting Unit Tax Office 2 for multiple companies or Company ZipCode for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 2

    Or

  • Company\ Contact Information\ZipCode

Length:

Minimum = 1

Maximum = 12

Data Type: String

<Ort> This fields shows the Tax Reporting Unit Tax Office 3 for multiple companies or Company Postal District for single company

Optional.

Values either: or

  • Tax Reporting Unit\ Tax Office 3

    Or

  • Company\ Contact Information\Postal District

Length:

Minimum = 1

Maximum = 30

Data Type: String

<Telefon> This fields shows the Tax Reporting Unit Tax Office 4 for multiple companies or Company Telephone for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 4

    Or

  • Company\ Contact Information\Telephone

Length:

Minimum = 1

Maximum = 20

Data Type: String

<Email> This fields shows the email specified from the Selection Criteria.

Optional.

From Selection Criteria.

Length:

Minimum = 1

Maximum = 70

Data Type: String

</DatenLieferant>
<Steuerfall> This field block shows the Tax related information.

Optional.

<Dauerfristverlaengerung> This field block shows information for Permanent Extension Filing.

Optional.

<Jahr> This field shows the Start Year used in the Selection criteria.

Optional.

Value: Start year based on Selection criteria (YYYY).

Data Type: String

<SteuerNummer> This fields shows the Company Tax No..

Optional.

Value: Company/Tax No.

Data Type: String

<Kz09> 5-digit manufacturer ID assigned to Deltek Germany.

Value: 21651"

Length:

Minimum = 5

Maximum = 95

Data Type: String

<Kz23> In addition to the information in the tax return, other or different information or facts must be taken into account (if yes, please enter a "1").

This fields shows the Needs additional Information field in the Selection criteria.

Value: Selection Criteria

Condition: IF checkbox is marked THEN map "1".

Data Type: String

<Kz23_Begruendung> This fields shows the Additional Information on Tax Registration field in the Selection criteria.

Optional.

Value: Manually entered via Selection criteria.

Data Type: String

Note: When Needs additional Information checkbox in the selection criteria is not ticked, this field will not populate.

Special Advance Payment

Copy to follow.

Special Advance Payment Mapping

Report Field Name Maconomy Mapping & Description
<Elster>
<TransferHeader> Important: Transfer header is only used for when the integration to Elster is done.

The same goes for all elements under this group.

Optional.

<DatenArt> This field shows the Data Type.

Optional.

Hardcode: "USTVA"

<Vorgang> This field shows the Process

Optional.

Hardcode: "send-Auth"

<Testmerker> Test notator, whether the file is a test or not.

Optional.

Condition: If Testmerker checkbox = true, "Ja"

Else map NULL

<VersionClient> This is the Maconomy version.

Condition: "21.0.04.0"

Optional.

</TransferHeader>
<DatenTeil> This field block shows the data part of UStVA.

Optional.

<Nutzdatenblock> Optional
<NutzdatenHeader version="11" > Attribute Code:

Hardcode: version = "11"

Optional

<Empfaenger id="F"> This field shows the Receiver information with ID. This has a static value of "F".

Optional.

Condition: id = Hardcode "F"

</NutzdatenHeader>
<Nutzdaten> Optional.
<Anmeldungssteuern xmlns ="" version="" > This field shows specific information for USTVA.

Version attribute is derived from current year and a hardcode "01".

Optional.

Attribute Code:

xmlns="http://finkonsens.de/elster/elsteranmeldung/ustva/v2021"

Attribute Code: version = Current year

Both Mandatory.

Data Type: String

Note: We did not change anything from the schema.
<Erstellungsdatum> Description: This field shows the start date of the report.

Optional.

Values either:

  • Start date of the period in the Selection criteria (YYYYMMDD) if period.

    Or

  • Start date in the Selection criteria (YYYYMMDD) if entry date.

Data Type: String

<DatenLieferant> This field shows the Company Information for single company transactions or Tax Reporting Unit information for multiple company transactions.

Optional.

Condition: IF Tax Reporting Unit is Entered in Selection Criteria.

(IF Company > 1 Tax Reporting Unit Information (see field values below)

ELSE

Company Information (see field values below)

)

<Name> This fields shows the Tax Reporting Unit Name for multiple companies or Company Name for single company.

Optional.

Values either:

  • Tax Reporting Unit\TaxReportingUnitName

    Or

  • Company\Company Name

Length:

Minimum = 1

Maximum = 45

Data Type: String

<Strasse> This fields shows the Tax Reporting Unit Tax Office 1 for multiple companies or Company Address 1 for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 1

    Or

  • Company\Contact Information\Name2

Length:

Minimum = 1

Maximum = 30

Data Type: String

<PLZ> This fields shows the Tax Reporting Unit Tax Office 2 for multiple companies or Company ZipCode for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 2

    Or

  • Company\ Contact Information\ZipCode

Length:

Minimum = 1

Maximum = 12

Data Type: String

<Ort> This fields shows the Tax Reporting Unit Tax Office 3 for multiple companies or Company Postal District for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 3

    Or

  • Company\ Contact Information\Postal District

Length:

Minimum = 1

Maximum = 30

Data Type: String

<Telefon> Description: This fields shows the Tax Reporting Unit Tax Office 4 for multiple companies or Company Telephone for single company.

Optional.

Values either:

  • Tax Reporting Unit\ Tax Office 4

    Or

  • Company\Contact Information\Telephone

Length: Minimum = 1 Maximum = 20

Data Type: String

<Email> This fields shows the email specified from the Selection Criteria.

Optional.

From Selection Criteria

Length:

Minimum = 1

Maximum = 70

Data Type: String

</DatenLieferant>
<Steuerfall> This field block shows the Tax related information.

Optional.

< Umsatzsteuersondervorauszahlung> Description: This field block shows information for Permanent Extension Filing.

Optional.

<Jahr> This field shows the Start Year used in the Selection criteria.

Optional.

Value: Start year based on Selection criteria (YYYY).

Data Type: String

<SteuerNummer> This fields shows the Company Tax No..

Optional.

Value: Company/Tax No.

Data Type: String

<Kz09> 5-digit manufacturer ID assigned to Deltek Germany.

Value:hardcode "21651"

Length:

Minimum = 5

Maximum = 95

Mandatory

Data Type: String

<Kz10> This fields shows the Corrected Registration field in the Selection criteria.

Optional.

Value: Manually entered via Selection criteria.

Data Type: String

<Kz26> This fields shows the SEPA-Direct Debit Mandate Payment field in the Selection criteria.

Optional.

Value: Manually entered via Selection criteria.

Data Type: String

<Kz29> This fields shows the Settlement of the refund amount desired / Refund amount is assigned field in the Selection criteria.

Optional.

Value: Selection Criteria

Note: When this is ticked, then Special advance payment (kz38) will populate.

Code: IF checkbox is marked THEN map "1"

Data Type: String

<Kz38> This fields shows the Special Advance Payment field in the Selection criteria.

Optional.

Value: Manually entered in Selection criteria.

Note: When Settlement of the refund amount desired / Refund amount is assigned checkbox in the selection criteria is not ticked, this field will not populate.

Data Type: BigInteger

Total digits: 13

Kz Line Usage

Lines for Customer and Vendor Transactions

The following table shows the kz lines that are related to either customer or vendor transactions. This information is included for reference.

Related Transaction Kz Line
CUSTOMER kz21
kz41
kz45
kz81
kz86
VENDOR kz46
kz47
kz67
kz66
kz89
kz91
kz93

Additional Kz Lines in Selection Criterion

The following Kz lines are not developed by Deltek but can be manually updated and added via the selection criterion. This allows you to add these fields to the UStVA report XML output file.

  • Kz22
  • Kz39
  • Kz42
  • Kz43
  • Kz44
  • Kz48
  • Kz49
  • Kz59
  • Kz60
  • Kz62
  • Kz63
  • Kz64
  • Kz65
  • Kz69
  • Kz76
  • Kz77
  • Kz80
  • Kz87
  • Kz90
  • Kz94
  • Kz95
  • Kz96
  • Kz98

Unused Lines

The following kz fields are not applicable to Maconomy and are not included in the Selection Criteria nor in the file for USTVA. They are included here for reference and awareness.

  • kz33
  • kz35
  • kz36
  • kz51
  • kz52
  • kz53
  • kz54
  • kz55
  • kz57
  • kz58
  • kz68
  • kz70
  • kz72
  • kz73
  • kz74
  • kz78
  • kz79
  • kz84
  • kz85
  • kz97

Troubleshooting

Background Task Timeout

Reports with large volumes of records take longer to process and the background task may timeout. To prevent timeout errors, you must change the character stream size to 2000 or higher (on the BO server console), and set the background task duration to more than 24 hours (on Maconomy).

Set Character Stream Size

To prevent timeouts while running the report, you must change the character stream size on the Business Objects (BO) Central Management Console (CMC) prior to running the report.

To change the character stream size:

  1. On the BO CMC, log in as an Administrator.
  2. Click Servers and select Server List.
  3. From the list of server names, click WebIntelligenceProcessingServer.
  4. Select Properties then edit the Maximum Character Stream Size (MB) field value, from 15 to at least 2000 or your preferred value up to 4095.
    Note: The recommended value when running the report is 2000.
  5. Click Save then close the dialog box.
  6. Right-click WebIntelligenceProcessingServer then select Restart Server.

Set Background Task Maximum Duration

Note: This section applies to the Workspace Client.

If the default maximum duration time (1440 minutes) is not enough to generate the report, you can change the maximum duration for the background task.

To change the maximum duration:

  1. Generate a report to start a background task.

    Click OK in the prompt.

  2. Go to Setup » Background Tasks » Status and locate your task. It should be at the top of the list.
    1. Select the task and click the Abort action button.
    2. Click OK in the prompt.
    3. Right-click the task (the status displays as Failed) and click Copy as Template.

      A new task should display at the top of the list (the status displays as Pending.)

  3. Go to the Editing tab then locate and double-click the pending task.
    Note: You may need to filter the list and show Inactive Pending Tasks.
    1. Edit the Max. Duration field to a higher value, such as 2880 for 48 hours.
    2. Click the Save » Activate action.
    3. Click OK in the prompt.
  4. Go to the Status tab and click the Refresh action button.

    The task should run and generate a report.

    Note: If the background task still fails, you need to adjust the maximum duration time to accommodate the amount of records.