İçereği Atla
Odoo Menü
  • Portal
  • Ücretsiz deneyin
  • Uygulamalar
    Finans
    • Muhasebe
    • Faturalama
    • Masraf Yönetimi
    • Elektronik Çizelge (BI)
    • Belgeler
    • İmza
    Satış
    • Müşteri İlişkileri Yönetimi (CRM)
    • Satış
    • Satış Noktası Mağaza
    • Satış Noktası Restoran
    • Abonelikler
    • Kiralama
    Web Sitesi
    • Web Sitesi Oluşturucu
    • eTicaret
    • Blog
    • Forum
    • Canlı Sohbet
    • eÖğrenme
    Tedarik Zinciri
    • Envanter
    • Üretim
    • Ürün Yaşam Döngüsü Yönetimi
    • Satın Alma
    • Bakım
    • Kalite
    İnsan Kaynakları
    • Çalışanlar
    • İşe Alım
    • İzin
    • Değerlendirme
    • Referans
    • Filo Yönetimi
    Pazarlama
    • Sosyal Medyada Pazarlama
    • E-posta ile Pazarlama
    • SMS ile Pazarlama
    • Etkinlikler
    • Pazarlama Otomasyonu
    • Anket
    Hizmetler
    • Proje Yönetimi
    • Çalışma Çizelgeleri
    • Saha Hizmeti
    • Yardım Masası
    • Planlama
    • Randevular
    Verimlilik
    • Sohbet
    • Onay
    • Nesnelerin İnterneti
    • VoIP
    • Bilgi Bankası
    • WhatsApp
    Üçüncü taraf uygulamalar Odoo Stüdyo Odoo Bulut Platformu
  • Sektörler
    Perakende satış
    • Kitapçı
    • Giyim Mağazası
    • Mobilya Mağazası
    • Gıda Marketi
    • Hırdavat Dükkanı
    • Oyuncak Dükkanı
    Gıda ve Konaklama
    • Bar ve Pub
    • Restoran
    • Fast Food Restoranı
    • Konuk Evi
    • İçecek Distribütörü
    • Otel
    Gayrimenkul
    • Emlak Acentesi
    • Mimarlık Firması
    • İnşaat
    • Emlak Yönetimi
    • Bahçe Tasarımı
    • Mülk Sahipleri Derneği
    Uzmanlık
    • Muhasebe Firması
    • Odoo Partner
    • Pazarlama Ajansı
    • Hukuk Firması
    • Yetenek Kazanımı
    • Denetim ve Belgelendirme
    Üretim
    • Tekstil
    • Metal
    • Mobilyalar
    • Gıda
    • Bira fabrikası
    • Kurumsal Hediye
    Sağlık ve Spor
    • Spor Kulübü
    • Optik Mağazası
    • Fitness Merkezi
    • Sağlıklı Yaşam Merkezi
    • Eczane
    • Kuaför Salonu
    Ticaret
    • Tamirci
    • BT Donanım & Destek
    • Güneş Enerjisi Sistemleri
    • Ayakkabı İmalatçısı
    • Temizlik Hizmetleri
    • HVAC Hizmetleri
    Diğerleri
    • Kar Amacı Gütmeyen Kuruluş
    • Çevre Ajansı
    • Reklam Panosu Kiralama
    • Fotoğrafçılık
    • Bisiklet Kiralama
    • Yazılım Bayisi
    Tüm Sektörlere Göz Atın
  • Topluluk
    Öğrenim
    • Eğitim Araçları
    • Dokümantasyon
    • Sertifikasyonlar
    • Eğitim Etkinlikleri
    • Blog
    • Podcast
    Eğitim ve Gelişim
    • Eğitim Programı
    • Scale Up! İşletme Oyunu
    • Odoo'yu Ziyaret Edin
    Yazılım
    • İndirin
    • Sürümleri Kıyaslayın
    • Sürümler
    İş Birliği
    • Github
    • Forum
    • Etkinlikler
    • Çeviriler
    • Partner Olun
    • Partnerler için Hizmetler
    • Muhasebe Firmanızı Kaydettirin
    Hizmetler
    • Partner Bulun
    • Muhasebeci Bulun
    • Bir danışmanla görüşün
    • Kurulum Hizmetleri
    • Müşteri Referansları
    • Destek
    • Sürüm Yükseltme
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Demo randevusu alın
  • Fiyatlandırma
  • Yardım

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

  • Müşteri İlişkileri Yönetimi
  • e-Commerce
  • Muhasebe
  • Envanter
  • PoS
  • Proje Yönetimi
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Etiketler (View all)
odoo accounting v14 pos v15
About this forum
Yardım

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

Abone Ol

Get notified when there's activity on this post

Bu soru işaretlendi
accountingcreditcardreconciliationv14
3 Cevaplar
3085 Görünümler
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
Vazgeç
Tony S.
Üretici

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

Avatar
James White
En İyi Yanıt

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
Vazgeç
Tony S.
Üretici

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.
Üretici

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.
Üretici En İyi Yanıt

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
Vazgeç
Avatar
Ray Carnes (ray)
En İyi Yanıt

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
Vazgeç
Tony S.
Üretici

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

Tony S.
Üretici

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!

Üye Ol
İlgili Gönderiler Cevaplar Görünümler Aktivite
ODOO14 CE : accounting > Actions > Reconciliation - qweb2 error
accounting reconciliation qweb2 v14
Avatar
Avatar
1
Tem 22
3812
User error - Bank Reconcialation (v14)
accounting reconciliation UserError v14
Avatar
Avatar
1
May 22
7487
Reconcile a PDC (Post Dated Cheque) Çözüldü
accounting reconciliation pdc v14
Avatar
Avatar
1
Mar 24
4565
Odoo Enterprise V14, why Odoo shows stock journal entries in bank reconciliation screen? Çözüldü
accounting reconciliation bank v14
Avatar
Avatar
1
Oca 21
3432
Possible to use Reconciliation Models for other accounts?
accounting reconciliation
Avatar
0
Eki 24
2267
Topluluk
  • Eğitim Araçları
  • Dokümantasyon
  • Forum
Açık Kaynak
  • İndirin
  • Github
  • Runbot
  • Çeviriler
Hizmetler
  • Odoo.sh Hosting
  • Destek
  • Sürüm Yükseltme
  • Özel Geliştirmeler
  • Eğitim
  • Muhasebeci Bulun
  • Partner Bulun
  • Partner Olun
Hakkında
  • Şirketimiz
  • Pazarlama Gereçleri
  • İletişim
  • Kariyer
  • Etkinlikler
  • Podcast
  • Blog
  • Müşteriler
  • Hukuki • Gizlilik
  • Güvenlik
الْعَرَبيّة 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, müşteri ilişkileri yönetimi, eTicaret, muhasebe, envanter, satış noktası, proje yönetimi gibi şirketinizin tüm ihtiyaçlarını karşılayan bir açık kaynak işletme uygulamaları paketidir.

Odoo’nun eşsiz değer önermesi, aynı anda hem kullanımının çok kolay olup hem de tamamen entegre olmasıdır.

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