View source | Discuss this page | Page history | Printable version   

ManualDoc:TC56E698100314ABBBBD3A89626CA551C

Financialaccount10.png

There are key fields to note:

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

Retrieved from "http://wiki.openbravo.com/wiki/ManualDoc:TC56E698100314ABBBBD3A89626CA551C"

This page has been accessed 930 times. This page was last modified on 28 November 2012, at 13:42. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.