Follow

Reading your Monthly Ledger Statement (CSV)

This page describes how to read the monthly ledger statements that you export from Bolt in CSV format, which contain transaction-level funding details. If you'd like to learn how to export a monthly ledger statement from your Bolt Merchant Dashboard, see this page. If you're looking for your higher-level monthly summary statement (PDF), see this page.

When you export a monthly ledger statement, each row in the spreadsheet represents a different activity, such as a payment, a credit, or a transfer to your bank. 

The columns in the spreadsheet are as follows:

  • Type - The type describes the activity associated with the funds. The different types are as follows:
    • cc_Payment - Represents the capture of a payment, such as a customer purchase.
    • cc_credit - Represents a credit issued from you to the customer (e.g. refund)
    • merchant_debit - Represents direct debits from your account at the acquiring bank to Bolt, typically due to initiation of non-fraud chargeback disputes.
    • merchant_credit - Represents direct credits to your account at the acquiring bank to Bolt, typically due to the resolution in your favor of non-fraud chargeback disputes.
    • Funding_transfer - Funding represents the transfer of funds from your settled balance to your bank account, which occurs at 1PM PT every business day.
    • Funding_withdrawal - Funding withdrawals represent the transfer of funds from your bank account to Bolt's bank account, in the event that the net settlement is negative (more credits issued than payments placed).
  • Date Authorized (UTC) - The exact date and time at which the payment was authorized, in UTC time zone.
  • Date Captured (UTC) - The exact date and time at which the payment was captured, in UTC time zone.
  • Date Settled (UTC) - The exact date and time, in UTC time zone, at which the payment settled, moving from your unsettled balance to your settled balance.
  • Date Funded (UTC) - The exact date and time, in UTC time zone, at which the transfer to your bank that included the payment was initiated.
  • Date Authorized (Local) - The exact date and time at which the payment was authorized, in your local time zone.
  • Date Captured (Local) - The exact date and time at which the payment was captured, in your local time zone.
  • Date Settled (Local) - The exact date and time, in your local time zone, at which the payment settled, moving from your unsettled balance to your settled balance.
  • Date Funded (Local) - The exact date and time, in your local time zone, at which the transfer to your bank that included the payment was initiated.
  • Transaction Reference - Bolt's 12-digit unique identifier for a transaction. This can be used to search your merchant dashboard for the transaction, and can also be used for reference when receiving support from the Bolt team. Note that multiple activities may be associated with the same transaction reference (e.g. payment and payment settlement).
  • Order Reference - The unique identifier for a transaction, as provided by your shopping cart platform. This reference number can be used to search your shopping cart platform for the transaction. Note that multiple activities may be associated with the same transaction reference (e.g. payment and payment settlement). Additionally, note that funding events will not have an order reference, as they are not logged in the shopping cart platform.
  • Status - The order status of the transaction. 
  • Currency - The currency in which the transaction activity occurred.
  • Total Amount - The total amount of the transaction, gross of Bolt and processing fees.
  • Net Amount - The total amount of the transaction, net of Bolt and processing fees
  • Processing Fee Amount - The total amount of the payment processing fees paid to Bolt on the transaction.
  • Bolt Fee Amount - The total amount of the Bolt fees paid to Bolt on the transaction.
  • Subtotal Amount - The total value of the items ordered, prior to application of shipping, tax, discounts, and fees.
  • Shipping Amount - The total value paid in shipping costs.
  • Tax Amount - The total value paid in sales taxes
  • Discount Amount - The total value subtracted from the order due to discounts
  • Discount Description - The discount code used by the customer to obtain a discount on the order.
  • Customer - The name of the customer who made the purchase
  • Email - The email address of the customer who made the purchase
  • Phone - The phone number of the customer who made the purchase
  • Card Type - The card network associated with the purchase (e.g. Visa, Mastercard, American Express, Discover)
  • Last Four Digits - The last four digits of the credit card that the customer used for purchase.
  • Street - The street address to which the order was shipped
  • City - The city to which the order was shipped
  • State - The state to which the order was shipped
  • ZIP - The ZIP code to which the order was shipped

At the bottom of the spreadsheet, you'll find rows containing:

  • Total Funding - The total amount paid to your account over the course of the month.
  • Total Processing Fees - The total amount paid to Bolt in processing fees over the course of the month.
  • Total Bolt Fees - The total amount paid to Bolt in Bolt fees over the course of the month.
  • Total Payments - Total payments, before fees, paid by your customers over the course of the month.
  • Total Credits - Total credits issued from you to your customers over the course of the month.
The monthly ledger updates as transactions are processed; as a result, the current month's statement always displays month-to-date information. 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments