Hi,
I have imported transactions from my bank. I have imported my receipt in the ReceiptHub. However, the XE rate is different than the one my bank used at the same date. How can I match easily the receipt to the transaction?
Hi,
I have imported transactions from my bank. I have imported my receipt in the ReceiptHub. However, the XE rate is different than the one my bank used at the same date. How can I match easily the receipt to the transaction?
Hi @cedev
Because of the exchange rate difference, itâs tricky to match up the bank transaction with the actual invoice. The way to do this at present is to use the âLog Paymentâ option from within the invoice itself and create the transaction this way.
It may however create a duplicate transaction, in which case, you can simply delete the untagged entry. This also accounts for the currency difference within your account too.
Hi,
Thank you for coming back to me. I have just done what you suggested and I also modified the exchange rate so I would have the correct amount in GBP. However, it did not match the receipt with the bank transaction.
Am I correct in assuming the invoice is in a non-GBP currency, and the payment is in GBP?
If so, if you just enter the non-GBP and GBP values, QuickFile will calculate the exchange rate based on this. It may be slightly different to the bank because of rounding however, but itâs the actual figure thatâs important rather than the exchange rate.
How can I add the GBP value in the receipt hub? It does not allow me to do it.
Are you using the foreign currency field or the GBP field to match the transactions?
Apologies, I was a little confused by your original post - I werenât sure where you were tagging the transaction from as you mentioned importing bank statements.
With the receipt hub this does work from exchange rates, although we can consider allowing this to be overridden (youâre welcome to start a new feature request for this if you wish). There could very well be a small rounding issue here based on the entered exchange rate.
When we try to match the invoice in the first instance, we just take the value of the invoice and the value entered - regardless of currency. For example, I entered â24â on my test account to reveal one GBP 24.00 and one CAD 24.00 invoice:
When it comes to creating the invoice, you may just need to tweak the exchange rate slightly to adjust for the rounding issue - ultimately, the exchange rate doesnât play a part in the final accounts, itâs just the invoice value. Providing the GBP and the non-GBP values are correct, everything else should fall into place.
I hope that helps!
Thanks for the answer.
Where did you find the screenshot? I have never seen this before.
The screenshot above was taken from within the receipt hub. When you first tag a document, you enter the amount and it searches for purchase invoices that do not have a document attached (by default).
Once you click âTag Me!â for the document in the receipt hub:
And then enter the value of the document youâre trying to match, it will automatically try to find the related invoice for you:
In this case, Iâve just uploaded the QuickFile logo as a demonstration.
OK, so the problem is that I do not have invoices beforehand. My process is:
Thatâs perfectly fine . There are multiple ways of working within QuickFile and we try to keep it pretty flexible.
I will however make a recommendation to our team regarding the GBP value as discussed above.
That would be amazing!
This topic was automatically closed after 7 days. New replies are no longer allowed.