I recently purchased the automatic bank feed for my business account. I also send in all of my receipts to quickfile to monitor my transactions. However is there a way to automatically link receipts to my bank transactions and create a purchase?
Initially i would upload a receipt and tag as paid, this would deduct from the relevant account, however with the bank feed, if I were to repeat this process, my bank feed would have already uploaded a transaction (from what I paid at the time), then if I upload and tag the receipt, it deducts this AGAIN from my bank. So I end up with duplicate transactions in my bank account.
I want to be able to have the bank feed, automatically create the purchase, upon which I then attach a receipt to for records - or at least a process as close as.
Am I missing something? My main irritation is it has made the bank feed purchase almost redundant.
There are a few ways around this, but it depends on your use case.
You could set up bank tagging rules to create purchase invoices for the incoming bank transactions. This would automatically create the invoice for you, leaving you to simply attach the file. However, it would only be a short invoice (e.g. a generic description).
The other way would be to create the purchase from the receipt hub itself. When you reach the last part, tick the āPaid in fullā box, select the bank account and we will automatically search for a bank transaction matching the amount (I will need to check the date range for this and come back to you)
If neither of these fit the bill, then at this time, Iām afraid the way youāre doing it would be the only solution.
Thank you very much for the prompt response, I really appreciate it.
In regards to your first element, where is it I would attach this? Currently if I navigate to my bank, click on the āTaggedā button to open the short invoice, there is no ability to attach any documents?
In regards to the 2nd - I have attempted to perform this route, however it does not find the duplicate transaction, even when I have purposely put it in to meet the criteria. Or do you mean this is something I would have to do this prior to the bank feed update and the feed will identify the duplication?
You would attach it through the Receipt Hub as normal, but when you enter the total, weāll search for any matching purchase invoices based on this.
But the bank tagging rule has to exist at the time the transaction is created. These can be created either by going through the tagging process and ticking the box to save the rule, or by going to Banking >> Bank Tagging Rules.
Typically, if the bank transaction exists when you select Paid in Full, it will search for it and it should show you. Although please let me know if this isnāt the case and Iāll take a look for you
I have set up all bank tagging rules. And have also retried the second option again however it does not seem to find the duplicate transaction and instead duplicates, despite having a matching transaction amount and date of transaction.
I went through the flow of the receipt hub, purposely stating an invoice date prior to the transaction:
And on the last step, it found the transaction:
I will need to check on this, but I believe there is a setting that comes into play here. In Account Settings >> Advanced Features, thereās the following setting:
Thank you sir! I will give this a go and feedback.
Part of my error may come from the fact that my bank feed upload usually automatically tag (but i did try one untagged) - and I match the date to the exact same time - I will try an input a date prior to the transaction date and see what happens.
