The rate table is the first component of the invoicing process.
1. Select "Rate Table" from the project billing menu.
2. When opening the rate table for the first time, users are prompted to use edit mode to verify model names and add base values for each unique model number in their inventory.
3. If you have multiple items with the same model number, they will be represented by a single line item in the rate table. This consolidation allows for easier management and calculation of charges based on the model number.
It's important to mention that even if a model number is not found in the catalog or if it is not currently in your inventory, it can still be included in the rate table.
This ensures that the rate table remains comprehensive and adaptable to future additions or changes in your inventory.
By using the model number as the defining characteristic in the rate table, you can accurately track and calculate charges for each item, regardless of their unique serial numbers.
Note: Model numbers added to the rate table will be retained even if they are deleted from the inventory. This ensures that rate table data is not lost in case the model is re-added in the future or if there are mistakes during inventory management.
4. If you don't want a specific item to be included in future billing, you have the option to ‘Exclude’ it.
To do this, you can go to the edit mode in the rate table by clicking on the pencil icon.
5. Select the checkbox next to the item to exclude it from future billing.
6. Click on the "Exclude" button to confirm the exclusion.
7. Once I choose to exclude it, you will notice that the line item is grayed out.
By excluding the model in the rate table, it will be automatically excluded from invoices for assignments where the model is assigned by default.
Note: It's important to note that the value is still retained in the rate table. This means that even though it is excluded from invoices, the information is still stored for reference purposes.
8. In the editing mode, you can update the model name and base value for the desired item.
Note: When you first open the rate table, it's important to know that not all model numbers will have the same description (model name). This is because users can change the descriptions. For example, one person might remove a specific tool from the description, while others keep it. You can also make changes to the descriptions.
The most recent description you added or edited will be the one that shows up. So, if you have 10 of the same tool with model number DCF896B and you updated the description yesterday, the system will show the updated description from yesterday, not an older one from two weeks ago.
9. After making the necessary changes in the rate table, click on the "Save Changes" button
Edit Rate Details
In the Edit Rate Details, you can see different rates for different time periods.
The daily rate is based on an 8-hour workday. It calculates the rate by dividing the base value by the number of workdays in a year.
The weekly rate assumes a 5-day work week, so it calculates the rate by dividing the total number of weeks in a year.
The monthly rate is calculated based on 365 days in a year.
10. This is another way you can make changes to the model name and the base value. To edit the item and see rates. Simply click on the item you want to edit.
11. Make the necessary changes to the model name or base value rate, and click on the "Save" button.
12. Click on the 'Base Rate History' tab to track the date, time, and person responsible for any changes made to the base value of the item over time.
Rate Table - Settings
13. Click on the gear icon to open the rate table settings. You to control the loss rate based on the percentage you want to allocate for lost tools.
For example, if a tool goes missing, breaks, or is damaged on a job site, the company may want to bill for that item. However, they may want to bill it at a value higher than 100% of the item's base value. This is because replacing a lost tool involves additional costs such as ordering, shipping, handling, and overhead expenses. With this feature, you can specify the percentage (e.g., 120%) of the base value that the company will charge to replace the lost tool.
14. Adjust the 'Loss Rate' by entering the desired percentage and click 'APPLY'
Export the Rate Table data
One useful feature is the ability to export the list. This allows you to save the list as a separate file that can be easily shared and review by a manager.
15.To export the list, simply locate the "Export" button at the top right corner.
16. The exported file will be in CSV format.
Join our Community!
We are excited to continue the discussion about Site Manager in our community forum. Contribute ideas, make suggestions, and discuss with other like minded asset managers. Click here!
Comments
0 comments
Article is closed for comments.