Inter-account transfers - incorrect dates & bank fees
Question asked by Lisa Coley 4 months ago
I have a double-ended question here.
We have UK £ bank accounts and overseas € accounts and occasionally we transfer money between the accounts.
I have one accounts (lets call it Euro 1) that has barely any transactions, in fact, it's just 9 in total for all of 2019/20.
We have transferred from another Euro account (let's call is Euro 2) that has over 100 transactions per month into the Euro 1 account 4 times in that year, €10,000 each time.
I have loaded the bank statement for each account into Clearbooks, and reconciled these payments using the Transfer tab.
However, looking at the total transactions for Euro 1 account I'm actually seeing 13 transactions (4 extra than the 9 there actualy are) and I assume this is because the £10,000 amount leaves Euro 2 account on, say, 9th April but arrives in Euro 1 account on 10th April. I assume that Clearbooks thinks these are two separate transactions. How can I solve this, as it shows my closing balance for Euro 1 account as £40,000 more than it should be! Do i have to delete items from the Euro 1 statement?
Second question, one of these transfers looks like it incurred a €26 bank fee, as €10,026 left Euro 2 account but only €10,000 arrived into Euro 1 account. I have tried reconciling this in the Euro 2 account statement as €26 using the transaction tab (creating is as a bank charge) and then using the Transfer tab to show just €10,000 arriving in Euro 1 account. However, going to the Euro 1 account, it is still showing as €10,026 arriving into the account. How do I get around this?
Essentially, my Euro 1 account balance is showing as €40,026 (the 4 erroneous payments in + the €26 bank charge) more than it should be.
Please can you help?!