Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
Solved! Go to Solution.
Thanks for breaking down your concern in such detail, Matt. I can see how managing sales from multiple farmers' markets with various payment methods can be challenging. No worries, I'm here to help you handle this situation.
Beforehand, let's delete the payment applied to invoices that messed up your sales records. This way, we can fix and input the transactions/payments accurately:
Since the payments and fees are coming from different bank accounts, it's accurate that you've used the Receive payments feature to mark them as paid. However, it should be deposited to the Undeposited funds. Then, you can add the fees and tokens and designate them to the correct accounts using the Bank deposit function in QuickBooks.
Doing so ensures you can match the manually generated deposits to the ones downloaded from the bank accounts. Moving forward, you can mark the invoice as paid while depositing the payment to the Undeposited funds account:
Once you're ready to designate the amounts into the accurate accounts, let's utilize the Bank deposit feature and add the POS fees and Tokens received as negative values. By initiating this, the entries will be deducted from your overall invoice payments received (sales):
Following that, go to the Bank transactions page. Then, locate the entry and match it to the manually generated deposit. Meanwhile, exclude the downloaded data for POS Fees and Tokens. I'd also recommend seeking assistance from an accounting professional to ensure your books are accurate when initiating these procedures in the system.
I'm also attaching this resource, which will be handy once you reconcile your accounts in QuickBooks: Reconcile an account in QuickBooks Online. It can help verify that your entries are correct by referring them to your bank statement.
If you have follow-up questions about handling the payments, fees, and tokens received, tick the Reply button. I'm always available to help you promptly.
Thanks for breaking down your concern in such detail, Matt. I can see how managing sales from multiple farmers' markets with various payment methods can be challenging. No worries, I'm here to help you handle this situation.
Beforehand, let's delete the payment applied to invoices that messed up your sales records. This way, we can fix and input the transactions/payments accurately:
Since the payments and fees are coming from different bank accounts, it's accurate that you've used the Receive payments feature to mark them as paid. However, it should be deposited to the Undeposited funds. Then, you can add the fees and tokens and designate them to the correct accounts using the Bank deposit function in QuickBooks.
Doing so ensures you can match the manually generated deposits to the ones downloaded from the bank accounts. Moving forward, you can mark the invoice as paid while depositing the payment to the Undeposited funds account:
Once you're ready to designate the amounts into the accurate accounts, let's utilize the Bank deposit feature and add the POS fees and Tokens received as negative values. By initiating this, the entries will be deducted from your overall invoice payments received (sales):
Following that, go to the Bank transactions page. Then, locate the entry and match it to the manually generated deposit. Meanwhile, exclude the downloaded data for POS Fees and Tokens. I'd also recommend seeking assistance from an accounting professional to ensure your books are accurate when initiating these procedures in the system.
I'm also attaching this resource, which will be handy once you reconcile your accounts in QuickBooks: Reconcile an account in QuickBooks Online. It can help verify that your entries are correct by referring them to your bank statement.
If you have follow-up questions about handling the payments, fees, and tokens received, tick the Reply button. I'm always available to help you promptly.
Wow, thanks for the detailed and quick response. I'll work through this over the next few days and let you know if I can figure it out... (for at least a couple of transactions)
I really appreciate the prompt response and great instructions.
Hello there, Matt.
We in the Community are extremely happy that you were able to find my colleague's post helpful and able to resolve your issue. We're more than happy to help you if you need more assistance managing sales from multiple farmers' markets with various payment methods or any other QuickBooks related concerns.
If you need tips and resources to manage your QuickBooks Online account and finances, feel free to visit our Support page to learn more. This provides information to help your navigation experience be more effective.
Keep us posted if you have other questions or concerns. I’m here to help you out. Take care and have a great day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here