← Back to team overview

openerp-community team mailing list archive

Re: Seeking clarification on reconciliation functionality in 7.0

 

On 01/18/2013 03:47 AM, Leonardo Pistone wrote:
usually in OpenERP when you read "reconciliation" it is about matching
payments to invoices (more precisely, matching journal items in
payable/receivable accounts together).

Certainly the terminology is different in the US. I understand the need to match payments to receivables and payables, and that all works fine. However, there is still a need to verify that bank statements, credit card statements, etc, match my records.

Typically, the way this works in US accounting systems, is that when the statement is received, the closing balance on the statement is entered into the accounting software, and the opening balance is set to the closing balance from last month, which should also match what is on the statement.

Each credit or debit to the account corresponding to the statement has a boolean flag which defaults to false. A dialog will present a list of all credits or debits where this flag is still false, and the user then selects some of these credits and debits in the list until the opening balance, plus all the credits, minus all the debits, equals the closing balance. Credits and debits are also totalled separately, and all these numbers (total debits, total credits, ending balance) match the statement. Then the dialog is confirmed, and all the entries that were selected have their flag set to true.

This way, if either I or the bank have records that differ, I'll notice. Differences could be from mistyped numbers, account fees, making entries to the wrong account, or fraud. How does one address this problem in OpenERP?


Follow ups

References