@lubos Report transformation for tax codes provide information on transactions that occurred within the specified period (selected time), but it does not provide information on the tax amount that must be paid, and this is because there may be carried forward VAT assets (carried forward or as Starting Balance) or liabilities to be considered in the period. My suggested solution is to allow the inclusion of the following in Report Transformations
-
Account Closing balance. The closing balance of an account(s) will be included in the report transformation to help compute the tax to be paid in cash at the end of the specified period. The date for the closing balance will be the same as the report’s chosen end date.
-
Account Starting Balance. The Starting balance of an account(s) will be included in the report transformation to help compute the tax to be paid in cash at the end of the specified period. The date for the starting balance will be the same as the report’s chosen Start date.
Use Case.
In some jurisdictions, customers are to withhold some or all the VAT amount on supplier’s invoices and pay to the tax office. It is called Withholding VAT. The supplier will disclose this VAT asset (credit) in the VAT returns provided the tax credit certificate has been received. Report transformations can include such asset (Account Closing balance) in the report to correctly compute the VAT to be paid to the tax office.
Many jurisdictions may allow a person to pay all or some of their tax liabilities due to the state later because of working capital issues, therefore, there will be a credit starting balance on the tax payable account for the current period. Others may also have output tax in excess over input tax for the prior period or may have overpaid taxes. Manager can include such balances (Account Starting Balance) in Report transformations to compute cash payable to the tax office for the current period. This will also be useful for those who have migrated to Manager with starting tax payable balances.
The second problem is that users can no longer choose accounts for tax liabilities when creating tax codes. In my opinion, users should be allowed to select the liability account they wish for tax code components. Choosing separate liability accounts for tax code components provides a second source of verification for tax code balances right on the summary screen. Also, this will be necessary to put the above suggestion into effect when working with multiple rates for tax codes.
Before
After
@Ealfardan what do you think of this?
