Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

Info

The Accounting Mapping feature requires data from the accounting integrations QuickBooks Online, QuickBooks On-Premise, and Xero. Only users with a financial role can use this feature.

This article is a guide on how to:

 

Table of Contents

Access the Account Mapping feature

...

To access this feature, go to Settings > Accounting Mapping.

...

This will show the Accounting Dashboard, where you can do the following:

  • Use the data from the integrated accounting software, and select a Financial Statement to map between Profit & Loss and Balance Sheet.
  • Review all sub-accounts that are displayed on the left side.
  • Select a Mapping Template. The The most commonly used templates are for the following: 

    • Service Leadership SLI

    • Bering McKinley 

    • Encore 

    • MSP Finance Team 
    • N-able Benchmark 
    • Taylor Business Group TAAP
    • Technology Marketing Toolkit
    • TruMethods 
  • SLI and Bering McKinley. Users can also create new templates by clicking the Edit Mapping Templates link on the upper right corner of the dashboard. 

    Note

    Contact our Support Team after creating your mapping template so they can help you integrate it with the mapping data.


  • Categorize sub-accounts by dragging them to the mapping template.

...

  1. On the MSPbots app, go to Widgets.
  2. Select a widget, go to Dataset, and select mapped from the Dataset drop-down list.
    mapped dataset
  3. Select the map in the Column Name field.
    mapped templatesImage Removedcolumns displayImage Added
Info

For now, the selection currently shows the maps available to income accounts only. Balance Sheets will also be available soon.

...