[QODBC-Desktop] Troubleshooting - How to run ProfitAndLossBudgetOverview by Class report
Posted by Jack - QODBC Support on 24 April 2017 11:40 AM
Troubleshooting - How to run ProfitAndLossBudgetOverview by Class report
Typical Profit & Loss Budget Overview By Class Report (for the current Fiscal Year to Date) in QuickBooks
Note: The QuickBooks Sample files set the QuickBooks date to December 15, 2021. The current Fiscal Year shown above is January 1 through December 15, 2021.
Report Displayed in QODBC
Open Microsoft Query in Excel
Note: Make sure you have installed Microsoft Query Add-on first. To learn how to install Microsoft Query, please refer to Microsoft Office with MS Query and QODBC.
Please start Microsoft Excel & Create a blank workbook.
Please select the "Data" tab and click "From Other Sources->From Microsoft Query."
Create a New Microsoft Query in Excel
Select the DSN you want to use to connect to the QuickBooks file. (Here, I choose the default data source with a sample company file opened.)
Note: Uncheck option "Use Query Wizard to Created/edit Queries" since we do not need to import any QuickBooks tables here.
Close the "Add Tables" window by clicking the "Close" button.
Press the "SQL" button to input your sp_report query as below. Here we take a ProfitAndLossBudgetOverview report as an example:
sp_report ProfitAndLossBudgetOverview show Amount_Title, Text, Label, Amount parameters FiscalYear = 2021, BudgetCriterion = 'AccountsAndClasses', SummarizeBudgetColumnsBy = 'Class', SummarizeBudgetRowsBy = 'Account'
Press an OK button to get results in Microsoft Query:
Return Records to Excel Spreadsheet
Select Menu File -> Return Data to Microsoft Office Excel to return records to Excel Spreadsheet.
Choose how you want to import data into your workbook & click "OK."
Data exported in the workbook.
Note: QuickBooks does not support creating a budget by class or other criteria for the Balance Sheet. So it is not available through QODBC reports (i.e., BalanceSheetBudgetOverview & BalanceSheetBudgetVsActual).
How to identify exported report data relation.
Please refer below screenshot for exported report data relation.