Qvinci's Advisory Portal is an invaluable tool which allows users to easily analyze business performance on-demand. Whether you are an Accountant or Franchisor, the Advisory Dashboard acts as a bridge for business leaders with meaningful metrics and a bird's-eye view of overall health and performance patterns. By acting as a historical source of truth, the Portal gives stakeholders an opportunity to develop improved strategies. Through this, also opening up the floor for meaningful conversations -- allowing Accountants to provide an invaluable service that will not only strengthen the operation of their clients, but transform relationships from Compliance to one of Consultancy. By the same token, the Advisory Portal allows Franchisors to monitor and proactively reach out to Franchisees to rectify issues that are negatively impacting profits.
A Video Introduction to the Advisory Portal
- Advisory Portal Contents
- Finding the Advisory Portal
- Changing Period Comparison
- Understanding the Advisory Analysis Card
- Setting Filters
- Setting a Reporting Date
- General Ledger Drill-Down and Journal Entries
- Exporting to Excel
- Adding a New Client/Company
Advisory Portal Contents
The Advisory Portal includes 10 metrics and ratios accounting professionals and executives frequently monitor. Additionally, it allows access to our General Ledger Activity Report and Journal Entry Management if enabled.
Available Metrics and Ratios:
- GL - Access to General Ledger Activity Report
- JE - Access to Journal Entry Management
- Total Income - A percent change of Total Income
- COGS - A percent change of Cost of Goods Sold
- Gross Profit Margin - A percent change of Gross Profit Margin
- Top 10 Expenses - A percent change of the Top 10 Expenses as a percent of income
- Net Income - A percent change of Net Income
- Net Profit Margin - A percent change of Net Profit Margin
- Months of Cash - A percent change of Months of Cash (expense per last month of data range)
- Cash - A percent change of Cash
- A/R - A percent change of Accounts Receivable
- A/P - A percent change of Accounts Payable
Finding the Advisory Portal
Step 1. Log in to your account via web.qvinci.com.
Step 2. Click on ‘Portals’ on the left navigation bar.
Step 3. Select ‘Advisory Portal’ on the drop-down menu.
📔The Advisory Portal is the default page for all users unless set otherwise
Changing Period Comparison
All values presented in the portal are a % change of the comparison dates that have been chosen. The Advisory Portal allows for the comparison of 5 different periods:
- Last Month versus Prior Month
- Last Month versus Same Period Last Year
- Last 3 Months versus Prior 3 Months
- Last 3 Months versus Same Period Last Year
- Fiscal YTD versus Prior Fiscal YTD
To modify the period:
Step 1. Navigate and click on the green box labeled 'Last Month versus Prior Month'.
Step 2. Select the desired periods for comparison.
Understanding the Advisory Analysis Card
Each cell in the Advisory Portal is "hot", meaning you can click on any cell containing a ratio. Doing so will bring an Advisory Analysis Card which contains the underlying data.
Step 1. Navigate and click on a cell under any one of the 10 Ratios.
Step 2. A pop-up will appear with a detailed Advisory Analysis Card containing the underlying data which makes up the ratio in question.
A filter can be set for any column field that contains the icon. This allows Portal users to narrow down to specific data using any parameter. To set a filter:
Step 1. Navigate to a column and click on the icon.
Step 2. Use the green box to change the Operator (Is equal to, Starts with, Contains).
Step 3. Enter the desired parameter into the text box.
- Setting a Reporting Date
Step 1. Click on the 'Reports & Libraries' on the left navigation bar.
Step 2. Select 'Account As Of Date'.
Step 3. The first step is to select the date type. Relative to the Current Date (recommended) and press Save at the bottom of the screen. When setting custom 'As Of Date' set the desired date and click Save on the bottom of the screen. (must be in mm/dd/yyyy format, i.e. 12/31/2020).
❗ NOTE: Files must be resynced to update the Advisory Portal based on the new Reporting Date. If no Reporting Date is set, it will default to today.
📔 For more information on As Of Date visit: Qvinci's "As Of Date"
General Ledger and Journal Entries
Similar to the Financial Portal the Advisory Portal is capable of navigating to the General Ledger Activity Report and also to the Journal Entry Management screen if enabled.
📔 For more information on Qvinci's General Ledger visit: Access General Ledger Activity Report.
📔 For more information on Qvinci's Journal Entry system visit: Creating & Managing Journal Entries in Qvinci.
Exporting to Excel
Step 1. Navigate to the button located at the top left of the screen.
Step 2. An Excel file will be immediately downloaded and available for use.
Adding a New Client/Company
For Franchises, Multi-Unit accounts, a button can be found at the top right of the screen.
For Accounting Firms and CPA accounts, a button will appear at the top right of the advisory Portal.
📔 For more information on adding additional Clients/Companies visit: Create Additional/Companies
We're More Than Happy To Help
Schedule a Call with Customer Success below, email us at firstname.lastname@example.org or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!