Digits Reports Builder: Report showing YTD split by months

Related products: Digits Reports Builder (Labs)

FEATURE REQUEST!!! In addition to the profit & loss for the last month, many of my clients like to see a report showing the year-to-date split by months. See below. This feature (and cash basis reporting) would definitely make me a dedicated Digits user.

 

Hey @shannonp,

Sorry for the delay here! We’ve been digging into this request on our end, and although YTD reporting is on our roadmap, your idea spurred some questions on how you would want this too appear in Digits Reports:

  1. Digits Reports generates comparisons from previous months, quarters, or years depending on the report type. For example, in a monthly report, we automatically calculate variances from the previous month to the current month (example below).
    In a YTD report, would you want those same comparisons to calculate based on the previous YTD interval? For example, if you were to generate a YTD report today (1/1/22 - 5/17/22), we’d compare the numbers from the previous year’s YTD interval (1/1/21 - 5/17/21). 

     

  2. In Digits Reports, when you hover over a line item, our Hover to Discover feature displays a bar chart that goes back in time (example below). Per your request, it sounds like you would want the bar charts to represent months. If you generated a YTD report today, would you expect to see months only for this year (January through May)? or would it be valuable to display bars that go even further back?

Thank you in advance for your insights, and I’m happy to hop on a call anytime to discuss these details if that is easier!

Andrew


Updated idea statusNewDiscussion ongoing

@Andrew

1.  Yes, that would be a great feature!
2.  I would say only the months of the current year since that’s the extent of the report I’m looking to run.


@Andrew - Agreed that this report is probably more useful for our 1,000 nonprofit clients.  Funding is so variable that they rarely look at monthly variances, and are more concerned with YTD variances.


@shannonp @don.needs Fantastic insights - Thank you both! 

We also hear that the monthly columns are valuable when you print reports, since the Hover to Discover feature in Digits, which could act in lieu of columns, wouldn’t show up if you print. 

I have a follow up question for later in the year when many months have passed (e.g. October, November): If possible, would you expect us to squeeze all of the month columns on the printed report even if it negatively affects the presentation? or would you prefer we fit the max amount of month columns so that the report presentation is clear, knowing that earlier months (e.g. January, February) would be cutoff?


@Andrew  Yes, printing with all months shown is beneficial. It’s usually ok when you print it landscape.


FEATURE REQUEST!!! In addition to the profit & loss for the last month, many of my clients like to see a report showing the year-to-date split by months. See below. This feature (and cash basis reporting) would definitely make me a dedicated Digits user.

 

Yes, I second this! My clients are also asking for this and I think it would be a great addition to the report.


This feature would be wonderful. QBO’s Simple Start does not let you compare previous month’s so I have to create and update a spreadsheet.