You can use this routine for apportioning fixed or variable overheads on your monthly or annual accounts. It can also be used for fixed and dynamic calculations.
For calculation and redistribution transactions you determine your own rules based on fixed percentages or on a dynamic base which is constantly changing, i.e., either amounts, quantities, statistical values or budgets. These types of transactions are ideal for operations that require Activity Based Costing.
The system creates the posting automatically based on the rules you set up in the calculation and redistribution files for the account combination and voucher type on which you make the original entries. You can define two different kinds of calculation and redistribution:
- Fixed calculation and redistribution, which creates postings based on a fixed percentage of the original entry.
- Dynamic calculation and redistribution, which creates postings based on a fixed percentage of the original entry, but apportioned according to budget or actual amount.
You can decide between two alternatives when you want the automatic postings to be created and posted. These are:
- When you update the base transactions and transfer them to the General Ledger.
- Delayed, when you run the batch program for calculation and redistribution update, e.g. at the end of each period.
Enquiries and printouts
- G/L transaction enquiry – displays all the updated postings in the General Ledger.
- G/L transaction details enquiry – displays detailed postings from G/L transaction log file.
- Fixed calc/red list – displays the fixed calculation and redistribution rules that exists in the system. Select the Print calculation/redistribution file (fixed) menu item to print the list.
- Dynamic calc/red list – displays the dynamic calculation and redistribution rules that exists in the system. Select the Print calculation/redistribution file (dynamic) menu item to print the list.
- A work list, that displays all postings that will be created according to your rules and selection. You print this when you do the simulation, see Create delayed calculation or redistribution transactions for more details.
- G/L transaction detail journal – displays each individual transaction before summation.
Code Description Base The original transaction and the contra account CAF Calculated with fixed percentage REF Redistributed with fixed percentage CAB Calculated on a base balance (dynamic) RED Redistributed on a base balance (dynamic)
You receive this list when you update the transactions. See About starting/closing manual transaction entry for more information of all lists you receive when you update.