On Sat, 18 Nov 2023 at 13:40, Maf. King <m...@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 . _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
