SmartFusion Modules > Accounting > Cost Allocations > Process > Print/Create Posting Entries - Variable Rate

Recent Changes:  
6.99 - Updated label for excluding pools to "Exclude pools where total to allocate is zero and hide zero amounts" and updated filter to look at Amount in order to review each record 
     - Fixed rounding error in calculations
6.79 - Redesigned process flow so that the calculation of units for pools with account matching would take unposted contributions from other pools into consideration  
6.73 - Updated calculation of Total Allocation from Other Cost Pools in order to handle more than 2 levels    
6.72 - Created Wiki page

Introduction

This menu option allows for the printing of reports and creating of journal entries for cost allocations.

Criteria

Select process - Print Only, Print & Create, Create Only
Enter JE posting date - enabled for the Create process
Enter posting reference - enabled for the Create process
Enter range to include

Pool number - enter the pool number range that must be considered for cost allocations (e.g. if a portion of Pool 1 is allocated to Pool 2 then both Pool 1 and Pool 2 must be included)
-- For this report, records are sorted by pool number (part of original design)

Date

Exclude pools where total to allocate is zero and hide zero amounts

Example for Pool #1 - Units NOT based on account match

Cost Allocations > Process > Enter/Edit Pools
Review the "Account matches for costs to be allocated" grid
Ex: ??-50-????-??-???? with "Units based on acct match" unchecked
Review the "Allocation to programs" tab > note the accounts and the units (which will have a value)
Fund Ledger > Reports > Budget Reports > select for the desired current period end date > select for the above account match > select for Revenues and Expenditures
Note the net amount and reverse the sign
Cost Allocations > Process > Print/Create Posting Entries (Variable) > select for Pool #1 > select for the same date range as the Budget Report > Print Preview
The top section will have the account match from the Budget Report as well as the amount
The bottom section will have all of the accounts from the "Allocation to programs" tab in Enter/Edit Pools as well as the units

Example for Pool #2 - Units based on account match

Cost Allocations > Process > Enter/Edit Pools
Review the "Account matches for costs to be allocated" grid
Ex: ??-50-????-??-???? with "Units based on acct match" checked
Review the "Allocation to programs" tab > note that for each account there is a second grid which has all of the accounts which will determine the units (the units themselves will be zero)
Fund Ledger > Reports > Budget Reports > select for the desired current period end date > select for Revenues and Expenditures
Select for the above account as before > note the net amount and reverse the sign
Select for each of the account matches that will determine the units for a given account
Total the net amount and reverse the sign
Cost Allocations > Process > Print/Create Posting Entries (Variable) > select for Pool #1 thru Pool #2 > select for the same date range as the Budget Report > Print Preview
The top section will have the "Pool Information" account match from the Budget Report as well as the amount
The bottom section will have all of the accounts from the "Allocation to programs" tab in Enter/Edit Pools as well as the units determined by the second grid
The units will be the total from the Budget Report plus any matching accounts from Pool #1 (which are unposted)