Our Beta Transaction Report is here! This report is part of the ongoing work we’ve been doing to refine and improve our reporting on Sawyer. This report seeks to provide better visibility into the total amounts paid by customer and by order across the initial order date (e.g. the at checkout amount) and across dates of billing (e.g. transaction dates) for amounts received from auto billing, payment plans, or on order actions such as receive payment.
What to Expect:
This report allows you to view all transactions across all payment types for orders placed at your business! With this report, you also have the option to filter by order date (date the order was originally placed) or by transaction date (date of the payment or refund - this will include initial at checkout amounts as well as recurring billing and amounts received on order actions.) This will allow you to see a complete picture of amounts paid, received, and refunded during specific date ranges.
This report expands upon the current Orders Report to provide better visibility into amounts paid and refunded on an order over time. This is especially helpful for businesses who offer flexible payment plans, monthly recurring billing, membership payments, or accept non-credit card payments on Sawyer using Custom Payment Types. Please note that our Bank Transfers Report is still the best report to use when reconciling amounts paid by credit card and deposited into your bank account from our payment processor Stripe.
You can use this report in a variety of ways after exporting as a CSV file:
- You can sort and sum amounts paid by customer email to see how much a specific customer has paid across all transaction dates.
- You can use the Transaction Date filters to view the amounts paid across payment types for a specific month or range of dates.
- You can sort the report by order ID to see total amounts paid for specific orders across payment types and dates.
- You can sort the report by transaction type to view all refunds by transaction date or by transaction month in which the refund occurred.
Accessing the Beta Transactions Report
All business can access this report under Financials > Orders > Download Reports. You'll see Revenue reports shown at the top and the new Beta Transaction Report will display first.
In addition business accounts with Grow and Scale access can also view this report from their insights dashboards.
- Go to Reports > Insights
- Locate Transactions Report below the insights graphs
- Optional - add filter by Order Date (original date of the order) or Transaction Date (date a payment was received including the initial order date)
As you download the report, here are a few things to note:
- This report contains live data and will be updated as new orders are placed or when new payments are received or refunded.
- This report directly downloads as a CSV file!
- This report contains revenue from all payment types - credit card transactions, gift cards, and any custom payment methods (e.g. cash, check)
- All add-ons (early drop-off, extended day, pick-up, or custom add-ons), required fees, and installment surcharges are automatically included in the revenue totals collected across the transaction dates and activities purchased.
- Orders that contain discounts (coupons, auto-discounts, and sibling discounts) have various rules based on the items purchased (e.g. pay in full pricing vs payment plans) As a result, you may notice discrepancies in amounts listed in the corresponding discount columns. Please note that the 'Checkout Amount USD' will be shown properly regardless of the amounts listed in the Gross, Coupon, Sibling Discount, and Auto Discount columns.
What does “beta” launch mean:
While this is an exciting first step into releasing better visibility into financial actions on your account, there may be future improvements made so please keep in mind that this is not necessarily the final version of the report.
Collecting Feedback: As feedback is extremely valuable to us during this process, we will be working closely with providers to gather suggestions and feedback on how we can improve reporting. As always, email us at support@hisawyer.com to submit any questions or feedback!
Understanding the Transactions Report
When you export this report, you’ll see multiple columns of data. See below for a detailed explanation of each column.
Column Definitions
- Order ID:
- Displays the Unique ID for the order.
- Provider ID:
- Displays the Unique Provider ID for the business.
- Provider Name:
- Displays the Name of the Provider Business.
- Customer ID:
- Displays the Unique ID for the customer.
- Customer Email:
- Displays the email address for the customer account.
- Customer First Name:
- Displays the First Name of the customer.
- Displays the First Name of the customer.
- Customer Last Name:
- Displays the Last Name of the customer.
- Child Names:
- Displays the names of child(ren) included in the transaction or order.
- Please note - this column will show any children associated with the Order ID separated by a comma. This report does not yet display the unique amounts paid by child.
- Order Schedules:
- Displays the names of the Semester or Camp/Event timeframes that the scheduled activities in this order are scheduled under.
- Please note - this column will show any Schedules associated with the Order ID separated by a comma. This report does not yet display the unique amounts paid by Schedule.
- Order Activity Names:
- Displays the names of the Scheduled Activities that are in this order.
- Please note - this column will show any Activities associated with the Order ID separated by a comma. This report does not yet display the unique amounts paid by Scheduled Activity.
- Order Date:
- Displays the date on which the original order was placed.
- Transaction Date:
- Displays the date of transaction for both payments and refunds.
- Please note - this includes any payment received via payment plans, monthly billing, membership payments, or order actions such as Receive Payment as well as refunds.
- Transaction Month:
- Displays the month of transaction or payment.
- Gross At Checkout Amount USD:
- Displays the gross amount owed at checkout before coupons and discounts are applied.
- Please note - for non-paid in full options such as payment plans and monthly recurring billing, this total does not reflect the total gross amount owed for the entire order but rather the gross amount owed at checkout for the individual transaction date before applicable coupons and discounts.
- Full Coupon Discount Amount USD:
- Displays the total discount amount applied to the order as a result of coupon codes.
- Please note - for payment plan orders, this may be spread across multiple transactions for the order.
- Coupon Discount At Checkout Amount USD:
- Displays the total discount amount applied at checkout as a result of coupon codes.
- Please note - this is only shown for transaction types ‘customer_paid_initial’.
- Full Sibling Discount Amount USD:
- Displays the total discount amount applied to the order as a result of sibling discounts.
- Please note - for payment plan orders, this may be spread across multiple transactions for the order.
- Sibling Discount At Checkout Amount USD:
- Displays the total discount amount applied at checkout as a result of sibling discounts.
- Please note - this is only shown for transaction types ‘customer_paid_initial’.
- Full Auto Discount Amount USD:
- Displays the total discount amount applied to the order as a result of auto discounts.
- Please note - for payment plan orders, this may be spread across multiple transactions for the order.
- Auto Discount At Checkout Amount USD:
- Displays the total discount amount applied at checkout as a result of auto discounts.
- Please note - this is only shown for transaction types ‘customer_paid_initial’.
- Checkout Amount USD:
- Displays the total amount charged to the customer at checkout.
- Sawyer Fee USD:
- Displays the total amount of Sawyer fees (e.g. marketplace fees or percentage subscription fees) that applied to the transaction.
- CC Fee USD:
- Displays the total amount of credit card processing fees that applied to the transaction.
- Refunded Amount USD:
- Displays the total amount refunded for the transaction.
- Sawyer Fee Refunded Amount USD:
- Displays the total amount of Sawyer fees refunded (e.g. marketplace fees or percentage subscription fees) for the transaction.
- Net Amount to Provider:
- Displays the total amount paid to provider after deducting applicable fees.
- Payment Plan Installment Count:
- Displays the number associated with the payment plan installment count. For example, if a customer is paying across 6 installments, each transaction date will reference which number payment is being paid.
- Transaction Type:
- Displays the type of transaction from the options below:
- Customer Paid Initial refers to the transaction associated with the initial order
- Customer Paid refers to the payment received associated with transactions outside of the initial order (e.g. payment plans, monthly billing)
- Customer Refund refers to the refunded transaction and corresponding date.
- Displays the type of transaction from the options below:
- Payment Type:
- Displays the payment type used for the transaction. Will include custom payment types used as well as "n/a - $0 charge" for $0 transaction amounts.
- Order Description:
- Displays any optional notes added during the initial order such as when using the quick charge feature or placing an order on behalf of the customer.
- Transaction Description:
- Displays any optional notes added for a transaction such as on refunds or payment actions such as receive payment.
- Payment Method Name:
- Displays the custom payment method name if applicable.
- Item Types:
- Displays the item types that are part of the order or transaction (i.e. semester, camp, drop-in, membership)
- Custom Booking Fee Name:
- Displays the name of the applicable Custom Booking Fee if configured for your business.
- Please note - Custom Booking Fees are only applied at the initial at checkout amount.
- Custom Booking Fee Type:
- Displays the type (percentage or fixed amount) of applicable Custom Booking Fee if configured for your business.
- Custom Booking Fee Percent:
- Displays the total Custom Booking Fee percentage amount applied to the order.
- Please note - this column will be empty if the fee configured for your account is a fixed amount.
- Custom Booking Fee Fixed Amount:
- Displays the total Custom Booking Fee fixed amount applied to the order.
- Please note - this column will be empty if the fee configured for your account is a percentage amount.
- Total Custom Booking Fee Collected:
- Displays the total amount paid by the customer in Custom Booking Fees.
- Please note - the column Checkout Amount USD column factors in all amounts paid across applicable fees and add-ons. These additional columns are shown for additional visibility into the Custom Booking Fee amount paid on an order.