Forum Discussion

MikeTamoush's avatar
MikeTamoush
Qrew Elite
4 years ago

Any new ways to deal with costs and revenue tables?

I have a table of costs, and a table of revenue. At this point I have a summary table of months, with a 'key' in both revenue and costs tables, to look at everything on a monthly basis. With the i...
Relationships
reports and charts
MikeTamoush's avatar
MikeTamoush
Qrew Elite
4 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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 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
------------------------------