Is there a way to memorize multiple project allocations to one vendor?

I have 7 projects that encompass the entire revenue and expenses of the company. When I allocate, for example, electricity costs, I need to allocate to 7 projects, in unequal amounts, but the same unequal amounts each bill. Currently, I'm manually allocating to each project. Is there a way to "memorize" a multiple allocation by vendor?

Parents
  • 0

    Have you tried setting up a recurring transaction after making the allocation?  

    You could use one for each vendor / monthly occurrence, or use one recurring transaction and change the payee before posting.

  • 0 in reply to RandyW

    Yes I've done that although it still takes time to go through my very long list. Less time of course than the alternative. My bigger issue right now is that I'm halfway through the fiscal year and I am adding projects retroactively to bills already posted. I've already accomplished this task for sales but in that case we use item numbers that align with both our revenue accounts and project accountsGrin. And 90% of the time a sales invoice has one line which means one project allocation. Not so for about 75 of vendor bills which I'm allocating. Just hoped there was a magic copy and paste feature lurking in the accumulated experiences of this group. 

  • 0 in reply to SandraB7691

    SandraB7691: I have been looking for a similar project allocation method that is consistent. Using RandyW's idea of recurring entries is helpful but as soon as the dollar value changes all allocations change. If the allocation is specific for the vendor you could allocate by percentage and the recurring entry will work each time. If the allocation is inconsistent or by dollar value the recurring entry saves some keystrokes but still has to be thoroughly checked for completeness. I have one client with many companies and each company could have between 90 and 150 active projects at any one time. I sure wish there was an easier way!

  • 0 in reply to Alwyn

    I'm going strictly on %ages.  So that does make it easier. I work for a private clinic that has 7 treatment areas and we are tracking them as projects so all revenue and expenses are being allocated. There are some expenses that are 100% to a treatment area, but overhead is allocated among the treatment areas, it's just that some are different. One treatment area uses a huge piece of medical equipment and it takes about 85% of the hydro...but then the heat (gas) is spread out among them. Internet, paper, etc. spread out equally (I'm not getting fussy about saying that one treatment area generates more reports and therefore uses more paper, etc). It sounds like my situation is more straightforward than yours. We might have up to 15 projects as the clinic is adding other treatment services but it will never be 90. My other issue (as an aside) is that by using %ages, I am sometimes left with pennies unallocated, which is negligible on the project income statement, but drives me NUTS as I like to do my check of unallocated amounts for QC.  (Other staff enter sales and must allocate at that point and they sometimes do it incorrectly). Do you know of a way to allocate the pennies to "deal with them"??

Reply
  • 0 in reply to Alwyn

    I'm going strictly on %ages.  So that does make it easier. I work for a private clinic that has 7 treatment areas and we are tracking them as projects so all revenue and expenses are being allocated. There are some expenses that are 100% to a treatment area, but overhead is allocated among the treatment areas, it's just that some are different. One treatment area uses a huge piece of medical equipment and it takes about 85% of the hydro...but then the heat (gas) is spread out among them. Internet, paper, etc. spread out equally (I'm not getting fussy about saying that one treatment area generates more reports and therefore uses more paper, etc). It sounds like my situation is more straightforward than yours. We might have up to 15 projects as the clinic is adding other treatment services but it will never be 90. My other issue (as an aside) is that by using %ages, I am sometimes left with pennies unallocated, which is negligible on the project income statement, but drives me NUTS as I like to do my check of unallocated amounts for QC.  (Other staff enter sales and must allocate at that point and they sometimes do it incorrectly). Do you know of a way to allocate the pennies to "deal with them"??

Children
No Data