How to Use Accounting Mapping for Encore

For the 19 Encore Metrics, we only need to map the following accounts:

1. Operating Income 
2. COGS - Cost of Goods Sold
3. Operating Expenses
4. Amortization and Depreciation - Related to operations  
5. Accounts Receivable - Related to Credit Sales

How to access Accounting Mapping on the MSPbots app

To access Accounting Mapping, go to the leftmost pane and click Settings > Accounting Mapping. 

Expanded pane view	Collapsed pane view

Example:

How to set up the Encore Accounting Mapping feature

To set up the Encore Accounting Mapping feature, navigate to Accounting Mapping on the MSPbots menu and do the following steps:

1. Select your Accounting Software. On the upper left section of the Accounting Mapping tab, hover over the dropdown for accounting software and select your software.
   
   
   
   
2. Select Profit & Loss Statement. On the same section, hover over the dropdown beside the accounting software dropdown list and select Profit & Loss Statement.
   
   
   
   
3. Select Map to Encore. Locate the Map to section and select Encore from the dropdown list. 
   
    
   
   

How to map accounts to Encore Account Mapping

To arrange the mapping in MSPbots Accounting Mapping for Encore:

1. Locate the appropriate accounts and drag them to the Encore template. 
   1. Browse the accounts available in your Accounting Software and locate the account that you wish to map in the MSPbots Encore feature.
   2. Locate the appropriate category in the Encore mapping template for your chosen account.
   3. Drag the account and drop it to the top of the category.
      
      
      
      The mapped account will grey out in the Accounting Software section and be visible below the Encore account category.
      
      
      
      
   4. Alternatively, you can use the search bar to start mapping an account.
      1. Browse the column for your accounting software for the accounts that you wish to map to the MSPbots Encore feature.
      2. Search for the appropriate category in the Encore mapping template.
      3. Select the account and drag it on top of the appropriate category.
         
         
         
         The mapped account will grey out in the Accounting Software column and be visible below the Encore account category.
         
         
         
         
2. Click Save to complete the Encore Accounting Mapping. The Save button for the Encore feature is located on the lower right part of the Accounting Mapping tab. 
   
   
   

What are the Accounts to map for the 19 Encore Metrics?

For the 19 Encore Metrics, we only need to map the following accounts: Amortization and Depreciation - Other Income Sub-category Income COGS and Expenses Accounts Receivable  Disregard the mapping for the following accounts: Bank Accounts payable Other Current Liabilities Credit Card Non-operating income & expense Interest Income Other Income Interest Expense Equity Other current assets Fixed Assets

Mapping Depreciation and Amortization in the Encore Mapping Template

In the section for the Encore mapping template, select the expand button corresponding to the main category Other Income to show the Amortization and Depreciation. 

You can also use the search bar option above as an alternative. 

Mapping Operating Income in Encore Mapping Template

In the section for Encore mapping template, select the expand button beside the main category Income to show Sales, Operating Revenues, Return & Allowances, and Miscellaneous Income.

You can also use the search bar option above as an alternative. 

Select the Expand button for the main category Income. Encore mapping accounts for: Special Product 1 Special Product 2  VOIP Revenue Hardware As A Service Revenue Miscellaneous Income Returns & Allowances Select the Expand button for the parent categories: Product Sales Recurring Service Revenue Labor-Related Revenue
Select the Expand button for the main category Income.  Select the Expand button for the parent category Product Sales. Hardware & Software Cloud Resale
Select Expand button for the main category Income. Select the Expand button for the parent category Recurring Service Revenue. Encore mapping accounts for: Managed Services BCDR (Business Continuity and Disaster Recovery) Security
Select the Expand button for the main category Income. Select the Expand button for the parent category Labor-Related Revenue. Encore mapping accounts for: Block Hour Revenue Time & Materials Project Revenues

Mapping Operating Expense in Encore Mapping Template

In the section for the Encore Mapping Template, select the expand button beside the main category Expenses to show Operating Expenses.

You can also use the search bar option above as an alternative. 

Select the Expand button for the main category Expenses. Encore mapping accounts for:  Accounting Advertising Automobile Expense Bank Charges Books and Publications Computer and Internet Continuing Education Contributions Dues and Subscriptions Employee Benefits Insurance Legal and Professional Licenses and Permits Meals & Entertainment Miscellaneous Office Expense Officer Salaries Postage and Delivery Printing Rent Repairs and Maintenance Salaries Admin Telephone Travel Utilities Website Expand button for Parent Category Taxes mapping to: Tax - Business Tax - Payroll

Mapping Cost of Goods Sold in Encore Mapping Template

In the section for the Encore mapping template, select the expand button beside the main category COGS - Cost of Goods Sold to show Costs and Sales Expenses.

You can also use the search bar option above as an alternative. 

Select the Expand button for the main category COGS - Cost of Goods Sold. Encore mapping accounts for:  VOIP Cost Hardware As A Service Cost Expand button for Parent Category: Product COGS Recurring Service COGS Labor Cost Sales Expense
Select the Expand button for the main category COGS. Select the Expand button for the parent category Product COGS. Encore mapping accounts for: Hardware & Software Costs Cloud Resale COGS Special Product 1 Special Product 2
Select the Expand button for the main category COGS. Select the Expand button for the parent category Recurring Service COGS. Encore mapping accounts for: Managed Services Costs BCDR Security Costs
Select the Expand button for the main category COGS. Select the Expand button for the parent category Labor Cost. Encore mapping accounts for: Technician Salaries Technician Payroll Taxes Technician Benefits Project Cost
Select the Expand button for the main category COGS.  Select the Expand button for the parent category Sales Expense.  Encore mapping accounts for: Salaries Commissions Marketing Travel and Lodging Training Other

Mapping Accounts Receivable in Encore Mapping Template

In the section for the Encore mapping template, select the expand button beside the main category Accounts receivable (A/R) to show Accounts receivable.

You can also use the search bar option above as an alternative. 

Select the Expand button for the main category Accounts Receivable (A/R).  Encore mapping accounts for: Accounts receivable