Skip to Content
Menu
This question has been flagged
1 Reply
3129 Views

we need clarification concerning Odoo 13 Bank reconciliation entries.

 

We are doing some of the payment/receipt entries through Journal Entries (under accounting – accounting – Journal Entries) (PIC > Journal Entry) Eg:

 

04.08.2020

Telephone charges 

5000.00 dr

 

04.08.2020

Bank Account   

 

5000.00 cr

 

Now, this being a journal entry, it is not reflecting in the bank statement for reconciliation. We have searched on the internet and found an option that we have to do a manual reconciliation. So we did manual reconciliation (PIC > Manual Operation option for the payments and receipts not reflecting in cust ven & Misc Match accounts). However, when we do manual reconciliation it again creates the same entry (PIC > Journal Entry created by System due to Manual Reconciliation). Hence the General ledger shows this entry two times.

 

As we don’t receive bills for all the payment/receipt, how we can make payments/receipt entries that don't have bills. Is there no option making receipts and payments through journal entries and get it reflected on the bank statement for reconciliation. If NO, then how we can pass those entry's. 

Avatar
Discard
Best Answer

Normally, there must be an accounting entry exist for each of the expenses you do in the business if you want to reconcile then. 

So, if you are not going to receive invocie from the vendors or it's miscelleneous expenses then directly create journal entry for those expenses. 

Where Expense account gets DEBITD and Vendor or Payable account gets CREDITED. Then you can reconcile auto / manually reconcile it with the payment entries you received in the bank statement. 

Because in the bank statement you received amount as you have paid it, so it will going to find all the credit entries against the payment you have done. 

Normally  Expense entries looks like 


Account
DebitCredit
Expense
50000
Payable
05000

    

Similarly if any taxes apply then it will be added in the debit side for the vendor bill. 

Now the payment entries


Account
DebitCredit
Payable50000
Bank Account
05000

So, reconciliation always be done with the same account and opposite accounting effect entries.  In above case both entries have Payable account with debit and credit effect. So system will suggest you to reconcile it. 

When you reconcile entries how many things it will perform. 

  • It will check for the vendor payment, if the payment is already created then it will link payment with related jounal item. So the payment entry and expense entry (or vendor bill entry) will be linked. 

  • If payment is not created then it will first create payment and validate it and linked it with journal item and then linked it with expense entry (or vendor bill entry).

  • Entries will be linked thourgh the reconciliation reference.

Avatar
Discard