Any new ways to deal with costs and revenue tables?

MikeTamoush
Qrew Commander
3 years ago
Projects. I can relate them all to a project summary table and pull costs and revenue per project there. I thought about using that table, but what I can't figure out is - I will have multiple dates. The date the revenue is recorded and the date the cost is recorded. This may be in different months. So if I use the project summary table, I don't think I can look at Gross margin per month?

It feels to me like I will still need to utilize a monthly summary table to look at costs/revenue per month, and a project summary table to view per project.

In the same way, I feel like I would also need a yearly summary table to view per year.

But I also keep thinking that all these new tools were supposed to help me avoid these summary tables...

------------------------------
Mike Tamoush
------------------------------
- MarkShnier__You
  Qrew Legend
  3 years ago
  But the fundamental problem is that if you have a mismatch on timing between revenue and cost recognition then you can't really know what the margin is in a particular month because for example a month maybe all cost and no revenue. And opposite for the next month. So really arguably the margin really only makes sense on a project to date basis. Even if you go annually then you can still have the problem that there is a stub of a cost or a revenue recognition mismatch during that. Of course the same problem can happen even on a project today basis if you have not got around to billing Revenue yet.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - MikeTamoush
    Qrew Commander
    3 years ago
    Try telling that to my mgmt! :) LOL
    
    I don't disagree, but alas I have been tasked with looking at costs and revenue per month, even though as you said, if a project costs hit one month and the revenue the next, its a bit non nonsensical. But if we have 30 projects in a month they can at least see how the costs and revenue are hitting as a total for all projects.
    
    Do you see any other way besides the monthly summary table? I think I still need it, but at least the new dashboards have global filters so I can avoid the user focus trick for that.
    
    Let me know if you think of a new trick with summary formulas or something sneaky!
    
    ------------------------------
    Mike Tamoush
    ------------------------------

Forum Discussion

Any new ways to deal with costs and revenue tables?