How to View Details of a Processed Owner Payment  Document Overview  - Ability to view details of processed Owner payments including check date, payment amount, any write- off amounts, and batch number  - Ability to search by customer or project number    NOTE: This query does not allow a search by invoice number.     Sample View Below – Owner Payment Details.      Accounts Receivable    Query   Payment Query       Enter the Company number  Click Query Data      Click the Query by Example search icon  Enter the Customer number in the search field  Press Enter      Click the desired row of data so the cells turn blue  Click Invoice Detail      Review payment details    

How to Assign a Posted Voucher to a Subcontract Document Overview  - Subcontract was approved as a voucher (AP Invoice) and needs to be applied to the commitment (subcontract)    Sample View Below.      Subcontract Management   Utilities   Assign Posted Voucher to Subcontract    Enter the Company number  Click Create Batch      Enter the Vendor number or double click to search  Enter the Invoice number  Enter the Contract number that the voucher needs to be applied to  NOTE: Do NOT hit Process. The dollar amount must be allocated in the SOV first (see Step 9).  The current invoice coding will appear under Distribution.  NOTE: If the AP voucher was posted with Job/Phase/Cat code different from the Subcontract and then Reclassed to match the contract, it is recommended to submit a zero-check instead of proceeding with this process.       Allocate the dollar amount under the Current Amount column in the desired Task row   Click Process    All fields will then turn blank  Click Post      Input the “Posting Date”  Click Post    The batch was successfully posted when the message below appears.        Verify the voucher was posted against the commitment in CMiC Field  Search for the job number in the white search field   Budget & Cost Management   Cost Status Query       Enter the phase coding that the commitment is coded to  Press Enter    Click the value in the Spent/Commitment column    Verify the voucher was credited (deducted) from the Spent Out of Commitment column  Verify the voucher is applied to the commitment and appears in the Spent Against The Commitment column   

Closing Jobs with Changes in Textura Fees Start of a Job  - Swinerton projects that are setup in Textura are charged an initial usage fee at the start of the job   - Textura usage fees are dependent upon the project’s contract value (Textura Pricing Schedule on the last two pages of this guide)   - A project’s contract value is found in the Potential Revenue field on its Job Start Form: Z:\SI\Accounting\SF\Accounting\JIP\Job starts    Close of a Job  - Prior to closing a job, the contract value needs to be manually adjusted in Textura if does not match the contract value in CMiC. Both systems need to match  - Integration between Textura/CMiC is focused on subcontract information (contracts, change orders, compliance status, invoices, payments)  - Any updates to the contract value needs to be completed BY THE PROJECT ACCOUNTANT in Textura  NOTE:  If the change in contract value causes the project to move from one Textura tier to another the fee is automatically recalculated and charged/refunded for the difference. These Textura invoices and credits are available the month following the project activity.     NOTE:  If you are NOT CLOSING THE JOB on the current month:  You can just wait for the invoice to be processed (sent to Project Setup by Textura). This cost will then hit the job once the invoice has been processed in AP Workflow.    If you ARE CLOSING THIS JOB on the current month:  If the job is closing in the current month, the Financial Manager needs to be aware that the contract amount has been changed and that if the job closes, the fee or credit will be put on the Division’s Overhead.    Example Below:   Job 17293068 was initially setup in Textura with a Potential Revenue of $800,000 (per the Job Start Form). The Textura usage fee fell under the tiered price structure of $650.   To double check the charge has hit the job, go to Job Costing > Logs > Transaction Detail. Enter the job number and apply filters to search by Phase 015425, Cateogry 71150, and Type “C” for costs.      Prior to closing the job, check to see if there has been a change to the project’s TOTAL CONTRACT VALUE. Go to JOB COSTING > Job > Enter Job.      Adjusting the Project Contract Value in Textura    To adjust the project contract value in Textura, go to Project Home > My Contract > My Change Orders. Fill out the required fields and then Click “Add”.    You will see “Success” appear when it has been updated.     The final step is to enter the difference in the “Allocate” column and then click “Save Changes”.         Swinerton Oracle TPM Pricing – For Projects Setup AFTER December 2018    Swinerton Oracle TPM Pricing – For Projects Setup BEFORE December 2018 

How to Import a Foreign Batch, Delete Data, and Perform a Reversal Document Overview  - This document will guide how to import, delete, and reverse a foreign batch    NOTE: Access is limited. Please reach out to the Operations Accounting Manager and Supervisors for assistance.    A .txt file of the journal entry is required to upload in CMiC. The below steps explain the process.     Open the journal entry and save it as a CSV Document (MS-DOS)(*.csv)   Optional: Add “csv” to the title of the file name    Click OK, and close the Excel file      Right-click the CSV file you just saved, select “Open with” and click “Notepad”    Delete everything highlighted in Red:    Once deleted, the file should look like this:      Click File, Save As, Add “txt” to file name. Click Save and close the file      Log in to CMiC Enterprise > Job Costing > Utilities > Import > Foreign Batch Import      Click on “Multi Companies Import” > Click “Choose File” to select your file (Select the .TXT file) > Click Import    Once you click Import the top of the screen will show Total Records Inserted        Click Close and Click Refresh    Once the Refresh is complete, you will see your Import. Select your Import and click Proceed:      If everything in the import file is correct, you should be able to click on “Build JC Transaction Batch”. If not, the button will be grayed out. If it is grayed out click on Edit Import Data to review the errors.    If the “Build JC Transaction Batch” is grayed out, click on Edit Imported Data and click Display Data to populate the imported transactions.  Once populated, scroll down to find the line item(s) missing a check mark in the “Valid” column  Click the transaction line and the error will populate in the indicated area on the screenshot below. You can send a screenshot of this to the Project Accountant who prepared the journal entry to fix the errors.  Once fixed, you can make the adjustment on this screen (click “Re-Validate” and then click “Close”), or Import the new file following the steps above.      If you choose to import a new file, remember to click “Delete Imported Data” and Click “Yes”    If everything on the import is correct, or you’ve made the necessary corrections, the “Build JC Transaction Batch” will be available to select:  DSRC Company Code = 010  Batch Number = click Create Batch     Click Inset and add your Foreign Batch Description. Once you click Save the batch # will populate    Click Select once the batch # is populated:    Journal Code = JC  Click Create Transactions  Status will show the # of records inserted into the batch you just created      MAKE NOTE OF THE BATCH NUMBER AND SHARE WITH PROJECT ACCOUNTANT  Click close, then click exit   

How To Post A Foreign Batch Document Overview  - Post a foreign batch after it has been uploaded by the Accounting Supervisors and/or Accounting Manager   - This is a required step in order for the transactions to hit the General Ledger  - Two reports will generate, the Job Costing – JC Posting Report and the General Ledger Posting Report  Sample Report Below – Job Costing – JC Posting Report.                  Sample Report Below – General Ledger Posting Report.                          Job Costing  Job  Post Batch    Enter the Batch number (provided by Supervisor/Manager)  Leave Automatic Accrual Reversal checked  Check Print Reports Immediately   Click Post    A new pop-up will appear; click Run Report.     

  HOW TO PRINT A POSTED BATCH TRANSACTION EDIT LIST REPORT Document Overview  - Confirmation a batch has been posted successfully  - Useful to review report for accuracy     NOTE: The batch number is required.  Sample Report Below.            Job Costing  Job  Print Edit List    Change the Batch Type to “Posted” by clicking the dropdown arrow      Enter the Batch number  Click Print    A new pop-up window will appear; click Run Report   

How to Move Costs from One Project to Another Document Overview  - Moving posted costs from one project to another project  - This is useful when needing to reallocate fees or moving costs  NOTE: Costs can NOT be moved if tied to a commitment (subcontract).   Verify that costs are in fact posted on the originating project before moving the costs to the new project.    Sample Report Below – JC Posting Report.              Sample Report Below – General Ledger Posting Report.                            Job Costing  Transactions  Enter Cost Transaction      Click Create Batch    The batch number will auto-populate and be tied to the user’s name    Complete the fields under the Transaction Section:  Post Date: Date/month desired for entry to post  Journal: Type of journal entry being posted (most job-related entries will be JC)  Source: Where the entry is generating from (short version)  Source Desc: Detailed information pertaining to the source  Reference: Job number, “tax”, etc.  Reference Desc: Details about the entry (billing info, City/County Sales tax rate, etc.)  Ref Date: Posting date (today’s date)  Helpful Tip: The information entered in items c. - g. above should be the same information in the Job Detail Transaction Log for consistency.      Under the Detail Section:  Insert a line item for each entry needed (two lines will be inserted in this example)  Enter Type: J = Job Cost Entry, G = General Ledger Entry  Company: Enter the company number in which the project resides   Job/Dept/Eqp/WO: most of the time this is the project number  Phase/Compon/Acc/WI: this information is obtained from either the AP Voucher GL Distribution, or CMiC Project Field   Cat/Tran/Exp: This is information is obtained from the same places as Cost Codes  Debit = will increase the account being posted to   Credit = will decrease the account being posted to        Click Save        Click Print Edit List    Click Print      Sample Report Below will generate. Review for accuracy.   Click Post Transactions    Ensure “Print Reports Immediately” is the only box checked      Click Post    Click Run Report        

How to Enter a Journal Entry with an Automatic Accrual Reversal    Document Overview  - Entries will automatically be reversed and posted the following period    Sample Report Below – JC Posting Report.      Sample Report Below – General Ledger Posting Report.      Job Costing  Transactions  Enter Cost Transaction    Click Create Batch       Complete the fields under the Transaction Section:  Post Date: Date/month desired for entry to post  Journal: Type of journal entry being posted (most job-related entries will be JC)  Source: Where the entry is generating from (short version)  Source Desc: Detailed information pertaining to the source  Reference: Job number, “tax”, etc.    Check Accrual    Under the Detail Section:  Insert a line item for each entry needed (two lines will be inserted in this example)  Enter Type: J = Job Cost Entry, G = General Ledger Entry  Company: Enter the company number in which the project resides   Job/Dept/Eqp/WO: most of the time this is the project number  Phase/Compon/Acc/WI: this information is obtained from either the AP Voucher GL Distribution, or CMiC Project Field   Cat/Tran/Exp: This is information is obtained from the same places as Cost Codes  Debit = will increase the account being posted to   Credit = will decrease the account being posted to    Click Save            Click Print Edit List    Click Print        Sample Report Below will generate. Review for accuracy.   Click Post Transactions                  Ensure the “Print Reports Immediately” and “Automatic Accrual Reversal” boxes are both checked    Click Post    Click Run Report   

How to Complete a Manual Journal Entry  Document Overview  - Moving posted costs from one project/department to another   - This is useful when there are only a few transactions that need to be completed instead of completing a foreign batch  Sample Report Below – JC Posting Report.      Sample Report Below – General Ledger Posting Report.      Job Costing  Transactions  Enter Cost Transaction    Click Create Batch       Complete the fields under the Transaction Section:  Post Date: Date/month desired for entry to post  Journal: Type of journal entry being posted (most job-related entries will be JC)  Source: Where the entry is generating from (short version)  Source Desc: Detailed information pertaining to the source  Reference: Job number, “tax”, etc.  Note:  If Accrual box is checked this entry will automatically be reversed and posted the following period.          Under the Detail Section:  Insert a line item for each entry needed (two lines will be inserted in this example)  Enter Type: J = Job Cost Entry, G = General Ledger Entry  Company: Enter the company number in which the project resides   Job/Dept/Eqp/WO: most of the time this is the project number  Phase/Compon/Acc/WI: this information is obtained from either the AP Voucher GL Distribution, or CMiC Project Field   Cat/Tran/Exp: This is information is obtained from the same places as Cost Codes  Debit = will increase the account being posted to   Credit = will decrease the account being posted to      Continue adding remaining line entries as necessary. When all entries are entered, all Debits must equal Credits; if the amounts do not balance, you will not be able to save the journal entry.    Click Save        Click Print Edit List    Click Print      Sample Report Below will generate. Review for accuracy.   Click Post Transactions    Ensure “Print Reports Immediately” is the only box checked (unless Accrual box was checked under the Transaction section).      Click Post    Click Run Report          

HOW TO CORRECT AN UNPOSTED BATCH  - Correct transactions prior to posting a batch   - Existing entries can be deleted from the batch prior to posting   - Additional entries can be added to the batch prior to posting   Job Costing  Transactions  Enter Cost Transaction    Click the magnifying glass in the Batch field    Locate the Batch by searching through the Batch List. You can also use the search fields to narrow down the options    Highlight the correct Batch  Click OK    Review the Detail section    Make any necessary corrections to each line as needed     Click Save