CMiC Upgrade - Operations Accounting
-
How to View Details of a Processed Owner Payment
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
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
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
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
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
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
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
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
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
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