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
    • Approvals
    • 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
    • Estate 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
    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

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

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
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

How do I reconcile a Manual Journal Entry in Odoo 18.0? Now that bank reconcilation is not using Outstanding Accounts?

Subscribe

Get notified when there's activity on this post

This question has been flagged
journalbank_statementmanualentryreconcilation
1 Reply
5171 Views
Avatar
Community Question

I have been working with Odoo for a few years and have just setup a new Odoo 18.0 database and are starting to work with our regular financial transactions.

In prior versions we needed to create Manual Journal Entries related to bank deposits or payments where we did not have an Invoice or Bill entered.

Examples:

  • Payroll Journal Entry
  • Daily Sales Journal Entry (from an external Point of Sale system)
  • Petty Cash Journal Entry
  • Owner Draw Journal Entry
  • Paid in Capital Journal Entry
  • Sales Tax Journal Entry
  • Income Tax Journal Entry

How are these entries recorded so that they show up during bank reconciliation?

0
Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

You can use any account that is configured to Allow Reconcilation.

One that is already available is the Liquidity Transfer (or equivalent in your Chart of Accounts):

  • for a bank deposit (incoming funds) you would debit this account
  • for a bank payment (outgoing funds) you would credit this account.

Recall that when you synch or import your bank statement, Odoo posts all counterpart entries to a Suspense Account you have configured on your Bank Journal. Then when you reconcile each transaction, we change the account to the one used in your Journal Entry, offsetting the amount you recorded. Because of this you should think of this account, like the Liquidity Transfer account, as one representing the unsettled transfer of funds from or to your bank account. During bank reconcilation these balances will be cleared.

If you have a substantial volume of these kinds of transactions, you may want to create additional current asset accounts to represent the cash coming from and going to your bank account.  As long as each account allows reconciliation, the debits and credits you record will show up as able to be matched with the incoming and outgoing cash transactions your bank posts to your bank statement. 


Note: If you have individual bank deposits (related to POS payments) you don't need to create individual debits, you can just record the total and during bank reconcilation as you match each individual statement line the total unreconciled debit balance will decrease until you have matched them all.


2
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
A Journal for each bank account?
journal bank_statement
Avatar
1
Feb 25
8369
How to go from a book transaction to the reconciled bank statement transaction? Solved
reconciliation bank_statement reconcilation
Avatar
1
Aug 18
4233
Proforma Invoice - Unposted Journal Entry
journal entry proforma
Avatar
Avatar
1
Jul 16
7510
Is there any way to reconcile a bank statement line with a paid invoice ? [ Bank Statement reconciliation process v7]
v7 bank_statement reconcilation
Avatar
0
Oct 25
4866
Meaning of red/green indicators in bank statement? Solved
v7 bank_statement reconcilation
Avatar
Avatar
Avatar
2
Dec 23
32919
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 ภาษาไทย 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