cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
CCS Finance
Level 1

P&L as of specific date compared to total annual budget

I am using QB Online. I want to create a report showing P&L amounts as of a specific date with a comparison to the total annual budget amount for each account and a % of budget column. Is that possible?

2 Comments 2
Bryan_M
QuickBooks Team

P&L as of specific date compared to total annual budget

I'm glad that you post here in the Community, @CCS Finance.

Currently, there isn't an integrated way to pull up a Budget vs Actual and Profit & Loss report with a ready annual budget amount for each account.

With this, let's consider pulling up both of your Budget vs Actual and Profit & Loss reports. From here, customize them with the specific dates you want and export them as a new excel file then you can now compare the list of amounts as of specific dates and the total annual budget amount budget for each account.

The following articles below will help you perform the outlined steps that were mentioned:
 

Moreover, here are the lists of articles you can view to check the stability of financial standing of your organization: Create and manage reports.

 

For additional assistance with reports, don't hesitate to reply to this post. Have a great day!

CCS Finance
Level 1

P&L as of specific date compared to total annual budget

Thank you, Bryan. I figured I could create what I want by exporting multiple reports to Excel and making adjustments there. I was hoping there was a more direct way to create the report I'm looking for. Please consider creating that possibility in QBO.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us