And friendly, helpful staff too!! Ordered on Wednesday and Friday mid morning I had the delivery I ordered gsm papers and they where delivered second day moreover it was my first purchase, this company is the best. I received my product quickly and hassle free. I thought it would take a while to receive my product.
I can't believe I found this gem of a supplier! Thank you for the stress free shopping! Staff is professional and they have such a vast variety of NCR business products and Paper products to choose from. Google rating score: 4. OK Learn more. Cookie and Privacy Settings. How we use cookies. Essential Website Cookies. Check to enable permanent hiding of message bar and refuse all cookies if you do not opt in. We need 2 cookies to store this setting.
Otherwise you will be prompted again when opening a new browser window or new a tab. Other external services. Privacy Policy. You can read about our cookies and privacy settings in detail on our Privacy Policy Page. Accept settings Hide notification only. Health and Safety. Frequently Asked Questions. No, SARS does not require the daily odometer readings for Read More. You should always maintain an opening and closing odometer reading Yes, you need a log book to support your claim One vehicle will be used against two allowances.
On the Your employer will declare any travel reimbursements paid to you Table of Contents. Last Updated:. Note: The template calculations only include the first client codes on the Clients sheet. If this default value is not sufficient, open the Name Manager feature Formulas tab on the ribbon and simply change the value of which is specified for the CRecords named range to the required number of client codes which need to be included in the template calculations.
All the calculations in the light blue columns on the Clients sheet are based on the filter selections which have been specified at the top of the sheet. These selections enable users to compile a client charge sheet based on any user defined date range and for any individual vehicle.
The filter selections on the Client sheet include the following user input cells: From Date - the date range for which the calculations on the sheet are performed starts on the user defined date in cell G4.
The date should be entered based on the regional date settings which are specified in the System Control Panel. If this cell is left blank, the date range will commence on the first day of the year that is five years before the current year it can therefore be reasonably expected that all logbook entries for the past 5 years will be included in the calculations on the Clients sheet.
To Date - the date range for which the calculations on the sheet are performed ends on the user defined date in cell I4. If this cell is left blank, the date range will end on the last day of the current calendar month which is determined based on the current system date.
Vehicle - the calculations on the Clients sheet can be performed based on a single vehicle or all the vehicles which have been added to the Vehicles sheet. If you want the calculations to be based on a specific vehicle, simple select the appropriate vehicle from the list box in cell K4.
If you want the calculations to be based on all vehicles, simply delete the contents of cell K4 in order to display a blank cell. Simply add a new vehicle registration number and enter a description for the vehicle. The columns with light blue column headings contain formulas which need to be copied for all new vehicles that are added to the sheet. Note: All the vehicle registration numbers that are added to the Vehicles sheet need to be entered in a continuous cell range otherwise some entries may not be included in the template calculations.
The Vehicles sheet contains the following user input columns: Vehicle Reg Number - a unique vehicle registration number needs to be entered for each vehicle. Vehicle Description - enter a description of the vehicle in this column. The Vehicles sheet contains the following calculated columns columns with light blue column headings which are all based on the filter selections at the top of the sheet: Total Mileage - this is the total mileage that has been recorded for the particular vehicle during the user defined period based on the logbook entries on the Logbook sheet.
Total Charges - this is the total charges which have been allocated to the vehicle and is calculated by multiplying the travel distance in column N on the Logbook sheet by the rate in column L on the Logbook sheet. Business Mileage - this is the total business trip mileage that has been recorded for the particular vehicle during the user defined period based on the logbook entries on the Logbook sheet.
This calculation indicates the level of usage of the vehicle for business purposes and can be compared to the same calculation for other vehicles in order to identify excessive private use of vehicles. Rate Charged - this is the average rate which has been charged to clients based on the use of the vehicle for business purposes and is calculated by dividing the total charges by the business mileage.
Business Trips - this is the number of business trips which have been allocated to the vehicle. If round trips are recorded as a single trip, the number of business trips would reflect round trips. Total Mileage by Month - these three columns display the total mileage per month which has been allocated to the vehicle.
The calculations in these columns can be used to review the total mileage which have been allocated to each vehicle for the appropriate quarter. The calculations in these columns can be used to review the business use of the vehicle for the appropriate quarter. Number of Business Trips by Month - these three columns display the number of business trips per month which has been allocated to the vehicle.
The calculations in these columns can be used to review the number of trips which have been allocated to the vehicle for the appropriate quarter. This is especially useful when you need to monitor sales representatives with fixed routes where each sales representative uses a separate vehicle. Note: The template calculations only include the first vehicle registration numbers on the Vehicles sheet.
If this default value is not sufficient, open the Name Manager feature Formulas tab on the ribbon and simply change the value of which is specified for the VRecords named range to the required number of vehicle registration numbers which need to be included in the template calculations. All the calculations in the light blue columns on the Vehicles sheet are based on the filter selections which have been specified at the top of the sheet.
These selections enable users to compile a vehicle charge sheet based on any user defined date range and for any individual client. The filter selections on the Vehicles sheet include the following user input cells: From Date - the date range for which the calculations on the sheet are performed starts on the user defined date in cell G4.
If this cell is left blank, the date range will commence on the first day of the year that is five years before the current year it can therefore be reasonably expected that all logbook entries for the past 5 years will be included in the calculations on the Vehicles sheet. Client - the calculations on the Vehicles sheet can be performed based on a single client or all the client codes which have been added to the Clients sheet.
If you want the calculations to be based on a specific client code, simple select the appropriate client code from the list box in cell K4. If you want the calculations to be based on all clients, simply delete the contents of cell K4 in order to display a blank cell. The contents of these forms can then be recorded on the Logbook sheet.
Note: An example of the input which is required in each column is supplied at the top of the sheet. Note: We strongly recommend issuing these forms in a numeric sequence by changing the form number at the top of the sheet before printing the form. This will enable users to check the form sequence in order to ensure that all vehicle logbook entries have been recorded. The following error codes may result from inaccurate input on the Logbook sheet and will be displayed in the Error Code column.
The heading of the affected input column will also be highlighted in orange:. Note: Input errors may result in inaccurate template calculations and it is therefore imperative that all errors are resolved before reviewing the template calculations.
How to use the Vehicle Logbook template Download the sample or trial version when reviewing these instructions. Client Charge Sheet The Clients sheet can be used to calculate the travel charges that needs to be invoiced to each client based on any user defined date range.
Filter Selection Options All the calculations in the light blue columns on the Clients sheet are based on the filter selections which have been specified at the top of the sheet.
0コメント