NOTES: Non-Financial Syncing is only available if requested by an account Admin. Please contact Qvinci support for more information. Non-financial syncing also requires Excel 2007 or newer.
If you are familiar with syncing P&L data via Excel, non-financial syncs are powered via the same engine, so the steps are nearly identical.
Generate the Syncing Template for the Qvinci Entity
- The Entity Syncer should log in at Qvinci.com and navigate to Manage > Entities on the left hand menu
- Select the Entity for which you'd like to sync non-financial data
- Click on the "Non-Financial Sync" tab
- Click the blue "Generate Template" button
- Open the template in Excel
NOTE: If the "Non-Financial Sync" tab does not appear, you are either not logged in as the Entity Syncer or the Non-Financial Sync feature has not been enabled for your account.
Review Required Formatting Rules
Strict formatting is required to ensure data can be read correctly. Please review the following guidelines for Non-Financial syncing.
- Account names must be entered on the left between the category titles of "Non-Financial" and "Total Non-Financial". These titles will be pre-populated in the template and are required; do not remove them. You can insert additional rows above the "Total Non-Financial" row if needed.
- Non-financial account names must be unique.
- If you have parent/child accounts in your data set, a header and total row are both required (See "Blue" and "Total Blue" in the example below
- Parent accounts should have no data for any month and must be completely blank
- Non-financial accounts and Total rows must contain data for at least one month. You can enter 0s for accounts without activity, as shown in Row 15 of the example.
Enter Non-Financial Data in the Template
- Click "Enable Editing" in the yellow bar across the top so that you can make changes
- Click "Enable Content" in the yellow bar across the top, as macros are required for successful syncing
- Navigate to the "NF" tab for the year which you need to sync. (For example, to sync non-financial data for 2019, you'd navigate to the "NF19" tab.) This tab will be pre-populated with any existing data or SCoA accounts if applicable; otherwise, example accounts will be present.
- Delete any account rows you do not need, and feel free to add additional rows for accounts that were not pre-populated.
REMINDER: All account names must exist between the "Non-Financial" and "Total Non-Financial" titles, which are required and must remain in the template.
- Click on any cell in the first blank column and click the gray "Set Start of Non-Financial Data" button, which will add month labels in Row 6.
- Enter your data for each non-financial account for the appropriate month(s). Each account and total row must have data for at least 1 month to sync successfully. You can add 0s for rows that don't have any transactions for the period.
- Save the template to your computer, keeping in mind you can re-use this template to update data for future months.
- In your web browser, navigate back to the Manage > Entities > Non-Financial page
- In the "Sync Non-Financial Data" section, go to Step 2 and click the browse/choose file button
- Select the Excel file that was just saved onto your computer
- Click the green "Sync" button under Step 3
How to Create New Tabs in 2020 with Non-Financial Sync
- NFS users can add a new tab for the current year if they are using a Non-Financial template.
- That was downloaded the previous year by clicking on the "Create worksheet for this year" button on the Location tab of the NF template.
- As of December 31, 2019, this option is only available if you download an updated template.
Troubleshooting Unsuccessful Syncs
Check that all the following are true:
- All account names are between the "Non-Financial" header and "Total Non-Financial" row
- All account names are unique
- Parent account headers do not have data
- All account rows and total rows do have data for at least one month
- All parent accounts have a matching total row
- Date headers are present in Row 6 (populated by clicking "Set Start of Non-Financial Data")
If you're still having issues, contact Qvinci Support with a copy of the syncing template handy.