CAPEX Rule Setup
This is a new feature in pcFinancials r1.2.
General
The CAPEX business rule will assist in automating budgeting of Capital Expenditures by automatically calculating and updating Income Statement and Balance Sheet based on the rule setup.
- This can in the next step be used 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.
1. Configure CAPEX Business Rule in Modeler
Configure Capex BusinessRule by modifying Depreciation list in the Modeler:
- Login Modeler
- Go to Lists → Depreciation → Records tab
- Save → CheckIn → Deploy
- Selling / COGS / Admin - choose specific account
- Copy - not used yet
- SystemDefined - not editable later if ticked
1.1 Examples with two asset classes
2. Run CAPEX Rule in Excel
CAPEX BusinessRule is executed on demand from the menu in excel, when you send data inside InputCAPEX.
- Budget_Tasks → Data Manager → Run Rules tab → capex_Calculation
- Click on Check Status.
When it shows : No submissions pending. All submissions have been processed.
It means Capex calculation is finished.
3. Create CAPEX InputSheet in Excel
- Login excel & your application
- Go to Admin_Tasks → Update Workflow Schedules → New Schedule from Template
- Select InputCAPEX.xlsm → Open
- Save it to WorkFlow folder → Close InputCAPEX
- Go to Admin_Tasks again → Generate Workflow → Run
- Go to Budget_Items → Enter_Budget
4. How to use InputCAPEX InputSheets
- Budget_Items → Enter_Budget → select the InputCAPEX template → Open