How to Apply Weekly and Monthly Rates

How to Apply Weekly and Monthly Rates

How to Apply Weekly and Monthly Rates

This is a great feature and fully automated based on your input. This program will now apply Daily, Weekly and Monthly rates to equipment. The program will bill the full value and add a credit back to the invoice that will reflect the credits due for each piece of equipment and provide you the full details and summary of how the credit was calculated and applied. There is some set up involved on the price list but this can be done by simply exporting current price list to excel make the change then import back to convert back to the *.bdata file. 


IMPORTANT:  Be sure to check the box on the Equipment Input Dialog for the Equipment you want to include in the Terms Discount Feature.   If you forgot to do this, go back to click on first equipment item for each and click MODIFY and check the box, then say yes to the pop up message to apply this to all of the same item.

Equipment Input Dialog


The BILLING TERMS is designed to allow you to bill Weekly and Monthly Terms on your Equipment
  • The Item MUST be qualified for the Terms.  Follow the instructions

  • During the Input (Equipment | Materials | Specialty Items) you will have an option to check the box to include item for Terms. (see dialog image below)

  • Once you check the box the and press enter the Cap Column on the input page will now say Yes - See Image below this column says No until the items are qualified

  • After you check the box and press Enter the Items are now ready to apply Weekly and Monthly Rates for the Equipment

  • To Remove Terms, repeat the steps above but this time un-check the box for Terms and Select Yes so it Removes Terms from all the same ID #'s.


IMPORTANT NOTE ABOUT WEEKLY AND MONTHLY RATES - The Price list MUST have a Weekly and Monthly Rate in order for the terms to work properly.  If you do not have a MONTHLY RATE, then take the WEEKLY RATE and multiply it by 4. This will make your MONTHLY RATE the same as 4 WEEKLY RATES.

Example:  

Item # 400 in the image below -  The setup is as follows:
  1. Daily Rate is $200.00 Per Day.  
  2. To Figure Weekly Rate - Weekly Rate to be billed as for Every 7 Days we will bill 5 Days.  To Get the Weekly Rate take the Daily Rate of $200.00 x 5 = $1,000.00 (Weekly Rate)
  3. To Figure Monthly Rate - Monthly Rate to be billed as for Every 30 Days we will bill 15 Days.  To Get the Weekly Rate take the Daily Rate of $200.00 x 15 = $3,000.00 (Monthly Rate)
  4. Now go and enter these as shown below into the price list.  
  5. Open Price Data File Dialog from the Project Data Files Menu located on the left side of the Programs Main Interface.
  6. Click on the tab - Equipment and Tools - Click on the item you want to add Weekly and Monthly Rates to (You Must Have a Weekly and Monthly Rate)

Or you can Export price data file to Excel add the Terms Weekly and Monthly Rates and then Import Back to Covert back to a .bdata file. See Price Data File to learn about Export and Import Function
New Equipment Term Discount Dialog -
Important - You must have your price list set up as shown above before this will work -
To Enable this new feature
  1. Set Up Price List as Shown Above
  2. Check the Box on the Dialog to Enable Equipment Term Discount Feature
  3. Entering  Qualifiers Weekly and Monthly
  4. Weekly should always be 7 if your rule is based on 7  days then bill this amount (ie: For Every 7 Days the Weekly Rate is Equal to 5 Days)
  5. Monthly should always be 30 if your rule is based on 30 days then bill this amount (ie: For Every 30 Days the Monthly Rate is Equal to 15 Days)
  6. Consecutive Days ONLY - You can Select to Yes or No - If No then the Count restarts once a break in the dates is detected
  7. Once all settings are complete and feature is enabled - Click ENTER to apply the Equipment Term Discounts

Below is the New Reports for Equipment Terms Discount Function Includes
  1. Billing Terms Summary
  2. Billing Terms Worksheet
  3. Worksheet Summary

  1. If you only want selected equipment to have applied discounts, make sure they are the only ones that have Weekly and Monthly Rates on the Price Data. All the others will have no value for Weekly or Monthly.

To Print the Summary Report and Include with Bill Package  

  1. Go to File
  2. Click on Print Bill Pages 
  3. Click on Billing Terms Summary



    • Related Articles

    • Apply Weekly and Monthly Equipment Rates

      Equipment Term Discounts - Weekly and Monthly Rates This is a great feature and fully automated based on your input. This program will now apply Daily, Weekly and Monthly rates to equipment. The program will bill the full value and add a credit back ...
    • Apply Optional Weekly Rates

      Apply Weekly Labor Associated Fees **IMPORTANT NOTE: THIS WILL OVERRIDE THE DEFAULT SETTINGS ON THE PROJECT SETTINGS FOR EACH ITEM  Open Project Settings Dialog Click on Weekly Associated Labor Fee(s) Setup to Open Dialog Weekly Associated Labor ...
    • Apply Weekly Associated Labor Fees

      Apply Weekly Labor Associated Fees **IMPORTANT NOTE: THIS WILL OVERRIDE THE DEFAULT SETTINGS ON THE PROJECT SETTINGS FOR EACH ITEM THAT IS ENABLED ON THE WEEKLY RATE DIALOG  **PROGRAM WILL BILL FULL WEEKLY RATE FOR EACH LABOR REGARDLESS OF HOURS OR ...
    • Default Rates and Markups

      Default Rates and Markups Copyright © 2022. All rights reserved - T&M Pro Suite - www.timeandmaterial.com - Setting the Standard for T&M Billing 
    • Apply Billing CAPS

      Apply Billing CAPS - BASED ON PERCENTAGE OF RETAIL VALUE Billing CAPS - This tool is designed to allow you to CAP items based on a Percentage of Retail Value Basically, what this means is you bill an Air Scrubber that is valued at $2000.00 dollars ...