Hi all:
Today I was idly doing some maintenance on my Quicken Deluxe 2010 file when I noticed that a credit card account that I very rarely use – though I’d made a small charge with the card a couple of weeks ago – was showing a debit balance (a “receivable” situation) instead of the small credit balance (“liability”) it should have shown. As I hadn’t used the card for at least a year prior to my recent small charge it was easy to deduce the amount of the error was $187.00, exactly.
Scrolling backwards through the credit card register it was clear that the error that had occurred was affecting the Quicken file well into the past: long periods of time where the balance should have been $0 were showing up as a debit of $187.00.
Since I print regular monthly “P&L” and “Balance Sheet” reports and reconcile the change in the Balance Sheet to the P&L it was easy for me to look back through prior months’ reports and see that this wasn’t an error I had somehow overlooked. It was clear that this error had somehow *physically* occurred in the file this month, even though it was affecting the reported balance in this account for many years in the past.
I also maintain credit card monthly statements for a considerable period of time so I kept working backwards until I came to the culprit: an “Opening Balance” entry in the Quicken file – marked as Reconciled – dated 4/15/2003 for exactly $187.00! My old statements confirmed that the actual credit card balance at that date was $0.
Unless I had somehow entered a fugue state and made that 4/15/2003 entry – I don’t think so – that Opening Balance entry was somehow generated by Quicken.
Two lessons:
1) You don’t use Quicken in situations where the data file absolutely, positively has to be bullet-proof.
2) The maintenance – outside of Quicken - of reconciliations of changes in net worth to the “Overall Total” of periodic Spending Reports will save your bacon, and your sanity.
Tom Young