CMiC Upgrade - Operations Accounting
-
How to View Account Transactions by Batch and Department
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
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
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
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
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
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
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
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
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
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