Versions Compared

Key

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

This The Accounting Mapping feature allows users to display and map their chart of accounts in MSPBots then MSPbots, and use it to create widgets, bots, and dashboards. 

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, users can go to Settings > Accounting Mapping.

This will take users to show the Accounting Dashboard, where they 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 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 
  • 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.

    Image Modified


Use the mapped accounts

...

To use the mapped accounts in widgets:

  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 datasetImage Added
  3. Select the map in the Column Name field.
    columns displayImage Added
Info

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



Content by Label
showLabelsfalse
max3
showSpacefalse
titleRelated Topics
excludeCurrenttrue
cqllabel in ("role","financial","mapping","accounting")