Skip to Content
Odoo Meniu
  • Autentificare
  • Try it free
  • Aplicații
    Finanțe
    • Contabilitate
    • Facturare
    • Cheltuieli
    • Spreadsheet (BI)
    • Documente
    • Semn
    Vânzări
    • CRM
    • Vânzări
    • POS Shop
    • POS Restaurant
    • Abonamente
    • Închiriere
    Site-uri web
    • Constructor de site-uri
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Lanț Aprovizionare
    • Inventar
    • Producție
    • PLM
    • Achiziție
    • Maintenance
    • Calitate
    Resurse Umane
    • Angajați
    • Recrutare
    • Time Off
    • Evaluări
    • Referințe
    • Flotă
    Marketing
    • Social Marketing
    • Marketing prin email
    • SMS Marketing
    • Evenimente
    • Automatizare marketing
    • Sondaje
    Servicii
    • Proiect
    • Foi de pontaj
    • Servicii de teren
    • Centru de asistență
    • Planificare
    • Programări
    Productivitate
    • Discuss
    • Aprobări
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Aplicații Terțe Odoo Studio Platforma Odoo Cloud
  • Industrii
    Retail
    • Book Store
    • Magazin de îmbrăcăminte
    • Magazin de Mobilă
    • Magazin alimentar
    • Magazin de materiale de construcții
    • Magazin de jucării
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Distribuitor de băuturi
    • Hotel
    Proprietate imobiliara
    • Real Estate Agency
    • Firmă de Arhitectură
    • Construcție
    • Estate Managament
    • Grădinărit
    • Asociația Proprietarilor de Proprietăți
    Consultanta
    • Firma de Contabilitate
    • Partener Odoo
    • Agenție de marketing
    • Law firm
    • Atragere de talente
    • Audit & Certification
    Producție
    • Textil
    • Metal
    • Mobilier
    • Mâncare
    • Brewery
    • Cadouri corporate
    Health & Fitness
    • Club Sportiv
    • Magazin de ochelari
    • Centru de Fitness
    • Wellness Practitioners
    • Farmacie
    • Salon de coafură
    Trades
    • Handyman
    • IT Hardware and Support
    • Asigurare socială de stat
    • Cizmar
    • Servicii de curățenie
    • HVAC Services
    Altele
    • Organizație nonprofit
    • Agenție de Mediu
    • Închiriere panouri publicitare
    • Fotografie
    • Închiriere biciclete
    • Asigurare socială
    Browse all Industries
  • Comunitate
    Învăță
    • Tutorials
    • Documentație
    • Certificări
    • Instruire
    • Blog
    • Podcast
    Empower Education
    • Program Educațional
    • Scale Up! Business Game
    • Visit Odoo
    Obține Software-ul
    • Descărcare
    • Compară Edițiile
    • Lansări
    Colaborați
    • Github
    • Forum
    • Evenimente
    • Translations
    • Devino Partener
    • Services for Partners
    • Înregistrează-ți Firma de Contabilitate
    Obține Servicii
    • Găsește un Partener
    • Găsiți un contabil
    • Meet an advisor
    • Servicii de Implementare
    • Referințe ale clienților
    • Suport
    • Actualizări
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Obține un demo
  • Prețuri
  • Ajutor

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

  • CRM
  • e-Commerce
  • Contabilitate
  • Inventar
  • PoS
  • Proiect
  • MRP
All apps
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
All Posts Oameni Insigne
Etichete (View all)
odoo accounting v14 pos v15
Despre acest forum
Suport

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

Abonare

Primiți o notificare când există activitate la acestă postare

Această întrebare a fost marcată
accountingcreditcardreconciliationv14
3 Răspunsuri
3089 Vizualizări
Imagine profil
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
Imagine profil
Abandonează
Tony S.
Autor

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

Imagine profil
James White
Cel mai bun răspuns

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
Imagine profil
Abandonează
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.

Imagine profil
Tony S.
Autor Cel mai bun răspuns

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
Imagine profil
Abandonează
Imagine profil
Ray Carnes (ray)
Cel mai bun răspuns

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
Imagine profil
Abandonează
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!

Înscrie-te
Related Posts Răspunsuri Vizualizări Activitate
ODOO14 CE : accounting > Actions > Reconciliation - qweb2 error
accounting reconciliation qweb2 v14
Imagine profil
Imagine profil
1
iul. 22
3829
User error - Bank Reconcialation (v14)
accounting reconciliation UserError v14
Imagine profil
Imagine profil
1
mai 22
7493
Reconcile a PDC (Post Dated Cheque) Rezolvat
accounting reconciliation pdc v14
Imagine profil
Imagine profil
1
mar. 24
4578
Odoo Enterprise V14, why Odoo shows stock journal entries in bank reconciliation screen? Rezolvat
accounting reconciliation bank v14
Imagine profil
Imagine profil
1
ian. 21
3436
Possible to use Reconciliation Models for other accounts?
accounting reconciliation
Imagine profil
0
oct. 24
2286
Comunitate
  • Tutorials
  • Documentație
  • Forum
Open Source
  • Descărcare
  • Github
  • Runbot
  • Translations
Servicii
  • Hosting Odoo.sh
  • Suport
  • Actualizare
  • Custom Developments
  • Educație
  • Găsiți un contabil
  • Găsește un Partener
  • Devino Partener
Despre Noi
  • Compania noastră
  • Active de marcă
  • Contactați-ne
  • Locuri de muncă
  • Evenimente
  • Podcast
  • Blog
  • Clienți
  • Aspecte juridice • Confidențialitate
  • Securitate
الْعَرَبيّة 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 este o suită de aplicații de afaceri open source care acoperă toate nevoile companiei dvs.: CRM, comerț electronic, contabilitate, inventar, punct de vânzare, management de proiect etc.

Propunerea de valoare unică a Odoo este să fie în același timp foarte ușor de utilizat și complet integrat.

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