Odooers论坛

欢迎!

该社区面向专业人士和我们产品和服务的爱好者。
分享和讨论最好的内容和新的营销理念,建立您的专业形象,一起成为更好的营销人员。


0

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

形象
odoo
形象
丢弃
2 答案
0
形象
odoo
最佳答案

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.


2 注释
形象
丢弃
形象
odoo
-

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.

形象
odoo
-

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

0
形象
odoo
最佳答案

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

形象
丢弃