Shelter-in-Place Journal, Day 134

It’s been at least a month since I last opened Quicken, and I was beginning to feel a little guilty about it. So I sat down this afternoon to get caught up.

Quicken is one of those programs that I’ve used for years but never really liked. It’s only recently that they’ve offered a reasonably-competent Mac version, but the current edition does everything I need – if I can figure out how to get it to behave. It likes to associate my credit card automatic payments with the wrong account (sometimes it’s the wrong credit card account; sometimes it’s the wrong checking account; sometimes both) but I’ve learned to double-check them and get them to the right place.

My problems today, though, weren’t Quicken’s fault. I blame Apple and Goldman Sachs.

Both Diane and I got Apple Cards when we bought our most recent Apple products to get the 3% rebate, and there are other times when we choose to use them. At first, the only way to look at your card activity was on your iPhone, and there was no way to export the data to Quicken. Later, Apple started exporting to CSV, and people found a convoluted path to get it into a format that Quicken would accept.

Last month, Apple (or Goldman Sachs, but probably Apple) unbent a little and added a QFX format export – that’s Quicken’s native interchange format these days (replacing QIF, “Quicken Interchange Format”, which they’ve obsoleted). You still have to export the data from your phone, but it’s easy to move it to the Mac and then to Quicken – and I did that today for both of our accounts, current to the end of June (because you can’t download transactions for the current account for some reason).

When I tried to reconcile the accounts, neither of them balanced. I carefully examined each and every transaction to make sure nothing was duplicated or omitted from the time I’d had to manually enter the data – nope! I even looked at the QFX files in a text editor to see if anything had been omitted there – nope! I finally decided to skip reconciling, which bugged me no end.

”¨A couple of hours later, I had a brainstorm and went back to look at the QFX files. One of the fields in the file is the “Ledger Balance”, which Quicken shows as the “online balance”, and which is the target balance for reconciliation. Here’s what it looks like in my download of May transactions:

<LEDGERBAL><BALAMT>-123.45<DTASOF>20200729120000[0:GMT]</LEDGERBAL> 

Or, in English: my balance was $123.45 as of 12:00:00 UTC on July 29, 2020.

There are at least two problems with this:

1) July 29, 2020 at 12:00:00 UTC is still in the future
2) The balance shown is my true current balance as of right now, but I have no way to download this month’s transactions (and I was looking at May, anyhow).

No wonder things didn’t balance! Thanks, Apple!

After I’d had enough of Quicken, I finally did get around to processing a couple of days’ worth of photos from 2005. I kept the last photo we took of our first Prius after it gave its all for Diane, and I found the first photo I took of RPI Reunion 2005 – the bed in our room at the Hotel Desmond. I’m not sure it was worth the effort of firing up Lightroom for those two photos – you be the judge.