General Ledger Based Weekly Reporting and Business Intelligence With Non-Sunday Aligned and Customizable Accounting Calendar Features

General Ledger Non-Sunday Aligned Weekly Reporting Overview

Qvinci now has General Ledger Non-Sunday Aligned Weekly reporting. Previously, Qvinci only provided Sunday-aligned reporting as is standard in QuickBooks. It is now capable of being set to any day of the week. This feature does have a fee. Please speak with your Solution Consultant or Customer Success Manager to have this feature enabled. 

WARNING: Do not attempt this process until you have been trained by your Qvinci Customer Success Manager. Please contact our support team for assistance.

General Ledger access must be enabled at the account level for all subscriptions in the account. To have General Ledger  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. Once these two features are enabled, General Ledger Non-Sunday Aligned Weekly reporting will be available in the Basic and Gallery Report sections of Qvinci.

The Qvinci admin (customer) may enable the weekly report feature upon account setup. However, the Qvinci admin must contact Qvinci's Customer Support team to have weekly reports enabled once locations are populated in the account. When weekly reporting is enabled, your file(s) will need to sync to activate weekly reporting. Users can then run reports using the weekly report cycle. The key to success is getting the accounting calendar set up and customized properly to meet your period-based reporting needs. Note: The weekly reporting feature is only available for Profit and Loss reports.  

The most important part of this feature is setting the accounting calendar correctly the first time. The account administrator will share the company's accounting calendar with Qvinci so we can incorporate your calendar into our platform. The admin will meet with the Customer Success team to verify the calendar is correct and discuss when they add their additional week. Qvinci then exports the calendar to your account, makes the necessary adjustments, and then uploads it into your account.  The last step is to sync all files. Once they have all synced you may run reports as you would normally in Basic Reporting or the GL reports in the gallery.

Introductory Video

Summary of Contents

Accounting Calendar Setup

Running GL Non-Sunday Aligned Weekly Reporting in Basic Reports

Running GL Non-Sunday Aligned Weekly Reporting from the Gallery Reports

Accounting Calendar Setup

Customizable Accounting Calendar Video

Step 1:  Finalize your accounting calendar before syncing files. If the accounting calendar needs to be adjusted, files will need to be resynced to get the updated GL Weekly data. 

1. Schedule a meeting with your CSM to develop the accounting calendar.

2. Set the desired fiscal month and start of the week with your CSM. If you are using the extended sync feature, you will need to know the # of syncing years as well. Remember, the accounting calendar start month is the starting month of your Fiscal Year for GL Weekly reporting.

3. Have your company's accounting calendar or any documentation that you can share with Qvinci to help identify any weekly adjustments that will be made to your accounting calendar. For example, we will need to know what 6-week period(s) you are using or planning to use to complete your calendar.

Step 2:  The account CSM will need to make any adjustments to the accounting calendar on our platform.

1. In Qvinci, navigate to Manage > Accounting Calendar for the target account and company/client.

2. Export the accounting calendar.

3. After you have downloaded the Excel accounting calendar, you can adjust the "Fiscal Year" and "Period" columns for any weeks that need to be shifted. (Note, you CANNOT adjust anything in the "Week Starting" column or the accounting calendar Excel export.)

4. When all desired adjustments to the accounting calendar have been made, go back to Manage > Accounting Calendar, select the accounting calendar Excel export you modified, and select "Import Accounting Calendar."

5. If any files have been synced to this company/client they will need to be resynced to get the updated GL Weekly data.

Running GL Non-Sunday Aligned Reporting in Basic Reports

Basic Weekly Reports Video

Basic Reports:

To view reports for a single LOCATION, specific GROUP, or ALL LOCATIONS:

1. Click the “Reports & Libraries” tab in the Qvinci menu.
2. Select "Basic Reports."
3. Select the "Profit & Loss GL Weekly" report.
4. Filter to the desired entity(-ies).
5. On the following screen, select frequency, date range, and report options.
6. Select "Build My Report."
7. You may now export the report as an Excel or PDF file.

Note: If only “Profit & Loss” appears as a report type, your company is not currently enrolled in weekly reporting. Only the Qvinci administrator may enable the GL Weekly reporting feature.

Running GL Non-Sunday Aligned Weekly Reporting in the Gallery Reports

Gallery Reports Video

Library Reports:

To view reports for a single LOCATION, specific GROUP, or ALL LOCATIONS:

1. Click the “Reports & Libraries” tab in the Qvinci menu.
2. Select "Libraries."
3. Navigate to the "Gallery" tab.
4. Select the "Profit & Loss GL Weekly" report you want to run.
5. Filter to the desired entity(-ies).
6. Select "Build My Report."
7. You may now export the report as an Excel or PDF file.

Note: If only “Profit & Loss” appears as a report type, your company is not currently enrolled in weekly reporting. Only the Qvinci administrator may enable the GL Weekly reporting feature.