Tax engine consists of 3 different excel files:
•Annex_6_1_Appendix_TaxationInDrools – rules to calculate taxes for all document subtypes except shares and vehicles.
•Annex_6_2_Appendix_TaxationInDrools_vehicle - rules to calculate taxes for vehicles.
•Annex_6_3_Appendix_TaxationInDrools_shares - rules to calculate taxes for shares.
Structure in all files is the same. In the spreadsheet “Rules” calculation rules are created. In the spreadsheet “TestCases” a copy of Rules page is made and boundaries or variables are replaced with values.
Figure 80 Rules spreadsheet
Figure 81 Variables block
Figure 82 Document subtype map
Figure 83 Parameters block (1)
Figure 84 Parameters block (2)
Figure 85 Calculation rules block
Figure 86 “Rules” spreadsheet