Ir al contenido
Menú
Se marcó esta pregunta
2 Respuestas
2916 Vistas

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. ​

 

Avatar
Descartar
Autor Mejor respuesta

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.


Avatar
Descartar

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.

Autor

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

Mejor respuesta

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

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
jul 24
2624
1
may 24
2660
1
may 24
2159
1
mar 25
4836
1
abr 24
1971