QFX Import - Account Balance

tashtut

I have been having the toughest time getting answers for my issue from support. Basically I needed to start my credit card import from scratch, after much back and forth from support here is where I am at and what I still don't understand.

1. Started new credit card and auto imported transactions from Citibank, which went back to July.
2. turned off auto downloads
3. imported transactions from June-July via QFX file from my bank account to quicken (confirmed there are no duplicates and that all transactions matched my statements.
4. HERE IS THE MAIN PROBLEM: Quicken support said I needed to change the live opening balance date to the date before the last transaction I imported....I did this and it made "today's balance" not match my bank account balance. Then I was told to change the live opening balance to match my bank account balance to match that date. This still made "today's balance" not match my online account. So I just started over steps 1-3 and imported June-July and then again May-June...and by not changing the live opening balance date or dollar amount my account now continues to match what my live balance is online as it auto-imports transactions.

So I don't understand why I need to change anything about the live opening balance yet that is continually what I am told to do.

Chris_QPW

tashtut said:

I needed to change the live opening balance date to the date before the last transaction I imported...

This statement is incorrect.

You are to change the OPENING balance not the balance for the last transaction.

When you downloaded the transactions, not all of them in the online account were downloaded.

That means unless you just happened to have zero dollars in the account at the start of that period Quicken had to put in an Opening balance for the amount that was in before that first transaction.

Now you come in and back fill the transactions.  Clearly your opening balance (the one before all the transactions in the register) needs to change so that as each transaction is added when you get to the end you will have your current balance.

I use Quicken Windows and the way it would do this is put in a transaction with a payee of "Opening Balance" with a date just before the first transaction, with a special syntax for the category that implies that the amount came from outside of Quicken.

Since it would have done that for the first download, you would go in and back date it to before the "back filling transactions" that you download, and for an amount of what would be in the account on the day before your first transaction.  This is what they are talking about, but the terms they are using are incorrect (as last transaction is actually the first transaction in the register).  Note if you have all the history of that account, then the account would start with a zero amount and as such just removing an "Opening balance" transaction would be the same as setting it to zero.

I'm not sure how Quicken Mac handles the opening balance, so someone that knows Quicken Mac will have to state how that is done, but the principal is the same, you are always talking about compensating for the amount that might be in the account before the transactions you do have in the Quicken register.