allocating percentages to multiple accounts

SOLVED

another question on this non profit client.    I have set up 5 different departments to represent the different revenue and expense type.  Within each department are several accounts.   It's the exact same set of accounts under each department (eg. I've number department 1 from 4100 - 4199, dept 2 from 4200 to 4299 etc).  Same for expenses but using 5000 accounts.    This is a non profit company that gets gaming funds from the government and when I process those grants and all the expenses I have to allocate as a percentage across the different department accounts.  So if I have a hydro bill, I need to allocate 20% to 1 account, 25% to another, 10% to another, 15% to another and the final 30% to the last account.   Is there a way to do this via the payments module?  

  • +1
    verified answer

    swissmrs59 said:
    Is there a way to do this via the payments module?

    You could use a Recurring Transaction in the Purchase Invoice screen, use a line for each account with the quantity field as the percentage, and punch in the total as the price.  As long as the percentages add to 100, (except for rounding) the total will match the price.  

    i.e.:

    Qty         Price     Amount                Account    

    0.20   x    1000    $200.00   Account 5101

    0.25   x    1000    $250.00   Account 5102

    Then next month update all the prices with the amount of that month's utility bill, etc.

    Unlike Departments, Projects can be configured to work off percentages, so you could enter one amount on one line each month, and have the project percentage divide it up.   But you would still have to set up each monthly bill in a recurring transaction with a Project breakdown for each line.