ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Barter statement
Excel template · VAT

Barter statement: mutual offset

Enter the goods, work and services each party delivered: the template calculates how much of the amount excluding VAT is offset, who pays the difference and how much VAT each party must transfer to the other party's VAT deposit account.

Updated:
Valtera_Barter_offset_act_EN.xlsx · 10 KB · Sheets: Guide, Barter act
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Barter_offset_act_EN.xlsx — Barter act · Preview with sample data
Act No.1Date20.10.2026VAT rate0
Party AExample LLCTIN (VÖEN)1234567891VAT payerYes
Party BPartner LLCTIN (VÖEN)9876543211VAT payerYes
Basis (contract)Exchange (barter) contract No. 7 dated 05.03.2026
I. GOODS, WORKS AND SERVICES DELIVERED BY PARTY A TO PARTY B
DescriptionUnitQuantityPrice (excl. VAT)Amount (excl. VAT)VATAmount (incl. VAT)
Cement M-400 (50 kg)bag4009.50
Delivery servicetrip2250
Total
II. GOODS, WORKS AND SERVICES DELIVERED BY PARTY B TO PARTY A
DescriptionUnitQuantityPrice (excl. VAT)Amount (excl. VAT)VATAmount (incl. VAT)
Office furniture setset31,200

How VAT is paid in a barter

  • Under Article 175.1 of the Tax Code, barter and mutual offset count as payment of the amount excluding VAT.
  • The VAT amount is not offset: each party must transfer it separately to the other party's VAT deposit account. Otherwise the buyer cannot offset that VAT.
  • A barter is valued at market price (Tax Code, Art. 14.3.1) and is a taxable transaction: each party issues an e-invoice for its own supply.
  • The difference between the amounts excluding VAT is paid in money to the bank account.

What the template includes

  • Parties, TIN (VÖEN), whether each is a VAT payer (selected from a list), VAT rate.
  • Two tables: goods delivered by A to B and by B to A (8 rows), amounts excluding and including VAT.
  • Settlement: the offset amount and the difference. Payment table: who pays whom, to which account and how much.

To check VAT: VAT calculator.

Frequently asked questions

What if one of the parties is not a VAT payer?

For that party, select "No" in the "VAT payer" cell: no VAT is charged on its supply and the VAT payment line is zero.

Is a contract needed for a barter?

Yes, an exchange (barter) contract is concluded. The statement formalises the goods delivered under the contract and the offset.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.