APM Project Journal Entry

Use Advanced Project Journal Entry to enter GL journals charged directly to Advanced Project Project/Phase and/or Cost Code or to transfer costs between projects, phases and or cost codes or GL accounts. Note that a journal entry does not auto reverse.

Some examples are:

APM Project Journal Entry In APM Project (after running Recalculate Analysis):

Transfer costs between Projects

  • Appears as a CostWIP transaction line in the Cost Type Transaction Detail card in Ledger.

  • Updates the Costed for the relevant Cost Type in the Cost Type Summary card in Ledger.

  • Changes Costed (and thus Remaining) in the Budget card for the Project > WBS Phase > Cost Code.

Transfer costs between Phases within a Project

  • Changes Costed (and thus Remaining) in Budget card for the Project > WBS Phase > Cost Code, for both the affected WBS Phases.

Transfer costs between Cost Codes within a Project > WBS Phase

  • Updates the Costed for the respective Cost Type in the Cost Type Summary card in Ledger.

  • Updates Costed (and thus Remaining) in the Budgets card for the Project > WBS Phase > Cost Code.

All other features and functionality remain the same as the Journal Entry in other menu paths in Kinetic. Read more about Setting Up GL Journals in the Standard Kinetic online help, and GL Journal Entry in the application help.

Accrued Flag and Classification

The Accrued flag and the Classification work together to define how the General Journal transaction is classified in the APM Project Ledger when Project Analysis is run.

The transaction amount (debit or credit) populates different columns in the project’s Ledger page, as follows:

Accrued flag Classification Ledger column populated with the Transaction amount:

True

Revenue

Revenue

False

Revenue

RevenueWIP

True

Cost

SpentAmount

False

Cost

CostWIP

The General Journal transactions appear in the Cost Type Transaction Detail card (see Cost Type Transaction Detail), for the Cost Code used in the Journal entry.

CostTypeTransactionDetail

Capturing an APM Project Journal

The example below demonstrates how to transfer costs between Projects, using APM Project Journal. There are two journal lines (a debit of 120.00 against G/L Account 8050|00|50, for Project CTR-1 and a credit of 120.00 against G/L Account Code 8050|00|50 for Project CTR-10) for a journal entry 'Meals on Consulting Trip'.

The steps are:

Step 1. Capture a Journal Group

  1. Navigate to Advanced Project Management > Project Accounting > General Operations > APM Project Journal Entry.

  2. Select New Group AddBtn on the Standard toolbar.

    1. Enter a value into the Group field.

    2. Accept all defaults.

  3. Select Save SaveBtn on the Standard toolbar.

    CaptureJournalGroup

Step 2. Capture a Journal

The example below demonstrates how to transfer a cost between two different projects, using journal entries.

  1. Select New Journal AddBtn on the Journal Entries in Process toolbar.

    NewJournal

    A new journal opens for the group.

  2. Capture the journal details.

    1. In the Description field, type in a description for the journal, for example 'Meals on Consulting Trip'.

    2. Select the Apply Date.

      The Apply Date must fall within the Fiscal Year and Fiscal Period of the current date.
    3. Keep all other defaults.

    SaveNewJournal
  3. Select Save SaveBtn on the Standard toolbar.

    The new journal is saved.

Step 3. Capture a Journal Line for Debit

Create a Debit journal line for the cost.

  1. Select Lines on the Navigation Tree.

    The Lines card appears.

  2. Select New Journal Line AddBtn on the Lines menu bar.

    NewJournalLine

    A new line is added.

    NewJournalLineAdded
  3. Select Lines / Line Details under the Related Pages node on the Navigation Tree.

    This displays the General card for the new line.

  4. Update the details for the Debit journal line.

    1. Clear the Accrued check box. Accrued is used by the system for posting project journal accruals.

    2. Select Cost from the Classification drop-down list. The Cost is for journal entries relating to transfer or reallocation of costs. Cost classification is required for the correct classification in the Project Ledger.

      Accrued and Classification work together to determine if the transaction is an accrual (deferral) transaction for APM Project Ledger classification purposed when Project Analysis is run. See Accrued Flag and Classification.
    3. In the G/L Account field, type in or select a G/L Account Code appropriate for the journal transaction. In this example, G/L Account number 8050-00-50 is used, which is the Meals and Entertainment cost code, for the Main branch, in the Services division.

    4. Enter the Project ID. In this example: CTR-1.

    5. In the WBS Phase ID drop-down list, choose a WBS Phase ID from the project.

    6. In the Cost Code drop-down list, choose a Cost Code from the Project > WBS Phase.

      Type displays the Cost Code Type for the selected Cost Code.

    7. Enter a value (120.00) in the Debit field.

    8. Select Save SaveBtn on the Standard toolbar to save the journal line.

    SaveJournalLine

Step 4. Capture a Journal Line for Credit

  1. Now create a new journal line, using the same G/L Account, but for a different Project, in this example: CTR-10. Clear the Accrued check box. Select the same G/L Account Code. Select a WBS Phase and Cost Code belonging to the Project. Enter a Credit amount (120.00).

  2. Save.

    NewCreditJournalLine

Step 5. Check the Journal Totals Balance

  1. Select Details on the Navigation Tree to open the Journal.

  2. On the Journal card, check that the Journal Totals are now balanced:

    CheckJournalsBalance

Posting an APM Project Journal

To post a journal entry:

  1. Select Post Asynchronous from the OverflowBtn Overflow menu.

    PostingAPMProjectJournal

  2. Select Process ProcessIcon image on the Journal Entry Post Process slide-out panel.

    The transaction is posted to the General Ledger.

Viewing the Posted Journals on the Project

Captured and posted journals can be viewed on several of the project pages.

  • Run Recalculate Analysis for the project to bring the journal transactions in.

FetchJournalEntry

The Transaction Summaries show the transaction in Cost Type Summary, Cost Type Transaction Detail.

For the credit journal transaction (project CTR-10) this is a negative value (-120.00).
For the debit journal transaction (project CTR-1) this is a positive value (120.00).

The budget for the affected Cost Code is also affected.

The transaction amount (120.00) is included in the Costed amount, and Remaining is reduced by that amount.

The project that the amount was transferred to has a change to its General Ledger also, and the affected Cost Code Detail Costed goes down, while the Remaining goes up.