Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

Tax Tables

Tax rates are entered in the Tax Tables section of the system. You can store as many as five different tax rates. You can also control when they go into effect and when the rates expire.

Video

Tax Tables PUBLIC.mp4

Step-by-Step

Adding Tax Rates

To add tax rates:

  1. Go to the System Maintenance tab.

  2. Select Financial from the left side panel.

  3. Click on the Tax Tables icon, to open the Tax Tables window.

  4. Click the Load Tax Tables button.


    IMPORTANT: The Description # fields, are associated to the corresponding Tax Rate # in the Tax Table. For Example, “Description #1” is linked to “Tax Rate #1”.


    A description MUST be entered in order to enter a tax rate percentage in the table. If a description is not entered the Tax Rate # field will not allow for data entry.

  5. Fill in the necessary Description #1 field, this is typically “Sales Tax”.

  6. Fill in the column information in the tax table. The below fields are required:

    • Store - The Store Number.

    • Tax Class - “Default” is the only option.

    • Start Date - When the tax rate goes into effect.

    • End Date - When the tax rate ends. (Usually this is left blank.)

    • Tax Rate #1 - The sales tax percentage. (The percentage symbol is not needed.)

  7. If an additional tax rate needs to be reported use the next available Description # and Tax Rate # fields. (#2, #3, #4, #5) to enter the necessary information.)

    Reminder; a Description # must be filled in to correlate with the corresponding Tax Rate #. For example if a county tax is collected in addition to a state sales tax:

    1. Add a description identifying the tax in the next available field, in this example Description #2.

    2. Add the percentage amount in the associated tax rate column, in this example Tax Rate #2.

  8. Click the Save button or F5 on your computer keyboard when done.

Editing Tax Rates

If there is a tax rate change DO NOT modify the existing tax rate. Instead go to the next available row. For instance if the sales tax rate has changed from 8.25% to 8.5%: :

  1. Go to the row with the current tax rate.

  2. Add an End Date in the End Date column. The end date will be the date that the new tax rate goes into effect.

  3. Go to the next available row to create the required changes. In this example we will fill in the below details:

    • Store Number - 10

    • Tax Class - Default

    • Start Date - 2023-01-01
      IMPORTANT: The end date of the current tax rate and the start date of the new tax rate should be the SAME.

    • End Date (if known, otherwise this can be left blank).

    • Tax Rate #1 - Sales Tax increase to 8.5

    • Tax Rate #2 - remains 2.0
      Note: You will need to carry over all tax rates that are unchanged when creating a new tax row.


      Note: Tax rate changes can be added at any time with future begin and end dates. Meaning if you are aware of an upcoming tax rate change you can prepare the changes in advance to ensure everything will be ready using the above instructions.

  4. Once all tax fields are filled out appropriately click the Save button or F5 on your computer keyboard when done.

Do not select tab or click on the next available row below the current tax rate. This will automatically create a new tax row. If a new row is created, simply press the delete key on your keyboard to remove it.

Tax Reporting

There are multiple reports available in the eGenuity Software. The Tax Summary Report displays the Tax Description, Tax Rate and Total Taxes Collected for the specified Date Range, grouped by Store. The system also allows you to modify the report using the Data Explorer feature as detailed in the video below.

Video

Report Explorer.mp4

Step-by-step

Data Explorer within Existing Reports

To Access Data Explorer, in Reports:

  1. Select the Business Management Tab.

  2. Select the Reports Icon.

  3. Select a Report from the available list.

  4. Update the parameters for the report as needed, on the right hand side.

  5. Select the Explore Button.

  6. In the Explorer View you can Hide All or Show all Columns by Using the buttons to the right, or Remove Specific columns by unchecking the visible box.

  7. You can shift the order of the columns or group the reports by a specific column.

    1. To Shift Columns, select the column header and drag the column to the left or right as needed.

    2. To Group Columns, select the column header and drag it into the gray area as pictured below:

  8. Once the report is formatted to your preference you can choose to Save the Layout for future use, Print or Export to Excel by choosing the appropriate icon at the top of the explorer window:

  9. You also have the option to Delete an existing layout that is no longer needed. To Delete:

    1. Select the layout from the layout drop down menu.

    2. Click on the Delete Icon.

    3. Click OK.

  • No labels