I think the question/answer are "backwards" @Karthic is saying that the transfers are being included, when the shouldn't. @Sherlock you are explaining why transfers shouldn't be included.Personally, I'm not seeing any transfers on the Spending tab, which is exactly how it should work.
Here is my screenshot. I masked some of the amounts while posting over the internet. You can see two items selected as "Citi Online". Those two are the payments made from my checking account that is messing up the spending calculations.
Transaction download problems with matching and adding
new transactions correctly?
First please ensure
that all optional settings in Quicken pertaining to recall, memorization,
automatic categorization and renaming of payee names are enabled. You find
those settings in Edit / Preferences / Data Entry & Quickfill and
Downloaded Transactions. Additional settings for the detection and processing
of transfer transactions can be found in Edit / Preferences / Transfer
Are you automatically accepting downloaded
transactions into your registers?
If you are relying
on Quicken to "automagically" fill your account registers from
downloaded transactions, you may run into problems. Despite all efforts by the
Quicken programmers, the "Autopilot" (that's my name for the part of
the Quicken program which processes downloaded transactions and converts them
into new register transactions) is not infallible. For that process to work
100% of the time one would need a crystal ball because the information
downloaded from the banks often is just too terse and cryptic.
You should, at least
for a while, turn off the "automatically accept downloaded transactions
into registers" setting to gain better control over what is downloaded and
what to do with it. Click on and review each downloaded transaction, make changes
if necessary (e.g., to get a payee name = "Starbucks" instead of
"POS TRANS 070119 STARBU", "POS TRANS 070219 STARBU",
"POS TRANS 070319 STARBU" or to assign a category) before you click
to accept each transaction.
Any changes you make
to downloaded Payee Names are remembered in Renaming Rules.
Any other changes
you make (add/change Category or Memo text) are remembered in the Memorized
Next time the same
transaction for this Payee comes along, Quicken should remember and give you a
better new register transaction.
Paper checks you write should be recorded in Quicken as you write the check
(and BEFORE you download transactions which might contain the cleared check).
That gives you a register transaction with correct check number, payee name and
category. No matter what information is downloaded from the bank, you already
have a correct register transaction which the downloaded data cannot mess up.
In case you have issues with transfer transactions not
being generated correctly:
For best results
manually enter transfer transactions into your register BEFORE you download
transactions from the bank which contain the transfer confirmations. For
recurring transfers use scheduled reminders and enter them a day or two before
the due date. Be sure to use distinct Payee Names for each transfer / credit
card payment to avoid confusing Quicken - memorized payee entries.
That takes the guesswork out of the Autopilot's process. Because a correctly
entered transfer transaction already exists in your account registers, the
Autopilot should just match the downloaded transfer transaction to the existing
one in both accounts.
Where are the "Auto-accept downloaded
There are two places
where this is controlled in Quicken for Windows:
- Globally, for all accounts, in Edit /
Preferences / Downloaded Transactions
- For each account individually, the
global setting can be overridden from the Edit Account Details screen, Online
Services Tab. Look for blue text "Automatic Entry is: ON / OFF".
Click the text to change the setting.
Thank you, Chris. I could fix the empty categories for this year, and it is better now. There are a few more things I had to investigate and hope it may give a real picture of my spending. Here is my observation - When quicken downloads the data for the accounts online, it marks TXFR on so many external financial institutions that supports electronic funds transfer thus leaving the category empty if the transaction date and posting dates are different for the same transaction amount. Moreover, due to TXFR markings, category lookup/pulldown prefills only the accounts in my list for the transfer. I had to manually remove TXFR, keep it empty so that I can assign the right category. It's a lot of manual work after downloading to get the right picture. Once again, I appreciate your help. Thank you!