EasyUC
English
Aurora

Choose appearance

4.8.7

Reports and analysis

Create an itemized bill

Display the calls of one or more numbers and output them as PDF, CSV or Excel.

EasyUC · Version 4.8.7

In EasyUC: EasyUC Cisco → Reporting → Itemized Bill

What it is for

The itemized bill lists all calls of one or more numbers within a period. It is built from the CDRs of the active CUCM connection and is used, for example, for cost centre billing or for providing information to a line owner.

The output is shown on screen and is available as PDF, CSV or Excel. A layout determines the appearance and the columns. Numbers of the other parties are shown masked as long as the permission for full numbers is missing.

Prerequisites

  • Licence module cucm and a working CDR import.
  • Permission View Itemized Bill Page (ROLE_APP_VIEW_ITEMIZED_BILL_PAGE) for the page and Create and Export Itemized Bills (ROLE_APP_EXPORT_ITEMIZED_BILL) for query and export.
  • For unmasked numbers Show Full Numbers in Itemized Bills (ROLE_APP_ITEMIZED_BILL_UNMASKED).
  • The numbers are in locations that your account is allowed to access.

Step by step

  1. Open Reporting → Itemized Bill.
  2. Under Numbers, search for a line or enter a number. Repeat this for further numbers.
  3. For many numbers, click Paste a list of numbers, paste one number per line or separated by commas and click Add.
  4. Select the Period with start and end, or click This Month, Last Month, Last 7 days or Last 30 days.
  5. Select the Layout.
  6. If required, open Filter and restrict direction, answered state, internal/external and minimum duration.
  7. Click Show. The page shows the totals, the Per number table and the individual calls.
  8. Click Load more to load further rows.
  9. Click PDF, CSV or Excel to download the file.

Fields and options

Field / actionMeaning and use
NumbersUp to 200 numbers per itemized bill.
Period366 days at most.
LayoutDetermines columns, cover page, header and footer, logo and masking. The default layout is preselected.
Show full numbers of other partiesOnly visible with the permission Show Full Numbers in Itemized Bills.
DirectionAll, Outgoing, Incoming.
AnsweredAll, Answered, Not answered.
Internal / externalAll, Internal, External.
Minimum duration (s)0 to 86400 seconds.
Number matchingExact or Trailing digits.
Include forwarded callsIncludes calls that were forwarded via the number.
Export limitsPDF up to 5,000 calls, Excel up to 50,000, CSV up to 1,000,000.

Check the result and troubleshoot

  • The key figures show Calls, Answered, Not answered, Outgoing, Incoming, Forwarded and Total Duration.
  • "No calls in the selected period.": Check the period, the number matching and the CDR import.
  • "The period contains … calls, more than the … a file of this type can hold. Use CSV or a shorter period."
  • "These numbers are outside your locations: …": Your account has no access to the location of the number.
  • "An export of yours is still running. Please wait until it has finished.": Only one export runs per account at a time.
  • "PDF export is not available on this server. Use CSV or Excel."
  • "Full numbers require the right "Show Full Numbers in Itemized Bills".": Without this permission, at least the last 3 digits of external numbers stay masked.
  • A note on the import status states the time up to which call data has been imported. Later calls are then still missing.

Related chapters