Extended Data Syncing

Overview

Qvinci now has an Extended Data Syncing capability.  Qvinci's reporting capability was limited to 3 years, including the current year to date (36 months in total) but now can be extended up to 7 years (84 months in total).  This feature does have a fee. Please speak with your Solutions Consultant or your Customer Success Manager to have this feature enabled.  Once enabled, it is accessible from the Basic Reports, General Ledger and Gallery Reports sections of Qvinci.

Video

Summary of Contents

Running Extended Sync in Basic Reports

Running Extended Sync in Library of Gallery Reports

Running Extended Sync in General Ledger

What's New:

• You can now add additional years at the Company or Client level in your account: Minimum value of 3, including the current year to date (36 months) and max value of 7 years (84 months).
• “Number of Years to Sync” includes current year to date.  

Running Extended Sync in Basic Reports

Qvinci's  Reports and Libraries tab allows all users to run reports on the Entities they have been set up to view. Users may opt to run Basic Reports rather than to design and style the reports in the library.  Basic Reports only require basic information to select in order to build the report you are looking for.

With Extended Sync enabled, just like before you may choose specific date ranges, which now include multiple choices at the bottom of the dropdown (All X) or set your custom date range.

Step 1. Choose whether to build the report from a Standard Chart of Accounts or Native QuickBooks Chart of Accounts by checking or unchecking the Account Mapping box, if applicable. Unchecking this box will run the report based on the Native charts of accounts in QuickBooks.

Step 2. You can select any other option from the menus that you'd like and that will display the information you would like to see in your results. 

Step 3. Once all the options are set, you can select the Build My Report  button.

You cannot make changes to Basic Reports. If you would like a more customized look for the information from a basic report, then you will need to save and modify a JumpStart template from the Qvinci Gallery.

Changing the Options in a Basic Report

Once you run a basic report, if you need to change options you can choose the "Options" button, which will provide you with all the options for building the report again.

Once you have completed, press the Rebuild  button from the bottom of your screen to run the report.

Running Extended Sync Library of Gallery Reports

Qvinci's  Reports and Libraries tab allows all users to run reports on the Entities they have been set up to view. Users may opt to run Basic Reports rather than to design and style the reports in the library. We now have as an option to have access to our Extended Sync for a fee.  Extended syncing is available for these Reports:  (Profit & Loss Monthly, Profit & Loss Weekly, Balance Sheet, Cash Flow, Sales by Customer, Expense by Vendor, Trial Balance, Peer Benchmarking, Ranking, Ratios, GL Activity). It is not available for A/R Aging and A/P Aging because they are run as today and looking backwards in time.  The Gallery has not changed, just the option to choose different years in the past.  

Running Extended Sync in the Library of Gallery Reports

Step 1. Navigate to Reports & Libraries from the left-hand menu and select "Libraries."

Step 2. Search for SPAY (Same Period All Years) in the Gallery Search bar. (You can run the report by hitting the green preview button.

Step 3. Or if you would like to edit the report, select the edit button

Step 4. The Qvinci Report Styler will open another tab.

Step 5. Select the month Macro in row 7.

Step 6. Then select the column chooser. It is on the left side menu.

Step 7. It will open the options available to you.

Step 8. Choose the Offset date range.  Use the dropdown arrow to choose the date range of your choice.

Step 9. Then hit the  button in the upper right hand corner.

Step 10.  You can also choose to set a Custom Date Range, which is also an option in the Column Chooser.

Example using the Offset and Custom Date Range:

Running Extended Sync in General Ledger

General Ledger access is a module available in Qvinci for QuickBooks Online and QuickBooks Desktop files. GL access must be enabled at the account level for all subscriptions in the account. To have GL access enabled please refer to the contact information at the bottom of this article. Your file will need to be synced again after it's activated. You can also learn more about creating and pushing Journal Entries through Qvinci here. 

Access General Ledger Entries via the Advisory Portal

Admins, Leaders, Managers, and Client/Company Staff can follow the steps below to view General Ledger entries. Note that users can only view GL entries for one QuickBooks file at a time; we do not yet offer consolidated GL functionality.

Step 1. Click on the Portal tab to view both portals, then click on the Advisory Portal.

Step 2. Find the column named GL.

Step 3. Click “View” in the GL column of the Entity you would like to see the GL for.

Step 4. Select the desired Filter Options (Click “Save” to use default filters).

GL with Extended Sync enabled:

The blue "Filter Options" button will bring up this menu again, letting you choose different account and date range settings. You can click on the three circles to the right of each column header to display additional sorting and filtering options. While you cannot build reports based on GL transactions, you can click the "Export to Excel" button in the top left to download a workbook with the displayed transactions.

NOTE on General Ledger Drilldown for Balance Sheet Reports

Drilling down from a Balance Sheet report will NOT show all the transactions that make up the actual total displayed. This is because the drill-down functionality only displays transactions that occurred during the date range of the report.  Balance Sheet reports represent a running total of an account as of a moment in time, it does not display every transaction for the history of the account.

For example, let's say you ran a Balance Sheet report for the month of June 2021. The report would display the running balance of every BS account as of June 30, 2021. Drilling down into the account totals, though, would only show you transactions that occurred during the month of June. If the account you click through to did not have any transactions for the date range, the GL tab will be blank.

Currently Not Supported

• API access to Extended Sync data
• Legacy P&L Weekly, there are no new “All X” date ranges. Data can only be accessed via manual adjustments to Offsets in ROMs in Report Editor.
• Extended Sync Budgets (still only have last 2 and current Fiscal Year)
• Extended Sync for Manual Entry Entities
• Currency Conversion for extended data (only default last 2 years and current fiscal year converted)
• Extended Sync Budgets (still only have last 2 years and current Fiscal Year)

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