The problem faced here is that the percentage allocations are representations not actualities. EG: a sales invoice is issued for 1000 and subsequently the 1000 is received into the active bank account and then needs to be re-distributed based on the percentage formula without any actual funds leaving the bank account, in addition, any expenditure needs to be “spent” from its allocation which is still part of the main bank account - all to messy & clumsy.
Therefore, based on the statement “Every 1 $ of Sales”, the focus (the process) should be based on SALES and not money, which will still achieve the same allocation representations without any piggy bank complications. So to do this simply, we just need to design an appropriate section in the P&L Chart of Accounts, create the Special Accounts and the real big plus - that the bank account can be left alone as it will require no fancy footwork of any fashion.
1 - The chart of accounts would look like this:
At the end of the first month you would create a Distribution Journal Entry based on the 1000 Sales:
At the end of each subsequent month you would edit the Journal, change the date and the distribution values.
At the commencement of a new financial year you would start a new Journal Entry.
3 - The Balance Sheet & Profit & Loss would look like this:
Note how the Operating Expenses allocation of 55% is represented by the sub-total
4 - The BS account Distribution Provisions has the individual balances via the Special Accounts:
5 - If a Saving Account is opened then its just a matter of transferring funds to match the provisions:
6 - Lastly, if any allocation does have funds spent then it just a Spend Money against the provision