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

Matching undeposited fund payments to downloaded transactions

I have 9 transactions in un-deposited funds that I need to match to an existing deposit.  The deposit account is already reconciled with the deposits downloaded from the bank.  The person wasn't doing the deposits correctly and we just caught this.  The undeposited funds are for a payment of a Quickbooks invoice, 1 per month.  The deposits in the bank register includes the deposit for the invoice payment.

What is the best way to fix this, can I match these payments up to the older deposits.  Should I just delete the amounts in the undeposited funds since the amounts are already in the bank and reconciled?  I read that I could just do a net zero deposit and clear them.  While that did clear them, i didn't like the way the negative amount showed up on the balance sheet (or it is possible that I'm doing it wrong :)  )

Any help, insight would be appreciated.

Solved
Best answer March 25, 2020

Best Answers
Highlighted
Community Champion

Matching undeposited fund payments to downloaded transactions

To fix this, edit the deposits, click the Payments button at the top and add the correct payment(s) to each deposit.  Delete the existing detail line(s) of the deposit which aren't linked to payments. 

 

When you get done the deposit should be for the same amount, so the change won't negatively impact your reconciliation.

View solution in original post

2 Comments
Highlighted
Community Champion

Matching undeposited fund payments to downloaded transactions

To fix this, edit the deposits, click the Payments button at the top and add the correct payment(s) to each deposit.  Delete the existing detail line(s) of the deposit which aren't linked to payments. 

 

When you get done the deposit should be for the same amount, so the change won't negatively impact your reconciliation.

View solution in original post

Highlighted
Moderator

Matching undeposited fund payments to downloaded transactions

Hi @DMichaelweaver,

 

@BigRedConsulting gave some great instructions for you.  Those should get you on your way!

 

Let us know if you run into any issues.

 

Thanks,

Lucas

Need to get in touch?

Contact us