The Transactions report is your source of truth for reconciling the card, ACH, and Buy-Now-Pay-Later payments you collected through Shopmonkey Payments. It lists every successful Shopmonkey Payments charge in the date range you pick, with the Gross Revenue, Fees, Net Revenue, and (when applicable) Surcharge Fees Collected cards at the top and a row-by-row table underneath. You can sort, filter by location, export to Excel, and click through to the order or customer behind any row — use it to reconcile your Shopmonkey Payments deposits against the work you billed, to spot refunds and disputes, and to see exactly how much of each charge you actually keep after processing fees.
Filters
| Filter | Default | What it does |
|---|---|---|
| Paid | The previous full calendar month | Limits the report to payments recorded in a specific date range. Despite the name "Paid," this filter looks at the date each payment was recorded in Shopmonkey, which for most Shopmonkey Payments charges is the same moment the card was run. For a payment you back-dated or entered after the fact, the date used here is when it was entered, not the date you wrote on it. |
| Locations (HQ only) | All of the locations you can see | Limits the report to payments assigned to the selected locations. If you leave every location unchecked, you get all of them. This filter uses the location on the payment itself, so in the rare case a payment was processed at a different location than the order it belongs to, the payment shows up under the processing location. |
| Countries (HQ only, multi-country setups) | Your home location's country | Narrows the list of locations you can pick from to a single country. It does not change the payment data directly — it just controls which locations appear in the Locations filter. |
Understanding Your Numbers
| Card / Column | What it means | What it doesn't include | When it's useful | Notes |
|---|---|---|---|---|
| Gross Revenue | The total amount charged across every successful Shopmonkey Payments transaction in your date range. | Cash, checks, and any payments taken outside of Shopmonkey Payments. Failed, pending, or canceled charges. Refunds are not subtracted — a refunded charge still counts toward Gross Revenue. | Seeing the top-line volume you ran through Shopmonkey Payments for the period. | If a customer was refunded, you'll see it flagged in the Status column of the row, but the original charge amount is still included here. |
| Fees | The total processing fees Shopmonkey Payments charged you on those transactions — card network fees plus processing fees combined. | Surcharges you collected from customers (those are shown separately). | Understanding the true cost of accepting cards and ACH for the period. | Fees can take up to 24 hours to finish processing, so very recent transactions may show a blank or low fee that updates the next day. |
| Net Revenue | Gross Revenue minus Fees — what you actually earned before the money hits your bank. | Refunds are not subtracted. Surcharges you collected are not added back in. | Reconciling against your Shopmonkey Payments deposits and understanding your true take-home. | Net Revenue always equals Gross Revenue minus Fees to the penny. It is not the same as what lands in your bank on a given day — payouts settle on their own schedule. |
| Surcharge Fees Collected | The total surcharges your customers paid on top of their bills to offset card fees. | Anything that isn't a customer-paid surcharge. | Confirming how much surcharge revenue you passed through for the period. | This card only appears when you actually collected surcharges in the date range — no surcharges means the card (and the Surcharge column in the table) simply won't show. |
| Date column | The date the payment was recorded in Shopmonkey. | — | Sorting transactions chronologically. | For most Shopmonkey Payments charges this is the same moment the card was run. For back-dated payments it's the day the payment was entered, not the day on the receipt. |
| Order # | The order the payment was applied to, linked so you can click straight into it. | Payments that aren't tied to an order at all (these won't appear on this report). | Tracing a payment back to the specific job. | — |
| Payer | The person or company whose card or bank account was actually charged. | — | Spotting third-party payments — a warranty company, an insurance provider, or a BNPL lender. | The payer can be different from the customer on the order. |
| Customer | The customer the order is for. | — | Seeing which of your customers the work was for, regardless of who paid for it. | If a warranty or insurance company paid, the payer and customer will not match. |
| Method | How the payment came in — Online or In-Person — along with a small icon showing whether it was a card, ACH, or BNPL transaction. | — | Seeing at a glance whether a charge was taken on a terminal, over the phone, or through an online payment link. | — |
| Total | The gross amount of the individual charge. | Refunds are not subtracted — if the charge was later refunded, the Total still shows the original amount, and the refund is flagged in the Status column. | Matching a row against an individual receipt or Stripe charge. | — |
| Fee | The processing fees on this specific transaction — card network fee plus processing fee. | Surcharges. | Understanding the cost of a single charge. | Hovering over the fee shows the breakdown: card network fee, processing fee, and total. A dash (--) means fees haven't finished processing yet; check back within 24 hours. |
| Net | What you kept on this specific charge after fees — Total minus Fee. | Refunds are not subtracted. Surcharges are not added back in. | Reconciling a single charge against a deposit line. | — |
| Surcharge | The surcharge the customer paid on top of this charge. | — | Confirming the pass-through amount on a single transaction. | This column only appears when surcharges exist somewhere in the date range. |
| Status | Whether the charge was refunded, partially refunded, or disputed — or simply "Succeeded" if none of those happened. | — | Spotting trouble transactions quickly. | Every row on this report is a charge that went through. "Refunded" or "Disputed" describes what happened after the successful charge — not whether it was approved. For ACH, "Succeeded" means the payment was accepted but may still take 4–6 business days to settle in your bank. |
Common Questions
Q: Why is Gross Revenue on this report different from Total Received on the All Payments report? A: This report only shows payments you ran through Shopmonkey Payments — cards, ACH, and Buy-Now-Pay-Later. The All Payments report also includes cash, checks, and any payments you recorded by hand. If you take cash and checks, All Payments will always be bigger than the Gross Revenue on this report.
Q: Why is Net Revenue different from what actually landed in my bank account? A: Net Revenue is Gross Revenue minus processing fees for every charge in your date range. Your bank deposits come in on a settlement schedule — a charge run on Friday may not hit your bank until Monday or later, and ACH transactions can take 4–6 business days to settle. So on any given day, the deposit amount won't match the Net Revenue for that same day. For bank reconciliation, compare Net Revenue to the Shopmonkey Payments payouts report over the same window, not to a single day's deposit.
Q: Why do refunded charges still count toward Gross Revenue? A: This report shows you every successful charge that happened in the date range. A refund is a separate event that comes afterward. So the original charge still appears in Gross Revenue, and you'll see the refund flagged in the Status column on that row. If you want to net refunds out, look at the Status column and subtract the refunded amounts yourself — or use a payout-based report that reconciles refunds against charges.
Q: Why don't my totals here match my Stripe dashboard? A: They should match charge-for-charge if you use the same date range and filter Stripe by "Created date." The most common cause of mismatch is comparing to Stripe's "payout" view, which groups by settlement date instead of charge date. Stripe also nets fees differently in some of its dashboard summaries.
Q: Why is a transaction missing? A: A few common reasons: the payment was cash, check, or recorded by hand (those don't appear here — this report is Shopmonkey Payments only); the charge failed, was canceled, or is still pending; the date falls outside your filter (remember the date used is when the payment was recorded in Shopmonkey, which can differ from when you wrote it on a receipt); or on HQ, the payment is assigned to a location you don't have checked in the Locations filter.
Q: Why did the Surcharge column disappear? A: The Surcharge column and the Surcharge Fees Collected card only appear when you actually collected surcharges in the date range you're looking at. If no customer paid a surcharge in that window, the column hides on purpose — it's not a bug. Widen the date range or change locations to a period where you collected surcharges and it'll come back.
Tips for Getting the Most Out of This Report
- Use it for monthly Shopmonkey Payments reconciliation. At the end of each month, set the Paid filter to the previous month and compare the Net Revenue card against your total Shopmonkey Payments deposits for the same period. The two should reconcile — if they don't, the difference is almost always settlement timing (payments at the end of the month settling next month). The All Payments report is the place to reconcile cash and check revenue; this one is just for Shopmonkey Payments.
- Watch the Status column for refunds and disputes. A quick scroll through Status shows you every refund and dispute in the period. If you need a clean "what did we really keep" number, export to Excel and subtract the refunded amounts from Net.
- Sort by Fee to find your most expensive transactions. High-ticket and certain card types carry bigger fees. Sorting by Fee (largest first) is a fast way to spot whether a few large charges are driving most of your processing cost for the month — useful when deciding whether to turn on surcharging.
Still have questions? Feel free to reach out to us through the chat icon. Thanks for reading!
Comments
0 comments
Article is closed for comments.