my organization needs me to pull every month a report that shows P/L YTD, budget and previous year comparison. I have been capable to put together this report only by exporting 2 reports into one file excel. I was wondering if there is a way to achieve this directly from a QB report.
I don't think there is a way to automatically get that in the format you are looking for. You can create the Profit & Loss Budget vs. Actual for a two year period, which puts all the data in one spreadsheet and would line up the rows. But the columns would be in date order, (not current year/month next to prior year month). You would still need to reorder the columns by cutting and pasting them, and then add a difference formula for the year over year data, but the formatting would already be there, simplifying the task.
That's a difficult answer, but if you open the report and enter dates 05/01/2018 to 04/30/2019, you will see what I mean.
If anyone else has the answer, I'm interested!
I appreciate you for posting here in the Community. I'm here to help share information about the reports available in QuickBooks Desktop.
Right now, the only way to come up with this report is by exporting them to Microsoft Excel and combining them manually from there. The custom reports available in QuickBooks are also for Summary, Transaction Detail, and Custom ODBC reports only.
I'm adding a screenshot for your visual reference:
For future reference about exporting reports, you can check the article I find helpful on this:
I'm personally taking of this request specific to building reports from the Profit and Loss and Budget. In the meantime, make sure to update QuickBooks into the latest release to ensure any new features or updates are available on your end.
In case you need the steps, here's how:
Feel free to reach out to me for any questions or concerns regarding the reports. The Community is always up to lend a hand.
Do you have any update on the creation of that report? I am trying to build it for my organization too... anybody with ideas about a simple way to do it?
hey, I need to create the same report... where you able to do it or did you find an easy way to do it?
Hi there, as542.
Welcome aboard to the Community. I'm here to provide some insights into the report you need in QuickBooks Desktop.
For now, you can only come up with this report by combining them manually through Excel. You can either create custom reports or choose what's available within the program, then proceed with the exporting process.
In case you need the step by step instructions, I'm also attaching the article I recommend:
Let me know if you have additional questions or concerns with the data you need. I'll be sure to lend a hand with the best of my ability.