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

[v17][Accounting] Cash basis tax configuration and use case

Subscribe

Get notified when there's activity on this post

This question has been flagged
Accountingv17SF-Experts
2 Replies
4281 Views
Avatar
Pei Hua Tsai (pht)

Prerequisite: 

This article includes intricate tax configuration and cash basis tax features. The screenshot provided pertains to version 17 and the USA localization; nevertheless, the process should apply to the majority of versions. 


Purpose: 

The regular tax is recorded on the invoice date. Conversely, Odoo offers a customized cash basis tax that is recorded according to the payment date. ​

 

0
Avatar
Discard
Avatar
Pei Hua Tsai (pht)
Author Best Answer

Configuration:

1.      In the accounting application -> configuration -> check the box on the cash basis.

Define the journal and the temporary tax holding account.
When the cash basis tax journal entry is posted automatically, the temporary tax holding account will balance to $0.
As the demonstration below, the journal is: Cash Basis Taxes and the account is 2225 Tax received cash basis.


2.      In the accounting application -> configuration -> taxes -> create a tax or select the existing tax.
The existing tax contains the tax type, amount, computation, and the account defined in the definition tab.


In the tax advanced options tab, select tax exigibility – Based on Payment and choose a cash basis transition account. For the demonstration purpose, a 7757 Tax – cash basis account is selected.
The cash basis transition account is to reflect the tax amount in the invoice and the cash basis taxes journal when the payment is recognized.




Workflow:

1. Create an invoice on January, 1/1/2024, $400 with 20% tax.
Notice that Odoo uses the 7757 tax–cash basis account for the 20% tax, in this case, $80.
The account is set on the tax.

P.S. The 20% tax is based on payment which means it is a cash basis tax. That is why Odoo pulled the cash basis transition account not the tax account - 251000 tax received. 


2. Register the payment on the invoice. The payment date is March, 3/11/2024.

The payment entry behaves the same as the standard payment.


3.  But once the payment is created and links to the invoice, Odoo automatically creates another journal entry in the cash basis taxes journal as below:
 
3.1 2225 Tax received cash basis (liability) account $400 credit shows 20% tag on the tax. This will be displayed in the tax report in March 2024.
P.S. 2225 is the tax temporary holding account set in the accounting configuration.
 
3.2 7757 Tax - cash basis account will be offset from the invoice. In step #1 invoice, the 7757 account has $80 in credit. Now, in the cash-based tax entry, there is $80 in the debit.
P.S 7757 is the tax transition account set in the 20% tax.
 


Tax report March 2024.


3
Avatar
Discard
Peskie

Excellent explanation this would have assisted me greatly back when I was trying to resolve this same issue! This information is not present in the documentation (Its an Odoo secret surprise)

In Australia we also need localisation and application of the tax grids to be correct for reports to work correctly which need manual adjustment. It would be a great thing to explain this better in the documentation - Documentation for localisation = None.

Having a runbot version of a cash basis demo company would also be very helpful for a cash basis company for Australia for example.

The "Allow Reconciliation Toggle" in the chart of account does this need any change for CASH BASIS ACCOUNTING ??

Thank-you for your well explained post.

Pei Hua Tsai (pht)
Author

Hello Peskie,

Thank you for the comments.
I am glad that this documentation is helpful.

As for the tax grid, I have other documentation focused on Canada tax report using tax grid.
https://www.odoo.com/forum/help-1/v17-how-can-i-customize-the-canadian-tax-report-canadian-localization-237528

"Allow Reconciliation" is a feature that shows up on bank reconciliation and allows reconciliation on the journal item page. Once the journal item is reconciled, the matching # column will show Axxxx.
This feature has nothing to do with cash basis, so whether you are on cash basis, the accounts can either allow reconciliation or not.

Best,
Pei

Avatar
Zomail Tahir
Best Answer

Thank you for the wonderful post. I have a question, though.

What happens if I receive partial payments for the same invoice? At what point is the invoice considered eligible for tax reporting?

Secondly, I’m currently using the “Based on Invoice” setting. If I change the setting to “Based on Payment,” will it affect already posted invoices and the tax report?

Any help in this regard would be greatly appreciated.

Regards,

Zomail

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
[Accounting] How do I set a due date on every 9th of the month? Solved
Accounting v17 SF-Experts
Avatar
Avatar
2
Sep 25
2874
[V17+] How does Odoo handle multiple branch (stores) transactions and show the consolidated report? Solved
Accounting v17 SF-Experts
Avatar
1
Jul 24
3778
How do I perform factoring in Odoo 17? Solved
Accounting v17 SF-Experts
Avatar
1
May 24
3576
How do I bring the fixed assets from my previous/old/legacy system to Odoo? Solved
Accounting v17 SF-Experts
Avatar
1
May 24
3143
[Accounting][v17] How do we import reconciled journal items with matching number? Solved
Accounting v17 SF-Experts
Avatar
1
Mar 25
6484
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