Import Variable Costs from Excel Workbook
If you wish to import variable items from a spreadsheet, please
Contact Us to ask for a copy of the spreadsheet template or you can set one up yourself as shown below.
The import file must be named "Variable Costs.xlsx" and must be saved in the "Excel Import" folder within the "CareMaster" folder. An example of the layout of the data is shown below.
Column A is the Charge Template reference, this can be found in the top right hand corner of each Charge Template and an example can be seen by viewing the Charge Template - Main page. Make sure that you have entered the correct reference for the Charge Template that you want to import into. You can print a list of the charge template references for each resident buy going to Charge Template List in the "Reports" menu.
Column B is the Charge Type. A list of these can be seen by viewing the Invoice Charge Types page. N.B. You can only import for Charge Types that are of the "Variable Lump Sum" type.
Column C is the description, this is a free text field.
Column D is the Nominal Code you want this charge to be posted to in Sage Accounts.
Column E is the Department Code you want this charge to be posted to in Sage Accounts. (if you do not use the Departments in Sage, leave this as "0").
Column F is the amount of the charge.
Column G is the Sage Tax Code.
Column H is the "From Date" for the charge.
Column I is the "To Date" for the charge.
Once you have entered all of the required data, save the file with the filename and location mentioned above.
Click on the "Invoicing" tab to bring up the list of options and then select "Variable Costs" followed by "Import Variable Costs from Excel Workbook" from the menu options list.
The "Import Variable Costs" screen will now appear.
If you are happy that all is correct, click on "OK" to continue. If not, click on "Close" to cancel.
If you continue with the process you will be asked to confirm your choice.
Click on "Yes" to go ahead or "No" to cancel.
Finally, you will see the "Import Complete" dialog box. Click on "OK" to end.
If you want to review the data you have imported you can go to
Update Variable Costs or if you want to go ahead and create invoices you can go to Generate Sales Invoices. The charges you have imported will be included when the particular invoicing period cycle is next run.
