All Collections
Figure: Detailed Use
Reports
Mismatched inventory to payment transactions
Mismatched inventory to payment transactions

Tracking situations where inventory is depreciated from a SKU on an order, but no credit card transaction for incoming funds is recorded.

Ned Creed avatar
Written by Ned Creed
Updated over a week ago

Mismatched Inventory to Payment Transactions:
This line item represents orders where the total of the inventory transactions does not match the total of all the payment transactions. 

It can represent two situations:

1 - Orders processed as “Not Paid”: When you process an order as an admin user, using the “Offline/Pay Later” feature, you are applying inventory to an order, yet receiving no funds at the moment of processing. That is a mismatch because Figure assumes inventory is being removed from stock and applied to an order, but no funds are being received to pay for that inventory.

A subset of processing an order as “Not Paid”, if you apply Credits and decrease the total amount of the order to $0, that amount of Credits will contribute to the Mismatched line item.

2 - Existing orders have a partial or full refund processed, but the inventory stays on the order: That is a mismatch where funds are returned to the customer and the Figure system assumes the customer still received the wines because the inventory remains on the order...again, a mismatch of inventory to payments.

If either of these two situations occur during the time span you are searching in the Accounting reports, this line item will populate with the financial amounts.

Be aware that the total number you are seeing in this line item could represent multiple orders and therefore one or both of the situations listed above.

Plus, this line item only produces financial totals for products. It does not account for sales tax or shipping charges on the order.

**Very Important**Lastly, this line item is partially dynamic.  One of its features is to track orders you process without a credit card, meaning you aim to receive payment for the wines via check or cash.
With that, if you process an order as Not Paid, and then collect cash or a check for the order and mark it as Paid, the
same amount will remain in this line of the accounting report. It is just continually tracking the amount of dollars you received via check or cash throughout the year. It should not be treated like it is an accounts receivable payment tracking system, where the dollars decrease as you receive cash or check payments.
However, if you receive payment for that "Not Paid" order via a credit card transaction,
it will remove that order's total from the accounting report line item...because it is no longer an order that was processed receiving cash or check.

Therefore, to cover yourself for later, as it is always difficult to remember and track down these orders at the end of the month, quarter, and/or year, it is wise to apply Tags to orders that are processed as “Not Paid”. Or if you process a refund but the wine/product/SKU stays on the order, create a Tag referencing that so you can research it later. Your accounting team will thank you when they are in the midst of reporting season.

Did this answer your question?