Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    • Referral Program
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Reconciling POS credit card transactions with bank statement

Subscribe

Get notified when there's activity on this post

This question has been flagged
accountingposreconciliationpayments
2 Replies
10859 Views
Avatar
Element Green

We are taking PayPal Here credit card payments with Odoo 12 Point Of Sale. We added a payment method for this which has its own Journal and account in the Chart of Accounts. The actual payment is processed with a separate app which we manually enter the total amount into. The money is deposited in our PayPal account, with a fee deducted from the amount. Odoo generates journal entries which Credit Accounts Receivable and Debit the PayPal Account, which seems correct.

We then import our PayPal statement from a CSV file. This creates a bank statement with the payments from customers and additional fee lines (created from an external script).  I would expect to then be able to reconcile these statement entries against the POS orders to track the PayPal account balance. It seems the POS orders are already reconciled though. Should these entries not be imported into the bank statement? We could still process the fees though by creating new Debit entries to the Bank Fees account. I think the main thing is to be able to track the balance of this account and perhaps verify that the payments were actually received.

Any tips on a good way to handle this?  This is for accounting in the USA.

Thanks in advance.

Element

1
Avatar
Discard
Avatar
Dolphin Stationers Ltd
Best Answer

Hi - Were you able to figure out an answer to this? I'm struggling with the same issue. Thanks



0
Avatar
Discard
Avatar
Element Green
Author Best Answer

I found a workable solution for now, but I'm not very convinced it is the right way. What I'm doing is filtering out the incoming credit card payments from the PayPal statements when importing them, leaving just transaction bank fees and other uses of the PayPal account to manually reconcile. Since credit card payments from customers using PayPal Here do go directly to the PayPal account, this seems OK (no account transfer required).

It seems like the POS system already adds statements to the PayPal Account Journal for POS transactions which use this payment method and automatically reconciles them. I found that it adds a journal entry in the POS Sale Journal which contains journal items which Credit items for Product Sales and tax to Tax Received and Debits Account Receivable for the total amount. This is then automatically reconciled against another Journal Entry in the PayPal Account Journal (payment method) which has an item that Credits Account Receivable and Debits the PayPal Account.

Since credit card transactions are verified via the PayPal Here app, it seems reasonable to assume they completed. It would be nice to have an extra reconciliation step and not have to filter out the payments from the statement data though, but I haven't figured out how to do this. If the POS system didn't automatically add the journal entry and a statement to the payment method journal, then that might be better. I tried enabling the "Post At Bank Reconciliation" option in the PayPal payment method journal, but this doesn't seem to have the effect I would expect. Any tips on the proper accounting way to do this would be greatly appreciated. For now I think I have to be content with just reconciling the non POS payment transactions and double checking the account balance against what the last statement in Odoo should be.

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

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

Sign up
Related Posts Replies Views Activity
Odoo Accounting reconciliation
accounting reconciliation invoices payments
Avatar
Avatar
1
Sep 25
2308
Pos sales reconciliation problem
accounting pos reconciliation payment
Avatar
0
Mar 25
2656
Manual bank transactions affected by bank feed refresh v19
accounting reconciliation
Avatar
Avatar
Avatar
2
Jun 26
1255
How can I deal with an erroneously imported bank statement in accounting?
accounting reconciliation
Avatar
Avatar
Avatar
3
Dec 25
2350
Worldline Saturn Terminal Payment
pos payments
Avatar
0
Feb 25
2376
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

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