Overview of Non-Financial Syncing

Overview

Non-Financial Sync lets you report on operational metrics that are not stored in your accounting system. These metrics can be added to Qvinci reports alongside financial data to provide a fuller view of performance.

Common examples include member or customer counts, employee headcount, units sold, service calls, and other KPIs.

Notes:

• Non-Financial Sync (NFS) must be enabled by a Qvinci account administrator. If it has not been enabled for your account, some of the options described below may not be available.
• Microsoft Excel 2007 or later is required for Excel-based Non-Financial Sync.
• If you have questions about enabling Non-Financial Sync, please contact Qvinci Support.

What is Non-Financial Sync?

Qvinci automatically synchronizes your financial data from your accounting system, including your chart of accounts and account balances. However, many organizations also track operational metrics that exist outside of their accounting software.

For example, a gym owner may want to report on monthly membership counts alongside revenue and expenses. While member counts aren't stored in QuickBooks or another accounting system, they can still be tracked in Qvinci using Non-Financial Sync or the Qvinci API **See below for more information.

After syncing this data, you can include it in your report templates and use it in calculations such as:

• Revenue per member
• Expense per employee
• Sales per location
• Any other custom KPI or operational metric

Add Non-Financial Accounts to the Standard Chart of Accounts (SCoA)

Before syncing any operational data, you'll first need to create the corresponding Non-Financial accounts within your Qvinci Standard Chart of Accounts (SCoA).

Users with the appropriate permissions can navigate to Manage > SCoA on the Menu after logging in. 

In the Non-Financial section, you can:

• Add new accounts
• Edit existing accounts
• Delete accounts that are no longer needed

When new Non-Financial accounts are created, Qvinci automatically adds a whitelist phrase to support automatic account mapping during synchronization.

Related: Learn more about whitelist terms and automatic account mapping.

Sync Non-Financial Data

Once your Non-Financial accounts have been created, you'll need to sync data for each Entity that will report on those metrics.

Entity Syncers can navigate to Manage > Entities > Non-Financial Sync tab

From there you can sync Non-Financial data via Excel upload:

1. Generate the  Excel template.
2. Enter monthly operational data.
   • Reporting period may very with accounting calendars
3. Save the completed template.
4. Upload the file back into Qvinci.

If you already sync financial data using Excel, the Non-Financial Sync process uses the same synchronization engine and follows nearly identical steps.

Related: See Non-Financial Sync: How to Create and Upload the Import Template for detailed step-by-step instructions.

 

Sync Non-Financial Data via API

Organizations looking to automate operational reporting can also send Non-Financial data directly into Qvinci using the Qvinci API.

The Qvinci API allows organizations to push financial and operational data into Qvinci, complementing the existing Qvinci Reporting API, which pulls standardized Qvinci data into external applications. Together, these APIs provide a two-way flow of information that helps standardize reporting across your organization's technology ecosystem.

Using the API can eliminate recurring manual Excel uploads while ensuring operational metrics remain up to date alongside your financial data.

If you'd like to learn more about API connectivity or discuss whether an API integration is right for your organization, please contact your Account Manager (AM) or Client Performance Manager (CPM).

Add Non-Financial Data to Reports

After your Non-Financial data has been synchronized, it can be incorporated into your Qvinci report templates.

By adding a Non-Financial section and corresponding macros to your report template, you can:

• Display operational metrics alongside financial data.
• Reference Non-Financial accounts in formulas.
• Calculate custom KPIs and performance metrics.
• Build richer reports that combine financial and operational insights.

Related: See Adding Non-Financial Data to Reports for complete instructions on configuring report templates to display Non-Financial data.

Have Questions?
We're More Than Happy to Help

Schedule a call with Customer Success below, email us at support@qvinci.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!

Schedule an Appointment with Customer Success