Spread income or cost over months

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'm looking at a way to allocate project revenue over multiple months. Lets say I have a project that starts on 6/25/17 and ends on 7/15/17 that brings a revenue of 10K. I need to split this revenue between June  and July based on the number of days the project spans over each month.

Anyone ideas?
Photo of @lin

@lin

  • 840 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Split it into days, and then summarize those days into the respective months.  (thats the short answer)

The long answer would take some time to describe, and might not meet all your needs.

Does that help point you in the right direction?  or Should we explore more?
Photo of @lin

@lin

  • 840 Points 500 badge 2x thumb
Yup it does.
Thanks Matt!