Using Client Reports Estimated Reading Time: 4 Minutes What client reports are available in Ubersmith? In Reports & Stats, Client Manager the following report types are available: Invoice Print Queue This report shows all invoices marked as 'queued'. You can generate .pdf files of one or more invoices, which changes the status of those invoices to 'printed'. Invoice/Renewal Calendar This report shows a calendar breakdown of number of invoices issued and amounts invoiced for both service starts and renewals. Values for future dates are based on expected service renewals and scheduled invoices. Charge Queue Manager This report shows all queued credit card charges. Charges are queued for one of two reasons: a previous attempt failed. a charge was scheduled for a later date. Renewal Queue Manager This report shows the list of services that are eligible for renewal. Renewals happen automatically, so this list is empty unless a given service failed to renew for one reason or another. The most common cause of a service not renewing is a service module function failing at renewal time. Charge Log This report shows the list of all charge attempts made during a specified time period. You can view either successful or declined charges, and filter by card type. Charge History This report shows a calendar breakdown of accepted and declined charge attempts. Expired Credit Cards This report lists credit cards according to their expiration status: Expired Credit Cards Unexpired Credit Cards Credit Cards Expiring Soon (within the next four months) Credit Cards Expired as of a selected date Payments Received This report lists and totals payments received, filtered by date and type. You can view the payment list for any date range to show which service items were paid over that period. This report includes any payments directly received as well as account credits from actual payments (check, cash, wire transfer etc). It does not include account credits that do not represent actual money received, such as refunds. Taxes Collected This report lists and totals payments applied to taxes on invoices, filtered by date and type. Taxes Refunded This report lists and totals any tax line items that had a refund applied to them, filtered by the specified date range. Taxes Invoiced This report lists and totals any tax line items that have been invoiced, paid or not, filtered by the specified date range. Tax Exemptions This report lists all tax exemptions, filtered by exemption status (Pending Approval, Active, Deactivated). You can change the status of any exemption shown. Refunds This report lists and totals any refunds issued. It is limited to those refunds that represent the reversal of an actual payment received from the client, or deactivation of applied credits that represent actual money received (check, cash, wire transfer etc). You can view the refund list for any date range to show which service items were refunded over that period. Service Status This report lists all the service status changes (Active, Pending, Suspended, Canceled, Deactivated), filtered by date range. This data is taken from the event log and does not necessarily reflect the current status of a given service. Service Plans This report lists the number of active services for each service plan, with the total dollar value in payments that have been received for each. Service Cancellations This report lists the services that are currently set to Canceled, filtered by date range and service plan, with the total dollar value of each. Normalized Recurring Revenue This report shows a calendar-based breakdown of the normalized dollar value of service renewals. The normalized value is the total value of the service renewal, divided by the number of months in the renewal period. Outstanding Services This report lists the service line items that currently appear in outstanding invoices, including the auto-suspend and auto-cancel dates for each line item. Sent Invoices This report lists and totals all invoices (paid or unpaid), filtered by date range. You can view the invoices list for any date range to show which service items were invoiced over that period. Revenue by Location This report shows the total dollar value for all services tied to a specific facility, as defined in the device manager. The values can be filtered by services invoiced, or services with payments applied. Top Customers This report ranks active clients, filtered by specific metrics (Services Invoiced, Payments Received, Number of Late Payments, Number of Services, and Client Since) and date range. Credits Issued This report lists and totals account credits started during the specified date range. The "Company Issued" column represents account credits that do not represent actual money being received from the client, such as refunds. The "Payments Received" and "Payment Gateway" columns represent account credits for actual payments received (check, cash, wire transfer etc).