Skip to Content
Odoo Menú
  • Registra entrada
  • Prova-ho gratis
  • Aplicacions
    Finances
    • Comptabilitat
    • Facturació
    • Despeses
    • Full de càlcul (IA)
    • Documents
    • Signatura
    Vendes
    • CRM
    • Vendes
    • Punt de venda per a botigues
    • Punt de venda per a restaurants
    • Subscripcions
    • Lloguer
    Imatges de llocs web
    • Creació de llocs web
    • Comerç electrònic
    • Blog
    • Fòrum
    • Xat en directe
    • Aprenentatge en línia
    Cadena de subministrament
    • Inventari
    • Fabricació
    • PLM
    • Compres
    • Manteniment
    • Qualitat
    Recursos humans
    • Empleats
    • Reclutament
    • Absències
    • Avaluacions
    • Recomanacions
    • Flota
    Màrqueting
    • Màrqueting Social
    • Màrqueting per correu electrònic
    • Màrqueting per SMS
    • Esdeveniments
    • Automatització del màrqueting
    • Enquestes
    Serveis
    • Projectes
    • Fulls d'hores
    • Servei de camp
    • Suport
    • Planificació
    • Cites
    Productivitat
    • Converses
    • Validacions
    • IoT
    • VoIP
    • Coneixements
    • WhatsApp
    Aplicacions de tercers Odoo Studio Plataforma d'Odoo al núvol
  • Sectors
    Comerç al detall
    • Llibreria
    • Botiga de roba
    • Botiga de mobles
    • Botiga d'ultramarins
    • Ferreteria
    • Botiga de joguines
    Food & Hospitality
    • Bar i pub
    • Restaurant
    • Menjar ràpid
    • Guest House
    • Distribuïdor de begudes
    • Hotel
    Immobiliari
    • Agència immobiliària
    • Estudi d'arquitectura
    • Construcció
    • Gestió immobiliària
    • Jardineria
    • Associació de propietaris de béns immobles
    Consultoria
    • Empresa comptable
    • Partner d'Odoo
    • Agència de màrqueting
    • Bufet d'advocats
    • Captació de talent
    • Auditoria i certificació
    Fabricació
    • Textile
    • Metal
    • Mobles
    • Menjar
    • Brewery
    • Regals corporatius
    Salut i fitness
    • Club d'esport
    • Òptica
    • Centre de fitness
    • Especialistes en benestar
    • Farmàcia
    • Perruqueria
    Trades
    • Servei de manteniment
    • Hardware i suport informàtic
    • Sistemes d'energia solar
    • Shoe Maker
    • Serveis de neteja
    • Instal·lacions HVAC
    Altres
    • Nonprofit Organization
    • Agència del medi ambient
    • Lloguer de panells publicitaris
    • Fotografia
    • Lloguer de bicicletes
    • Distribuïdors de programari
    Browse all Industries
  • Comunitat
    Aprèn
    • Tutorials
    • Documentació
    • Certificacions
    • Formació
    • Blog
    • Pòdcast
    Potenciar l'educació
    • Programa educatiu
    • Scale-Up! El joc empresarial
    • Visita Odoo
    Obtindre el programari
    • Descarregar
    • Comparar edicions
    • Novetats de les versions
    Col·laborar
    • GitHub
    • Fòrum
    • Esdeveniments
    • Traduccions
    • Converteix-te en partner
    • Services for Partners
    • Registra la teva empresa comptable
    Obtindre els serveis
    • Troba un partner
    • Troba un comptable
    • Contacta amb un expert
    • Serveis d'implementació
    • Referències del client
    • Suport
    • Actualitzacions
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Programar una demo
  • Preus
  • Ajuda

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Comptabilitat
  • Inventari
  • PoS
  • Projectes
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiquetes (View all)
odoo accounting v14 pos v15
About this forum
Ajuda

Odoo 14EE: Credit Card Refund Subtracted From Total Batch Amount - How Do I reconcile?

Subscriure's

Get notified when there's activity on this post

This question has been flagged
accountingcreditcardreconciliationv14
3 Respostes
3073 Vistes
Avatar
Tony S.

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?  

 

0
Avatar
Descartar
Tony S.
Autor

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

Avatar
James White
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.

0
Avatar
Descartar
Tony S.
Autor

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?

Tony S.
Autor

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.

James White

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.

Avatar
Tony S.
Autor 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?

0
Avatar
Descartar
Avatar
Ray Carnes (ray)
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

0
Avatar
Descartar
Tony S.
Autor

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

Tony S.
Autor

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.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrar-se
Related Posts Respostes Vistes Activitat
ODOO14 CE : accounting > Actions > Reconciliation - qweb2 error
accounting reconciliation qweb2 v14
Avatar
Avatar
1
de jul. 22
3789
User error - Bank Reconcialation (v14)
accounting reconciliation UserError v14
Avatar
Avatar
1
de maig 22
7469
Reconcile a PDC (Post Dated Cheque) Solved
accounting reconciliation pdc v14
Avatar
Avatar
1
de març 24
4551
Odoo Enterprise V14, why Odoo shows stock journal entries in bank reconciliation screen? Solved
accounting reconciliation bank v14
Avatar
Avatar
1
de gen. 21
3414
Possible to use Reconciliation Models for other accounts?
accounting reconciliation
Avatar
0
d’oct. 24
2253
Community
  • Tutorials
  • Documentació
  • Fòrum
Codi obert
  • Descarregar
  • GitHub
  • Runbot
  • Traduccions
Serveis
  • Allotjament a Odoo.sh
  • Suport
  • Actualització
  • Desenvolupaments personalitzats
  • Educació
  • Troba un comptable
  • Troba un partner
  • Converteix-te en partner
Sobre nosaltres
  • La nostra empresa
  • Actius de marca
  • Contacta amb nosaltres
  • Llocs de treball
  • Esdeveniments
  • Pòdcast
  • Blog
  • Clients
  • Informació legal • Privacitat
  • Seguretat
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo és un conjunt d'aplicacions empresarials de codi obert que cobreix totes les necessitats de la teva empresa: CRM, comerç electrònic, comptabilitat, inventari, punt de venda, gestió de projectes, etc.

La proposta única de valor d'Odoo és ser molt fàcil d'utilitzar i estar totalment integrat, ambdues alhora.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now