ManualDoc:TFF8080813320657F0133209DE21B0042
Contents |
Manual Reconciliations
- As already explained the process button Reconcile allows to manually reconcile existing financial account transactions in the "Reconciliation" window.
- Each reconciliation of that type once saved it is also saved in this tab in "Draft" status until it is finally reconcile in the "Reconciliation" window therefore it status changes to "Completed".
- It is possible to "Reactivate" a reconciliation of that type, therefore it can be changed in the "Reconciliation" window and be reconciled from that window once more.
Automatic Reconciliations
- Same way once a bank statement file has been imported, the bank statement lines can be automatically reconcile in the "Match using imported Bank Statement Lines" window accessible from the process button Match Statement.
- Each reconciliation of that type once saved it is also saved in this tab in "Draft" status until it is finally reconcile in the "Match using imported Bank Statement Lines" window therefore it status changes to "Completed".
- It is possible to "Reactivate" a reconciliation of that type, therefore it can be changed in the "Match using imported Bank Statement Lines" window and be reconciled from that window once more.
Reconciliations Posting
A Reconciliation of any type can be posted if the Payment Method used while creating the payment to be reconciled allows to do so once assigned to the financial account. If that is not the case Openbravo shows a warning : "Document disabled for accounting".
A "Deposit Reconciliation" posting looks like:
a. if the Payment Received was NOT posted in the "Payment In" window and the Deposit Transaction was also NOT posted in the "Financial Account" window:
Account | Debit | Credit |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount | |
Customer Receivables | Payment amount |
b. if the Payment Received was posted in the "Payment In" window and the Deposit Transaction was NOT posted in the "Financial Account" window:
Account | Debit | Credit |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount | |
Upon Receipt Use the "In Transit Payment IN Account" (i.e) | Payment amount |
c. if the Payment Received was posted in the "Payment In" window or not and the Deposit Transaction was posted in the "Financial Account" window:
Account | Debit | Credit |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount | |
Upon Deposit Use the "Deposit Account" (i.e) | Payment amount |
Each posting will be different when the amount comes partially o totally from a debt classified as doubtful. In that case, the posting will be as explained in | Doubtful Debt Run Window.
A "Withdrawal Reconciliation" posting looks like:
a. if the Payment Made was NOT posted in the "Payment Out" window and the Withdrawal transactions was also NOT posted in the Financial Account window:
Account | Debit | Credit |
Vendor Liability | Payment amount | |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount |
b. if the Payment Made was posted in the "Payment Out" window and the Withdrawal transactions was NOT posted in the Financial Account window:
Account | Debit | Credit |
Upon Payment Use the "In Transit Payment OUT Account" (i.e) | Payment amount | |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount |
c. if the Payment Made was posted in the "Payment Out" window or not and the Withdrawal transactions was posted in the Financial Account window:
Account | Debit | Credit |
upon Withdrawal Use the "Withdrawal Account" (i.e) | Payment amount | |
Upon Reconciliation Use the "Cleared Payment Account" (i.e) | Payment amount |
Reconciliations Reporting
Additionally there are two reports which shows information about each reconciliation, those reports can be run from the process buttons:
- Reconciliations Details
- Reconciliation Summary