NOTE: This feature is only available after the admin of a Qvinci account has requested the feature. If you would like to utilize this feature, please have your account admin Contact Qvinci Support for further details.
Once the Standard Chart of Accounts (SCoA) is created for the Company, the Admin, Leaders, Managers and Contributors may begin mapping the incoming accounts to the SCoA in Qvinci. Note that Cross-Account Type Mapping does not allow users to map across Report Types (ie: P&L accounts cannot be mapped to Balance Sheet accounts, or vice versa).
Map Accounts to the Qvinci SCoA
After managing the SCoA for the Client / Company a user may map accounts. Unlike the non-Cross Account Type workflow, users will see two Account Type dropdown fields now.
- From Tools > Map to SCoA tab click the "Classic Mapping" button in the top right corner
- The left dropdown (under Step 1) manages the Account Types for the Qvinci SCoA
- The right dropdown (under Step 3) navigates users across the accounts found inside the location's / entity's accounting files (under the Account Type the user tracks them as in the file).
Because two Account Type dropdown menus exist for Cross-Account Type Mapping, a user will find that Step 1 controls what appears in Step 2, and that Step 3 controls what appears in Step 4. With that in mind, a user may proceed to the mapping steps below.
- Under Step 1 choose the Standard Account Type desired for Native Accounts to map to and the user will notice that Step 2 updates with the corresponding Standard Accounts accordingly.
- Migrate to Step 3 to choose the Native Account Type to map from. The user will then see the corresponding Native Accounts appear under Step 4.
- The user will then begin mapping the Native Accounts shown in Step 4 to the Standard Accounts shown in Step 2 by checkmarking a Native Account in Step 4, clicking on a Standard Account in Step 2, and then clicking the "Map Selection" button.
- The newly mapped account will disappear from the screen if the user is on the "Unmapped" page, or will show the new mapping in the relationship if the user clicks on the "All Accounts" button from the right side of the page.
- If a remapping for a particular account is necessary simply repeat the mapping steps, but be sure to click the "All Accounts" button. This shows all accounts, as opposed to only unmapped ones, and will allow a user to repeat the mapping steps to update the mapping relationship.
Using Whitelist Terms
Whitelist terms may be used for Cross-Account mapping. The whitelist terms are Report Type specific. This means that terms associated with P&L accounts will not affect the mappings of Balance Sheet accounts, or vice versa. However, if duplicate whitelist terms exist among various accounts under the same Report Type, and a mapping collision occurs, the Account Type where the native account exists will win the mapping. If mapping issues occur because of whitelist collisions or overrides, it is best to remove that whitelist term completely from any Standard Accounts and instead manually perform the mappings.