The Balance Sheet business rule will automate certain aspects of balance sheet budgeting by applying calculation rules based on CAPEX, Income Statement and Statistical Accounts.

• To create automated Cash Flow calculations based on Income Statement and Balance Sheet please refer to Cash Flow rule setup.
• An overview of Automation and Business Rule options can be found in Business Rule Automation Overview.
• This Business rule can utilize Statistical Accounts (which may only exist in this system) and where data is entered through Microsoft Excel, pcMobile or systems integration. This which gives unprecedented flexibility to configure and automate business processes.

You need to configure this Business Rule by modifying two lists in the Modeler:

1. Login your modeler
2. Click on “Lists”
3. BSRules & BSRuleDetail
   

Please “CheckOut” to edit, “Save” & “CheckIn” after it's done.

• Label - business rule name
• Description - business rule description
• Entity - blank means all entities; otherwise select one entity
• BusinessProcess_Destination - see the exam from the above picture
• SystemDefined - not editable later if ticked

Please “CheckOut” to edit, “Save” & “CheckIn” after it's done.

• Label - an unique business rule code
• BaseAmtAcct - the source account
• BaseAmtTimeOffset - TimOffSet for the source account
• BasePctAcct - base percentage of the source account
• BasePctTimeoffset - TimeOffSet for the source account percentage
• OnlyClosing - if it's ticked, the detail is available on the last period of the year
• Acct - destination account
• Sign - exam: the value of the account is 500. If it's 1, then it shows 500; if it's -1, then it shows -500
• BSRuleMethod - FixedPct / BasePct / (1-BasePct)
• FixedPct - exam: 0.4
• SystemDefined - not editable later if ticked

Example for BSRuleMethod & FixedPct

1. BaseAmtAccount 5023 = 1000
2. BasepctAccount 6114 = 0.2
3. FixedPct = 0.4

• BSRuleMethod BasePct : Acct 1010 = 1000 x 0.2 = 200
• BSRuleMethod (1-BasePct) : Acct 1010 = 1000 x (1-0.2) = 800
• BSRuleMethod FixedPct : Acct 1010 = 1000 x 0.4 = 400

This Business Rule is executed on demand from the menu.

• Budget_Tasks → Data Manager → Run Rules tab → CAPEX_BR_BS
• Please configure ScenarioMbrs, TimeMbrs & EntityMbrs → OK
  

• Assuming that
  • 60% of all customers pay their debt the month after invoicing.
  • 40% pay their debt two months after invoicing.
• This means that in a certain month the Balance Sheet AR account is calculated as the sum of
  • 100% of what was invoiced last month
  • 40% of what was invoiced 2 periods ago

This is coded into the system as follows, the 1st & 2nd rows:

This is coded into the system as follows, the 3rd row: