CMiC Analytics - Accounts Receivable Bucket

This bucket includes BI reports detailing information from Accounts Receivable including customers, invoices, cash receipts, and aged receivables.

AR Dashboard Collection

This dashboard displays outstanding receivables by customer, aged receivables by aging period, average days to pay by customer, invoiced vs paid, as well as outstanding receivables by job.

AR Customers

This query displays a list of customers for a selected company. It includes their contact information, address, and class code.

AR Customers Card View

This query displays a list of customers categorized by company. It includes their contact information, average days to pay, and addresses.

AR Invoices

This query displays a list of AR invoices which includes details about customer, job name, post date, amount, retainage, and description. The information is subtotaled by customer.

AR Invoices Crosstab

This query displays a month by month summary of AR invoice amounts per customer. Clicking on a month will drill down into specific AR invoices which reveals more details about amounts, dates, and descriptions.

AR Invoices Card View

This query displays a list of AR reports categorized by company. It also shows a total invoice amount and outstanding amount by company.

AR Cash Receipts

This query displays a list of cash receipts from customers. Details include check numbers, dates, amounts, descriptions, etc.

AR Cash Receipts Crosstab

This query shows a month by month breakdown of cash receipts from each customer. Clicking on a month drills down into information about individual cash receipts which includes descriptions, dates, etc.

AR Aged Receivables Drill-Down

This query shows the aged receivables by customer, broken down by different aging periods such as 60 days, 90 days, etc. Clicking on a customer drills down into the aged receivables by job. Drilling down even further reveals details about individual AR invoices.

AR Aged Receivables Detail

This query shows aged receivables with details for each AR invoice and subtotaled for each customer. Clicking on a customer drills down into summaries for specific jobs.

AR Aged Receivables Crosstab

This query shows a month-by-month breakdown of aged receivables by customer. Clicking on a month drills down into specific AR invoices with details about amounts and post dates.

AR Aged Receivables Card View

This query shows a list of AR invoices categorized by company. It also shows the total outstanding receivables by company.