cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts less than the deposit amount. How do I view all payments instead?

 
Solved
Best answer 03-08-2019

Accepted Solutions
Moderator

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

Hi there, @johnny9x.

 

Thank you for getting back with the Community and provide more details about your concern. Allow me to help share other ways to match your deposit to the payments recorded in QuickBooks, and get this straightened out. 

 

You can record the payment with the total amount ($2175) to Undeposited Funds and enter the fee as a negative amount on the Bank Deposits screen when depositing the payment. This way, when you go to the Banking page, you'll match the exact value of the deposit ($175).

 

To start, you need to create an invoice with the total amount of the payments. After that, you need to record the invoice payment.

 

Let me show you how:

  1. Open the invoice.
  2. Click the Receive Payment button.
  3. Select the invoice you created on the Receive Payment screen.
  4. Enter the amount.
  5. In the Deposit to field, choose Undeposited Funds.
  6. Click Save and close.

 

 

After that, enter a Bank Deposit for the Merchant Service fee to clear the balance from the Undeposited Funds account, and move it to your bank account. 

 

Here's how:

  1. At the top right, click the Plus (+) icon.
  2. Select Bank Deposit.
  3. Mark the invoice payment you received previously from the Select the payments included in this deposit section.
  4. Expand the Add funds to this deposit section to add a new line item.
  5. In the Received From column, enter Square as a vendor.
  6. In the Account column, select Bank Charges and Fees or select an expense account you use to track these fees.
  7. In the Amount field, enter a negative fee amount (-0.74).
  8. Make sure the deposit matches the net bank deposit amount.
  9. Click Save and close.

 

Once done, you can now match the bank deposit on the banking page. These resources should help to get you on the right track for matching your bank transactions.

 

Stay in touch if you have any other questions about matching your downloaded bank transactions into QuickBooks Online. I'll be delighted to be your guide once again.

View solution in original post

5 Comments
Highlighted
QuickBooks Team

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

Hello @johnny9x,

 

Let me show you how you can view all payments.

 

Here are the steps:

 

1.    Go to Banking on the left side of your screen.
2.    Select Banking.
3.    Click the name of the business.
1.    Select the transaction and click the Find Match button.
4.    On the Match transactions window, choose the specific date to show all transactions that match with the deposit.

 

You can also go through the Find matching transactions section in this article for more information: Add and Match Downloaded Banking Transaction.

 

For any other concerns, please feel free to post again here in Community. Have a wonderful day!

Level 2

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

I followed the steps listed below, however I only see payments LESS THAN the deposit amount.  I want to view all my payments for a certain day even if they are MORE THAN the deposit amount.  Any idea how I can do that?

QuickBooks Team

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

You can filter the date range of the downloaded bank transactions to view all the payments, johnny9x. 

 

If you still can't see the transactions, you can click the Update now button at the upper-right corner of the Banking page. 

 

Here's how you can set the date range: 

  1. Go to the Banking page and then choose Banking
  2. Click the For Review tab. 
  3. On top of the DESCRIPTION column, click the filter icon to show details. 
  4. You can choose or enter the Date, From and To.
  5. Then, click Apply

Let me know if you have other concerns. 

 

Level 2

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

Let me try to be more clear, my payments are in Quickbooks however I cannot view them after clicking "Find Match" if they are LARGER than the deposit amount.

 

For example:

I have payments ranging from $10 to $700 on March 2.   If I click a bank deposit of $175, then "Find Match", I only see payments on March 2 ranging from 0 to $175.   Now if I click on a bank deposit of $1000, then "Find Match", I see all my payments for March 2 (everything from the $10 up to the $700).  

 

I believe Quickbooks is trying to be smart and filters out the higher payments.  Unfortunately this doesn't work for me since my merchant service deposits will withdraw their fees, then deposit the remainder of the deposit (ie: they only deposit $175, when the total payments for that day was $2175 and fees were $2000) . (this happens once a month where the merchant services takes the monthly fees out of 1 day's deposit.  

 

I don't believe there is a solution to this problem, only that I need a feature upgrade to allow me to see all my payments for a day after clicking "Find Match" even when they are higher than the deposit amount.

Moderator

Re: Quickbooks Online - For my bank deposits, clicking find match only shows payments of amounts ...

Hi there, @johnny9x.

 

Thank you for getting back with the Community and provide more details about your concern. Allow me to help share other ways to match your deposit to the payments recorded in QuickBooks, and get this straightened out. 

 

You can record the payment with the total amount ($2175) to Undeposited Funds and enter the fee as a negative amount on the Bank Deposits screen when depositing the payment. This way, when you go to the Banking page, you'll match the exact value of the deposit ($175).

 

To start, you need to create an invoice with the total amount of the payments. After that, you need to record the invoice payment.

 

Let me show you how:

  1. Open the invoice.
  2. Click the Receive Payment button.
  3. Select the invoice you created on the Receive Payment screen.
  4. Enter the amount.
  5. In the Deposit to field, choose Undeposited Funds.
  6. Click Save and close.

 

 

After that, enter a Bank Deposit for the Merchant Service fee to clear the balance from the Undeposited Funds account, and move it to your bank account. 

 

Here's how:

  1. At the top right, click the Plus (+) icon.
  2. Select Bank Deposit.
  3. Mark the invoice payment you received previously from the Select the payments included in this deposit section.
  4. Expand the Add funds to this deposit section to add a new line item.
  5. In the Received From column, enter Square as a vendor.
  6. In the Account column, select Bank Charges and Fees or select an expense account you use to track these fees.
  7. In the Amount field, enter a negative fee amount (-0.74).
  8. Make sure the deposit matches the net bank deposit amount.
  9. Click Save and close.

 

Once done, you can now match the bank deposit on the banking page. These resources should help to get you on the right track for matching your bank transactions.

 

Stay in touch if you have any other questions about matching your downloaded bank transactions into QuickBooks Online. I'll be delighted to be your guide once again.

View solution in original post

Need to get in touch?

Contact us