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

Go to Mavvrik portal and click on admin and then SaaS
Click on +Account and then select CSV
Select Provider as Create Provider
Enter the details
Click Next

Enter the account id same as in the csv

Upload CSV Cost File, format should be cost-yyyymm

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

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.

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

Click Next
Select X-axis, Group By, Filter By, Line Items to Display on SaaS dashboard

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

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
Same way upload the multiple files for different months

Add New Account in existing provider

Go to Mavvrik portal and click on admin and then SaaS
Click on +Account and then select CSV
Select Existing Provider
Enter the details

Account ID
Account Name

Click Connect
Upload the csv files for the new provider