LogoLogo
Navigating the Excel Add-In
Navigating the Excel Add-In
  • πŸ…Best Practices
  • πŸ“šMy books are closed - what do I do?
  • ⏬Installing the Drivepoint 2.0 Add-In
  • ☝️Core Functions of the Drivepoint Add-In
    • πŸ“ΊIntro: Video Walk-Through
    • πŸ”“Signing In
    • 🏠Home
    • ⬇️Import Data
      • πŸ—ΊοΈMapping Financial Accounts
    • πŸ“…Model Roll Forward
      • ❓Help! I accidentally rolled forward?!
    • ☁️Sync to Drivepoint
    • ⁉️Scenario Planning ("Create New Plan")
    • πŸ“ˆImport Plans to Compare in SmartModelβ„’
    • ❓FAQ on the new Add-In
  • πŸ”Permissions
    • πŸ«‚Creating and Managing Groups
  • πŸ—‘οΈRemoving the old Add-In "Drivepoint Legacy"
Powered by GitBook
On this page
  • How do I map my accounts?
  • Step-by-step Instructions
  • ‼️ Important Note for Netsuite Customers

Was this helpful?

  1. Core Functions of the Drivepoint Add-In
  2. Import Data

Mapping Financial Accounts

You need to map all of your accounts to Drivepoint categories. The mappings are stored in the Drivepoint cloud and will get pulled into every Plan when importing financial data.

PreviousImport DataNextModel Roll Forward

Last updated 3 months ago

Was this helpful?

How do I map my accounts?

When you are importing all data and your QBO or Netsuite is skipped, you receive an alert that you have new accounts to map. Please click on that link.

Step-by-step Instructions

  1. Open the Drivepoint Add-In and click on Import Data

  2. Next to your Financial data click on the > arrow

  1. Expand the Add-In Menu to map accounts for better visibility into all fields

  1. Click on "Unmapped only" to get a better view of the accounts you still need to map

  1. Scroll through the options in the Drivepoint menu to map every unmapped account

  1. If you are unsure of the unmapped account, you can also scroll to the right to "Full Account Information" and hover over the row to see more information from your accounting software (QBO/Netsuite) that might help map this account to Drivepoint

  1. Once you have selected a Drivepoint category, scroll down and click on "Save Accounts Map"

πŸŽ‰ Congrats - you have now mapped your financial accounts to Drivepoint categories.

‼️ Important Note for Netsuite Customers

There are some accounts that are always purposefully left unmapped because they could be totals or subtotals. Mapping those accounts will double count in M-monthly.

Examples of Accounts to leave unmapped:

☝️
⬇️
πŸ—ΊοΈ
Please do not map these accounts!