...
...
| Table of Contents |
|---|
...
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
...
Step-by-Step
Adding Tax Rates
To add tax rates:
Go to the System Maintenance Tab tab.
Select Financial from the left Side Panelside panel.
Click on the Tax Tables Icon icon, to open the Tax Tables Windowwindow.
Click the “Load Load Tax Tables” Tables button.
Fill out the 
IMPORTANT: The Description # fields, are associated with 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.Fill in the necessary Description #1 field, this is typically listed as “Sales Tax”.
Then proceed to fill 
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. (Note: There is a Tax Classes tab that is an obsolete feature.)
Start Date - When the tax rate
goes into effect. (Format is 4-digit year, 2-digit month and day.)
End Date - When the tax rate ends. This is usually left blank.(Format is the same as start date.)
Tax Rate #1 -
The additional Tax Rate Columns; Tax Rate #2, Tax Rate #3, Tax Rate #4, Tax Rate #5, are available if additional tax rates need to be reported. For example if a County Tax is collected separate from the State Sales Tax Rate. To update this information:
First Add a Description name in the next available field. Please note if a description is not filled in you will not be able to enter a tax rate.
Then add the percentage amount in the Appropriate Tax Rate Column:
- If there is a Tax Rate Change
The sales tax percentage. (The percentage symbol is not needed.)
If an additional tax rate needs to be reported use the next available Description # field and it’s corresponding Tax Rate # field to enter the necessary information.)
Reminder;a description must be filled before entering information in the corresponding tax rate. Example: A county tax is collected in addition to a state sales tax:
Add a description identifying the tax in the next available field, in this example Description #2.
Add the percentage amount in the associated tax rate column, in this example Tax Rate #2.
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%:
Go to the row with the current tax rate.
Add an
endEnd Date in the End Date
Column of the existing tax ratecolumn. The end date will be the date that the
New Tax Ratenew tax rate goes into effect.
Create a New Tax Rate Line filling in all required fields. 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
Tax Rate Changes (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.
Once all Tax Fields tax fields are filled out appropriately Click click the Save button or F5 on your computer keyboard to complete and save the changeskeyboard when done.
| Note |
|---|
Do not press the tab key or click on the next available blank row. This will automatically create a new tax row. If a new row is created, simply click on any field in the blank row and press the delete key on your keyboard to remove it. |
Tax Summary Report
There are multiple reports available in the eGenuity Software. The Tax Summary report contains store and tax information that can be filtered by date ranges and time periods. By using the report’s Data Explorer function, the report layout can be edited to create and save new layouts of the selected report.
Video
...
Step-by-step
Opening the Tax Summary Report
To open the Tax Summary report:
Select the Business Management tab.
Select the Reports icon.
Select a report from the available list.
Update the parameters for the report as needed, on the right-hand side.
Select the Explore button.
Editing the Report Layout in Data Explorer
The top section of the Data Explorer window has the following layout editing options:
Choose Layout - If any layouts have been saved, they can be selected here.
Show All Columns - Includes all fields in the report.
Hide All Columns - Removes all fields from the report.
Visible (checkboxes to the right of the field names) - excludes specific fields by unchecking the visible box.
The bottom section of the Data Explorer window, has the following report layout editing options:
Reorder columns - Columns can be reordered by clicking on the column header and, without releasing the click, dragging it to the left or right to new position and then releasing the click.
Group columns - Column data can be grouped by clicking on the column header and, without releasing the click, dragging it to the gray area as pictured below:
Once the report layout has been modified, the following options are available:
Save the layout to use later.
Print the report with selected layout.
Delete the layout.
Export the report with selected layout to Excel.
...
| Info |
|---|
To delete a layout that is not currently open, choose it from the layout dropdown box in the top section of the Data Explorer window and click on the Delete Layout icon. |