Skip to main content
Skip table of contents

CSV Connector Onboarding

Not every vendor is supported yet—and some costs still live in internal systems. With Mavvrik’s CSV upload, you can bring those costs into Mavvrik alongside your existing SaaS spend.

Upload a CSV, map the fields once, and your costs will flow into dashboards, allocations, and reports just like any other spend in Mavvrik.

Create new provider & Add Account

  1. Go to Mavvrik portal and click on admin and then SaaS

  2. Click on +Account and then select CSV

  3. Select Provider as Create Provider

  4. Enter the details

  5. Click Next

Enter the account id same as in the csv

image-20260106-071311.png
  1. Upload CSV Cost File, format should be cost-yyyymm

image-20260106-071919.png

After the CSV is uploaded, Mavvrik needs to know which column in your CSV matches each Standard Column used for reporting.

You’ll see a table with:

  • STANDARD COLUMN (Mavvrik’s predefined fields) . Hover on the labels to see the description

image-20260129-070452.png
  • CSV COLUMN (a dropdown where you select the matching CSV header)

Standard column

Required

Explanation (what Mavvrik expects)

Expected format

Example

invoice_month

Billing month the charge belongs to (monthly reporting grouping).

YYYY-MM

2025-12

usage_date

Date the cost/usage occurred (daily trends + allocations).

YYYY-MM-DD

2025-12-15

provider_code

Vendor/provider identifier (consistent code per SaaS).

text

zoom

billing_account_id

Stable ID for the billed subscription/account.

text

SUBZM001

cost

Final cost amount for the row/line item.

number

123.45

unit_of_quantity

Unit that describes what the quantity represents.

text

license

billing_account_name

Friendly name for the billing account.

text

Acme - Zoom Corporate

usage_account_id

Sub-account/workspace/department ID under billing account (if applicable).

text

dept-eng

usage_account_name

Friendly label for the usage account (team/department/workspace).

text

Engineering

location_id

Location identifier (region/site code).

text

us_east1

location_name

Friendly location label.

text

US East

sku_id

Vendor SKU/plan identifier.

text

ZWPROLIC

sku_name

Vendor SKU/plan name (if no stable SKU ID exists).

text

Pro Seat

product_name

High-level product family for grouping.

text

Zoom Workplace

provider_currency

Currency code for the cost values.

ISO currency code

USD

cost_type

Category/type of charge.

text

subscription / usage / tax

amortized_cost

Amortized version of cost (spread across term), if used.

number

100.00

quantity

Number of units billed (pairs with unit_of_quantity).

number

95

Required fields (must be mapped)

Any Standard Column with a * is required. These must have a CSV column selected before data can be processed.

  • invoice_month*

  • usage_date*

  • provider_code*

  • billing_account_id*

  • cost*

  • unit_of_quantity*

✅ For each required row:

  • Click the dropdown in the CSV COLUMN column.

  • Select the CSV header that matches the meaning of the Standard Column.

  • Repeat until all required fields are mapped.

Optional fields (map if available)

These fields are optional, but mapping them improves reporting, filtering, and allocations:

  • billing_account_name

  • usage_account_id

  • usage_account_name

  • location_id / location_name

  • sku_id / sku_name

  • product_name

  • provider_currency

  • cost_type

If your CSV doesn’t have one of these, you can leave it as Select column.

  1. Enter the display name and select a schema for column that has not been mapped.

image-20260106-072104.png
  1. Click Next

  2. Select X-axis, Group By, Filter By, Line Items to Display on SaaS dashboard

image-20260106-072446.png
  1. Click Connect

  2. After connecting, you will be able to see that the account has been onboarded successfully.

image-20260129-070938.png
  1. Click on Upload files icon and check the status of file if its valid or not. If there are any errors, fix the file and upload it again

  2. Same way upload the multiple files for different months

image-20260129-071215.png

Add New Account in existing provider

  1. Go to Mavvrik portal and click on admin and then SaaS

  2. Click on +Account and then select CSV

  3. Select Existing Provider

  4. Enter the details

  • Account ID

  • Account Name

image-20260106-072959.png
  1. Click Connect

  2. Upload the csv files for the new provider

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.