N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here
for more info!
The Accounting Mapping feature allows users to display and map their chart of accounts in MSPbots, and use it to create widgets, bots, and dashboards. Only users with a Financial role can use this feature.
For the 19 Encore Metrics, we only need to map the following accounts:
- Operating Income
- COGS - Cost of Goods Sold
- Operating Expenses
- Amortization and Depreciation - Related to operations
- Accounts Receivable - Related to Credit Sales
The Accounting Mapping feature requires data from the accounting integrations QuickBooks Online, QuickBooks On-Premise, and Xero.
This article is a guide on how to:
How to access Accounting Mapping feature?
To access this feature go to the leftmost pane and click
Settings > Accounting MappingExpanded pane view | Collapsed pane view |
---|---|
After selecting
Accounting Mapping you may now access the Accounting Mapping featureSample:
How to use the Encore Accounting Mapping feature?
To set up the Encore Accounting Mapping feature, open your Accounting Mapping tab.
If you can't see the tab click here for instructions on How to access Accounting Mapping feature?
Once in the Accounting Mapping Tab, you may now set up the settings for the Encore Accounting Mapping feature as follows:
Select your Accounting Software
On the upper left portion of the Accounting Mapping tab, Hover over the dropbox list and select the dropdown button > Your Accounting Software
Select Profit & Loss Statement
On the upper left portion of the Accounting Mapping tab beside the Accounting software dropbox list, Hover over the dropbox list and select the dropdown button > Profit & Loss Statement
Select Map to Encore
On the middle part of the Accounting Mapping tab beside the word Map to, Hover over the dropbox list and select the dropdown button > Encore
How to map accounts to Encore Account Mapping
To map your Accounts in MSPbots Accounting Mapping for Encore make sure that your on the Accounting Mapping tab and Set-up for the Encore feature are selected.
If you can't see the tab click here for instructions on How to access Accounting Mapping feature? if the Encore feature is not yet in place click How to access Encore Accounting Mapping feature?
To arrange the mapping in MSPbots Accounting Mapping for Encore here are the instructions to follow:
You may use the search Bar (optional)
a. Search the accounts available in your Accounting Software you wish to map in the MSPbots Encore feature
b. Search for the appropriate category in the Encore mapping template
c. Select and drag the Account and move it on top of the appropriate
Note: The mapped account will grey out in your Accounting Software area and will be visible below the Encore account category.
Locate the appropriate accounts and drag them to the Encore template
a. Locate the accounts available in your Accounting Software you wish to map in the MSPbots Encore feature
b. Locate the appropriate category in the Encore mapping template
c. Select and drag the Account and move it on top of the appropriate
Note: The mapped account will grey out in your Accounting Software area and be visible below the Encore account category.
Make sure to 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:
Please disregard the mapping for the following accounts:
|
---|
Mapping Depreciation and Amortization in Encore Mapping Template
In the Encore mapping template, Select the expand button
beside the Main category Other Income to show the amortization and depreciation.You may also use the search bar on item b in You may use the search Bar (optional)
Mapping Operating income in Encore Mapping Template
In the Encore mapping template, Select the expand button
beside the Main category Income to show Sales, Operating Revenues, Return & Allowances, and Miscellaneous Income.You may also use the search bar on item b in You may use the search Bar (optional)
| |
---|---|
| |
| |
|
Mapping Operating Expense in Encore Mapping Template
In the Encore mapping template, Select the expand button
beside the Main category Expense to show Operating Expenses.You may also use the search bar on item b in You may use the search Bar (optional)
|
---|
Mapping Cost of Goods Sold in Encore Mapping Template
In the Encore mapping template, Select the expand button
beside the Main category COGS to show Costs and Sales Expenses.You may also use the search bar on item b in You may use the search Bar (optional)
| |
---|---|
| |
| |
| |
|
Mapping Accounts Receivable in Encore Mapping Template
In the Encore mapping template, Select the expand button
beside the Main category Accounts receivable (A/R) to show Accounts receivableYou may also use the search bar on item b in You may use the search Bar (optional)