GL Allocation Templates are custom-made Journal Entry templates that allow one Source GL Account to have its account balance allocated to one or more Destination Accounts. This distribution is defined by the percentage entered for each account in the template form. As needed, the template can be put in use and will auto-fill with the correct amounts distributed to each Destination Account without the need to update any entries.
While these do not necessarily serve as memorized Journal Entries, GL Allocation Templates were built for amounts that need to be spread to other accounts, such as an equity distribution. Build any number of GL Allocation Templates that are needed for your Organization from the GL Allocation Templates page!
- Note: As of now, this feature does not support intercompany transactions.
Users with the following Primary Security Roles can view, create, edit, use, and delete GL Allocation Templates:
- Full Access
- Accounting Manager
- Accounting Clerk
GL Allocation Templates can be created and are housed on the GL Allocation Templates page, which can be opened by clicking 'Allocation Templates' under 'Administration' in the left navigation pane of the Accounting module.
GL Allocation Templates Page
Users can view and edit all existing Templates as well as create new Templates from the GL Allocation Templates page. Each column listed on this page can be sorted by clicking the arrow iconnext to the column title.
1) Search Bar - This will filter the listing for the values entered
2) Template ID - The auto-generated ID of the Template
3) Template Name - The name of the Template
4) Status - The status of the Template. Options include:
5) Location - The Location assigned to the Template, which will be listed in the header of the created Journal Entry
6) Source Account - The Source Account listed for the Template, which is the GL Account that provides the amount to be transferred in the 'Details' grid of the created Journal Entry. This account will be debited if it has a credit balance and credited if it has a debit balance
7) Last Modified By - The last User who edited the Template
8) Last Modified On - The date that the last User edited the Template
9) + New Template Button - This will create a new GL Allocation Template
From the grid, templates can be selected and then either marked as 'Active'/'Inactive' or deleted as needed. Click here to learn more about marking a template as 'Active'/'Inactive'.
GL Allocation Templates: Create and Edit a Template
Build out GL Allocation Templates for Journal Entries that spread an expense from one account to another. Click here to learn more about creating and editing a template.
GL Allocation Templates: Use a Template
Learn how to put a GL Allocation Template in use from within a new Journal Entry and from the template form. Click here to learn more about putting a template in use.
GL Allocation Templates: Allocation Calculator
The Allocation Calculator previews the 'Details' grid of the created Journal Entry based on the information entered in its template. Click here to learn more about the Allocation Calculator.
GL Allocation Templates: Mark as '(In)Active'
GL Allocation Templates have one of two statuses: 'Active' or 'Inactive'. Click here to learn more about updating template statuses.