Journal Job Costs
Costs can be added to a job using many documents such as invoices, transfers, and rentals. An alternative method is to post job costs using a journal entry. This method can be used to add costs when entering beginning balances or other accounting expenses.
WARNING: The job cost journal entry does not warn the user when applying job cost expenses to none job financial accounts. Although the post process does display an error, the Direct Job Cost option does not block journal entries to none job general ledger accounts.
Complete the following steps to post costs to a job using a journal:
-
Open the journal by selecting and click New to create the following journal:
-
Set the appropriate journal date to post job costs and financial transactions in the appropriate period.
-
Enter the expense G/L Account (debit) and the Debit Amount for the job costing expense along with the Job ID and Stage ID.
Do not enter the credit amounts on the same journal line that contains the Job ID.
Do not enter a G/L Account that is classified as Work in Process.
-
Enter the G/L Account (credit) and the Credit Amount for the offsetting financial account. DO NOT enter a JOB ID or Stage ID on the credit line.
-
The Reference 2 column can be kept blank. Enter an optional document ID.
-
Enter a value in Track 1 only to identify a quantity or hours. Inventory quantities and labor hours should be processed using the EBMS inventory and labor modules.
-
Save and process the journal after matching the Debit total and Credit total. Review Transactions and Journals > Journals > Creating Journal Entries for more journal details.
Posting Job Costing Journal Transactions:
Posting job costing transactions will display the following errors if a wrong expense account has been used to post job journals:
Review Direct Job Cost General Ledger Accounts for more details on job cost expense accounts.
Financial Transaction Mapping
|
Payroll Transactions
|
Rec
Type
|
G/L Account
|
Date
|
REF1
|
REF2
|
REF2 Flag
|
Source
|
Description
|
Amount
|
DC
|
ID
|
Printed
|
Status
|
STAT DEP
|
Track1
|
Track2
|
Flag1
|
Ware house |
Job |
Stage |
Job Trans |
|
Expense transaction for each detail line
|
Pe
|
pytmdet->gl_code
|
Line Date
|
Pay period
|
Work code
|
|
PYT
|
Employee name
|
Pay for line
|
D
|
Employee ID
|
|
|
|
Hours
|
(JC) "SO "+ Date
|
"H" or "U" - hours or units
|
|
Job ID |
Job Stage |
E |
|
Sales Transactions
|
Rec
Type
|
G/L Account
|
Date
|
REF1
|
REF2
|
REF2 Flag
|
Source
|
Description
|
Amount
|
DC
|
ID
|
Printed
|
Status
|
STAT DEP
|
Track1
|
Track2
|
Flag1
|
Ware house
|
Job
|
Stage
|
Job Trans
|
|
Transaction for invoice detail
|
SI
|
Account on line
|
Invoice date
|
Invoice
|
Inventory item
|
Maybe O
|
ARI
|
Descr
|
Selling price
|
C
|
ID
|
|
|
|
Shipped
amount
|
Price
|
V (if track count and periodic inventory)
|
|
Job ID
|
|
I
|
|
Error correction for materials list
|
Sm
|
Account from materials
|
Invoice date
|
Invoice
|
|
|
ARI
|
"Price Distribution Remainder"
|
Error amount
|
C
|
ID
|
|
|
|
|
|
|
|
Job ID
|
|
I
|
|
Job retainage for the invoice
|
SJ
|
jcjb->custret_gl
|
Invoice date
|
Invoice
|
|
|
ARI
|
Customer name
|
Total retainage
|
D
|
ID
|
|
|
|
|
|
|
|
Job ID
|
|
I
|
|
Job costing
Work-in-process
|
Rec
Type
|
G/L Account
|
Date
|
REF1
|
REF2
|
REF2 Flag
|
Source
|
Description
|
Amount
|
DC
|
ID
|
Printed
|
Status
|
STAT DEP
|
Track1
|
Track2
|
Flag1
|
Ware house
|
Job
|
Stage
|
Job Trans
|
|
Work in process - Cost in excess of billing
|
J1
|
jcjb->cstbill_gl
|
Process date
|
|
|
|
JCW
|
Work in process - 'job id'
|
Amount
|
D
|
|
|
|
|
% complete
|
|
|
|
Job ID
|
|
W
|
|
Work in process - Cost in excess of billing
|
J2
|
jcjb->wrkproc_gl
|
Process date
|
|
|
|
JCW
|
Work in process - 'job id'
|
Amount
|
C
|
|
|
|
|
% complete
|
|
|
|
Job ID
|
|
W
|
|
Work in process - Billing in excess of cost
|
J3
|
jcjb->billcst_gl
|
Process date
|
|
|
|
JCW
|
Work in process - 'job id'
|
Amount
|
C
|
|
|
|
|
% complete
|
|
|
|
Job ID
|
|
W
|
|
Work in process - Billing in excess of cost
|
J4
|
jcjb->wrkproc_gl
|
Process date
|
|
|
|
JCW
|
Work in process - 'job id'
|
Amount
|
D
|
|
|
|
|
% complete
|
|
|
|
Job ID
|
|
W
|
Review Transactions and Journals > Comprehensive GLT Transaction Reference for a complete list.