A method of using rules to execute periodic allocations of funds in a hierarchal accounting structure may include receiving an allocation rule, comprising a source account, a rule for determining a first amount, a parent account, and an allocation basis; accessing a multidimensional data cube comprising a hierarchal arrangement and aggregated balances for each level of the hierarchal arrangement; generating an allocation scenario by allocating the first amount to the aggregated balances for the one or more child accounts according to the allocation rule; generating one or more accounting journal entries corresponding to the allocation scenario; posting the one or more accounting journal entries to a general ledger associated with a relational database; and updating, using the relational database, the multidimensional data cube to reflect the allocation scenario.