The Mismatched Inventory to Payment Transactions line item appears in the Accounting Report > Sales by Channel, All report. It represents orders where the total price of the inventory on the order does not equal the total of the credit card payment transactions collected via Stripe. In other words, Stripe cannot fully account for the funds collected for these orders, so this line item flags them for your review.
This line item does not necessarily mean money is missing. It is a prompt for your team to research specific orders and confirm that funds were collected and deposited through your own channels.
NOTE: The amounts reflected in this line item are based on product prices only. Shipping charges and sales tax are not included.
What Causes the Mismatched Line Item
1 — Orders Processed as Offline / Pay Later (Not Paid)
When an admin user processes an order using the Offline / Pay Later checkbox on the final checkout page, inventory is applied to the order but no credit card transaction is collected at that moment. Stripe has no record of payment, which creates the mismatch.
This does not mean the money is missing. It means Offset and Stripe have no way of knowing whether the cash, check, or wire transfer was received and deposited. Your team needs to verify that manually through your own bank records.
If you reduce a Not Paid order to $0 using credits, the credited amount will also contribute to the Mismatched line item. This is rare, but worth knowing if you use internal credit accounts for tasting room tracking or similar purposes.
To learn more about processing offline orders, see Accepting Offline Payments: Pay Later, Cash, Check & Wire.
2 — Partial or Full Refund Processed, But Inventory Stays on the Order
When you issue a refund through the Billing section of an order without removing the products, Offset still considers the inventory as being on the order and allocated to the customer. Funds have been returned via Stripe, but the inventory remains, creating a mismatch between what Stripe tracked and what inventory shows.
This is intentional behavior when you want to refund a customer for a specific reason (damaged bottle, shipping issue, courtesy credit) without fully cancelling the order or removing line items.
To learn more, see Refunds & Cancellations.
How This Line Item Behaves (Important)
The Mismatched Inventory line item is partially dynamic, and its behavior is a frequent source of confusion. Here is how it works:
If you process an order as Not Paid and later mark it as Paid after collecting a check, cash, or wire transfer, the same dollar amount will remain in the Mismatched line item. Marking an order as Paid via cash or check does not remove it from this report. The line item continues tracking the total value of all orders paid outside of Stripe within the date range you have selected.
The one exception is if you collect payment on a Not Paid order using a credit card at a later date, and both the original order date and the credit card transaction date fall within the same date range you are searching. In this case, the amount will be removed from the Mismatched line item as the two transactions cancel each other out within that date range. If only one of the two transaction dates falls within your search range, the dollar amount will still appear.
Why the "Show Orders" Total May Not Match
When you click Show Orders on the Mismatched line item, the total displayed for those individual orders may not equal the amount shown in the line item. This is expected behavior.
The Mismatched line item can represent multiple orders and multiple situations, some Not Paid, some refunded without inventory removal, and some involving credits. The line item total is a combined financial figure across all of these scenarios for the selected date range, so it may not reconcile directly against the sum of individual order totals shown in the orders view.
How to Investigate a Mismatched Amount
If you need to research what is contributing to the Mismatched line item for a given period:
Navigate to Reports > Sales by Channel, All and select your date range
Click Show Orders next to the Mismatched line item to see the orders associated with that period
For each order, check whether it was processed as Offline / Pay Later or had a refund issued without inventory being removed
Cross-reference against your bank records to confirm whether offline payments were actually received and deposited
If you use order Tags, filter your Orders page by your offline payment tag to find Not Paid orders quickly
NOTE: As it is difficult to remember and track down these orders at the end of the week, month, quarter, and/or year, it is wise to develop a tagging process for orders that are processed as “Not Paid”, or if you process a refund but the wine/product/SKU quantity stays on the order. You can create a Tag referencing that moment, so you can research it later. Your accounting team will thank you when they are in the midst of reporting season. See Tags Overview for more information.