Page Comparison

If you want to learn more about budget insights in general, read Budget Insights. 

Contact your ServiceChannel manager to enable budget insights.

1. On the hamburger menu, click Admin > Budgets Insights. 
   The Budget Insights page opens.
   
   
   
2. In the Budget drop-down menu, click Create New to start configuring a new budget.
   
   
   
3. In the Name & Currency section, enter the budget name. 

4. In the Name & Currency section, select the primary currency of the budget.
   
   

   Note
   The work orders that fall into the budget allocation may have different currencies.However, the primary currency must be selectedfor the entire budget that will be shown in the Budget Insights window on proposals and work orders. You will also see the selected currency on the Budget Insights Analytics Report dashboard.

   
   

   • Category / Primary Category. Primary categories mean standard ServiceChannel categories. Simple categories are the customized categories serving as additional categories to the primary ones. See Managing Categories to learn more about category creation. 
   • Trade. The trades can be configured in the Admin module. See Managing Trades for more information. 
   • GL Code. GL Codes can be configured on the Admin – Accounting page. See Managing GL Codes for more information. 

   • Location / Region / District. You can manage locations in the Locations & Provider Assignments module. Regions and districts are specified on the Location Details page.
     

     Note

     The parameters selected affect the following ServiceChannel modules and sections:  When completing the Budgets Template, you should fill out only selected parameters and leave other columns blank.  Work orders and proposals fall into the budget if they meet the selected parameters. For example, if the GL Code parameter is selected, work orders without the GL code will not be assigned to the budget.  The Budget Insights Analytics Report dashboard will show you the analysis by the selected parameters. For example, if your budget has the Category parameter, you will see the Budget By Category section on the analytics dashboard.

     
     

     In the Parameters section, select at least 1 parameter that should be applied to the budget:
     
     
     

     Warning
     Only select parameters that you allocate budget by. For example, if you allocate the budget by the GL code and Location, do not select theCategory and Tradeparameters.

     
     

5. In the Fiscal Calendar section, enter the period name, select start and end dates, and the quarter for the period.
   
   

   Note
   The fiscal calendar name will be automatically populated for you, but you can change it if needed.

   
   
   

   Note
   Ensure the fiscal period name you enter matches the Fiscal Period Name in the Budget Template later.

   
   

   Warning
   Budget data for a fiscal year that is complete cannot be loaded.

   
   

6. (Optional) Click the Bin icon to delete the row.  
7. (Optional) Click the Clear All Settings button to clear all budget information. 
8. Click Submit.  

For your convenience, you can download the following retrieved data in the .xlsx format that will help you fill out the template: 
 

• Click the Template Instructions expandable section to view the list of reports available for download: 
  • Category or Primary Category is a report with the information on the Primary and Custom Categories configured in your ServiceChannel account in the Admin – WO Properties section. 
  • Trade is a report with the information on the Trades configured in your ServiceChannel account in the Admin – WO Properties section. 
  • GL Code is a report with the information on the GL codes for each trade and category configured in your ServiceChannel account in the Admin – Accounting section. 
  • Location ID, Region, and District is a report containing information about your locations specified in the Locations & Assignments module. Use it to fill out your budget template with: 
    • Subscriber ID 
    • Location ID 
    • Region 
    • District. 

1. On the Admin – Budget Insights page, click BudgetTemplate to open the section with the template.
   
   
   

   Note
   Note that the BudgetTemplate section will appear below the Budget Settings section after you complete the general budget information from step 1 and click Submit.

   
   

2. Click Blank Template to download the Budget Template to your computer.
   
   
   The template has been downloaded.
   
   

   Tip
   Short instructions on the template completion are in the Instructions tab of the template.

   
   
   

3. Fill out the following columns:
   

   Note
   Note that the following 3 columns are always required for completion:   Subscriber ID  Fiscal Period Name  Budget Amounts  Complete other parameters (Category, Primary Category, Trade, GL Code, Location ID, Region, District) only if you selected any of them in Budget Settings before.   For example, if you selected the Category parameter only, do not complete any other parameters in the template.

   • Subscriber ID (Required). Enter the Subscriber ID number for each row. It can be found at the bottom of the page or using the GL Code or LocationID, Region or District reports in the Template Instructions section. 

   • Fiscal Period (Required). Enter the Fiscal Period Name specified in the Fiscal Calendar section. For example, Pd01. 
     
     

     Note

     When completing the Fiscal Period Name column, note the following information:   The Fiscal Period Name entered in the Fiscal Calendar section of Budget Settings must match the name in the template.  The Fiscal Period Name entered should be equal to the number of locations/districts/regions/trades/categories tied to the budget and fiscal period. Each line should be separate.    Say you have 3 locations for the same fiscal period (Pd1) and 2 categories with different budgets. Then, your template should look the following way:  Pd1 – MAINTENANCE – 58473  Pd1 – MAINTENANCE – 57463  Pd1 – MAINTENANCE – 67567  Pd1 – REPAIR – 58473  Pd1 – REPAIR – 57463  Pd1 – REPAIR – 67567

     
     

   • Category (Optional). If you selected the Category as the parameter, enter custom categories specified in the Admin – WO Properties section the budget will be assigned to. 

   • Primary Category (Optional). If you selected the Primary Category as the parameter, enter primary categories from the Admin – WO Properties section the budget will be assigned to.
     

     Tip
     Download the Category or Primary Category report to get a customized report for your ServiceChannel account.

     
     

   • Trade(Optional). If you selected the Tradeas the parameter, enter thetradesspecified in the Admin – WO Propertiessection the budget will be assigned to.
     
     

     Tip
     Download the Trade report to get a customized report for your ServiceChannel account.

     
     

   • GL Code(Optional). If you selected the GL Codeas the parameter, enter GL codes configured in your ServiceChannel account in the Admin – Accountingsection the budget will be assigned to.
     
     

     Tip
     Download the GL Code report to get a customized report for your ServiceChannel account.

     
     

   • Location ID (Optional). If you selected the LocationID as the parameter, enter location IDs from the Locations and Provider Assignment module the budget will be assigned to.  
   • Region (Optional). If you selected the Region as the parameter, enter region(s) from the Locations and Provider Assignment module the budget will be assigned to. 

   • District (Optional). If you selected the District as the parameter, enter district(s) from the Locations and Provider Assignment module the budget will be assigned to.
     

     Tip
     Download the Location ID, Region, and District report to get a customized report for your ServiceChannel account.

     
     

   • Budget Amount(Required). Enter the budget amount for each row. 

   
   

4. Save the template to your computer in the .xlsx format.  

5. Click Upload Template and select your file. 
   
   
   

   Warning
   Note that the current file size limit is 30MB. If your file extends the limit, split up the budget into several files (for example, by fiscal periods 1-6, 7-12 and reach out to ServiceChannel Support for assistance toupload data.

   
   

6. (Optional) Correct the errors in the template if there are any. The error messages are listed in the last J column. 
    
   Once you uploadthe template, you can track how you are managing the budgets.