Reports

Monthly invoiced SIMs

The Monthly invoiced SIMs report is a dashboard showing SIMs that were active and billed during a selected month. Use this report to reconcile SIM-level billing, review active SIM trends, inspect data plan fees and pooled allowances, and export invoiced SIM details.

This dashboard counts any SIM that was active at any point during the selected month as invoiced for that month. A SIM that was active at the start of the month and later suspended is still counted here, whereas the SIM list report shows that SIM’s current state (suspended).

Questions this report answers

  • How many SIMs were invoiced for a given month?
  • How has my invoiced SIM count changed month over month?
  • Which data plans are my active SIMs on, and what are the associated fees?
  • What is the pooled data allowance and SIM count for each data plan?
  • When was a specific SIM first activated?
  • Which coverage policy is each invoiced SIM mapped to?
  • Can I export a full list of invoiced SIMs with their endpoint and billing details?
1

Log in to your emnify account.

2

Navigate to Reports.

3

Select Monthly invoiced SIMs from the report list.

Available data

NameTypeDescription
Active SIMsTileTotal count of SIMs that were active for the selected month.
Active SIMs MonthlyBar chartactive_sim_count per month. Use the All and Inv toggles to switch between all and inventory SIMs.
Data Plan Pooled Allowance including FeesTableData plans broken down by pooled allowance, SIM count, and fees. See Data plan pooled allowance.
First SIM Activation DateTableFirst activation date for each SIM. See First SIM activation date.
SIM to Coverage Policy MappingTableEach SIM mapped to its assigned coverage policy. See SIM to coverage policy mapping.
Active Sims- Overview including FeesTablePer-SIM detail with data plan, fees, endpoint, and tag details for every active SIM in the selected month. See Active SIMs overview including fees.

Data plan pooled allowance

Table breaking down the data plans used by SIMs that were active for the selected month.

ColumnDescription
data_plan_nameName of the data plan
sim_hosting_feePer-SIM hosting fee for the plan
data_plan_feeMonthly data plan fee
currencyCurrency the fees are billed in (for example, EUR)
data_per_sim_in_mbData allowance per SIM, in MB
sim_countNumber of active SIMs on this data plan
pooled_allowance_in_mbTotal pooled allowance across all SIMs on this plan (MB)

First SIM activation date

Table listing the first activation date for each SIM up to the selected month.

ColumnDescription
organisation_nameOrganization the SIM belongs to
sim_idUnique SIM identifier
first_activation_dateDate the SIM was first activated

SIM to coverage policy mapping

Table mapping each invoiced SIM to its assigned coverage policy.

ColumnDescription
organisation_nameOrganization the SIM belongs to
sim_idUnique SIM identifier
coverage_policyName of the coverage policy assigned to the SIM
updated_atDate the coverage policy mapping was last updated
sim_total_coverage_policyTotal number of coverage policies assigned to the SIM

Active SIMs overview including fees

Detailed table listing every SIM that was active for the selected month with its data plan, billing, and endpoint details.

ColumnDescription
data_plan_nameName of the data plan assigned to the SIM
tariff_profile_nameName of the tariff profile assigned to the SIM
allowance_in_mbData allowance for the plan, in MB
data_plan_feeMonthly data plan fee
sim_hosting_feePer-SIM hosting fee
currencyCurrency the fees are billed in (for example, EUR)
device_portal_urlDirect link to the device’s page in the Portal
sim_idUnique SIM identifier
activation_monthMonth the SIM was active (matches the Active Month filter)
imeiInternational Mobile Equipment Identity (N/A if not available)
iccidSIM card identifier (ICCID)
endpoint_nameName of the endpoint the SIM is assigned to
tagsComma-separated tags applied to the SIM or endpoint
organisation_nameOrganization the SIM belongs to

Each table can be sorted by any column and includes a search bar and a dropdown to show 10, 20, 50, 100, or 200 (default) entries.

Filters

FilterRequiredValueDefaultDescription
Active MonthYesDate pickerCurrent monthSelect the billing month to report on (in YYYY-MM-01 format, for example, 2026-04-01). The dashboard counts SIMs that were active at any point during this month.
WorkspaceNoPredefinedNoneSearchable dropdown listing the Workspaces you have access to. Only available with multiple Workspaces.
Tag NameNoPredefinedNoneFilter by SIM or endpoint tag name.
Tag Filter CriteriaYesPredefinedExact Combination
  • Exact Combination: all selected tags must be present per SIM (for example, if you select tag1 and tag2, both must be present along with other possible tags).
  • Partial Combination: at least one selected tag must be present (for example, if you select tag1 and tag2, either or both must be present for each SIM).

Apply filters

1

Click the filter icon at the top of the report to open the Filters panel.

2

Set your desired filters. Select the Active Month (required) to choose the billing month to report on. Use the Workspace and Tag Name dropdowns to narrow results. If filtering by tags, choose a Tag Filter Criteria to control how tags are matched.

3

Click Apply Filters to update the report.

To reset all filters, click Clear all.

Download report data

To download the full report (up to 500,000 rows), use the Active Sims- Overview including Fees table’s download menu and choose Export to .CSV.

Each chart and table in this report includes a menu (vertical dots icon) with download options.

1

Click the vertical dots icon on the chart or table you want to download.

2

Select Download, then choose a format:

  • Export to .CSV — download as a comma-separated values file
  • Export to Excel — download as an Excel spreadsheet
  • Download as image — save a screenshot of the chart or table

The same menu also provides Force refresh to reload the data and Enter fullscreen to expand the chart or table.