Adjusting the mapping between QuickBooks Online and LivePlan Follow

 

Note: The mapping interface is only accessible if you are connected to an accounting solution. Also, it's important to know that the account owner and any contributors who have access to the Dashboard can make changes to mapping. 

If you started a company file by connecting LivePlan with your accounting solution, then the software automatically created a starting set of forecast categories for you. It also mapped those forecast categories to your QuickBooks chart of accounts, so that the two sets of data can be compared side by side.

If you later make changes in your QuickBooks chart of accounts or your LivePlan forecast, then you'll need to update the mapping between them so your data comparison stays accurate.

 

Updating mapping after changing your chart of accounts

If you make changes to your chart of accounts in QuickBooks online, such as adding, removing, or re-naming accounts, then you'll need to re-sync QuickBooks with LivePlan.

  1. In the Dashboard tab, click the Sync menu. Then select Sync with QuickBooks Online:
    dashboard-resync-qbo.png
  2. After re-syncing, click the Mapping link to go to the Mapping page:
    dashboard-mapping-menu.png
  3. Your updated chart of accounts should now appear on the left side of the Mapping page:
    dashboard-mapping-cofa.png
  4. At this point, you can use the drop down menus on the right side of the page to make any adjustments to the forecast categories connected to your chart of accounts:
    adjusting-mapping-forecast.gif
  5. Click the Continue button at the bottom of the page:
    adjust-mapping-continue.png
  6. Proceed through the remaining pages of the mapping interface:
    adjusting-mapping-categories.png
  7. At the bottom of the Liabilities page, click I'm Done to save your changes:
    adjusting-mapping-im-done.png

 

Updating mapping after changing your LivePlan forecast

If you have added, removed, or re-named any of the categories in your LivePlan forecast, then you may need to update the mapping between these and your QuickBooks chart of accounts.

  1. In the Dashboard tab, click the Mapping link to go to the Mapping page:
    dashboard-mapping-menu.png
  2. The drop-down menus on the right side of the page represent your forecast categories. Click on any of these menus to update how these forecast categories are mapped to your QuickBooks chart of accounts:
    adjusting-mapping-forecast.gif
  3. Click the Continue button at the bottom of the page:
    adjust-mapping-continue.png
  4. Proceed through the remaining pages of the mapping interface:
    adjusting-mapping-categories.png
  5. At the bottom of the Liabilities page, click I'm Done to save your changes:
    adjusting-mapping-im-done.png

  

Adding revenue streams, direct costs, or expenses during mapping

While you are mapping your accounts, you may discover that a revenue stream or expense exists in your QuickBooks chart of accounts that doesn't exist in your LivePlan forecast yet. This is no problem. You can add the revenue stream or expense from the mapping screen instead. However, don't forget that you'll need to go back into your Forecast tab later and enter the data for that added revenue stream or expense.

  1. Next to the QuickBooks account that you want to map to the new revenue stream or expense, click Choose a destination.
  2. From the list box, choose Add new revenue stream (or Add new expense, if you are on the Expenses tab):
    add-new-revenue-xero.jpg#asset:1815
  3. In the overlay that appears, enter a name for the new revenue stream or expense:
    add new revenue map new.png#asset:772
  4. Click Add.
  5. The newly added revenue stream or expense will be automatically mapped to the desired QuickBooks Online account.
  6. Remember to go back into your Forecast tab to enter the data for this revenue stream or expense.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments