Skip to main content

Import invoice line item amounts

What invoice line item amounts should be imported and when?

Written by Petr Pech

I have the base amount and total

  • Quantity - mnozMj

  • Unit price - cenaMj

  • Base sum - sumZkl

  • Total sum - sumCelkem

  • Price type - typCenyDphK.bezDph

  • VAT rate - typSzbDphK

Example

<polozkyFaktury>
<faktura-vydana-polozka>
<mnozMj>60056.12</mnozMj>
<cenaMj>20.7646216572</cenaMj>
<sumZkl>1030613.73</sumZkl>
<typSzbDphK>typSzbDph.dphZakl</typSzbDphK>
<sumCelkem>1247042.61</sumCelkem>
</faktura-vydana-polozka>
</polozkyFaktury>

Alternatively, you can also import just the base amount, unit price, and quantity (i.e. mnozMj, cenaMj, sumZkl). Flexi is able to calculate the remaining values automatically.

I have the VAT amount and total

  • Quantity - mnozMj

  • Unit price - cenaMj

  • VAT sum - sumDph

  • Total sum - sumCelkem

  • Price type - typCenyDph.sDph

  • VAT rate - typSzbDphK

Example

<polozkyFaktury>
<faktura-vydana-polozka>
<mnozMj>60056.12</mnozMj>
<cenaMj>20.7646216572</cenaMj>
<sumDph>216428.88</sumDph>
<typSzbDphK>typSzbDph.dphZakl</typSzbDphK>
<sumCelkem>1247042.61</sumCelkem>
</faktura-vydana-polozka>
</polozkyFaktury>

VAT calculation

Total amount - (Total amount / 1.21)

60,000 CZK - (60,000 / 1.21) = 10,413.22 CZK

The values of internal code lists (e.g. price types and VAT rates) can be found in the so-called evidence list: https://demo.flexibee.eu/flexi/demo/evidence-list/

Did this answer your question?