ManualDoc:TC56E698100314ABBBBD3A89626CA551C

There are key fields to note:

• Document No.: that is the imported bank statement number which is provided by the corresponding document sequence.
• Document Type: that is "Bank Statement File" document category (not "Bank Statement").
• Name: that is the name given by Openbravo which is a combination of the transactions dates and the amount in/out difference.
• Import Date: that is the date when the file was imported.
• Transaction Date: that is the date to use while posting the bank statement to the ledger.
• File name: that is the name of the file imported

An imported bank statement file can be "Reactivated" as once imported it gets processed automatically.

Once reactivated the bank statement header information as well as the bank statement lines can be changed as required.

Once done the bank statement can be Processed once again.

A Bank statement can be posted if that it is enabled in the accounting configuration tab of the financial account.

If you are not able to import a bank statement file, it is also possible to create bank statements and bank statement lines manually.

Bank Statement Posting example

This article illustrates Bank Statement posting concept with an example.

Example: bank statement posting

Let's consider a scenario where a bank statement contains 3 bank statement lines for a total amount of -5627.42€. The system will show below ledger entries after posting the bank statement.

Account	Dr	Cr
Bank transitory account	5627.42
Bank asset account		5627.42

Negative Bank Statement Lines:

Let's imagine that one of the bank statement lines has an amount = -4.627,42, that would mean a payment OUT: (Debit Amount = Payment OUT= Paid)

Bank statement line clearance posting looks like:

Account	Dr	Cr
Vendor liabilities	4627.42
Bank Transitory account		4627.42

Therefore the complete set of posting will look like:

Invoice posting:

Account	Dr	Cr
Expense	4627.42
Vendor liabilities		4627.42

Bank Statement Posting:

Account	Dr	Cr
Bank transitory account	4627.42
Bank asset account		4627.42

Bank statement line clearance posting:

Account	Dr	Cr
Vendor liabilities	4627.42
Bank Transitory account		4627.42

Positive Bank Statement:

Let's imagine that one of the bank statement lines has an amount = + 1000,00, that would mean a payment IN: (Credit Amount = Payment IN = Received)

Bank statement line clearance posting:

Account	Dr	Cr
Bank Transitory account	1000.00
Customer		1000.00

Therefore the complete set of posting will look like:

Invoice posting:

Account	Dr	Cr
Customer	1000.00
Income		1000.00

Bank Statement Posting:

Account	Dr	Cr
Bank Asset Account	1000.00
Bank Transitory Account		1000.00

Bank statement line clearance posting:

Account	Dr	Cr
Bank transitory account	1000.00
Customer		1000.00

And Finally, the last bank Statement line for an amount = -2000.00, that would mean a payment OUT: (Debit Amount = Payment OUT= Paid)

Bank statement line clearance posting:

Account	Dr	Cr
Vendor liabilities	2000.00
Bank Transitory account		2000.00

Therefore the complete set of posting will look like:

Invoice posting:

Account	Dr	Cr
Expense	2000.00
Vendor liabilities		2000.00

Bank Statement Posting:

Account	Dr	Cr
Bank transitory account	2000.00
Bank asset account		2000.00

Bank statement line clearance posting:

Account	Dr	Cr
Vendor liabilities	2000.00
Bank Transitory account		2000.00