CMiC Upgrade - Operations Accounting
-
How to Run a Non-Compliance Subcontractor Report
How to Run a Non-Compliance Subcontractor Report Document Overview - Ability to view subcontractor(s) on specific job(s) with Reason For Holds - View Outstanding Amounts on Hold - Report is useful for Project Administrators to view/update compliance Sample Report Below. Accounts Payable Reports Non-Compliance Report Enter desired search parameters “From Vendor” and “To Vendor” (this will show a specific subcontractor and ALL jobs they are on) “From Job” and “To Job” (this will show ALL subcontractors on that specific job) Click Run Report
-
How to Run a Posted Voucher Report by Vendor
How to Run a Posted Voucher Report by Vendor Document Overview - View history of posted payments to a vendor during a specific timeframe - View payment details including invoice date, amount, cost coding, payment method (ACH, Textura, etc.), and retainage NOTE: This report does not allow a search by project or drill down capabilities. This report is broad and provides a history of invoice and payment details by vendor ONLY. Sample Report Below. Accounts Payable Reports Posted Voucher Listing Enter vendor number in the “From Vendor” field or double click to search Enter the same vendor number in the “To Vendor” field Enter “From Invoice Date” Enter “To Invoice Date” Enter “From Due Date” (optional) Enter “To Due Date” (optional) Change “Show Distribution” to Yes Click Run Report
-
How to Run a Summary of Total Purchases by Vendor
How to Run a Summary of Total Purchases by Vendor Document Overview - Report shows total amount paid to a vendor over a period of 3 years NOTE: This report does not allow a search by project or show details. This report provides a summary of total purchases. Sample Report Below. Accounts Payable Voucher Vendor Purchases Enter vendor number in the “From Vendor” field, or double click to search Enter the same number in the “To Vendor” field Click Run Report
-
How to Run a Voided Invoice Report by Vendor
How to Run a Voided Invoice Report by Vendor Document Overview - Report contains both voided subcontracts and vouchers (AP invoices) - Report includes invoice date/number, original/voided batch numbers, and amounts - Ability to search for invoices during a specific duration - Report provides information on whether an invoice has been voided out of the system NOTE: This report ONLY offers a search by vendor, NOT by job number. Sample Report Below. Accounts Payable Reports Voided Item List Enter desired search parameters “From Vendor” and “To Vendor” (this will show a specific vendor and their invoices that have been voided on ALL jobs) “From Invoice Date” and “To Invoice Date” (optional - this will show a specific vendor and their invoices that have been voided on ALL jobs during a time period) Click Run Report
-
How to Run a Billing and Payment Status Report by Project
How to Run a Billing and Payment Status Report by Project Document Overview - Ability to view details of Owner invoices including paid and outstanding amount, retainage, and date payment was received Sample Report Below. Accounts Receivable Reports Billing And Payment Status Report Enter the same Company number in the “From Company” and “To Company” fields Enter the same project number in the “From Job” and “To Job” fields Enter Aging Dates Change Show Deposits to Y Click Run Report
-
How to Run a Submitted Owner Billing Summary Report
How to Run a Submitted Owner Billing Summary Report Document Overview - Report shows summary of total billings submitted to an Owner by project - Report shows invoice date, outstanding retainage, and gross amounts NOTE: This report does NOT provide any payment or invoice information. Sample Report Below. Accounts Receivable Reports AR – Invoice Listing Enter Company Enter the same customer in the “From Customer” and “To Customer” fields (or double click to search) Double click the search field next to From AR Invoice and search for the project number Enter the project number Click Search The list will display all invoices submitted to the Owner in ascending order. Enter the customer’s first invoice number applied to the job in the “From AR Invoice” field Enter the customer’s last invoice number applied to the job in the “To AR Invoice” field Enter the “From Date” and “To Date” fields (Optional) Click Run Report
-
How to Run a Total Outstanding Accounts Receivable Report by Project
How to Run a Total Outstanding Accounts Receivable Report by Project Document Overview - Report shows total outstanding balance due from Owner by project - Report shows outstanding balance in 30/60/90 day increments NOTE: This report does NOT provide invoice details. Sample Report Below. Accounts Receivable Reports Aged Report - Summary Enter the same Company number in the “From Company” and “To Company” fields Enter the same project number in the “From Job” and “To Job” fields Enter “Aging Date” and “Cut Off Date” (optional) All other fields will auto-populate Choose Report Type (PDF/Excel) Click Run Report
-
How to Run an Accounts Receivable Aging Report by Project
How to Run an Accounts Receivable Aging Report by Project Document Overview - Ability to view outstanding balance due from an Owner by project in 30/60/90 day increments - Report shows invoice details including date, outstanding amount, and retainage - Useful for Project Administrators and Project Managers to view outstanding Owner payments Sample Report Below. Accounts Receivable Reports Aged Report – Detailed Enter the same Company number in the “From Company” and “To Company” fields Enter the same project number in the “From Job” and “To Job” fields Enter the current date in the “Aging Date” and “Cut Off Date” fields All other fields will auto-populate Click Run Report
-
How to View Details of an Owner Payment
How to View Details of an Owner Payment Document Overview - Report shows details of an Owner billing including invoice numbers, date, and outstanding amounts - Report shows details of Owner payments including check date, payment amount, and invoice number - Ability to search by customer, invoice, or project number NOTE: If a payment ever needs to be voided after it has been posted, the batch number is required. Sample View Below – Owner Billing Details. Sample View Below – Owner Payment Details. Accounts Receivable Query Invoice Query Search Option 1 Search by: Customer Invoice Number Job Code (project number) Click Query Data Click Payments View detailed payment information Search Option 2 Click the Query by Example search icon and search by: Company Customer Invoice Number Invoice Date Due Date Etc. Press Enter Click Payments View detailed payment information
-
How to Run an Accounts Receivable Posted Batch Report
How to Run an Accounts Receivable Posted Batch Report Document Overview - Report shows the different Billing Modules a batch was posted to - Report shows allocation of accounts and phase codes that a Billing was distributed to - Report will download as three separate PDFs: Accounts Receivable, Job Costing, and General Ledger Sample Report 1 of 3 Below: Accounts Receivable – Invoice Posted Listing Report. Sample Report 2 of 3 Below: Job Costing – JC Posting Report. Sample Report 3 of 3 Below: General Ledger Posting Report. Accounts Receivable Utilities Print Posting Reports Enter “Company” Click the Query by Example search icon Enter the batch number Press Enter When batch appears, click Print Click Run Report