I have taken over a client file, and somehow a prior GST return doubled itself when it was paid. The original filing (journal entry) showed an amount owing of $3,902.57. The bill was not paid completely (short $0.06), but when I review the bill payment, it says "Bill Amt" of $3,902.57 (which is correct), "Amt Paid" of $3,902.51 (which is also correct), and "Amt Due" of $7,805.08" (which is the sum of the original bill plus the payment - not correct at all!) Now my trial balance and A/P summary have a discrepancy of $3,902.57.
If I advance both the trial balance and the A/P summary day by day, I can see the date at which they stop matching - but there's nothing in the transactions (drilled down from the trial balance) to show why it's there, and if I drill down in the A/P summary where it suddenly shows up again, it just takes me back to the original journal entry of the tax filing that was paid.
The outstanding amount shows up in payables again, but if I "pay" it, it affects both the A/P summary AND the trial balance, which puts me right back where I was to begin with. However, to make things even weirder, when I go back into the payment, it keeps showing "Bill Amt" of $3,902.57, "Amt Due" of $3,902.57, and "Amt Paid" of $0.00 - even though the amount at the top is $3,902.57. I click it off, so that it shows "Amt Paid" of $3,902.57, and as soon as I save it, it reverts to $0.00 again.
I've tried rebuilding the file, but it says there's no problems. Is this fixable, or should I just restart the file from the year-end trial balance?
