Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
CCS Finance
November 14, 2022
Question

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 replies

Bryan_M
Bryan_MQuickBooks Team
QuickBooks Team
November 14, 2022

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 FinanceAuthor
November 15, 2022

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement