Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI need to produce a p&l that includes a month as well as ytd. The issue is that I need to go back to the month of October 2020. When I run the report it gives me only October in the ytd if I choose that month for the report. If I choose ytd it picks up any transactions that have been done since October in the ytd.
Can I get a budget vs actual for the month of October that gives me a yearly budget but does Not include transactions since October?
Let's customize your reports to get the data you need, jstahl.
There's a possibility that the First month of fiscal year is October in the Account and Settings. Hence, the report only displays October transactions. Here's how to review the company settings:
For your Profit and Loss report, we can change the Report period and displayed columns to display the data by month. Here's how:
Meanwhile, your Budget VS Actuals report will show the transactions if they are available within your register. Hence, we cannot exempt the October transactions while displaying the budget of the same month. Instead, we can export the report to Excel and customize it there. Here's how to do it:
You can use these links for reference when running and customizing reports in QuickBooks Online:
We'll be right here if you need additional assistance in getting your data through reports.
All the settings are correct. October is the first month of the fiscal year. The issue is when I go Back to run the October vs actual. When I include the total budget, the higher ups want actual budget just thru October (and as it stands it includes all entries including any made in November, December, etc.).
The first month of the fiscal year is October and all settings are correct. The issue is that they want me to go back and run October P&L and include budget vs actual. It includes all entries in QB since then (November, December) not just October. So I can either do a report with Just October and it gives me just that month's budget Or the fiscal year which includes all entries since then.
Trying to figure out how to give them the report they want.
Hello there, @jtsahl.
I understand that it would be easier to customize a report in QuickBooks Online t to show to them a specific account or customer format/layout. However, we cannot exempt the October transactions on a report while displaying the budget of the same month.
As a workaround, you can export the report to Excel and customize it there. To do that, you can follow the steps above.
I’ve added an article where you can get more information on customizing reports in QuickBooks: Customize Reports in QuickBooks Online.
Please let me know how it goes. You can also share your screenshot in this thread, and I'll get back to you as soon as possible. Thanks.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.