cancel
Showing results for 
Search instead for 
Did you mean: 
MrsCrawdaddy
Level 1

Variance reports

I need to figure out how to run a variance report for our monthly P&L to show the beginning and ending balances that do not mach. Does QuickBooks have a report like that?? If not, how to I create one??

4 Comments 4
BigRedConsulting
Community Champion

Variance reports

RE: show the beginning and ending balances that do not mach.

 

I don't think a P&L can be checked that way. It doesn't include balances, but instead the numbers for each account are the sum of the detailed activity for the period.

 

What do you want to compare the report against?

MrsCrawdaddy
Level 1

Variance reports

Once a month, we have to submit the P&L's to the treasurer to review and approve for submission to the Board of Directors. I have run into issues when the ending balances of say Aug doesn't match the beginning balances in Sep when they should. So I want a report that shows the variances between those amounts and what we budgeted vrs what was collected with the YTD figures. Basically, when there's a discrepancy with amount collected, YTD totals, budget, etc, I can see how much that discrepancy is. 

BigRedConsulting
Community Champion

Variance reports

RE: I have run into issues when the ending balances of say Aug doesn't match the beginning balances in Sep when they should.

 

Again, the P&L doesn't have balances. There's no way to look at a P&L for Sept and see that it is somehow out of sync with Aug, because they're not connected at all.

 

If, however, you mean you're printing a P&L by month, say for the Quarter, and in Aug you presented a P&L for (let's say) July and Aug, and then in Sept you present a monthly P&L for three months, including July, Aug, & Sept, and on that report Aug is now different, then I see what you're faced with.

 

However, there is no handy report that can compare the old version of Aug with the new one to see if they're different. This is because a P&L is generated on the fly based on the current data. As a result, there's no "way back" machine to look at an old version of it.

 

If what you really need to know is whether or not the report is materially different, then comparing the gross profit and total expense subtotals might be sufficient. If they're the same, then probably the rest of the details are the same - or at least materially the same. If that's not enough, then the only way is probably to manually compare the numbers, one row at a time.

 

RE: So I want a report that shows the variances between those amounts and what we budgeted vrs what was collected with the YTD figures.

 

Sorry, I can't get my head around that. Again, not sure what you'd be comparing. There is a Budget v. Actual report in QB, but I don't think that's what you're asking for.

 

RE: Basically, when there's a discrepancy with amount collected, YTD totals, budget, etc, I can see how much that discrepancy is. 

 

Same. Don't know what you're describing. How do you have a "discrepancy with amount collected"?

MrsCrawdaddy
Level 1

Variance reports

We are an HOA and members pay monthly dues. What I will have to do is use the previous months P&L report and copy it to that month's report to excel and put a formula in to figure out the variances, that's what I've been doing. Just wanted to know if there was an easier way

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us