Creating a Budget vs Actual report begins with the Profit & Loss in Qvinci. There is no "Budget vs Actual" base report on the Reports tab of Qvinci. Rather, users are able to create a P&L and then append Budget data to the P&L.
Note: As of current, the Budget vs Actual data is not supported for the "Profit & Loss - Weekly" report. Additionally, Qvinci only syncs budget data from QuickBooks Desktop and QuickBooks Online.
Start with a Profit & Loss Report
Clone an existing, or build a new, P&L report:
- The Admin may view the Report Library > Qvinci Gallery tab to "Save As" a P&L template, or
- The user may "Save As" an existing P&L report they have already created, or
- The user may start with a new P&L report from the "Reports" tab and "Memorize & Style"
1) Once a P&L report exists in the Report Library the user will want to remove all financial data values.
2) Identify which column the first financial data set should appear. For example, the CoA likely exists in Column A. Column B is usually a spacing column, so Column C should likely be the first financial column.
3) In the first column where financial data should exist the user will want to click the cell above where the first account in the CoA exists. For example, if Ordinary Income/Expense is on line 6, choose C5 and click on it.
4) With cell "C5" selected, in the tool bar click "Column Chooser". The following selections page will appear and the user should:
- Select a Frequency (this determines how the data is displayed in the columns)
- Select a Date Range (this returns the relative financial data for the time frame chosen)
- At the bottom of the pop-out, select the desired Budget options:
- Budget - append the budget information after the corresponding Actuals)
- Budget $ Diff - append the BvA $ Diff after the corresponding actual and budget columns
- Budget % Diff - append the BvA % Diff after the corresponding actual and budget columns
- Remove Actuals - when a "budget only" report is necessary, use this option to remove Actuals
- Click "Submit" to save the preferences
5) Back in the Report Editor the user will see that cell "C5" has been updated with a macro which will drive the frequency, date range and budget selections.
6) A finished template should look something like this:
7) The previewed template, or the downloaded Package, will render a report which appears as such: