Journal Entry Setup by AAI Table

For journal entries to be calculated correctly, you must set up the correct journal types in each Automatic Accounting Instruction (AAI) table. These tables list all of the journal types that you must set up to process time and labor journal entries completely.

This table lists all of the AAI tables, and their corresponding numbers. For example, the Debit-Labor/Billing/Equipment table is table 1. These numbers are used in the subsequent tables to specify the AAI table in which you must set up each journal type.

AAI table numbers are:

AAI Application Name

Application Number

Debit-Labor/Billing/Equipment

Table 1

Debit-Burden/Premium - Labor Dist

Table 2

Credit-Cash Bank Account

Table 3

Credit-Liabilities

Table 4

Credit-Labor Billings

Table 5

Dr/Cr - Accruals/Clearing

Table 6

These tables list the journal types that must be set up for each type of payroll journal entry. The tables are organized by journal entry document type (T1 though T7), and include this information for each journal type:

  • Description - The name of the journal type.

  • AAI Table - The specific AAI table where you must set up the journal type.

  • Entry - This specifies whether the journal type is used to create debit or credit journal entries.

This table lists the T-1 payroll disbursement journal entries:

Journal Type

Description

AAI Table

Entry

AL

Actual Liabilities (Deductions, Benefits)

4

Credit

AT

Actual Taxes

4

Credit

AW

Accrued Wages

6

Debit

CF

Burden Offset (Clearing) - Fringe

6

Debit

CT

Burden Offset (Clearing) - Taxes

6

Debit

DP

Disbursed Amount (Computer Checks)

3

Credit

DA

Disbursed Amount (Auto Deposit)

3

Credit

This table lists the T-2 payroll distribution journal entries:

Journal Type

Description

AAI Table

Entry

AW

Accrued Wages

6

Credit

FB

Flat Burden Expense

2

Debit

FC

Flat Burden Offset (Clearing)

6

Credit

LD

Labor Distribution Straight Time

1

Debit

PR

Labor Distribution Premium Time

2

Debit

This table lists the T-3 actual burden journal entries:

Journal Type

Description

AAI Table

Entry

CF

Burden Offset (Clearing) - Fringe

6

Credit

CT

Burden Offset (Clearing) - Taxes

6

Credit

BF

Fringe Burden (Benefits & Accruals)

2

Debit

BT

Tax and Insurance Burden

2

Debit

This table lists the T-4 labor billing distribution journal entries:

Journal Type

Description

AAI Table

Entry

RD

Labor Billing (Recharge) Distribution

1

Debit

RO

Labor Billing (Revenue) Offset

5

Credit

This table lists the T-5 equipment distribution journal entries:

Journal Type

Description

AAI Table

Entry

ED

Equipment Billing Distribution

1

Debit

EO

Equipment Billing (Revenue) Offset

See note.

Credit

Note: EO can be set up as the Revenue Credit on the Depreciation Information Form in the Equipment Master or the General Ledger AAIs or both.

This table lists the T-6 payroll accruals/deferrals entries:

Journal Type

Description

AAI Table

Entry

AW

Accrued Wages

6

Credit

CF

Burden Clearing - Fringe

6

Debit

CT

Burden Clearing - Taxes

6

Debit

FC

Flat Burden Clearing

6

Credit

IC

Inter-Company Settlements

6

Debit & Credit

This table lists the T-7 payroll voucher journal entries:

Journal Type

Description

AAI Table

Entry

AL

Actual Liabilities (Deductions, Benefits, and so on)

4

Debit

AT

Actual Taxes

4

Debit