Duplicate Deposits when Synchronizing Bank Account

threehorn

Hello

When I receive a manual check payment against an invoice, it credits my bank account. Then, when I synchronize my bank account, it shows the same credit from when I deposited the check. What is the best practice to handle this duplicate transaction?

QaisE

Hi @threehorn - thanks for reaching out to us on the Community! You bring up a great question here. Normally, when you have a bank connection in Wave, invoice payments that are manually recorded will often duplicate with the deposit transaction you receive from your bank connection. The best practice here is to merge the two transactions together when they appear.

To merge, go to Accounting > Transactions, select the checkboxes next to the transactions and click merge up top - near the delete button.

However, there is another process you can try that would avoid having duplicates in the first place. Instead of recording the payment on the invoice, you can leave it unpaid until you receive the deposit transaction from your bank connection. When the deposit comes through, you can categorize the transaction as a Payment Received for an Invoice in Wave and then select the outstanding invoice. This will mark the invoice as paid without having to create a separate transaction for it. Hope this helps!

threehorn

Thanks!

The second process seems to be the best solution. I appreciate it!

Erik

threehorn

Sorry, another question though....

One of the deposits that came through was for two invoices. It cannot merge one deposit with two payments even though they total the same.

Can I delete the two payments and reprocess this as you described in the second solution above?

CallieP

Hey @threehorn , thanks for getting back! You got it, you can delete the payments and then reassign them to the invoices individually if that's what works best for you!

threehorn

Hi,

I am still having this same challenge.

I have a deposit that was payment for 6 invoices. See below.

I have already put those payments in manually, but I know I can delete those payments as you have stated earlier. My challenge is... How do I assign the deposit to be the payment for multiple invoices?

Erik

CallieP

Hey @threehorn , thanks for your message. If you need one deposit to be assigned to multiple invoices, what you'll want to do is split this deposit. Head to Accounting > Transactions > click the deposit > on the right hand editing modal, click 'Split this deposit' (you may need to scroll down to see it). Learn more here as well! Then, you can assign the category of each split to 'Payment Received for an Invoice in Wave', then, choose the outstanding invoice.

Flopbot

@QaisE ,

Thanks for the great best practice advice! That is good to know!