1. A method of using a formula to execute periodic transfers in a hierarchal accounting structure, the method comprising: receiving a transfer formula, comprising: a source account; a target account; an offset account; an account characteristic; and a formula for determining a first amount of the source account based on the account characteristic; accessing a multidimensional data cube, comprising: a hierarchal arrangement comprising the source account, and the target account; and aggregated balances for each level of the hierarchal arrangement; generating a transfer scenario by transferring the first amount to the aggregated balance for the target account according to the transfer formula; generating one or more accounting journal entries corresponding to the transfer 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 transfer scenario.