cancel
Showing results for 
Search instead for 
Did you mean: 
Matt Johnson_CHD
Level 1

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.00POS deposit to bank acct
   $    18.00POS Fee (Expense)
   $    75.00Tokens (ACH Payment to bank)
   $    25.00Tokens Cash
   $  100.00Tokens Check
   $  200.00Cash 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
Best answer 3 weeks ago

Best Answers
Ivan_G
QuickBooks Team

Point of Sale results in multiple invoices with multiple payment sources

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:

 

  1. Go to the Sales menu and select All sales.
  2. Locate the payment you've generated from the list.
  3. Tick its designated dropdown arrow under the Action column.
  4. Choose Delete, and when prompted, confirm the action by clicking Delete.

 

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:

 

  1. Open the Receive payments page.
  2. Select the Customer and the accurate Invoice from the Outstanding transactions list.
  3. From the Deposit to section, select the Undeposited funds or the Payments to deposit accounts (depending on what is visible on your end).
  4. Complete the rest of the form and double-check everything.
  5. Once done, hit Save and close.
    image (3).png

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):

 

  1. Go to the + New menu and select Bank deposit.
  2. Choose the Account to which the payment should be deposited.
  3. Pick the accurate payment from the Select the payments included in this deposit section.image (4).png
  4. Enter the fee and token's Amount as negative values and choose an expense Account designated for these data. If you've yet created one for each, here's how:
    • Click the Account column and then + Add new.
    • Use Expense as the Account Type, and Name the accounts as POS Fees and Token Received
    • Choose the appropriate Detail Type and then Save and Close.
  5. You may also input essential notes for each entry using the Description column.
  6. Complete the rest of the form, and once done, hit Save and close.SSSS.png

 

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.

View solution in original post

3 Comments 3
Ivan_G
QuickBooks Team

Point of Sale results in multiple invoices with multiple payment sources

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:

 

  1. Go to the Sales menu and select All sales.
  2. Locate the payment you've generated from the list.
  3. Tick its designated dropdown arrow under the Action column.
  4. Choose Delete, and when prompted, confirm the action by clicking Delete.

 

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:

 

  1. Open the Receive payments page.
  2. Select the Customer and the accurate Invoice from the Outstanding transactions list.
  3. From the Deposit to section, select the Undeposited funds or the Payments to deposit accounts (depending on what is visible on your end).
  4. Complete the rest of the form and double-check everything.
  5. Once done, hit Save and close.
    image (3).png

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):

 

  1. Go to the + New menu and select Bank deposit.
  2. Choose the Account to which the payment should be deposited.
  3. Pick the accurate payment from the Select the payments included in this deposit section.image (4).png
  4. Enter the fee and token's Amount as negative values and choose an expense Account designated for these data. If you've yet created one for each, here's how:
    • Click the Account column and then + Add new.
    • Use Expense as the Account Type, and Name the accounts as POS Fees and Token Received
    • Choose the appropriate Detail Type and then Save and Close.
  5. You may also input essential notes for each entry using the Description column.
  6. Complete the rest of the form, and once done, hit Save and close.SSSS.png

 

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.

Matt Johnson_CHD
Level 1

Point of Sale results in multiple invoices with multiple payment sources

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.

AdonL
QuickBooks Team

Point of Sale results in multiple invoices with multiple payment sources

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us