How to book a bank statement

 

---

 

The bank statement shows the date on which payments to creditors and payments from debtors were processed by the bank. This includes both procedural and manual payments. Each of these payments has its own booking method. To book a bank statement, first select the journal in the header of the payment. The header contains the general data applicable to the entire payment, including the current opening balance. Then, create a payment line, where you select the internet banking batch.

 

 

Step 1: Select the journal

 

Open the payment and select the Journal in the header. The header of the payment contains the opening and closing balance. Enter the new balance in the Control balance field, as stated on the bank statement. After each payment line you create and fill, this field will be updated by MKG, as well as the other fields in the header.

 

 

Payment 1: procedural sales invoice

 

Click on Payment line

to create a line. In this line, select 'Debtor' in the Type option. Then choose the debtor in the Sub-administration. If it concerns a payment for one or more procedural sales invoices, the invoice numbers are often mentioned in the description on the statement. Enter the credited amount in the Financial amount field.

 

Sub-administration items Under Sub-administration items you will find the items included in this payment. If these are not selected, the Incorrect booking field will be checked in the payment line.

 

 

Payment 2: procedural purchase invoice

 

Click on Payment line

to create a line. In this line, select 'Creditor' in the Type option. Then choose the creditor in the Sub-administration. If it concerns a payment for one or more procedural purchase invoices, the invoice numbers are often mentioned in the description on the statement. Enter the debited amount in the Financial amount field.

 

Note! Do not forget to place a minus sign before the amount in the Financial amount field if it is a payment to a creditor.

 

 

Payment 3: manual purchase invoice with different VAT

 

Click on Payment line

to create a line. In this line, select 'General ledger' in the Type option. Then choose the general ledger account in the Sub-administration, for example, in the case of a payment for insurance. Enter a Description. Enter the debited amount in the Financial amount field.

Click through on the line. Check in the 'General' group that this payment concerns Costs and that No VAT is selected.

 

 

Payment 4: direct debit

 

Click on Payment line

to create a line. In this line, select 'General ledger' in the Type option. Then choose the general ledger account in the Sub-administration, for example, in the case of a direct debit for an internet subscription. Enter a Description. Enter the debited amount in the Financial amount field.

Click through on the line. Check in the 'General' group that this payment concerns Costs and select Including VAT. The 'VAT' group will expand, showing the VAT amount.

 

 

Step 2: Save the payment

 

The Control balance field shows the new balance, as stated on the bank statement; the Difference field shows € 0.00. Now click on Save

to save the payment. The bank statement is booked.

 

 

---

Book a bank statement A video of this guide is available, showing you the steps described. Do you want to see how to book a bank statement in MKG? Watch this video. duration: 6:49 | sound: no | video opens in new window

---

 

Knowledge Center How do you process an internet banking batch in the payment