Use Allocations to automatically distribute overhead such as rent and electricity to your various departments.

Setup:

  1. Open GL/Main/Allocation Entry
  2. Click the Next Entry Number (#) button for the Allocation No. field
  3. To copy an existing allocation entry, click the Copy button, then make any necessary modifications
  4.  Type the description of the allocation
  5. Click the Lookup button for the Source Account field and select the general ledger account number
  6. In the Allocation Method drop-down box, select the calculation method to use for the allocationgl allocations 1
  7. If Basis was selected as the allocation method, in the Allocation Basis drop- down box, select the basis to use. If Budget method was selected, select the budget code. gl allocations 2
  8. In the Allocation Cycle drop-down box, select whether the allocation cycle is to be automatically selected for posting at the end of each period, quarter, or fiscal year, or manually posted
  9. In the Amount to Allocate drop-down box, select the type of amount to allocate
  10. If Manual is selected, enter the amount of the manual allocation in the Manual Amount field. Note: if a manual amount that is greater than the balance of the source account is entered, it creates an over-allocation.
  11. Enter the Journal Comment field – optional
  12. Click the Lines tab
  13. Click the Lookup button for the Account No. field and enter a destination account number for the distribution. Asterisks (*) and at signs (@) can be used to create account masks.
  14. If Quantity was selected as the allocation method, enter the quantity to be distributed to this account. If Percent was selected as the allocation method, enter the percentage to be distributed to this account. If Basis was selected as the allocation method and you want to link the basis amount to another account, select the Link check box, and enter an account number to use for the basis calculation. To create account masks use @ signs.
  15. Enter the Comment field for the distribution and enter other destination accounts as necessary gl allocations 3
  16. To view the information entered for accuracy, click the Print button and print the Allocation Listing.
  17. Click the Accept button

There are more detailed examples in the Help screens under “Create and Maintain Allocations”

For Monthly Use:

You can generate allocations manually using General Journal Entry, or automatically during period-end processing using Allocation Selection in the Period End menu.

A. General Journal Entry-Manual Allocations

  1. Open GL/Main/General Journal Entry
  2. Enter the Source Journal or choose from the lookup
  3. Click the Next Entry Number (#) button for the Allocation No. field
  4. Enter the Posting Date
  5. Click the Copy From button in the top right corner
  6. Click the Allocation option and then click OK
  7. Click the Lookup button at the Allocation Number field and select the Allocation Entry gl allocations 4
  8. Either enter the Source Amount or click the Current Activity or Current Balance button to have the amount automatically filled in
  9.  Based on the Allocation Entry the journal entry distribution will automatically calculate
  10. Print the Journal and Update it

B. Period End Processing

  1. Open GL/Main/Period End
  2. Choose Allocation Selection gl allocations 5
  3. Set the appropriate dates
  4. Select the Source Journal and the next Journal Number will automatically set
  5. Click the Proceed button gl allocations 6
  6. The Allocation Selection screen will display all allocations that will be generated, based on the initial entry of the allocations  a. To see the details of a particular allocation click the Zoom icon to the right gl allocations 7b. To change the Source Amounts to the Current Balance click the black gear icon c. To change the Source Amounts to the Current Activity click the blue gear icon
  7. Click the printer icon to print the Allocation Journal and update it

Post to Twitter Tweet This Post

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!