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"?
