Acute Data Systems

How to set up allocations in Sage 100 General Ledger

Description

To process your Allocation Entry, go to the Period End Menu and use Allocation Selection to select allocation entries for posting before completing period-end or year-end processing. After you select the allocations, you can then post them thru the Allocation Journal.

Resolution

  1. Open General Ledger, Main, Allocation Entry.
  2. Click the ‘Next Entry Number (#)’ button for the ‘Allocation No.’ field.
  3. To copy an existing allocation entry, and make any necessary modifications, click the ‘Copy’ button.
  4. Type the description of the allocation in the ‘Description’ field.
  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 allocation.
  7. If ‘Basis’ was selected as the ‘Allocation Method’, in the ‘Allocation Basis’ drop-down box, select the basis to use. If ‘Budget’ basis was selected, select the budget code for the basis.
  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.
  11. Note, if a manual amount that is greater than the balance of the source account is entered, it creates an over-allocation.
  12. Enter the ‘Journal Comment’ field, if necessary.
  13. Click the ‘Lines’ tab.
  14. 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.
  15. 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.
  16. Enter the ‘Comment’ field for the distribution, and enter other destination accounts as necessary.
  17. To view the information entered for accuracy, click the ‘Print’ button, and print the Allocation Listing.
  18. Click the ‘Accept’ button.
Sage 100
Request Support