Point of Sale results in multiple invoices with multiple payment sources
Hi All,
We are a very small dairy farm. 75% of our sales are through farmers markets, we may do 5 or more markets in a weekend. Our point-of-sale app is WooCommerce. After a typical weekend WooCommerce will make a deposit to our QBO linked bank account. But that deposit is not for the total amount of sales, only credit cards. The cash sales either turn up as cash in the cash boxes, or tokens. Tokens can be redeemed by ACH payment to the linked bank account, check(s) indicating the weeks the tokens were received, and/or cash.
This means our income is split along several payment lines that don't correspond well to given invoices. I made the HUGE mistake of marking the invoices as paid by receive payment without associating a deposit, ACH payment, check deposit, or cash income. Consequently, QBO shows our income as grossly overstated because deposits are not associated with an invoice. So, as I'm writing this, I realize I have two problems.
1. How to fix the mistake
2. How to correctly handle the transaction going forward.
For the sake of argument, how to correctly handle the transaction will likely reveal the solution to past mistakes...
A typical weekend of farmers markets may look like this:
| Farmers Market POS invoices (200 invoices) | $ 1,000.00 | $ 582.00 | POS deposit to bank acct |
| $ 18.00 | POS Fee (Expense) | ||
| $ 75.00 | Tokens (ACH Payment to bank) | ||
| $ 25.00 | Tokens Cash | ||
| $ 100.00 | Tokens Check | ||
| $ 200.00 | Cash Sales |
To complicate matters (as if its not already too complicated) the deposits to the bank may be mobile deposits or ACH payments that occur days after the sale with little or no correlation to the invoices.
Any help would be greatly appreciated. Thanks.



