The example is only an example report layout only, you can change the columns to be displayed to suit your requirements like I've done here:

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

For USA users of QuickBooks, QODBC has the same reports that can be found in QuickBooks:

BalanceSheetBudgetOverview

sp_report BalanceSheetBudgetOverview show Amount_Title, Label, Amount parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

BalanceSheetBudgetVsActual

sp_report BalanceSheetBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget, Difference, Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

ProfitAndLossBudgetOverview

sp_report ProfitAndLossBudgetOverview show Amount_Title, Text, Label, Amount parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

ProfitAndLossBudgetPerformance

sp_report ProfitAndLossBudgetPerformance show Amount_Title, Text, Label, Amount parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

ProfitAndLossBudgetVsActual

sp_report ProfitAndLossBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget, Difference, Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts', SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'

The parameters and filters that are available in a report can be found by running:

sp_paramters sp_reportname

So to report by customer (job) we do:

sp_report ProfitAndLossBudgetVsActual show Amount_Title, Budget_Title, Difference_Title, Percent_Title, Text, Label, Amount, Budget, Difference, Percent parameters FiscalYear = 2006, SummarizeBudgetColumnsBy = 'Customer'

To see how these stored procedures are used, see: How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? 

I see, you want this report to look like the first one above it without all the xxxx.1, xxxx.2 etc, sub-values.

Ok to collapse the report use where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> ''

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> ''

Sorry I don't see your problem:

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2006, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> ''

They are entered correctly in QBooks.  Here is a print shot of a few lines from the budget vs actual report in QBooks:

	Jan 08	Budget	Feb 08	Budget
410100 · EpiForce Product - Domestic	116,750.00	233,730.00	0.00	354,867.00
410110 · EpiForce Product - Foreign	88,785.50		0.00
410500 · EpiForce Maint - Domestic	22,645.91	37,222.00	21,184.88	37,222.00
600400 · Bonuses	31,000.00	30,717.00	31,000.00	30,717.00
600500 · Car Allowances	750.00		750.00
600610 · Medical Insurance	47,401.46	59,400.00	40,156.24	59,400.00
600620 · Dental Insurance	4,423.57	5,600.00	4,175.39	5,600.00

Our budget is broken out further by class/dept.  Here is what I have entered in the sql query: 

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2008, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> ''

And here is some of the returned data:

Label	Amount_1	Amount_2
410100 · EpiForce Product - Domestic	116750	0
410110 · EpiForce Product - Foreign	88785.5	0
410500 · EpiForce Maint - Domestic	22645.91	21184.88
600400 · Bonuses	31000	31000
600500 · Car Allowances	750	750
600610 · Medical Insurance	47401.46	40156.24
600620 · Dental Insurance	4423.57	4175.39

Why doesn't that budget info show up?  Thank you

Try running the report expanded:-

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2008, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account',
DisplayReport='Yes'

I've added the DisplayReport='Yes' parameter to force the report to be displayed in QuickBooks so you can sort out what the report is doing.

Sorry, we only have a ProfitAndLossByClass, there's no "Profit and Loss by Account by Class":-

sp_report ProfitAndLossByClass show Text, Label, Amount
parameters DateMacro = 'ThisYearToDate'

Technically I can do:

sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2008, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Class', SummarizeBudgetRowsBy = 'Account'

But I don't get any report values returned.

Sorry, I'm a little confused.  I have 2 issues:

1) When I run: sp_report ProfitAndLossBudgetVsActual show Text, Label, Amount, Budget,
Percent parameters FiscalYear = 2008, BudgetCriterion = 'Accounts',
SummarizeBudgetColumnsBy = 'Date', SummarizeBudgetRowsBy = 'Account'
where {fn LOCATE(':', "RowData", 2)} = 0 or Text <> ''

my budget amounts do not show up.  They are in Quickbooks though.

2) I am also trying to get a profit and loss budget vs actual by class.

I have done as you suggested and DisplayReport='Yes'.  All of the filters and settings are exactly the same as when I run it directly in Quickbooks.  I believe the issue is that my budget in Quickbooks is by account and class and your sp_report is not pulling the budget report for account and classes.  I need to be able to see the budget figures.

Thank you

Piyush,

You are wonderful!  Thank you.  That worked to get me the budget figures.  Thanks again.

I am able to get the Profit and Loss Actual vs Budget but when I run it, it only does through this month so it gives me Jan, Feb, Mar, Apr, and May.  How do I tell it to print all months Jan-Dec for the current fiscal year?

There are budget amounts.  When I run the report in QuickBooks it shows the budget amounts even if there are no actual transactions. Isn't there a way to get the budget to show up?