Reading your Daily Bank Transfer Statement (CSV)

This page describes how to read the daily bank transfer statements that you export from Bolt, so that you may understand the details of transactions that were included in a transfer to or from your bank account. If you'd like to learn how to export a daily bank transfer statement from your Bolt Merchant Dashboard, see this page.

When you export a daily bank transfer statement, each row in the spreadsheet represents a different transaction that occurred through Bolt. Note that only captured transactions are included, as transactions that have been authorized but not captured are not part of the funds transfer. If a transaction is partially captured, only the amount that was captured and included in the transfer will display in the bank transfer statement.

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 a row for the total. This total row will include the total net amount, total processing fee amount, total Bolt fee amount, and total gross amount. 

The total net amount will match the value of the transfer in the Bolt Merchant Dashboard, and is the amount that you should expect to see deposited into or withdrawn from your bank account when the transfer is complete.