Přejít na obsah
Odoo Menu
  • Přihlásit se
  • Vyzkoušejte zdarma
  • Aplikace
    Finance
    • Účetnictví
    • Fakturace
    • Výdaje
    • Spreadsheet (BI)
    • Dokumenty
    • Podpisy
    Prodej
    • CRM
    • Prodej
    • POS Obchod
    • POS Restaurace
    • Předplatné
    • Pronájem
    Webové stránky
    • Webové stránky
    • E-shop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Dodavatelský řetězec
    • Sklad
    • Výroba
    • PLM
    • Nákup
    • Údržba
    • Kvalita
    Lidské zdroje
    • Zaměstnanci
    • Nábor
    • Volno
    • Hodnocení zaměstnanců
    • Doporučení
    • Vozový park
    Marketing
    • Marketing sociálních sítí
    • Emailový marketing
    • SMS Marketing
    • Události
    • Marketingová automatizace
    • Dotazníky
    Služby
    • Projekt
    • Časové výkazy
    • Práce v terénu
    • Helpdesk
    • Plánování
    • Schůzky
    Produktivita
    • Diskuze
    • Schvalování
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Aplikace třetích stran Odoo Studio Odoo cloudová platforma
  • Branže
    Maloobchod
    • Knihkupectví
    • Obchod s oblečením
    • Obchod s nábytkem
    • Potraviny
    • Obchod s hardwarem
    • Hračkářství
    Jídlo a pohostinství
    • Bar a Pub
    • Restaurace
    • Fast Food
    • Penzion
    • Distributor nápojů
    • Hotel
    Nemovitost
    • Realitní kancelář
    • Architektonická firma
    • Stavba
    • Správa nemovitostí
    • Zahradnictví
    • Asociace vlastníků nemovitosti
    Poradenství
    • Účetní firma
    • Odoo Partner
    • Marketingová agentura
    • Právník
    • Akvizice talentů
    • Audit a certifikace
    Výroba
    • Textil
    • Kov
    • Nábytek
    • Jídlo
    • Pivovar
    • Korporátní dárky
    Zdraví a fitness
    • Sportovní klub
    • Prodejna brýli
    • Fitness Centrum
    • Wellness praktikové
    • Lékárna
    • Kadeřnictví
    Transakce
    • Údržbář
    • Podpora IT & hardware
    • Systémy solární energie
    • Výrobce obuvi
    • Úklidové služby
    • Služby HVAC
    Ostatní
    • Nezisková organizace
    • Agentura pro životní prostředí
    • Pronájem billboardů
    • Fotografování
    • Leasing jízdních kol
    • Prodejce softwaru
    Procházet všechna odvětví
  • Komunita
    Edukační program
    • Tutoriály
    • Dokumentace
    • Certifikace
    • Vzdělávání
    • Blog
    • Podcast
    Podpora vzdělávání
    • Vzdělávací program
    • Scale Up! Hra na firmu
    • Navštivte Odoo
    Získat software
    • Stáhnout
    • Porovnejte edice
    • Verze
    Spolupráce
    • Github
    • Fórum
    • Události
    • Překlady
    • Stát se partnerem
    • Služby pro partnery
    • Registrujte svou účetní firmu
    Získat služby
    • Najít partnera
    • Najít účetní
    • Setkejte se s poradcem
    • Implementační služby
    • Zákaznické reference
    • Podpora
    • Upgrady
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Dohodnout demo
  • Ceník
  • Pomoc

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

  • CRM
  • e-Commerce
  • Účetnictví
  • Sklad
  • PoS
  • Projekty
  • MRP
All apps
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
Pomoc

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

Odebírat

Get notified when there's activity on this post

This question has been flagged
accountingcreditcardreconciliationv14
3 Odpovědi
3079 Zobrazení
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
Zrušit
Tony S.
Autor

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

Avatar
James White
Nejlepší odpověď

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
Zrušit
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 Nejlepší odpověď

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
Zrušit
Avatar
Ray Carnes (ray)
Nejlepší odpověď

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
Zrušit
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!

Přihlásit se
Related Posts Odpovědi Zobrazení Aktivita
ODOO14 CE : accounting > Actions > Reconciliation - qweb2 error
accounting reconciliation qweb2 v14
Avatar
Avatar
1
čvc 22
3795
User error - Bank Reconcialation (v14)
accounting reconciliation UserError v14
Avatar
Avatar
1
kvě 22
7476
Reconcile a PDC (Post Dated Cheque) Vyřešeno
accounting reconciliation pdc v14
Avatar
Avatar
1
bře 24
4556
Odoo Enterprise V14, why Odoo shows stock journal entries in bank reconciliation screen? Vyřešeno
accounting reconciliation bank v14
Avatar
Avatar
1
led 21
3417
Possible to use Reconciliation Models for other accounts?
accounting reconciliation
Avatar
0
říj 24
2253
Komunita
  • Tutoriály
  • Dokumentace
  • Fórum
Open Source
  • Stáhnout
  • Github
  • Runbot
  • Překlady
Služby
  • Odoo.sh hostování
  • Podpora
  • Upgrade
  • Nestandardní vývoj
  • Edukační program
  • Najít účetní
  • Najít partnera
  • Stát se partnerem
O nás
  • Naše společnost
  • Podklady značky
  • Kontakujte nás
  • Práce
  • Události
  • Podcast
  • Blog
  • Zákazníci
  • Právní dokumenty • Soukromí
  • Zabezpečení
الْعَرَبيّة 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 je balíček open-source aplikací, které pokrývají všechny potřeby vaší společnosti: CRM, e-shop, účetnictví, sklady, kasy, projektové řízení a další.

Unikátní nabídka od Odoo poskytuje velmi jednoduché uživatelské rozhraní a vše je integrované na jednom místě.

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