OVERVIEW

This guide outlines how an Entity Syncer can sync financial data via Excel in Qvinci. Viewers can access synced reports, but only the Entity Syncer can perform the sync. A new Excel template must be generated at the beginning of each year.

VIDEO TUTORIAL

STEPS TO CONNECTING QVINCI EXCEL TEMPLATE

 Generate the Excel Template

1. Use Excel 2007 or newer – Older versions are not supported.

2. Log into Qvinci at www.qvinci.com.

3. Navigate to Manage > Entities from the left menu.

4. Click on the desired Entity in the left-hand panel.

5. If Excel Sync is not yet enabled:

   • Click Enable Excel Syncing (bottom right) and proceed.

6. Go to the Export Excel tab (top center).

7. Select January as the start month.

8. Click Generate Template to download the Excel file.

 Enter Financial Data into the Template

1. Reopen the Entity in Manage > Entities, go to Export Excel, and download the latest template.

2. Open the template and enable macros when prompted.

   

3. Read the Intro tab in the template for specific data formatting instructions.

4. Set-up:

   • Export a Profit & Loss report by month from your accounting software for the calendar year.

   • Copy all accounts and monthly data.

   • Paste the data into the “P&L” tab, starting at cell A8.

5. Confirm:

   • Chart of Accounts is in Column A.

   • Monthly values are in subsequent columns.

6. Click a cell in the column where financial data begins (e.g., Column C), then click “Set Start of Financial Data” at the top.

7. Repeat for other reports (Balance Sheet, Cash Flow, etc.) as needed, following formatting rules in the Intro tab.

8. Avoid using dollar signs or formatted symbols in financial values – plain numbers only.

 Sync the Excel Template to Qvinci

1. In Qvinci, go to Manage > Entities, and select the correct Entity.

2. Open the Sync Excel tab.

3. Confirm the currency displayed matches the currency in your Excel data.

4. Click Browse or Choose File to upload the completed template.

5. Click Sync.

6. Wait for the confirmation message (sync typically takes 30 seconds to 2 minutes).

✅ After Sync: The Excel template may be reused. New templates will auto-populate with previously synced data.

📌NOTES & REMINDERS

• Only the Entity Syncer can perform the sync.

• Generate a new template at the start of each year.

• All financial data must be in plain numeric format (no dollar signs or commas).

• Macros must be enabled in Excel for functionality to work.

• Refer to the Intro tab in the template for report-specific formatting and data entry instructions.

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