Configuring the Tax Rates driver
The Tax Rates driver contains tax rates that are used by bank balancer to calculate the incremental tax expense related to balancing entries. Although its primary purpose is to support Bank Balancer calculations, the Tax Rates drivers table may be used by other planning utilities as well. All tax rates are company-specific.
Configuring Tax Rates
To configure Tax Rates:
- From the Command Center home page, click Financial Planning.
- Open the budget, scenario, or forecast for which to edit the driver.
- Click the Drivers & Assumptions tab.
-
Click the Tax Rates link.
NOTE: The driver opens in the Desktop Client and displays the Tax Rates sheet by default.
-
In the TaxRates sheet, double-click Add New Row(s) to open the Insert dialog box and add tax rate rows for every company requiring a budget tax rate.
NOTE: The TaxRates sheet is preconfigured to handle up to 25 companies.
-
For each tax rate row, provide the following:
Column Name Entry Requirements Tax Rate Description Enter a description in the Tax Rate Description column.
NOTE: The tax rate description should include the company number as the last characters of the description.
Base Year Forecast MoYYYY Enter the tax percentage amount in each Base Year Forecast MoYYYY column. Plan Year Forecast MoYYYY [Optional] Enter the tax percentage amount in each Base Year Actual MoYYYY column. - Click the Save button on the Axiom ribbon to save tax rate drivers to the database.
- Close the Tax Rates file after completing any needed inputs.