All topics
English

Build and use reports · 3 min read

Export reports and resolve unexpected results

Download Excel or CSV and verify scope, unit, access and limits before using the file.

In this guide
  1. Export the current scope
  2. Choose a format and recognize limits
  3. Use reports in agency routines
  4. Investigate unexpected figures
  5. If a report or action is missing
  6. Keep learning

For: CRMDAY One users with the Insurance profile.

Export the current scope

  1. Open the saved report and check applied filters.
  2. Adjust sorting and temporary conditions if needed.
  3. Click Export.
  4. Choose Excel (.xlsx) or CSV.
  5. Open the download and compare headings, unit, count and values.

Export uses the current scope and is not automatically limited to the visible 25-row page. It requires module export permission; related contact fields also require the corresponding Contacts export access.

Export menu with Excel and CSV in a saved report.
Export menu with Excel and CSV in a saved report. Open the image to enlarge it.

Choose a format and recognize limits

Format or typeConsideration
ExcelFormatted sheet with title, context, header filters and typed numbers, currencies and dates.
CSVUTF-8 text using displayed labels and presentation; check delimiter/import settings.
TableUp to 10,000 rows. Refine filters if a truncation notice appears.
Summary / MatrixExports result groups, not automatically every individual record.
MembersPerson rows arranged by policy; the file limit counts people and can cut a block.

The file is a snapshot at export time and does not update with the book. Store and share it only with appropriate recipients.

Use reports in agency routines

RoutineStarting definition
Document follow-upPolicies Table with Pending DMI greater than zero; add criteria for other document needs.
RenewalsExpiration-date range with contact and owner.
Portfolio meetingActive policies Summary by carrier with count and net premium sum.
WorkloadOpen Tasks by owner template, refined by available board, stage or due date.
SalesDeals by stage or won by month; check pipeline, status, date and amount.

Open the record to take action in its module. Filtering or exporting does not send messages or move Tasks.

Investigate unexpected figures

  • Check module and whether the unit is record, policy or member.
  • Review all versus any conditions, dates and status.
  • Separate count, sum and average; avoid double-counting subtotals.
  • Compare identical queries and access.
  • Check blanks, related-contact links and unfilled fields.
  • Read limited-group or omitted-column notices; narrow broad queries.

Unavailable fields used in filters, metrics or groups can block execution. Do not remove a condition simply to run the report without understanding the expanded scope.

If a report or action is missing

Confirm active organization, sharing, plan modules and permissions with the administrator. Reports is unavailable in delegated access. Protected fields may be hidden or masked; export scope can differ from viewing access.

For help, provide report name, module, type, filters, expected result and warning without unnecessary personal data. Return to format selection or member analysis when counts do not mean policies.

Keep learning

Updated October 25, 2026.