Searching journal transactions and resolving unallocated cash issue
Problem reported by James Hayes 10 years ago
Following an accidental VAT overpayment a few years back we have a couple of "Unallocated cash" transactions showing that I would really like to clear from the system.
The original VAT overpayment is reconciled in the accounts, as is the repayment from HMRC of that amount - so i don't know why there are, what appear to be, duplicated unallocated transactions for the same as the bank balances are fully balanced. Clearly we've entered something wrong at some point and then subsequently amended things, but it's not at all clear from the system whether the duplicated entries are amended transactions that supercede earlier transactions or not.
There appear to be 4 transaction ID's that i can find (5 if we include the original non-duplicated VAT payment) - but there may be others. Some do not appear to be allocated to HMRC as an entity though. The easiest way of tracking them down is to search for transactions containing the amount paid "£1396.14" - but if i search for that figure it only appears to include PAY or PUR references - not journals themselves.
Are you able to run an exhaustive search for the above transaction value, confirming details of all and any transactions or manual entries that include that figure. If you're then able to confirm which of those entries correspond to the two that are visible in "unallocated cash" that would be ideal, and furthermore advise how best to remove those two unallocated entries.
regards,
James