Skip to Content
This question has been flagged
creditcardposreconciliationbank_statement
1 Reply
2128 Views
Avatar
Sveng

Using EE v15

Have a Credit Card Payment method configured in POS. The daily payments using this method are batched (total) e.g.


BNK2/2023/03/0004: Customer Payment R 8,072.53 - 07/03/2023 : Combine Credit Card POS payments from POS/00008


The Bank payouts for this payment terminal batch are paid out by transaction type i.e Debit Card and Credit Card resulting in two bank statement lines being imported/sync'ed matching the total of the Odoo batched entry of the batch. e.g.

840000007/03/2023: CREDIT CARD EFTPOS SETTLEMENT DR EFTPOS 2PF 9 0002281491836R 2,752.69
840000007/03/2023: CREDIT CARD EFTPOS SETTLEMENT CR EFTPOS 2PF 9 0002281491836R 5,319.84

How can the two bank statement lines be reconciled to the one Odoo batched line?

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Match the batch to the first statement line.  

Since you will go over (in your example by R 5,319.84) - create a Manual Operation that posts this difference back into the AR account you are using for POS payments. 

This will be a negative amount representing the difference between the batch total and the first statement line and will allow you to validate your first statement line reconcilation.

You will now see the credit for the difference show up on the Customer/Vendor Matching tab ready to match with the second statement line.

If you don't have enough left in the batch to match 100% with the second statement line (because of fees) then you can again create a Manual Operation that posts the difference to an expense account or (even better) create a reconciliation model that allows you to post the difference due to fees with a single button.

Avatar
Discard
Sveng
Author

Tx Ray, you are always on the button!

Now the question is can this be automated or does it need to be a manual match for each daily batch?

Ray Carnes (ray)

I don't know of an easy way to automate this - the reference the bank provides is probably not predictable in advance and the amounts won't match.

Sveng
Author

The Reference is always the same since it is linked to a credit card terminal but the amount differs

Related Posts Replies Views Activity
How to reconcile a bank statement against transactions on the system?
creditcard reconciliation bank_statement
Avatar
0
Mar 15
3482
Bank reconciliation: Bank to Bank. Am I doing something wrong? Solved
reconciliation bank_statement
Avatar
Avatar
1
Jan 24
1300
Bank Statement Reconcile (CE)
reconciliation bank_statement
Avatar
0
Mar 23
2043
bank outboud vender payment plus bank charges Solved
reconciliation bank_statement
Avatar
Avatar
1
Nov 22
1859
Partial Bank Reconciliation (Odoo v12e)
reconciliation bank_statement
Avatar
0
Feb 22
1229