How to View Account Transactions by Batch and Department   Document Overview  - Summary of account transactions by batch and department   - Ability to search by batch   - Ability to search by specific timeframe  - Useful tool for Department budgeting      NOTE: This report is mostly used by GL; it is specific to each Department.     Sample Report Below:        General Ledger  Query   Transaction Query                 Enter “Company”  Enter “From Post Date” and “To Post Date”  Enter “Department Number”  Click Query Data    

How to View Account Transactions by Department Document Overview  - Summary of overhead account transactions (office supplies, employee relations, meals, rent, etc.) with      ability to view details  - Ability to search by specific timeframe  - Ability to View Opening and Closing balances  - Useful tool for Department budgeting      NOTE: This report is not project related; it is specific to each Department.     Sample Report Below:      General Ledger   Query  Account Activity Query     Enter “Company”   Enter “Year”  Enter “From Period” and “To Period” (use number associated with month, for example 5 = May)  Click Query Data    Once Account section appears, click the Query icon  Enter the “Department”   Click Query Data one more        Click a row of data under the Account section for total Opening and Closing Balance    View details of the data beneath, under the Transaction section        

How to View the Job Status of a Project Document Overview  - View status of a project:  Closed = project is financially closed in CMiC and no further transactions can take place   Pending = project is financially open in CMiC, but the budget has not been locked by the Financial Manager  In Progress = project is financially open in CMiC and the budget has been locked by the Financial Manager      Sample View Below:        Job Costing   Job  Enter Job    Click the Query icon  Enter project number in the “Find” field  Press Enter  View status of project under Status column  NOTE: In this example, the project is In Process.     

How to Run a General Ledger Transaction Detail Report by Department Document Overview  - View posted transactions during a time frame by department   - This report helps verify journal/reclass entries that have posted to the General Ledger     NOTE: This report is mostly used by the GL Team.    Sample Report Below.      General Ledger  Reports  Detail Transaction Report        Enter “Company “  Enter “From Department”  Enter same number in “To Department”  Enter “From Post Date” (required field)  Enter “To Post Date” (required field)  All other fields will auto-populate; no need to modify  Click Run Report       

How to Run a Job Cost Posting Report After a Batch has Been Posted Document Overview  - Report provides details of a job costing batch that has been posted  - Confirmation a batch has been posted successfully for job costing  - Useful report for view changes impacting job cost.  Sample Report Below.      Job Costing  Utilities  Print Posting Reports        Click the Query by Example icon  Type the batch number in the blank search filed  Press Enter           Click the row beneath “* Batch”  Click Print          Click Run Report     

How to Run a Job Costing Transaction Report by Project Document Overview  - Report includes details of job cost by project (expense reports, labor hours, insurance, vendors, subcontractors, etc.)  - Report includes billing accruals   - Last page of report provides overall summary by category code    Sample Report Below (including overall summary page).        Job Costing  Reports  Job Cost Transaction Report      Enter “Company”  Enter project number in “From Job” field   Enter same project number in “To Job” field  Enter specific coding in “From Job Cost Code” field (optional)  Enter same specific coding in “To Job Cost Code” field (optional if entered in Step 7)  Enter specific dates (optional)   All other fields will auto-populate; no need to modify  Click Run Report     

How to Run a Subcontractor Compliance Report by Job Document Overview  - View compliance status of subcontractors by job   - View expiration dates of compliance items of subcontractors by job   - Report shows compliance status for subcontractor(s) by job, which may impact payment    Sample Report Below.    Subcontract Management  Reports  Compliance Reports      Enter “From Company”  Enter “To Company”   Enter project number in “From Job” field  Enter same project number in “To Job” field  Enter/search vendor number in “To Vendor” field (optional)  All other fields will auto-populate; no need to modify  Click Run Report   

How to Run a Summary of Total Accounts Payable by Job Document Overview  - Summary of total Accounts Payable per vendor by job and outstanding amounts due  - Ability to view cost and revenue budgets; construction start and end dates    NOTE: This is a good tool share with the Project Team when jobs are nearing completion. Allows Team to view any outstanding items before a job can be fully closed out.      Sample Report Below.      Job Costing  Logs  JC Analysis Log        Enter Company in “Company Code” field   Enter project number in “Job Code” field  Click Apply Filter      Click the dollar amount under the A/P Invoices column    A new pop-up window will appear with a summary of AP Invoices (vouchers), with vendor details, invoice amounts, outstanding amounts, etc.  Download report as an Excel file by clicking Export   

How to Run a Summary of Total Accounts Receivable by Job Document Overview  - Summary of total Accounts Receivable by job and outstanding amounts owed from Owner  - Ability to view cost and revenue budgets; construction start and end dates    NOTE: This is a good tool share with the Project Team when jobs are nearing completion. Allows Team to view any outstanding items before a job can be fully closed out.        Sample Report Below:        Job Costing  Logs  JC Analysis Log      Enter Company in “Company Code” field   Enter project number in “Job Code” field  Click Apply Filter      Click the dollar amount under the A/R Invoices column      A new pop-up window will appear with a summary of AR Invoices with invoice amounts, outstanding amounts, batch numbers, etc.  Download report as an Excel file by clicking Export   

How to View All Outstanding Subcontract Vouchers by Job Document Overview  - View all outstanding subcontract vouchers (RFP invoices) per vendor by job  - Report breaks down outstanding items by:  Vendor number and name  Voucher date  Original amount  Outstanding amount  Brief description  Status of payment (any holds)        Sample Report Below.    Accounts Payable  Reports  Outstanding Vouchers by Job Report       Enter project number in both “From Job” and “To Job” fields    All other fields will auto-populate; no need to modify  Click Run Report