PERFORMANCE CANVAS

The Best Practice in Financial Control - EPM, CPM, Budgets, Reports, Plans, Dashboards, KPI Management, Scorecards & Consolidation

User Tools

Site Tools


pcfinancials:admin:balancesheet

Balance Sheet Rule Setup

This is a new feature in pcFinancials r1.2.

General

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.


Configuring the Balance Sheet Business Rule

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

1. BSRules - "Records" tab

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

2. BSRuleDetail - "Records" tab

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


When does the calculation occur?

This Business Rule is executed on demand from the menu.

  • Budget_TasksData ManagerRun Rules tab → CAPEX_BR_BS
  • Please configure ScenarioMbrs, TimeMbrs & EntityMbrs → OK


Examples

Calculating Accounts Receivable

  • 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:


Copying Current Year Net Income from Income Stmt to Balance Sheet

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

pcfinancials/admin/balancesheet.txt · Last modified: 2015/03/17 10:28 by pcevli