Skip to main content
SubscriptionFlow Docs
Import Usages

Usages Import

Updated usage importusagesusage based billing

This guide walks you through the process of importing usage data for subscription plans tied to usage-based pricing models. Note that usage will fail if the customer, plans, and subscription is not already present in this system. Read about the sequence of imports here.

usage graphic.jpg

Sample File:

Take a look at this sample file for the import of Usages.

Usages Sample File

Step 1: File Preparation

Create a CSV file that contains the following required fields. 

Usage
Subscription* The subscription id this usage is attached to.
Charge* The charge ID (usage-based) that this usage is attached to.
Customer* A unique identifier tying a subscription to a specific customer.
Start Date* Usage is tracked for a period that starts at this date.
End Date* Usage is tracked for a period that ends at this date.
Quantity* A numeric value quantifying usage based on the criterion defined by the plan this subscription is tied to.

Step 2: File Upload

  1. Go to the ‘Usage’ module. If it is not visible simply click the gearbox next to Dashboard and shift it from unselected to selected to make it visible.

  1. Browse a CSV carrying usage data.

  1. Here is some sample usage data.

  1. Upload the file and click ‘Next’.

Upload your Files

On Data Preview & Mapping, click Analyze with AI to let AI clean your file and pre-fill the column mappings, or Skip & Map Manually to map the fields yourself.

AI Data Refinement

Step 3: Field Mapping

  1. The box on the right shows the fields required for mapping a successful import.

Field Mapping

  1. Set the date format and choose advanced settings. Click ‘Next’. To learn more about these settings go to this import guide.

Date format, Save field mapping and Next

  1. In the event of a successful import, navigate to the usages module to see your new usage from import.

Imported records

Imported records

  1. Go to Subscriptions to locate the one with the usage just uploaded. Click on the customer this subscription is tied to.

  1. Scroll down and configure your tabs.

  1. Enable usages to be visible.

  1. The newly imported usage will be visible in this list with a pending status.

Step 4: Trouble Shooting

  1. Once the import is completed, scroll to the right to find if records were successfully imported or updated or failed. Download the errors file to find the cause of record import failure.

Import finished

That is how you import usage. The next time this customer is scheduled to be billed, if the period defined within the usage corresponds to this billing period the system will add these usage-based charged to their invoice.

Was this article helpful?0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.