Month-End Closing

This process describes the monthly account reconciliation process.

Background Info

Monthly, we reconcile our accounting with the bank and credit card accounts. This makes sure that we have booked everything correctly.

Checklist

• each account balance is equal to the balance in the bank statement
• all added bookings have a receipt
• all bookings are correctly classified

Process AG

High Level Process

1. In bexio

   1. in banking, reconcile bank transactions by fetching in the Banking module

2. In Revolut

   1. make sure all expenses are entered for the previous month
      
   2. export expenses
      1. select Ready to export
      2. select time range
      3. click on Download
         

   3. get Transactions by going to https://business.revolut.com/transactions (NOTE: there will be duplicates with the expenses, but they will be ignored by Kontera)
      

   4. export the statements by going to https://business.revolut.com/overview?type=statements&accountType=all-main.
      

3. in Kontera

   1. import expenses from Revolut
      
      
      
   2. import transactions from Revolut
      
      The duplicates will be ignored:
      
   3. book unmatched transactions
      1. transfers:
         1. Ohne Kontakt
         2. 1090
         3. No VAT
         4. Bankkurs nicht übernehmen
            
   4. verify automatically matched transactions, specifically MwSt:
      1. if MwSt on receipt, V-code (Vorsteuer -> zurückfordern)
         1. VM: 4000er Konten (V-Marge) CoS)
         2. VB: alle anderen (V-Betrieb): Personal 5, betrieblicher Aufwand 6)
      2. Dienstleistungen aus dem Ausland: Bezugssteuer
         1. BZM: 4000er Konten
         2. BZB: alle anderen

4. in Amnis

   1. for each account, download the statement as a PDF
      
   2. Enter the transactions, as manual bookings
      1. the transfer from ZKB own account: book against 1090. Look up the FX of the ZKB transaction to make sure the 1090 balances out.
         
         
         
      2. The FX transactions in bexio are booked against 1090, as manual transactions
      3. The Cashbacks, you book as a manual booking:
         

5. in bexio, reconile the statements with the bexio account balance

   1. For each account, check ending balance by comparing the Kontenblatt in bexio with the statement's balance
   2. for CHF Accounts, select 1. of month to last of month in bexio
   3. for FX Accounts, select 1.1. of year to end of last of month. This allows you to compare against value in foreign currency
   4. for REVOLUT and AMNIS, compare PDF statement
      
   5. for ZKB, compare with balance in e-banking
      
   6. for Telxi we reconcile the balance:
      

VAT (MwSt)

General

Vorsteuer vs. Bezugssteuer

• BZx: Bezugssteuer, Dienstleistungen aus dem Ausland

• Vx: Vorsteuer

Marge vs. Betrieb

• xM: M = Marge, d.h. bezogenen Dienstleistungen, die die Top Line, also die Marge betreffen, also alles was auf 3xxx Kontos gebucht wird

• xB: B = Betrieb, d.h. alles, was für den Betrieb notwendig ist, also was auf 4xxx Kontos gebucht wird

Specifics

• AirBnb: V00

• Cloudflare: BZB

• Google Ads: BZB

• Banken (e.g. Kontoführungsgebühr): V00

• Freshworks: VB

• pax8: BZM

Post Condition:

• the end balance is the same
• all the bookings are the same