Access General Ledger Transactions

Overview

General Ledger (GL) access is available in Qvinci for both QuickBooks Online and QuickBooks Desktop files. This feature must be enabled at the account level and applies to all subscriptions within the account.

Once GL access is activated, the affected files must be synced again before transactions can be viewed. To request activation, please contact Qvinci Support using the information at the end of this article.

You can also learn more about creating and pushing Journal Entries through Qvinci in our related documentation.

Access General Ledger Entries via the Advisory Portal

Admins, Leaders, Managers, and Client/Company Staff can view General Ledger entries by following the steps below.

Important: General Ledger entries can only be viewed for one QuickBooks file at a time. Consolidated GL viewing is not currently available.

Steps

1. Click the Portal tab and select the Advisory Portal.

2. Locate the GL column.

3. Click View in the GL column for the Entity you want to review.

4. Select your desired Filter Options, then click Save. If no changes are made, the default filters will apply.

You can reopen the filter menu at any time using the blue Filter Options button. Additional sorting and filtering options are available by clicking the three-dot menu next to each column header.

While GL transactions cannot be turned into Qvinci reports, you can export the displayed transactions by clicking Export to Excel in the top left corner of the screen.

Access General Ledger Transactions from a Report Preview 

You can also drill down into General Ledger transactions directly from a Balance Sheet or Profit & Loss report in Qvinci. This allows you to see the journal entries that make up a specific account balance for the selected period.

Steps

1. Click the Reports & Libraries and select Libraries.

2. If needed, use the Filter Entities option at the top of the screen to select a single entity.

3. Click Preview next to the Balance Sheet or Profit & Loss report you want to view.

4. The report opens in a new tab. Double-click any financial cell to drill down into the General Ledger transactions that make up that amount.

   • If no new tab opens, confirm that only one entity is selected before previewing the report.

6. The GL transactions for the selected account will display in a separate tab.

Note: GL drill-down is not available for cells that contain formulas. Only values sourced directly from QuickBooks can be drilled into.

IMPORTANT Note on Balance Sheet Drill-Down

When drilling down from a Balance Sheet report, the General Ledger view will not show all transactions that contribute to the total balance shown on the report.

Balance Sheets represent a running total as of a specific date. To prevent displaying an account’s full transaction history, Qvinci only shows transactions that occurred within the date range of the report.

Example: If you run a Balance Sheet for June 2021, the report shows account balances as of June 30, 2021. Drilling down into an account will only display transactions that occurred during June. If no transactions occurred in that period, the GL view will be blank.

Have Questions?
We're More Than Happy to Help

Schedule a call with Customer Success below, email us at support@qvinci.com it is always FREE!

Schedule an Appointment with Customer Success