Skip to main content

Available Columns by Report Type

info

Refer below for a list of all available columns for each report type, along with a short descriptive text and API codes. For column definitions, please refer here.

Reconciliation Report​

Metadata
  • API Code: ReconciliationReport
  • Description: Reconcile between Splitit internal records and gateway transactions
  • Merchant Name
  • Plan Number
  • Gateway Transaction Timestamp
  • Funding Type
  • Gateway Transaction ID
  • Gateway Transaction Amount
  • Gateway Transaction Type
  • Gateway Transaction Currency
  • Installment Number
  • Number Of Installments
  • Is Full Captured
  • Order Number
  • Card Brand
  • Card Type
  • Terminal Name
  • Plan Amount
  • Shopper Name
  • Shopper Email
  • Account Id
  • Account Name
  • Legal Business Name

Daily Activity Report​

Metadata
  • API Code: daily_activity_report
  • Description: Plan-level activity view for the selected period
  • Legal Business Name
  • Account name
  • Account Id
  • Plan Number
  • Order Number
  • Activity
  • Activity Date
  • Status
  • Installment Number
  • Amount
  • Currency
  • Fail Reason
  • Platform
  • Additional Identifier

Plan Details​

Metadata
  • API Code: NewPlans
  • Description: New installment plans generated during selected time frame
  • Plan Number
  • Order Number
  • Created Date
  • Total Plan Amount
  • Currency
  • Plan Status
  • Merchant Name
  • Number of Installments
  • Business Unit Name
  • Card Type
  • Card Brand
  • Shopper Name
  • Shopper Email
  • Funding Type
  • Terminal Name
  • Plan On Hold
  • Paid Installments
  • Delayed Installments
  • Outstanding Installments
  • Outstanding Amount
  • Credit Refund Amount
  • Non Credit Refund Amount
  • Plan Created by
  • Plan End Date
  • Agent Name
  • First installment amount
  • First installment date
  • Account Id
  • Account Name
  • Legal Business Name
  • Shopper Address Country
  • Shopper Address State
  • Plan Allocation

Notification Of Fraud Report​

Metadata
  • API Code: NotificationOfFraudReport
  • Description: Notification of fraud report
  • Account Id
  • Account Name
  • Legal Business Name
  • Notification Date
  • Card Brand
  • Card Type
  • Fraud Amount
  • Currency
  • Plan Number
  • Order Number
  • Plan Status
  • Plan Original Amount
  • Number Of Installments
  • Installment Amount
  • Installment Number
  • NOF Reason Code
  • NOF Reason Description
  • Shopper Email
  • Shopper Name

Shopper Outstanding Report​

Metadata
  • API Code: MerchantPlanOutstandingAmountReport
  • Description: Shopper outstanding
  • Report Date
  • Business Unit
  • Merchant
  • Installment Plan Number
  • Total Plan Amount
  • Order Number
  • Plan Activation Date
  • Currency
  • Number Of Installments
  • Plan Status
  • Paid Amount
  • Outstanding Amount
  • Paid Installments
  • Outstanding Installments
  • Last Collection Date
  • Amount For Next 0 To 30 Days
  • Amount For Next 31 to 60 Days
  • Amount For Next 61 To 90 Days
  • Amount For Next 91 Plus Days
  • Account Id
  • Account Name
  • Legal Business Name

Pending CC Report​

Metadata
  • API Code: PendingCC
  • Description: Pending CC report
  • Merchant Name
  • Business Unit
  • Plan Number
  • Order Number
  • Created Date
  • Currency
  • Original Amount
  • Number of Installments
  • Paid Installments
  • Outstanding Installments
  • Delayed Installments
  • Outstanding Amount
  • Plan on Hold
  • Card Type
  • Card Brand
  • Shopper Name
  • Shopper Email
  • Funding Type
  • Account Id
  • Account Name
  • Legal Business Name
  • Plan Allocation

Refund Report​

Metadata
  • API Code: RefundReport
  • Description: Refund Report
  • Legal Business Name
  • Account Name
  • Account id
  • Refund Date
  • Plan Number
  • Refund id
  • Number Of Installments
  • Amount
  • Currency
  • Credit Refund Amount
  • Refund - Plan Reductions

Chargeback Report​

Metadata
  • API Code: ChargebackReport
  • Description: Disputes status for each merchant
  • Plan Number
  • Plan Created Date
  • Plan Status
  • Order Number
  • Chargeback Amount
  • Installment Amount
  • Currency Code
  • Chargeback Type
  • Case Number
  • External Chargeback Id
  • Reason Code
  • Reason Description
  • Chargeback Status
  • Chargeback Created Date
  • Chargeback Due Date
  • Plan Amount
  • Chargeback Installment Number
  • Number Of Installments
  • Card Brand
  • Is Pre-Arbitration
  • Account Id
  • Account Name
  • Legal Business Name
  • Capture Date

Settlement Report Summary​

Metadata
  • API Code: SettlementReportSummary
  • Description: Highlights the net settlement amount, which represents the actual funds deposited into your bank account
  • Merchant
  • Settlement Date
  • Total Line Items
  • Gross Settlement Amount
  • Total Fees
  • Tax
  • Net Settlement Amount
  • Invoice ID
  • Reserve
  • Account Id
  • Legal Business Name

Settlement Report Details​

Metadata
  • API Code: SettlementReport
  • Description: Transaction-level breakdown providing in-depth insights of your financial activity (from new plans to refunds and chargeback resolutions)
  • Merchant
  • Business Unit
  • Business Unit ID
  • Plan Number
  • Order Number
  • Number of Installments
  • Plan Created Date
  • Activity Date
  • Ref Transaction ID
  • Transaction Type
  • Installment Number
  • Plan Currency
  • Original Plan Amount
  • Transaction Amount
  • Exchange Rate
  • Exchange Rate Date
  • Settlement Currency
  • Gross Settlement Amount
  • Variable Fee
  • Fixed Fee
  • Net Settlement Amount
  • Settlement Date
  • Invoice ID
  • Shopper Name
  • Shopper Email
  • Card Brand
  • Card Type
  • Terminal api key
  • Terminal name
  • Tag1
  • Tag2
  • Account Id
  • Account Name
  • Legal Business Name

Settlement Report Gross - Debit​

Metadata
  • API Code: SettlementReportMerCollection
  • Description: Settlement Report Gross - Debit
  • Merchant
  • Business Unit
  • Business Unit ID
  • Plan Number
  • Order Number
  • Number of Installments
  • Plan Created Date
  • Activity Date
  • Ref Transaction ID
  • Transaction Type
  • Installment Number
  • Plan Currency
  • Original Plan Amount
  • Transaction Amount
  • Exchange Rate
  • Exchange Rate Date
  • Settlement Currency
  • Variable Fee
  • Fixed Fee
  • Gross Settlement Amount
  • Net Settlement Amount
  • Settlement Date
  • Invoice ID
  • Shopper Name
  • Shopper Email
  • Card Brand
  • Card Type
  • Account Id
  • Account Name
  • Legal Business Name

Standard Merchant Fee Report​

Metadata
  • API Code: StandardMerchantFeeReport
  • Description: Transaction-level breakdown providing in-depth insights of your financial activity (from new plans to refunds and chargeback resolutions)
  • Merchant
  • Business Unit
  • Plan Number
  • Order Number
  • Number of Installments
  • Plan Created Date
  • Activity Date
  • Payment Type
  • Ref Transaction ID
  • Installment Number
  • Plan Currency
  • Original Plan Amount
  • Transaction Amount
  • Exchange Rate
  • Exchange Rate Date
  • Settlement Currency
  • Converted Transaction Amount
  • Variable Fee
  • Fixed Fee
  • Total Fees
  • Invoice Date
  • Invoice ID
  • Account Id
  • Account Name
  • Legal Business Name

Standard Merchant Fee Report Summary​

Metadata
  • API Code: StandardMerchantFeeReportSummary
  • Description: Highlights the net settlement amount, which represents the actual funds deposited into your bank account
  • Merchant
  • Invoice Date
  • Total Line Items
  • Converted Transaction Amount
  • Total Fees
  • Tax
  • Net Settlement Amount
  • Invoice ID
  • Account Id
  • Legal Business Name

Merchant Balance​

Metadata
  • API Code: MerchantBalanceReport
  • Description: Merchant balance
  • Legal Business Name
  • Account Name
  • Account id
  • Plan Number
  • Order Number
  • Plan Created Date
  • Settlement Currency
  • Funding Category
  • Gross Amount
  • Funded Amount
  • Total Plan Fees
  • Yet To Be Paid
  • Refund Amount
  • Chargeback Amount
  • Chargeback Reserve Amount
  • Pre Chb Refund Amount
  • CHB Cancelation Amount