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 |