Follow

Calculate VAT Manually

Important

Review the contents of this article together with your trustee.

We do not offer accounting support. These instructions are only intended to familiarize you with the capabilities of our software. We did not consider all possible types of postings, such as input tax adjustments, adjustments to foreign currency payments, etc.

 

Contents

 

Important Prior Knowledge

  • This article will review the posting rationales that are relevant for VAT.
  • In the account sheet, filter by the VAT rate under "Advanced filters".

 

Initial Situation

The wrong accounting method ("As received"/"As agreed") has been selected for your client's account. If there are already postings for this year, you cannot convert them. The easiest way would be to calculate the VAT for this year yourself.

 

Procedure

Regardless of the accounting method you choose, you need the following reports:

What Data range Where
Income statement and balance sheet Q1 - Q4 20xx / S1 & S2 20xx Accounting -> Reports -> …

Account form

  • 1100
  • 2000
  • 1170, 1171 & 1172
  • 2200 & 2202
Q1 - Q4 20xx / S1 & S2 20xx
Outstanding debit/credit items Closing date of the end of the quarter/semester
VAT settlement Q1 - Q4 20xx / S1 & S2 20xx Accounting -> VAT

 

Tip

Adjust the accounting method for next year now. You can do this under “Settings” → “All Settings” → “Accounting” → “Basic VAT Settings”. Click on the tax period and select the next year, if available.

If this does not exist, you can create it via “Add next period”. Please note that if you change your accounting method at the Swiss Federal Tax Administration (ESTV) for the next year, you must also adjust this setting in bexio for next year.

 

Back to the Contents

 


 

I selected the "As agreed" accounting method, but I think I should have selected "As received" (effective taxation)

 

Accounting method (Actual) Accounting method (Target)
As agreed As received

 

VAT

You use the amounts of the VAT statement ("As agreed") as a basis. Manually calculate the VAT amount owed according to the amount collected for each VAT rate (2.5%/3.8%/7.7%). You will find the figures for this in combination with the respective items list and the account sheet for account 1100.

What VAT rate The net amount VAT amount
Sales in accordance with the "As agreed" accounting method 7.7% 10'000.- 770.-
Minus open outstanding debit items as of 3/31/2020 7.7% - 2'000.- - 154.-
Plus outstanding debit items as of 12/31/2019 7.7% + 3'000.- + 231.-
Total sales as agreed   = 11'000.- = 847.-

 

Input tax

You use the list of outstanding credit items and the account sheet for accounts 1170 and 1171. There you will see the associated input tax postings. This allows you to add up the tax postings and calculate the input tax deduction. Be sure to sort the deductions into the categories “Input tax on investments” (Item 405) and “Input tax on materials” (Item 400).

What VAT rate The net amount VAT amount
Input tax in accordance with the "As agreed" accounting method Ziffer 400   250.-
Minus input tax on open credit items as of 3/31/2020 Ziffer 400   - 25.-
Plus input tax on open credit items as of 12/31/2019 Ziffer 400   + 35.-
Total input tax on Item 400     = 260.-

 

What VAT rate The net amount VAT amount
Input tax in accordance with the "As agreed" accounting method Ziffer 405   400.-
Minus input tax on open credit items as of 3/31/2020 Ziffer 405   - 150.-
Plus input tax on open credit items as of 12/31/2019 Ziffer 405   + 250.-
Total input tax for Item 405     = 500.-

 

Import tax

You therefore also report the import tax in the quarter of payment. If you posted a credit item with import tax in Q1 but paid it in Q2, you must make the appropriate corrections.

Please make sure that you only account for the credit items for which you claim input tax deduction.

 

Back to the Contents

 

 


 

 

I selected the "As received" accounting method, but I think I should have selected "As agreed" (effective taxation)

 

Accounting method (Actual) Accounting method (Target)
As received As agreed

 

VAT

You use the amounts of the VAT statement as received as a basis. Manually calculate the VAT amount owed according to the amount agreed for each VAT rate (2.5%/3.8%/7.7%). You will find the figures for this in combination with the respective items list and the account sheet for account 1100.

What VAT rate Net amount VAT amount
Sales in accordance with the "As agreed" accounting method  7.7% 10'000.- 770.-
Plus open outstanding debit items as of 3/31/2020  7.7% + 2'000.- + 154.-
Minus outstanding debit items as of 12/31/2019 (These should not be taken into account if the "As agreed" VAT method was select for the previous year; otherwise, they are not deducted.)  7.7% - 3'000.- - 231.-
Total sales (under "As agreed")    = 9'000.- = 693.-

 

As you have read under “Posting rationale for "As collected" (effective taxation)”, we post the VAT using the "As collected" method to the 2202 account. To check the VAT amount as of 3/31/2020, use the account sheet for account 2202.

Input tax

You use the list of outstanding credit items and the account sheet for accounts 1170 and 1171. There you will see the associated input tax postings. This allows you to add up the tax postings and calculate the input tax deduction. Be sure to sort the deductions into the categories “Input tax on investments” (Item 405) and “Input tax on materials” (Item 400).

What

VAT rate Net amount VAT amount
Input tax in accordance with the "As agreed" accounting method Ziffer 400   250.-
Plus input tax on open credit items as of 3/31/2020 Ziffer 400   + 25.-
Minus input tax on open credit items as of 12/31/2019 Ziffer 400   - 35.-
Total Vorsteuer Ziffer 400     = 240.- 

 

What

VAT rate Net amount VAT amount

Input tax in accordance with the "As agreed" accounting method

Ziffer 405   400.-

Plus input tax on open credit items as of 3/31/2020

Ziffer 405   + 150.-

Minus input tax on open credit items as of 12/31/2019

Ziffer 405   - 250.-
Total input tax for Item 405     = 300.-

 

As you have read under “Posting rationale for "As agreed" (effective taxation)”, we post the VAT using the "As agreed" method to the 1172 account (including also on the accounts payable side, i.e., supplier invoices). To check the VAT amount as of 3/31/2020, use the account sheet for account 1172.

 

Import tax

You therefore also report the import tax in the accounting quarter. If you posted a credit item with import tax in Q1 but paid it in Q2, you must make the appropriate corrections.

Please make sure that you only account for the credit items for which you claim input tax deduction.

 

Back to the Contents

 


 

I selected the "As agreed" accounting method, but I think I should have selected "As received" (net taxation)

Accounting method (Actual) Accounting method (Target)
As agreed As received


VAT

You use the amounts of the VAT statement as agreed as a basis. Manually calculate the VAT amount owed according to the "As received" method as per the VAT rate. You will find the figures for this in combination with the respective items list and the account sheet for account 1100.

If you work with two net tax rates, calculate the VAT to be paid for each net tax rate. In our example, we use a net tax rate of 4.9%.

What

VAT rate Net amount VAT amount

Sales in accordance with the "As agreed" accounting method

Net tax rate 4.9% 10'000.- 490.-

Minus open outstanding debit items as of 3/31/2020

Net tax rate 4.9% - 2'000.- - 98.-

Plus outstanding debit items as of 12/31/2019

Net tax rate 4.9% + 3'000.- + 147.- 
Total sales as agreed   = 11'000.-  = 539.- 

 

Import tax

You therefore also report the import tax in the semester of payment. If you posted a credit item with import tax in S1 but paid it in S2, you must make the appropriate corrections.

Please make sure that you only account for the credit items for which you claim input tax deduction.

 

Back to the Contents

 


 

I selected the "As received" accounting method, but I think I should have selected "As agreed" (net taxation)

Accounting method (Actual) Accounting method (Target)
As received As agreed

 

VAT

You use the amounts of the VAT statement as received as a basis. Manually calculate the VAT amount owed according to the "As agreed" method as per the VAT rate. You will find the figures for this in combination with the respective items list and the account sheet for account 1100.

If you work with two net tax rates, calculate the VAT to be paid for each net tax rate. In our example, we use a net tax rate of 4.9%.

What

VAT rate Net amount VAT amount
Sales in accordance with the "As agreed" accounting method Net tax rate 4.9% 10'000.- 490.-

Plus open outstanding debit items as of 3/31/2020

Net tax rate 4.9% + 2'000.- + 98.-

Minus outstanding debit items as of 12/31/2019
(These should not be taken into account if the "As agreed" VAT method was select for the previous year; otherwise, they are not deducted.)

Net tax rate 4.9% - 3'000.- - 147.-
Total sales (under "As agreed")   = 9'000.- = 441.- 

As you have read under “Posting rationale for "As collected" (effective taxation)”, we post the VAT using the "As collected" method to the 2022 account. To check the VAT amount as of 3/21/2020, use the account sheet for account 2202.

 

Import tax

You therefore also report the import tax in the accounting semester. If you posted a credit item with import tax in S1 but paid it in S2, you must make the appropriate corrections.

Please make sure that you only account for the credit items for which you claim input tax deduction.

 

Back to the Contents

 


 

Posting rationale

 

"As received" accounting rationale (effective taxation)

We post the income using the "As received" method promptly, i.e., at the time when the invoice is issued. For example, if an invoice is issued for a total of CHF 107.70, we post the following when the invoice is issued:

Date Debit Credit Amount
07/03/20xx 1100 - Receivables from services (debit items) 2202 - VAT equalization accounting method 7.70
07/03/20xx 1100 - Receivables from services (debit items) 3401 - Gross proceeds of credit transactions 107.70

And at the time of payment:

Date Debit Credit Amount
07/31/20xx 2202 - VAT equalization accounting method 2200 - Owed VAT 7.70
07/31/20xx 1020 - Bank 1100 - Receivables from services (debit items) 107.70

 

"As agreed" accounting rationale (net taxation)

When using net taxation, we post the gross income. At the same time, the VAT amount is removed from the income. If an invoice is generated with a net tax rate of 5.9% for a total of CHF 100.00, we post the following when the invoice is issued:

Date Debit Credit Amount

07/03/20xx

3401 - Gross proceeds of credit transactions 2200 - Owed VAT 5.90
07/03/20xx 1100 - Receivables from services (debit items) 3401 - Gross proceeds of credit transactions 100.-

 

And at the time of payment:

Date Debit Credit Amount
07/03/20xx 1020 - Bank 1100 - Receivables from services (debit items) 100.-

 

Import tax "As agreed" posting rationale (effective taxation)

Standing:

Date Debit Credit Amount
07/01/20xx 1171 - Pre-tax investments, other operating expenses, Kl. 1/5-8 2203 - Import tax 7.70
07/01/20xx 6570 - Leasing and rental of hardware and software 2000 - Liabilities from services (credit items) 100.-

Payment:

Date Debit Credit Amount
07/31/20xx 2000 - Liabilities from services (credit items) 1020 - Bank 100.-

 

Import tax "As received" posting rationale (effective taxation)

Standing:

Date Debit Credit Amount
07/01/20xx 1172 - Input tax adjustment for settlement method 2202 - VAT equalization accounting method 7.70
07/01/20xx 6570 - Leasing and rental of hardware and software 2000 - Liabilities from services (credit items) 100.-

Payment:

Date Debit Credit Amount
07/31/20xx 1171 - Pre-tax investments, other operating expenses, Kl. 1/5-8 1172 - Input tax adjustment for settlement method 7.70
07/31/20xx 2202 - VAT equalization accounting method 2203 - Import tax 7.70
07/31/20xx 2000 - Liabilities from services (credit items) 1020 - Bank 100.-

 

 

Back to the Contents

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request