Discussions

Expand all | Collapse all

Spread income or cost over months

  • 1.  Spread income or cost over months

    Posted 06-06-2017 17:30
    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?


  • 2.  RE: Spread income or cost over months

    Posted 06-07-2017 05:20
    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?


  • 3.  RE: Spread income or cost over months

    Posted 06-07-2017 12:30
    Yup it does.
    Thanks Matt!