1 / 53

IFM APPORTIONMENTS

IFM APPORTIONMENTS. Elisa Vick elisa.vick@cistech.net 678.613.4898. Introduction. Apportionments are used to spread a source value or values across multiple cost centers or accounts within your general ledger. Apportionments are made up of the following:

psellers
Download Presentation

IFM APPORTIONMENTS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IFM APPORTIONMENTS Elisa Vick elisa.vick@cistech.net 678.613.4898

  2. Introduction • Apportionments are used to spread a source value or values across multiple cost centers or accounts within your general ledger. • Apportionments are made up of the following: • An apportionment definition which includes an ID and a criteria (optional). • Apportionment source lines which define the general ledger account values that you are apportioning from (optional). • Apportionment target lines which define the general ledger accounts that you are apportioning the source values to. If a criteria is not specified on the definition, then the criteria for each target is specified directly on the target.

  3. Introduction – Apportionment uses • Apportionments can be used within an AP transaction i.e. to take a Rent billing and spread the total value across multiple cost centers which occupy the rented space. • An apportionment can also be used to spread value within a general ledger account (such as utilities) across multiple cost centers at the end of a period rather than using the apportionment on each individual transaction. • Benefits • Apportionments save time. You don’t have to enter multiple G/L lines and remember which cost centers to allocate values to.

  4. Introduction • Benefits (cont.) • Criteria can be used in multiple apportionments. If multiple expenses are apportioned to the same cost centers based on the same criteria (such as Square feet or Head count), you only have to set up the criteria once and that criteria can be specified on multiple apportionments. • You can create multi-tiered apportionments. You may have a target that receives value from a source and that target can become a source for another apportionment within an apportionment list. This method may be used across companies to spread costs first to a generic cost center and then, once the cost is within the appropriate company, spread it to the appropriate cost centers.

  5. Apportionments – Executed over account balances Target Account 1 Target Account 2 Apportionment Source Target Account 3 Based On: 1. Apportionment Criteria 2. Manual Apportionment Data

  6. Apportionments - Executed at time of transaction entry Target Account 1 Target Account 2 Specified Apportionment Transaction Target Account 3 Based On: 1. Apportionment Criteria 2. Manual Apportionment Data

  7. Apportionment Criteria

  8. Apportionment Criteria

  9. Apportionment Criteria Criteria used to divide a value among several units. Enter ID & description. Select F15 to add Criterion values. Press to Accept

  10. Apportionment Criteria Values

  11. Apportionment Value • Unit: Identifier/Name • ID and Name of the unit to which the apportionment value relates. • Criterion value • Value entered is used to derive the proportion that is assigned to the unit. • Proportion is given by the criterion value for the unit divided by the total of criterion values for all apportionment values belonging to the apportionment criteria. • Up to 13 digit numeric field with 2 decimal positions.

  12. Apportionment Criteria Values Select F6=Create to continue entering Apportionment Criteria or F12=Cancel to return to the Apportionment Menu. Press enter to accept.

  13. Apportionment Criteria Values When complete, you will have a listing of all of the units included as criteria with their respective values. You don’t need to include all units In your apportionment. The system Will automatically calc. the % based On units used in the targets.

  14. Work With Appportionments

  15. Apportionment Setup

  16. Apportionment • Identifier • ID of an apportionment (used to spread a source value across a set of general ledger target accounts). • 10 characters. • Name • Name describing the apportionment. • Up to 26 characters.

  17. Apportionment • Criteria • ID of an apportionment criteria to use when assigning the proportion of value to each of the target accounts. • Leave blank to specify the criterion value to each target unit individually.

  18. Apportionment Setup Press enter to accept.

  19. Apportionment Sources

  20. Apportionment Source • Unit Identifier/Name • ID and name of the unit component of the unit/nature combination that is the source for the apportionment. • Nature Identifier/Name • ID and name of the nature component of the unit/nature combination that is the source for the apportionment.

  21. Apportionment Source • Offset nature Identifier/Name • Nature to which the reciprocal posting is made following an apportionment. • Usually the same but may be different from the apportionment source nature. • Balance to apportion • Valid options: • Period - Balance to be apportioned is the balance at the end of the most recent complete period. • Year to date - Balance to be apportioned is the overall balance for the year to date.

  22. Apportionment Sources Select F12=Cancel to return to the Apportionment panel Press enter to accept.

  23. Apportionment Targets

  24. Apportionment Targets

  25. Apportionment Target • Unit Identifier • ID of the unit for this apportionment target. • A unit can only appear once per apportionment. • Nature Identifier • ID of the nature serving as the apportionment target nature.

  26. Target – With Apportionment Criteria Specified Select F12=Cancel or F3=Exit to return to the Main Menu Continue to add targets Using F6 until complete. Press enter to accept.

  27. Target - Without Apportionment Criteria Specified If no apportionment criteria is specified then you must specify either a Criteria nature or Target criteria value. Press enter to accept.

  28. Apportionment Lists Once all targets are added go to option 3 to work with apportionment lists.

  29. Apportionment Lists Use F6 to create a new list

  30. Apportionment Lists Enter an ID and a name and press enter to add the record then F15 to add the apportionments.

  31. Apportionment Lists Use F6 to add an apport.

  32. Apportionment Lists Enter an apport. ID and press enter. Continue to use F6 to add additional apport. to the list.

  33. Apportionment Request Notice the balance in the source account to be allocated. We will run the apport. request to apportion this amount to our targets.

  34. Apportionment Request

  35. Apportionment Request Use F6 to add a new request.

  36. Apportionment Request • Identifier • Automatically defaults to ‘New’. • Apportionment List • Enter the ID for the list you wish to run. • Latest period • Period for which you want to run the apportionment. • Type • Leave at default of 1 to apportion actual amounts vs. budget amounts. • Financial division • Company for which you are running the apportionment request.

  37. Apportionment Request • Transaction type • Used to create the transaction type for the transaction generated from the apportionment. • Date of transaction • Determines the effective date of the transaction. • Request status / Record status • Leave at default.

  38. Apportionment Request Press enter twice And F12 to return to apportionment request menu.

  39. Apportionment Request

  40. Apportionment Request

  41. Transaction Created from Apportionment (10,000/18000)*100= 55.56 AND (8,000/18,000)*100= 44.44

  42. Posting Apportionment Request Transaction

  43. Apportionment within Transaction • Following is an example of creating a transaction which uses an apportionment to spread one value across multiple units/natures. • The apportionment only specifies Targets and instead of using an apportionment criteria, Criteria target values are specified on each target unit/nature.

  44. -Unit 100810 has a criteria target value of 33 -Unit 100820 has a criteria target value of 27 -Unit 100830 has a criteria target value of 40

  45. Creating the transaction You must use the long transaction entry method if you will be specifying an apportionment on a transaction.

  46. Creating the transaction Enter the total value you wish to apportion. Enter the apport. ID Which specifies the Appropriate allocations. Note-You do Not have to Enter a unit/ Nature.

  47. Creating the transaction If using the apportionment in a Journal Entry type of transaction, be sure to enter the offset side of the transaction.

  48. Creating the transaction Process the transaction As you normal.

  49. Creating the transaction The apportionment correctly allocated the $1,000 across specified units/natures.

More Related