Skip to main content
December 19, 2023
Question

Bank Feed Deposits Matched to Journal Entries Still Showing as Not 'Recorded'

  • December 19, 2023
  • 2 replies
  • 0 views

In our QBO, we account for bank deposits in with Journal Entries: the total of the deposit is listed as a Debit, then subsequent items (everything included in the deposit) are listed as Credits, with Cash as 'Undeposited Funds' charted to the customer account for our POS system under Name, and Checks as their own line items as AR and charted to the proper customer account under Name. In the end we have the deposit total that matches the deposit our bank received.

 

I match these Journal Entries to the Deposit shown in our bank feed--all good there. BUT, I am getting a message on the QBO home dashboard that reads:

 

Some QuickBooks Payments deposits weren't automatically recorded. After you receive the funds in your account, record them manually as a Bank Deposit.Take Action
 
When I click the "Take Action " link, I see a list of all the cash lines on the Journal Entries I noted above, seemingly waiting for deposit. Is matching the Journal Entry to the deposit in the banking feed not enough to actually record them, thus leaving them sitting in Undeposited Funds? What else should I be doing?
 

2 replies

December 19, 2023

Hello there, Bpetryak. Allow me to share a way to record your bank deposits successfully.

 

We need to record the deposits that did not automatically get recorded manually. Here's how:

 

In the Merchant Service Center:

 

  1. Go to Company Settings, then select Payments. Click Manage details to open the Merchant Service Center (MSC) in a new window or tab.
  2. In MSC, go to Activity & Reports and select Deposits.
  3. Pick a date range and click Search.
  4. Expand deposits by clicking the arrow next to them.
  5. Click the Hide/Show Columns button and toggle Trans ID. This helps with matching the right transactions from QBO.

 

In QuickBooks Online:

 

  1. Go to the + New button and select Bank deposit. Then click the QuickBooks Payments header with card logos to expand them.
  2. Using the MSC report, create one deposit at a time in QBO by checking off the correct payments.
  3. Compare Trans ID with MSC. In QBO, click the Payment or Sales Receipt, then click the Transaction was processed link below the Payment Method. This pops up the Transaction ID in QBO.
  4. Repeat these steps for all deposits that need to be created in QBO.

 

After successfully matching your transactions, you can now reconcile your accounts to balance your books.

 

Let us know if you have further questions regarding matching your transactions. The Community is always here 24/7 to provide assistance. Keep safe.

December 22, 2023

Hi,

 

That sounds a bit confusing, but I'll look into the steps you're describing. This doesn't quite answer my overall question of process/best practice... should I be doing theses steps all the time? What's the point of matching anything to the transactions in the bank feed if it's not to tie a QB transaction to bank activity, thus 'finalizing it'?

 

Thanks

December 23, 2023

Thanks for getting back to the thread, bpetryak.

 

Let me jump into this conversation and provide you with further insights on the possible reason why you're getting the error message even after matching your downloaded transactions.

 

Once you sign up for QuickBooks Payments, QuickBooks automatically adds a deposit if there’s a matching sales receipt or invoice payment in your account.

 

If not, then you'll get the alert “Some QuickBooks Payments deposits weren't automatically recorded. After you receive the funds in your account, record them manually as a Bank Deposit.”


Please note that if you process payments in the Merchant Service Center, your deposits won’t import into QuickBooks Online. Therefore, you’ll have to add them manually in the program. Whenever possible, I'd suggest processing your payments in QBO so you don’t have to do this.

 

To find out which deposit isn't recorded in QuickBooks, please follow these steps:

 

  1. Go to Settings , then select Account and settings.
  2. Click Payments, then Manage Account.
  3. Select Activity & Reports and click Deposits.
  4. Select the latest deposit to see the individual payments.

 

Once done, follow these steps to record the deposit in QuickBooks. 

 

  1. Go to + New and click Bank deposit.
  2. Select the QuickBooks Payments section.
  3. Match the payments in the list with the payments in the Merchant Service Center report.
  4. Select Save, then Close.

 

If the total deposit doesn't match, add the sales in QuickBooks Online and add them to the deposit. Or, use the Add funds in the deposit section.

 

To prevent the same error message from happening in the future, let's make sure that payments and processing fees will be recorded to the correct accounts. For additional reference, you can check out this article: Choose where to record payments and processing fees for QuickBooks Payments.

 

After categorizing your downloaded transactions, you can reconcile your accounts to ensure they match your bank and credit card statements.

 

Please let me know if you have further queries about matching your transactions. I'm always here to help you out. Have a good one.