I 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:
Click the Gear icon in the upper-right corner and select Account and Settings.
Select the Advanced tab and go to the Accounting section.
From there, you'll see the First month of fiscal year.
Click Done if there are no changes.
For your Profit and Loss report, we can change the Reportperiod and displayed columns to display the data by month. Here's how:
Click Reports on the left menu and pull up the Profit and Loss.
Change the Report period to Custom and enter the date range.
In the Displaycolumns by field, select Months.
Click Run report.
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:
Open your Budget VS Actuals report.
Click the Export option (paper icon) and select Export to Excel.
Save the file and open it through Excel.
Customize the data.
You can use these links for reference when running and customizing reports in QuickBooks Online:
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.
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.