Journal Allocation Tool

The Journal Allocation Tool allows you to run allocations on journal lines. You can allocate journal lines based on a G/L Account, Dimension combinations, split by percentages or using fixed amounts.

This can be useful for organizations where journal lines often need to be allocated to different departments, projects, or more generally, any combination of dimensions; and split by either specific amounts or a percentage of the original amount.

Multiple allocations can be setup ahead of time, each with a unique Allocation Code, so that the users will simply select the Allocation Code they want to use for their journal, and let the Journal Allocation Tool do the rest.

 

The first step is to define the allocations using the ‘Allocation Setup Worksheet’ page:

 

JATScreenshot2-orig

 

Allocation Code:

A unique code for each allocation. This allows you to setup different allocations ahead of time, then from the journal, simply select which allocation you want to use on the selected journal lines. In the example above, four different allocations have been defined.

 

Account Type / No., Bal. Account Type / No., Currency Code, Amount:

If these fields are populated on the Allocation Setup Worksheet, they will replace the corresponding fields on the new journal lines that will be created by the allocation. If the field is left blank in the Allocation Setup Worksheet, the Journal Allocation Tool will keep the value from the original journal line. In the case of the Amount field, leaving these all zero will allow you to use an Allocation % instead of a fixed Amount.

 

Allocation %:

If all the Amount fields for an allocation are zero, and Allocation % is non-zero, the Journal Allocation Tool will calculate that percentage of the Amount of the original journal line, and use the result as the Amount of the new journal line that will be created by the allocation. In this scenario, the Allocation % fields of the allocation must total 100%.

 

Copy Dims from Original Line:

If this field is set to Yes, the Journal Allocation Tool will copy the dimensions from the original journal line, to all new journal lines created by the allocation.

If this field is set to No, the Journal Allocation Tool will copy the dimensions from the Allocation Setup Worksheet line, if any have been defined.

 

In the example above:

 

  • The ‘EXPENSE-ALLOC’ allocation splits the journal line by G/L Accounts and a percentage of the original amount.

 

  • The ‘FA-ALLOC’ allocation splits the journal line into two Fixed Asset lines, with different dimensions (not shown), each new line getting 50% of the original amount.

 

  • The ‘PROJ-ALLOC’ allocation simply splits the original journal line into three lines with amounts of 60%, 25%, and 15% of the original amount. No other changes are made.

 

  • The ‘REC-PAYMENT’ allocation creates 2 payment lines: one to Vendor No. 10000 for USD 250, another to Vendor No. 20000 for USD 500. Both payments will be from Bank Account ‘CHECKING’.

 

To define the dimensions on the allocated line, select the line, then press the Dimensions button in the Navigate tab on the Allocation Setup Worksheet:

 

JATScreenshot3-orig

 

Enter the dimension values:

 

JATScreenshot4-orig

 

When the Journal Allocation Tool is installed, a new ‘Allocate’ button will be available in the following journals:

  • General Journal
  • Sales Journal
  • Purchase Journal
  • Cash Receipt Journal
  • Payment Journal
  • IC General Journal
  • Job G/L Journal
  • Fixed Asset G/L Journal

 

To perform allocations, simply select the lines to be allocated, then press the Allocate button in the Line tab:

 

JATScreenshot5-orig

 

The Journal Allocation Tool will run and an Options page will be presented:

 

JATScreenshot6-orig

 

Allocation Code:

Enter or select the Allocation Code to be used. A lookup to the Allocation Setup Worksheet allows you to quickly view the setup and select the appropriate Allocation Code for this allocation.

 

Keep Original Lines:

After the allocation has been performed, keep or delete the original line(s) that were originally selected in the journal.

 

Flip Sign:

After the allocation has been performed, flip the sign (ie. multiply by -1) of the Amount on the new journal lines that were created by the allocation.

 

When you press OK, the new journal lines will be created along with any dimensions that were defined on the Allocation Setup Worksheet lines.

 

JATScreenshot7-orig

 

JATScreenshot8-orig