I'm here to help you create a budget report that shows the current month, current YTD, prior month and prior YTD amounts.
While there isn't a report that can show all those details, you have the option to run and customize the Profit and Loss Budget Performance report. Since this only shows one date range at a time, try customizing it and set the date range to This Month, Last Month and Last Fiscal Year-to-date.
Once done, you can export the report to Excel. From there, you can merge them and make the necessary changes.
Click Reports at the top.
Under Budget & Forecasts drop-down, select Profit and Loss Budget Performance.
Click Next twice, then Finish.
By default, the date range of this report is set to This Month. You can manually change it to Last Month and Last Fiscal Year-to-date. Then, export it to Excel after this change.
Click the drop-down arrow beside Excel.
Select Create New Worksheet or Update Existing Worksheet.
Update if needed.
Your suggestions and ideas are important to us. While we're unable to get a single report that shows all the details you need, you can submit feedback so we can add this report. Just click the Help menu at the top, then choose Send Feedback Online.
That's it. Please feel free to ping me in the comments below if you need anything else. Have a lovely day.