Payment reports show data from the payments you receive and record from your customers. You can see a breakdown of all of your payments, the type of payments, and which customers are bringing in the most business. If you have Shopmonkey Payments integrated, you’ll see each of the payments processed and you’ll see when you’ll receive payouts for those transactions.
These reports are populated when you record a payment with the New Payment button on an order and when you use Shopmonkey Payments. These reports will show payments regardless of order status so payments made on estimates and invoices will show.
What payments were made last week?
This report shows important information for any payment made. Every time a payment is processed it is recorded as a line in this report. If two payments are accepted for the same invoice they will show up as two separate lines. (e.g. $100 deposit on #1090 is on a line, $101.50 remaining balance on #1090 is an additional line) This includes both payments received and refunded. You can find the payment date, customer name, payment amount, and other essential information from the report. Each line will also have the order number listed and clicking on the link will take you to the related order.
You can filter the list by Companies, Customers, Payment Type, and QB Status to find the exact payment you’re looking for.
Do our customers pay more with cash or card?
This report shows a breakdown of each payment type Check, Cash, Card, or Other. You’ll find the total dollar amount for each payment type and you can see the percentage of the total payment amount by each payment type.
The Creation date filter is based on the date the payment was created not the date the order was created.
Summary by Customer
Which customers are the most valuable?
This report shows you the payments made by customers and fleets. You can see the total amount and see the profitability percentage for the customer or fleet. Profitability is calculated by dividing Total Profit by Line Item Total for each order.
You can filter the list by Creation, Customer Type, Invoice Date.
How much did we process through Shopmonkey Payments this month?
This report shows a list of all Shopmonkey Payments transactions. At the top, you’ll be able to see the Gross Revenue, Fees, and Net Revenue for your transactions.
Gross Revenue - The total amount charged to customers and fleets
Fees - The total of processing fees
Net Revenue - The Gross Revenue minus Fees
For each transaction, you’ll be able to see the payment date, order number, customer name, payment amount, fees, and other essential information. The Location column will show if the transaction was processed Online or In-Person via a Shopmonkey Card reader. The Status column will show if the transaction was processed successfully, refunded, or failed.
When did our last Shopmonkey Payment happen?
This report shows the status of your current and past payouts. Payouts are the accumulation of your transactions using Shopmonkey Payments. Payouts are usually sent to your bank account on a 2-business-day rolling schedule. For more information about Payouts check out our help article.
At the top, you’ll see the Balance Remaining and In Transit.
In Transit - The accumulated payout that is in the process of moving to your connected bank account (Typically 2 business days).
Balance Remaining - The accumulated transactions processed with Shopmonkey payments that have not yet begun to transition to your connected bank account. The balance represents all transactions from the last payout onward and is likely to change as transactions are still accumulating. Once done accumulating, this balance will be bundled as the following payout.
In the list, you’ll be able to find the date the payout was initiated, the date it arrived in your account, the bank account it was sent to, the amount of the payout, and the status of each payout.
Thanks for reading about Payment Reports. Check out the help article for all reports here, and let us know if there is anything we can help you with.