CMiC Analytics - Accounts Payable Bucket

This bucket contains BI reports pertaining to Accounts Payable, including information about vendors, invoices, checks, and aged payables.

AP Dashboard Collection

This dashboard shows various metrics including outstanding payables broken down by aging periods and vendors. It also includes a calculation of the average days to pay, check amounts by vendor, paid amounts by fiscal period, and a summary of aged payables.

AP Vendors (AP Vendor Listing)

This query shows a list of all vendors for a selected company. It includes their contact information, location, and vendor class.

AP Vendors Card View

This query shows a card view of the vendors in your CMiC system. The vendors are categorized into vendor classes such as architects, builders, or electrical subcontractors.

AP Invoices

This query shows a detailed listing of each AP invoice with invoice numbers, descriptions, post dates, vendor codes, due dates, amounts, retainage, and outstanding amounts. Where applicable, you can jump to an AP invoice record by clicking on the Image Link column of that invoice. You can also drill down into payment details by clicking on an individual row to see a breakdown of check payments applied to the invoice.

AP Invoices Crosstab

This query shows a month-by-month summary of the payables per vendor. You can click on a particular month to drill down into specific invoices and from there, view the invoice record by clicking on the Image Link.

AP Invoices Card View

This query shows a list of AP invoices organized by vendor, along with total outstanding amounts for each vendor.

AP Checks

This query displays a list of checks provided to vendors. It includes information such as vendor name, check number, post date, 1099 code, currency code, and description.

AP Checks Crosstab

This query displays a month by month summary of the checks provided to vendors. Clicking on a month drills down into the details of individual checks provided to a vendor. Information includes the check amount, check number, post date, etc.

AP Aged Payables Drill-Down

This query displays the aged payables for each vendor broken down by different aging periods such as 60 days, 90 days, and 120 days. Clicking on an aging period drills down into individual invoices for a particular vendor.

AP Aged Payables Detail

This query displays the aged payables for each vendor broken down by different aging periods with details for each invoice on the same screen. Clicking on a vendor drills down to more details about each invoice, including the job code and contract code. Drilling down even further, the query displays data about checks applied to a selected invoice.

AP Aged Payables Crosstab

This query displays the outstanding payables for each vendor broken down by due date (month). Clicking on a month drills down into details about specific invoices, their amounts, their due dates, etc.

AP Aged Payables Card View

This query displays the total and outstanding payables, categorized by company.