Purchase record not found by search

Support
1

Hi there, I have a purchase invoice and have now imported a CSV file of my bank statement. When I click the search button it is not finding the matching amount despite that I can see the two items clearly listed next to each other in the bank statement - one is tagged and the other isn’t. Could anyone help me work out why one isn’t finding the other please? (I’ve searched within a wide enough date.)

Many thanks in advance,

Emma

2

Are you searching from the bank?

Is it a debit or credit? If it’s a debit are you prefixing with a minus symbol?

3

I’m in the ‘bank statement section’. It was a payment made by debit card.

4

1196×105 15.4 KB

5

Whichever I search with it comes up as no matching transactions found as you can see in this image despite them matching in both amount and the word “currys"

1153×156 19.8 KB

6

OK so you’re clicking the small blue search icon next to the transaction?

What this does is search for items with similar descriptions. So if you have an item called PCWORLD 00001 it will search for anything starting with PCWORLD.

Those two transactions won’t find each other as they the descriptions are very different. For more search options it’s better to use the advanced search box here:

786×229 16 KB

7

Yes, I was clicking the magnifying glass. I’ve now done the advanced search as you’ve suggested and it brings up the two amounts but I need to match/reconcile one with the other rather than it being two separate entries. One is already tagged (with purchase invoice and picture uploaded from CamScanner(, the other isn’t (and was uploaded from the bank statement CSV file).
Thanks

814×454 51.8 KB

8

Just delete one (with the red X to the right) and if necessary tag the other.

9

Hi Ian, I thought that the bank statement was meant to reconcile with the purchase invoice or that when you searched for similar mouths within the correct date range then it’d flag up that there was already a purchase record but this hasn’t happened.

10

QuickFile does a couple of things here:

  1. When uploading a bank statement it will check for any matching entries on the bank with the same date and amount. The dates on the two entries you reference are different here so it wouldn’t have been caught (assuming you uploaded the statement after manually marking the purchase paid), nonetheless you can widen the range in the account settings if you want. See Account Settings >> Company Settings >> Advanced Features.

765×87 3.79 KB

  1. When you click to tag an untagged bank entry it will search for unpaid invoices + and - 1 month around the bank entry, again you can widen this search if you want.

Whenever you’re uploading a bank statement and manually paying down entries there’s always a risk you will get some duplication. Normally in such cases you’d just delete the untagged duplicate.