The Sales Details report lists every transaction in your Member Splash site, one line per item, with its order, payment status, dates, payment method, and account. Use it for accounting, reconciliation, and tracking down a specific payment.
To open it, go to Finances → Sales Details. For totals instead of individual
transactions, use Sales Summary.
Filter the Report
Choose any combination of filters (described below).
Click Apply. The number of matching transactions appears above the results.
To clear all filters, click Reset.
Order Date Range
Show transactions by order date, using a preset such as Year to Date, Last Month, or Last Quarter, or your own dates. This is usually the main filter for monthly reporting.
Account Type
Show only certain account types.
Payment Status
Paid, Unpaid, Pending, or Partial.
Payment Method
ACH, Credit, Check, Cash, Account, Comp, or No Charge.
Fee Type
Show one category of fees, such as Swim Team Registration. Point of sale items with a missing or unrecognized category are listed under Uncategorized.
Search By
Find transactions by name, account number, legacy account number, or order number.
Search by Date Paid
To see what was paid in a period, instead of what was ordered, set Search By to Date Paid and choose From and To dates. Results include every order paid in that window, even if it was ordered earlier, for example in the previous year. While Date Paid is selected, Order Date Range is greyed out.
Columns
The report shows these columns by default: Order #, Acct Type, Transaction ID, Order Date, Payment Status, Date Paid, Method, Acct #, Billing Contact, Category, Item, Quantity, Price, and Total.
To change which columns appear and in what order:
Click Columns.
Drag columns between the Active and Inactive lists, and drag active columns up or down to reorder them.
Click Save.
Your column layout is saved for you, used in exports, and kept for your next visit.
Special Transactions
Reservations: open a reservation payment's info window to see the reservation ID, facility, date and time, and length. $0 reservations aren't recorded. See Reservations - Paid Reservations.
Voided point of sale orders aren't included in totals..
Export Transactions
To export only certain transactions, check the boxes next to them. To export everything that matches your filters, don't select anything.
Click Export and choose CSV or Excel.
The file uses your active columns in the same order as the report.
Common Uses
Monthly reconciliation: set the date range to Last Month and Payment Status to Paid, then export to Excel to compare with your bank statement.
Outstanding payments: filter Payment Status to Unpaid or Pending, and use the Billing Contact column to see who to follow up with.
Payment methods: filter by Payment Method to see how members pay and what you're spending on processing fees.
Revenue by category: filter by Fee Type, for example Swim Team Registration, to see that category's revenue for a period.