Community mailing list archives

Re[2]: Reconciling credit card processing deposits

- 10/31/2014 04:09:43
Hi Eric/Chris,
If you don't have a credit card but cash money you have to do it on the same way.
Use a "in between" account and reconcile.
No open customer invoices because the are already paid (by cash or creditcard)
You only have to receive the money on you bank account
Best regards,
Johan Bosma
Senior Consultant

Onestein B.V.
Tel: +31 (0) 88 6270400

<IMG border=0 alt="" src="cid:emd8853a17-15fe-4174-9c10-36fd9e07e4a2@johan-hp">

------ Origineel bericht ------
Van: "Caudal Eric" <>
Aan: "Community" <>
Verzonden: 31-10-2014 0:41:56
Onderwerp: Re: Reconciling credit card processing deposits
<BLOCKQUOTE class=cite2 type="cite">
This is the way to go indeed
Eric Caudal

On 10/31/2014 05:17 AM, Humberto Arocha wrote:
<blockquote cite="" type="cite">

Hello Chris,

As you have told, you are dealing with reconciliation, I think that there is a missing concept in the middle, money to reconcile,

Let us say,

First transaction
Receivable (dr)  600
Income (cr) 600

Second transaction
Receivable (dr)  400
Income (cr) 400

Creating a payment with a journal named Credit Card

Payment with Credit Card
UnreciledCreditCard (dr)  1000
Receivable (cr) 600
Receivable (cr) 400

This last Receivables are reconciled with the first ones. Thus your customer invoices are paid.

Next, at the end of month you import your bank statements for your credit cards.

And a Journal entry like this should be performed,

Bank (dr)  1000
UnreciledCreditCard (cr)  1000

This last UnreciledCreditCard entry line will be reconciled with previous one.

As a conclusion you keep track on both your customer invoices paid, and  those payments that bank has to fulfill you.

Expect this can work for you,

Best regards

On Oct 30, 2014 3:12 PM, "Chris Jones" <> wrote:
I've been struggling with this issue for 9 months now, talked to a half dozen developers and read every inch of documentation and have tried a ton of different addons and still can't find a good solution. It's getting to the point where I might just integrate with Xero and ditch OpenERP for accounting. 

Here's the scenario.

Credit Card processor sends over nightly batches for all processed transactions for that day. Let's say there are two credit card payments processed, $400 and $600. They wire a $1000 deposit. 

As soon as the payments are received the Customer Invoices are marked as paid using the Register Payment button. 

At the end of the month the bank statement is imported and the $1000 deposit shows up. 

If I leave the $1000 deposit in the bank statement I end up with double income. Otherwise I have to delete the $1000 deposit from the bank account and replace it with the two invoices using the Import Invoices function. But for that to work I have to go back and delete the Customer Payments so that the Invoices are Open again. 

If I don't use Register Payments it's difficult to keep track of which invoices have been paid until the end of the month. 

I've built a module that automates invoice reconciliation for credit card payments but it only works with the credit card processor Bluepay. I'm looking for a solution for those not using Bluepay. 

I tried the npg_account_make_deposit and npg_bank_account_reconciliation addons but they didn't seem to solve the issue. 


Chris Jones
Open Source ERP Solutions

Post to:

Post to:

2014-10-31 4:37 GMT+08:00 Chris Jones <>:
I think that's exactly what is needed. A way to import Paid invoices into the bank statement. 

I can open source the Bluepay integration for matching invoices with deposits if someone would be willing to help out on importing paid invoices into the bank statement. I'm a reseller of Bluepay too so if you want to use them for credit card processing let me know. Otherwise for those using the code might be helpful to build a similar connection to their API. 

On Thu, Oct 30, 2014 at 1:23 PM, Gonzalo Ruzafa <> wrote:

In my opinion, the origin of the problem is the impossibility to bring Paid Invoices to the bank statement. Of course you cannot keep your invoices opened when they have already been paid until the end of the months, that would cause continuos difference between Odoo bank accounts balance and real ones (the only alternative would be to reduce the time gap between bank reconcilliations).

If you could bring Paid Invoices to the bank statement, that would not need to be concilled later during the concilling process, but would just add in order to go from the start balance to the end balance.

Summing up, these would be the modifications required:

  1. Possibility to bring Paid Invoices to the bank statement 
  2. Don't introduce them in the concilling process

We are willing to start working on this Chris, let us know, maybe we can do it together.

Opinions are welcome!

Ing. Gonzalo Ruzafa
(+54 9 341)153 718905

Post to:

+86 186 21 36 16 70

Post to: