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

help fixing square - undeposited funds

So I am trying to fix everything in my register right now, and the biggest problem is that my undeposited funds are showing super high. I have pinpointed the bulk of the problems to when we used square for a few weeks while waiting on our current processor to setup our MID.

 

I had given up trying to use a sales receipt like I do with our own terminal normally, because square takes it fees out off the top which was making it hard/impossible for me to get anything to populate and match  when deposits would be made. I ended up using square's autoimport feature on QB and it created a separate invoice for anything so they could be matched in bulk. The issue seems to be that it put everything into "undeposited funds"

 

Is there a way for me to fix this now without it being an absolute nightmare? It won't let me edit the deposits since it says they are matched already.

 

"This transaction has been deposited. If you want to change or delete it, you must edit the deposit it appears on and remove it first."

 

Whats the best way forward from here?

3 Comments 3
Catherine_B
QuickBooks Team

help fixing square - undeposited funds

Hi there, Dejekt. 

 

It looks like the invoices are automatically imported from Square, and the Deposit you matched to these invoices are from our Bank feeds. We can undo the match at one and from there, we can edit the payment. I'll guide you through the steps. 

 

First, let's undo the matched transactions. 

  1. Go to the Banking page and click the bank. 
  2. From the Reviewed tab, select all the deposits we've matched. 
  3. Click Undo above the Date column. 

Then, let's go back to the invoices and receive the payment for each. You can either deposit the payment to Undeposited Funds which we'll deposit it afterwards, or directly depositing it to the bank. Once we're done, we can now match the deposits to the payments we created. 

 

You can always refer to these articles for more details:

Reach out to me if you have other questions. Take care!

JennaD13
Level 1

help fixing square - undeposited funds

Catherine B -  will this method work if  bank transactions for that time frame have been reconciled?

 

MJoy_D
Moderator

help fixing square - undeposited funds

I can share some information that can help you with unmatching a reconciled bank transaction, @JennaD13

 

Yes, you can follow the steps provided by Catherine_B above in unmatching a reconciled transaction. However, I suggest reaching out to your accountant for advice since this can impact your accounts. 

 

After you undo the transaction, It'll go back to the For Review tab. For detailed guidance on how to match the transaction with an existing transaction or view its multiple matches, check out this article: Categorize and match online bank transactions in QuickBooks Online. That will also explain why there are transactions that don’t have a match. 

 

For detailed guidance on how to enter transactions into the Undeposited Funds account and record it as deposit, refer to this article: Deposit payments into the Undeposited Funds account in QuickBooks Online

 

In case you'll encounter errors after reconciling your accounts, you can view this article on how to create an adjusting entry to resolve any discrepancy: Enter an adjusting entry for a reconciliation in QuickBooks Online

 

Let me know if you have follow-up questions about undoing bank transactions that has been reconciled. I'm always here ready to help. Have a great rest of the day!

Need to get in touch?

Contact us