Knowledgebase
[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).

Refer: Can you create a budget for balance sheet items by class?

How to identify exported report data relation.

Please refer below screenshot for exported report data relation.

Also, Refer

How to use the QuickBooks Reporting Engine with QODBC Online

QODBC Report Parameter & Schema details.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).