Skip to main content
SubscriptionFlow Docs
Import Invoices & Transactions

Transactions Import

Updated

SubscriptionFlow allows you to import historical transactions for your records. This guide walks you through the process of importing transactions. Note that customers these transactions are tied to must already exist in the system.

Sample File:

Transactions Import Sample

Step 1: Prepare your file

Prepare your data. Make sure to include the following mandatory fields:

Mandatory Fields

Name Description Example
Name An identifier label TR_001
Amount The quantity transacted. 120
Customer ID A 25 character string that identifies a customer within the system. 2bfd07aa-e055-467a-8381-edf7d7960f9e
Transaction Category The category of transaction which may be Payment, Payout, Write-Off or Credit-Note. Payment
Transaction Type This is the type of transaction which may be payment or refund - the two transaction types. Refund
Status The status may be Paid, Pending, Declined, Failed. Paid
Currency The currency of the transaction USD
Payment Source A text descriptor of the payment mode. Cash
Unapplied Amount If not linked to an invoice this transaction can correspond to an unapplied amount that can be applied to future invoices 50
Invoice ID A 36 character string that identifies an invoice in the system. 66728254-50a3-4209-8dff-b7d2f7e3bd02
Payment Method ID To identify a specific payment method in the system against other payment methods. ccof:CA4SEDfxxqF8zeYK5HwfJJMbRCQoAg
Transaction ID A unique 35 character string to map relevant transactions in the system. 65e55004-2630-42af-bd66-32caf772d69b

**Note:**To import a refund the Category is set to Payment and the Type is set to Refund. To import a credit note set to Payment and the Credit-Note is set to Transaction.

You may also add optional fields such as miscellaneous charges, , reference, payment method ID and transaction ID.

Export your data to CSV; only CSV files are supported.

Step 2: Upload the file

  1. Open Transactions (if you don't see it, click Customize Navigation at the bottom of the left menu and move it to the visible modules). Click More, then Import. Import Data opens.

Import in the Transactions More menu

  1. Under Manual Import, click the CSV / XLS card. Click Browse Files, upload your file and click Next.

Upload your Files

  1. Click Skip & Map Manually (or Analyze with AI to let AI clean the file and suggest mappings), then Next.

Data Preview & Mapping

Step 3: Map the file

  1. Transactions isn't shown on File(s) Mapping by default. Click Configure.

File(s) Mapping

  1. In Customize Import Modules, select Transactions under Hidden Modules, click the right arrow to move it to Visible Modules, and click Save Changes. You only need to do this once.

Customize Import Modules

  1. Transactions now appears as a module. Drag your file from Unmapped Files onto Transactions, then click Next.

Transactions module on File(s) Mapping

  1. On Field Mapping, check that each column is mapped to the right SubscriptionFlow Property, for example Customer ID to Customer and Transaction Type to Type. Click Next.

Field Mapping

  1. Review Mapping shows the mapped fields. Click Next to start the import.

Review Mapping

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.