Order Payments Report | Boulevard Support Center

We're excited to bring you an expanded reporting experience. If you don't see the reporting features described below, don't worry—this updated reporting experience will become available to your account over time.

Resource	Link
Order Payments Report	https://dashboard.boulevard.io/reports/order_payments

Note: This report was previously titled “Payments & Refunds”.

Overview

The Order Payments report helps you see all payment and refund transactions processed through Boulevard. It provides a transaction-level view of every payment and refund, including method, merchant, settlement timing, and client and staff detail.

Use this report to reconcile daily payment and refund totals against drawer or deposit records, monitor settlement timing against processor batches, and analyze payment method mix and processing fees. It's especially useful for multi-location reconciliation and dispute investigations, since you can filter by payment method, merchant account, or date to isolate exactly the transactions you need.

Note: Refunds appear as negative Transaction Amounts within this same report, not as separate rows — filter Transaction Type = Refund to see them in isolation. For bank reconciliation, use Settled On rather than Transaction Date, since the two can differ by a day or more and Settled On will be blank for cash, check, and other non-processor payment methods. See the Report Caveats section below for how voucher, gift card, and account credit redemptions can inflate payment totals if not filtered out.

What this report is best used for

Understand when and why to use this report through common use cases, descriptions, and example questions it can help answer in your day-to-day operations.

Use cases	Description	Example questions this report helps answer
Payment and Refund Reconciliation	Review all payments and refunds within a selected date range to confirm totals match drawer or deposit records. Includes location-level validation.	How much cash and card payment was processed yesterday? What are the total refunds for the week?
Settlement and Deposit Tracking	Monitor settlement dates and deposited amounts to ensure payment processor totals align with bank deposits.	When did this payment settle with my processor? Do settlement totals match daily deposits?
Prepaid, Gift Card, and Voucher Tracking	Track prepaid product usage, voucher redemptions, and gift card sales or liabilities across transactions.	How many prepaid redemptions occurred today? What was the total voucher redemption value this month?
Processor and Payment Method Analysis	Analyze processor fees, payment methods, and card brand distribution to understand net retained value and payment mix.	What was the total processing fee this month? What percent of transactions were Visa vs Amex?
Client and Staff Accountability	Review which clients and staff are linked to transactions for auditing, refund validation, and dispute resolution.	Who processed this refund? What payments has this client made recently?
Multi-Location Reconciliation	For multi-location businesses, verify that deposits and transactions across all sites align with centralized batch totals.	Do all locations’ deposits add up to the merchant batch? Which location has unsettled transactions?

Prerequisites

Before using this report, make sure the following are in place. These directly impact whether you can access the report and how accurate the data will be.

Permissions: You must have the appropriate Data & Reporting permissions enabled to see this report: Financials Reporting > Payment & Disputes
- If you don’t see the report, check your permissions first - see Reporting Permissions for more information.
Location and Access Scope: What you see in the report depends on your access:
- You’ll only see data for assigned locations
- Row-level access may further limit visible data
- If it looks like data is missing, verify your location assignments and access settings.
Required Setup: For the report to show meaningful data, you must be processing payments and refunds through the Dashboard.

Default report configuration

See how the report is structured when first opened. Learn what each field represents, how the data is organized, and which fields can be used to filter results.

Group By (default)

The default fields the report is grouped by when you first open it.

Field name	Definition	Example	Filter?
Location Name	The name of the business location where the transaction occurred.	Joshua Tree	Yes
Transaction Date	The local calendar date and time when the payment or refund transaction was created.	2026-01-12	Yes
Transaction ID (hidden in table, visible in exports)	Unique identifier of the payment or refund transaction.	0eab0ef7-4323-4a02-a5e6-0364a6e5934e	Yes

Columns (default)

The default columns displayed when you first open the report.

Field name	Definition	Example	Filter?
Order Number	Human-readable order number linked to the transaction, visible to staff and clients.	23645	Yes
Transaction Type	Classification of the transaction. One of: Payment, Refund.	payment	Yes
Client Name	Full name of the client associated with the transaction.	Kaya Vidangos	Yes
Payment Method	Method used for payment. One of: Apple Pay, Cash, Voucher, Account Balance, Other, Credit Card, Prepaid Product Units, Check, Gift Card.	Credit Card	Yes
Transaction Amount	Total dollar amount processed for the transaction. Positive for payments and negative for refunds. Units: dollars.	264	No
Merchant Name	Name of the merchant account used to process the transaction.	Shirley Rich Santa Barbara	Yes

Customizable fields

Explore the fields you can adjust to tailor the report to your needs. Each field includes a definition, example, and whether it can be used in filtering.

Field name	Definition	Example	Filter?
Location Name	The name of the business location where the transaction occurred.	Joshua Tree	Yes
Transaction Date	The local calendar date and time when the payment or refund transaction was created.	2026-01-12	Yes
Transaction ID	Unique identifier of the payment or refund transaction.	0eab0ef7-4323-4a02-a5e6-0364a6e5934e	Yes
Order Number	Human-readable order number linked to the transaction, visible to staff and clients.	23645	Yes
Transaction Type	Classification of the transaction. One of: Payment, Refund.	payment	Yes
Client Name	Full name of the client associated with the transaction.	Kaya Vidangos	Yes
Payment Method	Method used for payment. One of: Apple Pay, Cash, Voucher, Account Balance, Other, Credit Card, Prepaid Product Units, Check, Gift Card.	Credit Card	Yes
Transaction Amount	Total dollar amount processed for the transaction. Positive for payments and negative for refunds. Units: dollars.	264	No
Merchant Name	Name of the merchant account used to process the transaction.	Shirley Rich Santa Barbara	Yes
Custom Payment Name	Name of the custom payment method used, if the business has configured custom payment options.	blvd os test	Yes
Order Date	The local calendar date on which the associated order was closed.	2026-04-17	Yes
Location Group Name	The location group the business location is associated with, if applicable.	West Coast	Yes
Order Status	Current status of the associated order. One of: Refunded, Deleted, Voided, Open, Closed.	refunded	Yes
Settled On	Local date and time when the transaction was settled by the payment processor.	#N/A	Yes
Operator Name	Full name of the staff member who processed or recorded the transaction.	Jon Doltar	Yes
Client Last Name	Last name or surname of the client associated with the transaction.	Vidangos	Yes
Card Type	Classification of the card type used for payment. One of: Credit, Debit, Prepaid.	credit	Yes
Location Id	Unique identifier of the business location associated with the transaction.	1ddf3ea3-56f7-44ea-acf5-f7d93bedae78	No
Location External Id	Identifier for the business location from an external system, if provided.	JT	No
Order Id	Unique identifier of the order linked to the transaction.	1c3ccf14-3291-4255-a5b1-05e098505b2c	No
Operator ID	Unique identifier of the staff member who processed or recorded the transaction.	45cce4e3-3df7-45dd-b921-8f5e4601048e	No
Client Id	Unique identifier of the client associated with the transaction.	f1ab3bbc-8caf-4f57-b9d7-1aece1b3e78e	No
Client Email	Primary email address of the client associated with the transaction.	email@email.com	No
Client Phone Number	Primary phone number of the client associated with the transaction.	18133173487	No
Payment note	Free-text note added to the transaction. May include custom payment method details, or adjustment notes.	Account Credit Adjustment	No
Is Custom Payment	Flag indicating whether the transaction used a custom-configured payment method (true = custom).	FALSE	Yes
Card Brand	Brand of the payment card used. Example: Visa, Mastercard, Amex.	Visa	Yes
Card Last 4	Last four digits of the card number used in the transaction.	6007	Yes
Card Present	Flag indicating whether the card was physically present during payment processing (true = present).	TRUE	No
Gift Card Id	Unique identifier of the gift card associated with the transaction, if applicable.	null	Yes
Gift Card Code	Gift card code associated with the transaction.	null	No
Prepaid Product Name	Name of the prepaid product associated with the transaction.	Allergan Botox	No
Prepaid Product Quantity	Quantity of prepaid units redeemed or purchased in the transaction. Units: count.	10	No
Voucher Source Name	Name of the originating source from which the voucher was issued. Example: package, membership, promotion.	Michal Exchange Package	Yes
Voucher Source Type	Type of voucher source. One of: Package, Membership, Promotion, Manual.	Package	Yes
Refund Reason	Categorical reason selected for issuing the refund, if provided.	Marketing	No
Refund Explanation	Free-text explanation entered by staff describing the refund context or justification.	other	No
Net Prepaid Value	Total net dollar value of prepaid product units used in the transaction. Units: dollars.	15000	No
Transaction Fees	Total processing fees charged by the payment processor for the transaction. Units: dollars.	3.2	No
Offset Fees Collected	Total dollar amount of offset fees collected as part of the transaction, if applicable. Units: dollars.	0.91	No
Transaction Amount (Less Fees)	Transaction amount after deducting processing fees. Represents the amount retained by the business before tax and gratuity adjustments. Units: dollars.	260.8	No
Client Tag	Client tag associated with the client profile, if applicable.	BioPeel NS	Yes
Appointment Tag	Appointment tag associated with the linked appointment, if applicable.	First Time	Yes
Order Tag	Order tag associated with the linked order, if applicable.	New Client	Yes
Location Tag	Tag assigned to the business location for categorization, filtering, or segmentation.	High Volume	Yes

Report Caveats

There are a few important caveats and limitations to be aware of when using this report. Use these details to better understand how the data behaves and how to interpret it correctly.

Caveats	Details and Impact
Account Credit Adjustments and Gift Card Adjustments are excluded from this report	Transactions where the payment method or payment note is "Account Credit Adjustment" or "Gift Card Adjustment" are filtered out at the data level. These represent internal liability balance changes — not actual payments collected from a client — and are excluded to prevent inflation of payment totals. This is consistent with how these items are treated in Sales reports. Note that account credit redemptions (where a client uses their account credit to pay for a service) are still included.
Transaction Date and Settlement Date are two different dates — they will not always match	Transaction Date is the local date and time when the payment was created in Boulevard. Settled On is the date the payment processor confirmed the funds were settled into the merchant account. These can differ by one or more days depending on the payment processor, card type, and settlement batch timing. For bank reconciliation, use Settled On — not Transaction Date — to match transactions to deposit records.
Settled On may be blank for some transactions	Settled On is populated only after the payment processor confirms settlement. Transactions that are still pending, held for risk review, or where settlement data has not yet been received from the processor will show a blank Settled On date. Transactions processed via non-card methods (cash, check, custom payments) will also show blank in this field as they are not settled through a processor.
Refunds appear as negative Transaction Amounts — they are not separate rows by default	Refund transactions are included in this report alongside payments. Refunds appear as negative values in the Transaction Amount field with Transaction Type = "Refund". When summing Transaction Amount across a date range, refunds automatically net against payments. To see refunds in isolation, filter Transaction Type = Refund. Refund Reason and Refund Explanation are available as additional columns for refund-specific analysis.
Transaction Amount is the gross payment amount — it does not deduct processing fees	Transaction Amount reflects the full dollar amount processed for the transaction before any processing fees are deducted. Use Transaction Amount (Less Fees) to see the amount retained by the business after processing fees. Transaction Fees shows the fee amount charged by the processor for each transaction.
Voucher, Account Balance, and Gift Card payment methods reflect redemptions — not liability sales	When a client pays using a voucher, account credit, or gift card, the transaction appears in this report with the corresponding Payment Method. These entries represent the redemption of a previously sold liability — not a new cash payment. They will inflate total payment volume relative to cash or card collected if not filtered. Use Payment Method to separate cash and card collections from liability redemptions when reconciling against bank deposits.

Use Case Example Configurations

Learn how to set up the report for specific scenarios with practical examples. Follow along to create views that answer common questions and support your workflows.

Use case	Description	How to configure the report
Payment and Refund Reconciliation	Review all payments and refunds within a selected date range to confirm totals match drawer or deposit records. Includes location-level validation.	Filters: set Transaction Date to the period you want to reconcile; filter by Location Name to scope to a specific location; filter by Payment Method to isolate a specific tender type (e.g. Cash, Credit Card); filter by Transaction Type = Refund to see refunds only.
Settlement and Deposit Tracking	Monitor settlement dates and deposited amounts to ensure payment processor totals align with bank deposits.	Columns: add Settled On, Merchant Name. Filters: set Transaction Date to the period you want to review; filter by Payment Method = Credit Card to isolate card transactions that settle through a processor; filter by Location Name as required; note that cash and custom payment methods will show blank in Settled On.
Prepaid, Gift Card, and Voucher Tracking	Track prepaid product usage, voucher redemptions, and gift card sales or liabilities across transactions.	Columns: add Prepaid Product Name, Prepaid Product Quantity, Net Prepaid Value, Gift Card Code, Voucher Source Name, Voucher Source Type. Filters: set Transaction Date to the period you want to analyze; filter Payment Method to Voucher, Gift Card, or Prepaid Product Units to isolate specific redemption types; filter by Location Name as required.
Processor and Payment Method Analysis	Analyze processor fees, payment methods, and card brand distribution to understand net retained value and payment mix.	Group by: Payment Method, Transaction Type. Columns: Transaction Amount, Transaction Fees, Transaction Amount (Less Fees), Offset Fees Collected. Filters: set Transaction Date to the period you want to analyze; filter by Location Name or Location Group Name as required; add Card Brand and Card Type to Group by for card-level breakdown.
Client and Staff Accountability	Review which clients and staff are linked to transactions for auditing, refund validation, and dispute resolution.	Columns: add Operator Name, Client Email, Refund Reason, Refund Explanation, Payment Note. Filters: filter Transaction Type = Refund to focus on refunds; filter by Client Name or Client Tag to scope to a specific client; filter by Location Name as required
Multi-Location Reconciliation	For multi-location businesses, verify that deposits and transactions across all sites align with centralized batch totals.	Group by: Location Name, Transaction Date, Merchant Name. Columns: Transaction Amount, Transaction Amount (Less Fees), Transaction Fees. Filters: set Transaction Date to the period you want to reconcile; filter Transaction Type = Payment to exclude refunds from the totals; filter by Order Status to surface open or voided orders if needed.