[GNC] Trail balance Imbalance / multi-currency transaction

[David Kirkby]

On Sat, 18 Nov 2023 at 13:40, Maf. King <maf at chilwell.net> wrote:

> On Saturday, 18 November 2023 04:17:50 GMT David Kirkby wrote:
> > Unfortunately, when entering the transaction into GnuCash, I created a
> > split and  put the £7 bank fee into Expense -> Bank Charges. The result
> is
> > that £7 is accounted for twice. I'm show it as an expense, but the bank
> > statement has already taken this into account.
>
>
> Where is the £7 accounted for twice?   Is it also in the exchange rate
> conversion or something?   What you describe above sounds exactly the
> correct
> thing to have done.
>

*I have discovered that's not the source of the problem, which explains why
it does not go away if I delete the transaction! *

I found the source of the problem by changing the end date of the
accounting period in GnuCash, then doing a trial balance. Things are okay
unless the end of the accounting period is set to 25/7/22 or later.

Looking at my accounts, there was a transaction on 25/7/2022, and that was
a foreign currency transaction where I purchased something in HK$1650.00.
There would have been a bank fee associated with that, but I might not
necessarily have recorded it separately, and I would have expected it to be
higher than £7, as I paid the vendor's bank charges too. But what I see is.

Debit: Expenses -> Stock  £214.45
Credit:Assets -> Bank account £207.45
Nothing is recorded in bank fees.

So I suspect that's the cause of the problem. The amount spent on stock for
that transaction is higher than the amount deducted from the bank account.

I have just made a backup of the accounts, unposted that HKD transaction
and deleted the transaction.  The trial balance indicates no problems.

Unfortunately I have reconciled the bank account, which meant deleting a
reconciled transaction.

What's the best way to solve this? Clearly something was wrong with that
transaction, I could re-enter it and it should solve the problem, but then
I have deleted a reconciled transaction.

Is it best to delete the transaction, or try to find where the £7 went to?

I'm rather uneasy. I have deleted a reconciled transaction, but the amount
deducted from the bank account shown in GnuCash matches what the bank
statement shows.

Dave .