How to View Outstanding and Paid Owner Invoices Document Overview  - Report shows all invoices tied to a specific Owner   - Report shows invoice details including invoice amount, outstanding amount, retainage  - Report shows aging in 30/60/90 day increments    Sample Report Below.      Accounts Receivable   Query  Customer Account Quick Query             Enter Company  Enter Customer number (or double click to search for customer)     Click Query Data                    Click the Query by Example search icon  Enter the invoice number in the search field  Press Enter    Click Details to view additional invoice information   

How to View Payment Details by Owner Document Overview  - Report shows Owner payments including invoice number, invoice amount, and amount paid   - Able to search by customer or project number  - Useful when Owner asks to view a Statement     NOTE: This is a payment query by customer only, NOT by invoice.     Sample View Below.      Accounts Receivable   Query   Payment Query       Enter Company number  Click Query Data    Enter Customer number  Enter Project number  Press Enter      Click the desired row of data so the cells turn blue  Click Invoice Detail    View payment details     

CLOSING JOB CHECKLIST (see attached)

How to Run a Subcontract Subledger Report When Requested by Textura Document Overview  - Textura requests a Subledger Report when an Off-System Payment (OSP) has been made via CMiC  - An OSP must be recorded by Textura in order for the contract amount to match CMiC  - Report shows if a subcontract has been paid outside of Textura   - Textura requests this report from Project Accountants           Subcontract Management   Reports  Detail Report      Enter Company   Enter the same project number in the “From Job” and “To Job” fields  Enter the same vendor number in the “From Vendor” and “To Vendor” fields (optional)  Enter “From SC Contract” number (optional)   Click Run Report   

How to Add Billing Codes to a Project  Document Overview  - This process is performed after a budget is uploaded and/or when there are changes to a budget   - Ensures all phases and cost codes are applied to a project  - Perform this process if CMiC contains errors on billings  Sample View Below.      Job Billing   Contracts  Enter Contract    Click the Query by Example search icon  Enter the project number  Press Enter      Click the pencil edit icon next to the project number      Click Add New Bill Codes      Select Add New Bill Codes Only  Click Ok      When the alert box appears, click Ok      Click Save         

How to Attach Backup Documentation to an Owner Billing  Document Overview  - Upload and attach an Owner billing PDF file to an invoice   - Beneficial for audits, inquiries, backup, etc.     Sample View Below.        Accounts Receivable   Query   Invoice Query          Enter Company number  Enter the project number in the “Job Code” field  Click Query Data      Locate the correct invoice from the table  Click the desired row of data so the cells turn blue  Click Attachments            Click Choose Files, or drag and drop the file inside the dotted box to upload the PDF document  Click Ok        The file was successfully uploaded when a number appears next to the Attachments icon. This number also symbolizes the quantity of files uploaded to the specific invoice.      

How to Add PLP and PSI Coding to a Project   Document Overview  - Add coding to an existing project template    NOTE: This function is primarily used by Project Setup and Financial Managers. Access is restricted. Reach out to Project Setup for assistance.    Sample Completed Function Below.        Job Costing  Setup  Local Tables  Enter Cost Code           Click the Query by Example search icon  Enter the year and division number of the project needing to have PLP or PSI coding setup, followed by a % symbol        Click the Insert icon  Enter the project number  Enter the project name  Under Ctrl.Cost Code enter “ALL”  Under Cost Code Type Code enter “OH”  The job number will populate on the Alternate line  Enter NA in the WM column   Ensure the project is marked “Yes” for active      Job Costing  Job  Assign Phases      Enter the project’s Overhead number in the “Job” field  Click the Insert icon to add a new line  Enter the project number  The project name will populate in the “Description” field  Type ALL in the “Control Phase Code” field  Type OH in the “Phase Type” field  Ensure the WM is set to “NA”  Click the Save icon    Click the Category Detail button           Click the Insert icon  Enter the coding in the “Category” field   Click Save  Click Close      Job Costing  Setup  Local Tables  Enter Cost Code         Click the Search icon  Enter the project number  Press Enter  Change the Active column to “No”      A popup alert will appear   Click “No” twice   

How to Apply a Joint Check Method Before Payment is Released on a Subcontract  Document Overview  - Useful when payment needs to be disbursed to a subcontractor and a lower sub-tier at the same time  - Company names of both the subcontractor and lower sub-tier will be listed on the same check  - Ensures the subcontractor pays the lower sub-tier   - Payment will be disbursed by the invoice due date  NOTE: Subcontract must have no Paid When Paid (PWP) or Compliance holds.    Sample View Below.        Accounts Payable   Payment  Adjust Voucher Status      Enter the Company number  Enter the Job number, Vendor number, or both  Click Query Data    Click on the Normal Vouchers tab      Click the Query by Example search icon  Enter the Invoice number  Press Enter  Click Joint Payee      Click the Insert icon  Fill in the Joint Payee Name  Fill in the dollar amount   Click Close      Click Save   

How to Apply a Paid When Paid Hold to a Subcontract  Document Overview  - Subcontract will not be paid until the Paid When Paid (PWP) hold is manually removed    Sample View Below.      Accounts Payable   Payment  Adjust Voucher Status      Enter the Company number  Enter the Job number, vendor number, or both  Click Query Data      Click on the Normal Vouchers tab    Click the Query by Example search icon  Enter the “Invoice” number  Press Enter      Uncheck the PWP Hold box  Change the Status to P (P = Perm Defer)  Click Save    The invoice automatically moves to the Deferred Vouchers tab.     

How to Remove a Paid When Paid Hold on a Subcontract  Document Overview  - Subcontract will automatically be paid by the invoice due date for Normal Payment (N) release    NOTE: Before removing the PWP Hold, ensure the subcontractor does not have any Compliance Holds.    Sample View Below.      Accounts Payable   Payment  Adjust Voucher Status      Enter the Company number  Enter the Vendor number, Job number, or both  Click Query Data    Click on the Deferred Vouchers tab      Click the Query by Example search icon  Enter the Invoice number  Press Enter    Uncheck the PWP Hold box  Ensure the Status is N (N = Normal)  Click Save  The invoice will automatically move to the Normal Vouchers tab.