> ## Documentation Index > Fetch the complete documentation index at: https://docs.sezzle.com/llms.txt > Use this file to discover all available pages before exploring further. # Understanding the Sezzle Transaction Report > What every worksheet and column in your Sezzle Transaction Report means, how funds reach your bank, and how to trace an order. The Transaction Report details all the financial transactions for your store that occur within Sezzle: orders, refunds and disputes, as well as settlements and withdrawals from your Sezzle account to your company's bank account. > **Trace an order** > > Confirm you received the funds for a specific order, step by step. > **Understand your payouts** > > How orders become settlements, withdrawals, and deposits to your bank. > **Look up a worksheet** > > What every tab and column in your report means, in plain language. ## Overview The report includes a variety of worksheets (tabs) to help organize the data for easier reconciliation. Depending on your store's integration with Sezzle, you may not have all the worksheets listed in this guide. ### How funds flow For most Sezzle merchants, funds are paid out in three stages: > **1. Orders** > > Orders become Settlements (Payouts). > **2. Settlements** > > Settlements become Withdrawals. > **3. Withdrawals** > > Withdrawals are sent to your linked bank account. Trace these stages in the report: Orders → Withdrawal Account Ledger (or the Interest Account Ledger if you're on the Interest Plan). > [!NOTE] > > **Report file naming.** Previously the report was appended with the generation date. It now includes the *from* and *to* dates of the data in the report. > [!NOTE] > > **Split by shopper currency.** The Orders, Virtual Card Orders, Captured Orders Breakdown, Refunds, Disputes, Withdrawal Account Ledger, and Interest Account Ledger worksheets are split by shopper currency. If your store had orders paid in both USD and CAD within the requested period, you'll see two sheets instead of one, for example "Orders - USD" and "Orders - CAD". ## Worksheet directory Every worksheet in the report, what it's for, and which integration or program it applies to. Select a worksheet for its full column-by-column definitions. | Worksheet | Applies to | Purpose | | - | - | - | | Orders | Direct Integration | Orders that have been processed through Sezzle, including captured, uncaptured, paid out (settled) and pending payouts. | | Captured Orders Breakdown | Direct Integration Virtual Cards | Breakdown of all orders that were captured into captures and fees. | | Virtual Card Orders | Virtual Cards | Orders that have been initiated through the Sezzle Virtual Card. | | Fee Collection History | Virtual Cards | Daily fees on virtual card activity and applicable daily fee refunding. | | Refunds | Direct Integration | Shows all orders that have been refunded through Sezzle. | | Disputes New | Direct Integration Virtual Cards | Shows all disputes opened on your orders — both open and closed — with their current status. | | Withdrawal Account Ledger | Direct Integration Virtual Cards | Shows all transactions that affect the Withdrawal Account balance. | | Interest Account Ledger | Direct Integration Virtual Cards | Shows all transactions that affect the Interest Account balance. | | Reserve | Optional | Events tied to the Rolling Reserve, from either holding of funds or release of funds. | | Referral | Affiliate | Events tied to referrals. | ## Worksheet reference Column-by-column definitions for every worksheet. ### Orders Direct IntegrationDashboard: OrdersSplit by shopper currency * Contains details for all orders processed through Sezzle. * Directly corresponds to the “Orders” page within the Sezzle dashboard. | Column title | Purpose | | - | - | | **Order Created Date** | Date when the shopper successfully completed a Sezzle checkout and a Sezzle order was placed | | **Order Created Time** | Time when the shopper successfully completed a Sezzle checkout and a Sezzle order was placed | | **Order Captured Date** | Date the order was captured by the merchant | | **Order Captured Time** | Time the order was captured by the merchant | | **Sezzle Order ID** | Order ID created by Sezzle — it is a unique Sezzle identifier | | **Sezzle Order UUID** | Order UUID used in the Sezzle API (used for capture or reauthorization, see docs.sezzle.com) | | **Order Status** | Current status of the order within Sezzle Order can be in either of the following states: Pending · Approved · Approved, with Refund · Authorized, pre-capture · Authorization expired/canceled | | **Reference ID** | Order ID that Sezzle received from your e-commerce platform (typically directly corresponds to the order ID within your order management system) | | **Customer Name** | Name of the customer per their Sezzle account This may not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Customer Email** | Email of the customer per their Sezzle account This may not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Order Total** | Amount the customer paid at checkout — the order total, before any Sezzle fees | | **Capture Order Total** | Amount of the total order that has been captured by the merchant before the Sezzle fees are subtracted | | **Release Order Total** | Amount of the total order that has been either released by the merchant or expired due to the authorization expiry date | | **Sezzle Fee** | Total fee amount that was charged for this order | | **Fee Refunded** | If applicable, amount of the fee refunded to you on an order that has been refunded | | **Net Order Total** | Amount settled to your account for the order Orders that have not been refunded: Order Total − Sezzle Fee Orders that have been refunded: Capture Order Total − Sezzle Fee − Total Refund Amount + Fee Refunded Will not include any FX fees, as those are applied on a withdrawal basis Virtual Card orders and fees may show up differently | | **Total Refund Amount** | Total amount of all refunds issued If multiple refunds were issued on an order, this will show the combined total For specifics on individual refunds, you can review the Refunds worksheet | | **Order Purchase Currency** | Currency that the shopper used to pay for the order | | **Order Total in Merchant Currency** | Gross amount of the order in the currency of the store If the shopper’s currency and the store’s currency are the same, there will be no difference in the two gross amounts | | **Merchant Currency** | Currency of the store | | **Authorized Amount Total** | A sum of all checkout authorizations of an order | | **Authorization Expiration** | Date at which an authorization on an order is set to expire. If multiple authorizations per order exist, the latest authorization date is displayed. A merchant must capture the order before the authorization expiry | | **Settlement Date** | Date of the earliest settlement for any of the captures of the order in a given row | | **Settlement Status** | Can be “Not settled” (none of the order’s captures are paid out), “In progress” (some of the order’s captures are paid out) or “Completed” (all of the order’s captures are paid out) | ### Captured Orders Breakdown Direct IntegrationVirtual CardsSplit by shopper currency * Breakdown of all orders that were captured into captures and fees. | Column title | Purpose | | - | - | | **Type** | Type of row we are showing: Order, Capture, Fee | | **Created Date** | Date that Sezzle created the order | | **Captured Date** | Date that Sezzle captured the order | | **Platform Order ID** | Unique ID that the merchant is given for a session (i.e. new checkout) request | | **Sezzle Order ID** | Order ID created by Sezzle | | **Shopper Order ID** | Total number of orders placed by the shopper of the current order (just after placing the order) | | **Product Type** | Type of Sezzle product used for the order (Affiliate, Gift Card, Standard Checkout, Long Term Lending, Virtual Card, Four Pay Monthly, Six Pay Monthly) | | **Reference ID** | Order ID received by Sezzle from your e-commerce platform (typically directly corresponds to the order ID within your order management system) | | **Amount** | Total amount of that part of the transaction | | **Order Purchase Currency** | Currency that the shopper used to pay for the order | | **Merchant Currency** | Currency of the store | | **Transaction\_UUID** | Unique ID for the capture | ### Virtual Card Orders Virtual CardsDashboard: OrdersSplit by shopper currency * Contains details for virtual card orders initiated by Sezzle. * Directly corresponds to the “Orders” page within the Sezzle dashboard. | Column title | Purpose | | - | - | | **Order Created Date** | Date that shopper completed a Sezzle checkout and placed a Sezzle order | | **Order Created Time** | Time that shopper completed a Sezzle checkout and placed a Sezzle order | | **Order Captured Date** | Date that Sezzle captured the order | | **Order Captured Time** | Time that order was captured by Sezzle | | **Sezzle Order ID** | Order ID created by Sezzle — it is a unique Sezzle identifier | | **Order Status** | Current status of the order within Sezzle Order can be in either of the following states: Pending · Approved · Approved, with Refund · Authorized, pre-capture · Authorization expired/canceled | | **Reference ID** | ID of the terminal the virtual order transaction took place | | **Customer Name** | Name of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Customer Email** | Email of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Sezzle Fee** | Total fee amount that was charged for this order | | **Fee Refunded** | Amount of the fee refunded to you on an order that has been refunded | | **Order Total** | Gross order amount | | **Capture Order Total** | Amount of the total order that has been captured by the merchant before the Sezzle fees are subtracted | | **Release Order Total** | Amount of the total order that has been either released by the merchant or expired due to the authorization expiry date | | **Net Order Total** | Amount settled to your account for the order Orders that have not been refunded: Gross Order Total − Sezzle Fee Orders that have been refunded: Gross Order Total − Sezzle Fee − Total Refund Amount + Fee Refunded Will not include any FX fees, as those are applied on a withdrawal basis Virtual Card orders and fees may show up differently | | **Total Refund Amount** | Total amount of all refunds issued If multiple refunds were issued on an order, this will show the combined total For specifics on individual refunds, you can review the Refunds worksheet | | **Order Purchase Currency** | Currency that the shopper used to pay for the order | | **Order Total in Merchant Currency** | Gross amount of the order in the currency of the store If the shopper’s currency and the store’s currency are the same, there will be no difference in the two gross amounts | | **Merchant Currency** | Currency of the store | | **Authorized Amount Total** | A sum of all checkout authorizations of an order | | **Authorization Expiration** | Date at which an authorization on an order is set to expire. If multiple authorizations per order exist, the latest authorization date is displayed. A merchant must capture the order before the authorization expiry | | **MID** | MID that the order originated from Ties only to virtual card orders | | **Card Network Auth Ref** | Reference number for the card authorization Ties only to virtual card orders | ### Fee Collection History Virtual Cards * Shows Sezzle Virtual Card fees assessed (if applicable). * Handled outside of the typical settlement process. | Column title | Purpose | | - | - | | **Fee Collection ID** | Contains the ID of the virtual card fee collected | | **Transaction Date** | Date the virtual card transaction occurred | | **Total Amount** | Amount of fees collected on a fee collection ID | | **Currency Code** | Currency of the event | | **For Fees Assessed On** | Date the virtual card fees were calculated | | **Debit Status** | For direct bank debit transactions, it shows the bank transaction status: in progress, succeeded, failed, or scheduled. For the other fee collection methods, it shows “scheduled” because there is no bank transaction — Sezzle simply updates the balance of the Sezzle holding account. | ### Refunds Direct IntegrationDashboard: RefundsSplit by shopper currency * Contains all refunds that have been processed through Sezzle. * Includes partial and full refunds and corresponds to the “Refunds” page within the Sezzle dashboard. | Column title | Purpose | | - | - | | **Refund Date** | Date refund was processed by Sezzle | | **Refund Time** | Time refund was processed by Sezzle | | **Sezzle Order ID** | Order ID created by Sezzle | | **Reference ID** | Order ID received by Sezzle from your e-commerce platform (typically directly corresponds to the order ID within your order management system) | | **Customer Name** | Name of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Customer Email** | Email of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Gross Order Total** | Amount the customer paid at checkout — the order total, before any Sezzle fees | | **Refund Amount** | Amount of one individual refund. If multiple refunds were issued, the amounts are combined and displayed in the next column | | **Total Refunds on Order** | Combined amount of all refunds that were issued on the order | | **Net Order Amount** | Amount due to you after all refunds have been applied Often negative as the Sezzle fee itself is typically not refunded to the merchant | | **Refund Currency** | Currency the refund was issued in and corresponds to the currency the shopper used at checkout | | **Transaction UUID** | Assigned to every request to refund issued by a merchant Also known as a Refund Request Unique ID | ### Disputes NewDirect IntegrationVirtual CardsDashboard: DisputesSplit by shopper currency * Contains every dispute opened within the report's date range, both open and closed. Each row is one dispute, sorted by **Dispute Open Date** (newest first). * The date range applies to the **Dispute Open Date**, so a dispute appears in the report for the period it was opened, even if the order was placed earlier. * Directly corresponds to the “Disputes” page within the Sezzle dashboard, where you can respond to a dispute (**Manage Dispute**) or issue a refund. * While a dispute is open, the shopper’s installment payments on that order are paused. Only one active dispute can exist on an order at a time. * If you resolve a dispute by issuing a refund, the refund also appears on the Refunds worksheet. | Column title | Purpose | | - | - | | **Order Date** | Date the shopper placed the disputed order | | **Sezzle Order ID** | Order ID created by Sezzle — the same ID shown as “Order ID” on the Disputes page Matches the **Sezzle Order ID** column on the Orders worksheet (not the Sezzle Order UUID), so you can use it to look up the order | | **Reference ID** | Order ID that Sezzle received from your e-commerce platform (typically directly corresponds to the order ID within your order management system) Same value as the Reference ID on the Orders and Refunds worksheets. Blank if the order has no reference | | **Customer Name** | First and last name of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Customer Email** | Email of the customer per their Sezzle account May not match directly with the order information in your e-commerce platform, as shoppers are able to enter different values in each system | | **Dispute Open Date** | Date the dispute was first opened Doesn't change if the dispute is later reopened | | **Dispute Closed Date** | Date the dispute was closed Blank while the dispute is still open. If the dispute was reopened, this is the date it closed after being reopened May also be blank for some older closed disputes | | **Order Amount** | Total of the original order in the shopper's currency — not the amount under dispute Shown without a currency symbol (for example, 1,234.50); the currency is in the sheet name, such as “Disputes - USD” | | **Dispute Status** | Current status of the dispute, using the same labels as the Disputes page: Action Required · Processing · Dispute Closed See the dispute status key below for what each status means and what to do | #### Dispute status key | Status | What it means | | - | - | | Action Required | **Sezzle needs your response.** Use **Manage Dispute** on the Disputes page to submit evidence, tracking information or comments, or issue a refund, before the response deadline. If you don't respond in time, the dispute can be ruled in the shopper's favor. | | Processing | **Sezzle is working on the dispute.** For example, it's waiting on the shopper for more information or reviewing the evidence. This includes disputes that have been reopened. No action is needed from you right now. | | Dispute Closed | **The dispute has been resolved.** Select **View Closed Dispute** on the Disputes page to see the details. | A closed dispute ends in one of these outcomes: > **Ruled in your favor** > > The shopper's claim wasn't upheld, and payments resume normally. > **Ruled in the shopper's favor** > > You're responsible for the refund amount. > **Sezzle absorbs the cost** > > No financial impact on you. > **Mutual resolution** > > All parties reached an agreeable outcome, such as after a voluntary refund. ### Withdrawal Account Ledger Direct IntegrationVirtual CardsSplit by shopper currency * Shows all transactions that affect the Withdrawal Account balance. * Transactions are split into individual orders and fees. | Column title | Purpose | | - | - | | **Posted Date** | Date the line item was settled | | **Activity Date** | Date the transaction was created | | **Transaction Type** | Short description of the line item | | **Order ID** | Order ID created by Sezzle (only for line items that are orders) | | **Credit** | Money coming into the account | | **Debit** | Money leaving the account | | **Balance** | Amount of the Withdrawal Account after the transaction | | **Payout ID** | If the line item has a corresponding settlement, the settlement ID will be displayed in this column | ### Interest Account Ledger Direct IntegrationVirtual CardsSplit by shopper currency * Shows all transactions that affect the Interest Account balance. * Transactions are split into individual orders and fees. | Column title | Purpose | | - | - | | **Posted Date** | Date the line item was settled | | **Activity Date** | Date the transaction was created | | **Transaction Type** | Short description of the line item | | **Order ID** | Order ID created by Sezzle (only for line items that are orders) | | **Credit** | Money coming into the account | | **Debit** | Money leaving the account | | **Balance** | Amount of the Interest Account after the transaction | | **Payout ID** | If the line item has a corresponding settlement, the settlement ID will be displayed in this column | ### Reserve Optional * This plan holds a portion of your settlements for a set period (if applicable). For example, if 15% of funds are held for 65 business days, 85% of your funds are released per the regular settlement period for your store and the rest are released on business day 66. * Specific percentage and holding period may vary. | Column title | Purpose | | - | - | | **Date** | Date of the event within the reserve | | **Release Date** | Date that the funds will be released | | **Description** | Describes the event that happened, whether it be funds that are released or funds that are withheld If there are funds that are withheld, it will include the payout ID | | **Amount** | Amount of the event within the reserve Amounts in parentheses ( ) notate amounts withheld, and positive amounts notate amounts released | | **Currency** | Currency of the event | ### Referral Affiliate * Serves as a ledger for all events that occurred with referrals (if applicable). | Column title | Purpose | | - | - | | **Date** | Date of the event | | **Description** | Describes the event that happened | | **Debits** | Amount that may be debited from your referral amount | | **Credits** | Amount that may be credited to your referral amount | | **Affiliate Balance** | Amount associated with affiliates if applicable | | **Transferred to Withdrawal Account** | Referral amount transferred to the withdrawal account | | **Currency** | Currency of the event | ## Troubleshooting ### Tracing an order **1. Find the Reference ID** Find the order ID in your e-commerce system. That becomes the **Reference ID** within this report. If you can't find the order, it was most likely created outside the report data range. **2. Check the settlement status** Locate the order by its Reference ID in the Orders sheet, then look at the **Settlement Status** and **Settlement Date**. Status **Completed** means you've received all of the funds for that order. To trace them in detail, copy the **Order ID**, an internal Sezzle ID for the order. **3. Search the ledger** Go to either the Withdrawal or Interest Ledger, depending on where you're set up to receive your settlements, and search for all transactions with that order ID. **4. Do the math** The total of all credit **Order** transactions minus the total of all debit **Sezzle Fee** transactions with the given order ID is the amount you've been paid for that order in the selected time period. > [!NOTE] > > **On the Interest Plan?** Orders processed into the Interest Plan are added to the total balance of the Interest Account, which is then manually withdrawn. Those funds go to a pool of money that isn't immediately transacted with your bank account, so you won't be able to trace orders directly to a bank transaction. You can still trace how much money is in your interest account for any given order: follow the steps above, but select the Interest Ledger instead of the Withdrawal Ledger. All transactions found for a given Order ID reflect the amount received in your interest account for that order. ### Date mismatches Due to time zones, there is a chance that the order date within Sezzle may not be the exact date within your e-commerce system. All time stamps in the transaction data report are in UTC. If you cannot find an order on the date expected, search for the order by the ID from your e-commerce platform, as that will be the **Reference ID** within the report. ### Manual capture If you are on manual capture, each payment comes in as an **authorization**. You must capture the payment to get paid. When you capture a payment authorization, the order will be fulfilled. If you do not capture the payment authorization, the funds will be held for up to seven days. You have **seven days to capture**; if you do not, the funds will be released. This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.