Skip to Content
Menu
This question has been flagged

Odoo 14ee

Hello, Hope you can help as I have been pulling my hair out.

The total batch for 1 day should be $265.06 to represent 1 invoice.  We issued a credit to another customer on the same day for $84.44. Our processor removed the $84.44 from the $265.06 so the actual deposit was $180.62. 

The Problem is: 

I have 1 invoice for $256.06, and another customer's credit memo for $84.44  which needs to be reconciled.  Odoo won't let the $256.06  and -$84.44 recording reconcile against the deposit of $180.68.

Does anyone know how i can reconcile these three things together?  

 

Avatar
Discard
Author

A Odoo certified accountant who was doing my bookkeeping opted to not have a separate credit card journal..

Best Answer

Hi Tony,   tying your comments together:  You did two transactions, one each for two clients.  The problem is that your daily statement from your provider - Stripe, say - is for a single daily total.  Further, your accountant has suggest not keeping a separate credit card journal.  Do I have that correct so far?  If so, then I do have a solution - but since this is Enterprise Accounting, it isn't as simple as one might wish.

I suspect you have more problems that just the one you noticed yesterday because in Odoo Accounting I have found that the only way to do business is to "Always tell ALL of the truth"; if you do two transactions, you need to enter two transactions.  If you do a transfer, you need to do TWO entries - one for transferring out and the other for transferring in.  In fact our rule is that every xfer must have separate e-documents saved for both sides of the xfer - one for the SEND xfer and another for the unrelated RECEIVE xfer. 

I do have a separate credit card journal for each credit card and I also have a separate payment provider journal (Stripe) for electronic payments.  When an electronic payment is made on a Customer Invoice, it is automatically entered into the Stripe journal.  When a Customer Invoice Credit is issued, that also is entered in the Stripe journal.  The Invoices are ALREADY RECONCILED automatically against those Stripe Journal entries. (Note, the credit is manually issued through the Stripe Dashboard - and then recorded in the Invoice as completed)

I receive a notice whenever Stripe puts through a deposit to my bank.  I take this email notice and save it as a transfer document pair saved with a descriptive name:  

   2022-01-27 - xfer - stripe - TO - bank03 - X956 - 180.62 (.pdf)

   2022-01-28 - xfer - bank03 - FROM - stripe - X956 - 180.62 (.pdf)

Then I actually make the transfer entries (internal transfers) in the journals on bookkeeping day and attach these supporting documents.  Finally, because accounting is meticulous, I then archive the original files for backup.

Because Stripe does not offer a monthly statement, I actually go in and pull a .csv report monthly and create my own paper statement which I then use to generate a journal statement for Stripe - and then validate all transactions against that at month-end.

At no time was there any manual reconcile required for the actual invoice or credit invoice.  They are simply invoices that fed amounts into the Stripe journal and auto-reconciled.  It is the two xfer entries (one SEND and one RECEIVE) that matter - and that must balance.

Avatar
Discard
Author

Holy bookkeeping! Thanks for your reply.

Yes I see that and that was how I wanted it set up originally, however i took less than ideal advise.

Any suggestions on how to make the credit memo and invoice reconcile? Or at least both get makes as "reconciled" so the disappear?

Author

I'm not allowed to edit my comments. But you are correct. We changed processors and for some reason the refund is deducted from the daily batch deposit.

At this point, I'd take a full backup of your database. Then I'd restore it on a test server (with no internet connection) and I would plan and execute a manual reconciliation on the test system. You'll need to be very clear on where the actual transactions took place - or create interim transactions. Once I had the right outcome and the balance sheet still looked right, I'd then do it on the production database.

Forensic repair is always a bit nervous-making. I would strongly advise having your Odoo Partner assist with this. If nothing else, he will be able to get the Odoo team to lend a hand.

Author Best Answer

Are you saying take the $84 refund from customer A and apply it to customer B's invoice of $256?   How would I do that?

Avatar
Discard
Best Answer

If you apply the credit to the Invoice then you only have an open balance of $180.62 to reconcile against the deposit of $180.62.

We register Accountants / Accounting firms and certify those who take our certification exam (which covers all functional areas).

Details at https://www.odoo.com/slides/odoo-certification-v15-108

Avatar
Discard
Author

There is no way to do this as you have to have Customer's A refund reconcile with the actual customer payment.

Author

For anyone else with this issue, i ended up having to apply the credit to another customers invoice, which reduced the invoice due down to the reconcilable amount of $180.62.

Related Posts Replies Views Activity
1
Jul 22
2051
1
May 22
5352
1
Mar 24
2633
1
Jan 21
1611
0
Oct 24
105