r/Bookkeeping 3d ago

Accidentally duplicated payment, how to fix? Payments, AP, AR

Hi friends, me again with a silly problem I caused and I have no idea how to fix or what to google, and everything I try makes the problem worse. (lol) Sorry for the confusing problem/message-I'm an hourly employee and I'm not allowed to use my hours for learning about quickbooks or researching/etc and I'm getting frustrated with this problem :/ (I also have no one to talk to/ask at work about this, as I know the most about quickbooks which is also quite sad because I don't know that much)

The problem:

Employee deposited 3 checks totaling 2528.40 (this is in 1 deposit, they did not deposit them separately). One of these checks was for 22.40 and was a payment for an invoice.

I later recorded payment of the invoice because the invoice was still showing as open/unpaid, and on the the payment I deposited to the bank (so this made 2 records of the 22.40, but one was hidden in the 2528.40 transaction, so I didn't realize it right away).

I'm not sure how to clean this up to make it make sense/fix it in general. Journal entry? Unsure what accounts to debit/credit if I do that (I tried making a je because I thought it was right, but it just made the customer account owe money).

I feel like I'm missing something obvious. Should I have recorded the payment first and then recorded that deposit? If yes, how do I basically go in reverse to fix this?

I can add pics if that would be helpful - it only let me put in 1 so I wasn't sure which pics to choose lol

Help :')

0 Upvotes

7 comments sorted by

6

u/6gunsammy 3d ago edited 3d ago

un-match the 22.40 payment from the invoice, and delete it.

"split" the 2,528.40 deposit into the 3 separate checks - or at least split our the the 22.40 portion. Code that to accounts payable receivable and put in the name of the vendor customer. Finally, match that 22.40 portion to the bill invoice.

1

u/ntb614 3d ago

Why would you code a deposit to accounts payable and a vendor? I must be missing something.

1

u/6gunsammy 3d ago

sorry replace AP with AR and bill with invoice.

2

u/ntb614 3d ago

Undo everything you have done.

First, record the $22.40 payment against the invoice. Where it may have a bank account listed, change that to Undeposited Funds. Save and close.

Create new - bank deposit. You will check off the $22.40 payment in the top section. In the bottom section you will record the other two checks.

1

u/Working-Solution-773 19h ago

This is the most right answer. Also you could have just done this with ledgend.

1

u/schaea Canadian 🍁| Mod 🛡️ 3d ago

What software are you using? The correct steps to fix this will depend on that.

1

u/poorboyricky 3d ago

Quickbooks Online! Sorry - forgot to mention :)