What is a Rate sheet?
Rate sheets can be used while there is a discount or hike for a particular product in seasons or occasions.
How to create/add a new Rate sheet?
You can create your own special Rate sheet for Sales and Purchase under Manage > Rate sheet.
Page Contents
Add Rate Sheet
To add special Rate Sheet,
- Click on Add Rate Sheet button in the top right corner.
- Provide details such as for whom and for what items the rate sheet with the rate percentage of standard rate is applicable.
- Hit Save.
Field Description
| Fields | Description |
|---|---|
| Name | Provide the suitable name for the Rate Sheet |
| Valid From & Valid To | Choose the “Valid From” and “Valid To” dates. This ratesheet specifies the offer dates for the services provided by company during the validity period. |
| For | Choose whether it is applicable for Sales or Purchase or Both. |
| Currency | Choose the Currency for the Rate sheet. |
| Applicable to Customer / Tags / Branch | Choose the Customer / Supplier contacts to Tags where the Rate Sheet to be applied. |
| Round off | Choose this option to round off the value to ones, fives, tens, fifty and Hundreds. |
| Apply for | Choose whether the Rate Sheet applied for “All items” or “Individual items”. You can set the custom rate and percentage for each item(when you choose to apply rate sheet for “Individual Items) |
| Item rate | Select the Item rate percentage to be added or discounted to standard rate For ex: If you provide a rate percentage of 110%, then the rate applied is an additional 10% of standard item rate. If you provide rate percentage as 90%, then the rate applied is discounted 10% of standard item rate. |
How to apply rate sheet in invoices/quote
Go to Manage > Rate sheet.
Click Add Rate Sheet and provide the name of the rate sheet along with a discount percentage.
Hit Save.
Rate sheet for Diwali
Before applying rate sheet, base rate of the product is Rs.14000.
Choose desired rate sheet under Rate column in invoice.
After applying the Diwali rate sheet, the rate of the product became Rs.12,600 = 90% of 14000 as entered earlier while adding rate sheet.
Edit Rate Sheet
To edit an Rate Sheet, hit on the Edit option stuck with each item.
Make your changes and hit Save.
Delete Rate Sheet
You can use the Delete option from the drop-down stuck with each Rate sheet to remove the Rate sheet.
