Duplicate Entries in Bank Account statement feed

[Slav]

I use the bank feed to get the transactions from the bank (Revolut Bussines).
The problem I’m having is that if I create a purchase (via receipts hub > upload invoice > create new purchase > paid in full > select source > revolut account, this is correctly match to existing transaction which is great BUT the instead of tagging existing transaction and adding this purchase / invoice to it, it creates an ADDITIONAL entry in the Statement list! The same goes for Sales invoices.

[rhc]

Hi,
When you use the bank feed, you should tag your invoices from the tagging button from the bank account, This way, it will look for matching invoices.
You could also continue the way you are doing it now and just delete the line in your bank account in quickfile which was brought in via bank feed.
Hope this helps

[Slav]

Thank you kindly for your reply!

I couldn’t see a way to match invoice from the bank feed, but will try to look again.

As for deleting the bank feed items, I thought I’ve tried it and it came back next when refreshing?
Will have to double check this as well…

Thank you for your help.

[QFMathew]

Hi @Slav

Can I just check I understood correctly on this point -

@Slav

this is correctly match to existing transaction which is great BUT the instead of tagging existing transaction and adding this purchase / invoice to it, it creates an ADDITIONAL entry in the Statement list! The same goes for Sales invoices.

Do you mean that it’s correctly picking up the original transaction in the bank account, but although you’re selecting it, it’s still creating a new one?

[Slav]

@QFMathew

Do you mean that it’s correctly picking up the original transaction in the bank account, but although you’re selecting it, it’s still creating a new one

hm, I don’t really know all the correct terminologies, as I am not accountant (but app dev) and my LTD is a few months old … but let me describe what happens on the example of that Amazon transaction that’s in the screenshot.

So it starts with transaction appearing in the bank feed (downloaded from Revolut open bank feed), the icon looking like “Upload to cloud”.

Now I go to my amazon purchase, download invoice in pdf.

1. go to Purchases > receipt hub
2. Drag my pdf there
3. Click on tag me
4. Fill in total amount
5. Will get “We couldn’t find any matching purchases on your account.Click the button below to create a new record.”
6. Create new purchase / fill in supplier , dates , amount and currency
7. Check “This item has been paid in full” and select: Paid from: Revolut Bussines (GBP) account

Then I’ll get a message this invoice / purchase has been linked to bank transaction…

When I return back to the bank feed now I see what is screenshoted above… Original bank feed transaction + this new created purchase as a separate item with the “door with arrow” icon.

So I end up with double purchase amount in overal balance.

Hope that answers your question?

[QFMathew]

Hi @Slav

Thanks for the information.

I’ve just had a go and wasn’t able to replicate it. But looking at your initial screenshot I notice the error - the dates are different. If the payment date was the same, it should prompt you to match to an existing payment. If the dates are different, it will create a new payment.

As @rhc mentioned above, it may be worth just creating the invoices from the receipt hub and then tagging from the bank account.

Hope this helps

[Slav]

Hi Mathew, Thank you for your reply.
The issue is that despite those differences in dates that invoice and created purchase

DID find and link to that Bank feed entry!

So usable / correct thing to do would be to simply TAG that existing bank feed entry (with the purchase info) instead of creating a new duplicate entry.

I can do a video capture next time I’m creating a new purchase to show you the whole issue, this happens to me all the time.

[QFMathew]

Just to clarify, what’s the date on the purchase invoice? Is it different to the tagged payment (30/01/2022)?

[ian_roberts]

@Slav

Check “This item has been paid in full” and select: Paid from: Revolut Bussines (GBP) account

This is where you’re going wrong - my rule of thumb is only tick the “paid in full” box if the payment came from an account that doesn’t have an automated feed (e.g. if you paid in cash). If you have a feed for the bank from which you paid, then don’t mark as paid in the receipt hub, instead wait for the “money out” to appear on your feed and tag the payment from there.

[Slav]

The date on the amazon invoice pdf is 31 January 2022:

[Slav]

I’ve tried now this route and it works, thanks for the advice! However, I still think this shouldn’t happen, as the item HAS been paid in full, so that’s factually correct, and just because I have automated feed, it shouldn’t create duplicate transactions like these when I go via receipts hub / new purchase route, especially since those feed transactions were linked to the purchase…