Home Page link  

Assign batch categories

 

Quicken Personal Finance Discussions - Quicken - personal finance software discussions

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Assign batch categories QGuy 02-23-2007
Posted by QGuy on February 23, 2007, 12:49 am
Please log in for more thread options
Hi,

I'm using Quicken 2007 and wonder how I can achieve the following.

I've downloaded a whole bunch of transactions from my bank.
Basically all that's there is the company, amount and balance, that's
it.

How can I select a bunch of transactions and assign a category for
them, in batch, instead of one by one?
Then I'll be able to do reports much easier than the way things are
now.

TIA

Ric

--
Posted via a free Usenet account from http://www.teranews.com


Posted by John Pollard on February 23, 2007, 9:34 am
Please log in for more thread options
QGuy@ether.net wrote:
> I'm using Quicken 2007 and wonder how I can achieve the
> following.
>
> I've downloaded a whole bunch of transactions from my
> bank. Basically all that's there is the company, amount
> and balance, that's it.
>
> How can I select a bunch of transactions and assign a
> category for them, in batch, instead of one by one?
> Then I'll be able to do reports much easier than the way
> things are now.

If you haven't "Accepted" the transactions yet, Accept one,
Memorize it, make sure QuickFill is on; then when you accept the
others, Quicken will give them the same category as the first.

If the transactions have already been Accepted into your Quicken
register, use Find/Replace to find all the transactions for a
given payee, then replace the blank category with the category
of your choice. (And you still should probably Memorize one of
those transactions so the next time you download for that payee,
Quicken will categorize the transaction for you.)

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Posted by QGuy on February 23, 2007, 11:51 pm
Please log in for more thread options
wrote:

>If you haven't "Accepted" the transactions yet, Accept one,
>Memorize it, make sure QuickFill is on; then when you accept the
>others, Quicken will give them the same category as the first.
>
>If the transactions have already been Accepted into your Quicken
>register, use Find/Replace to find all the transactions for a
>given payee, then replace the blank category with the category
>of your choice. (And you still should probably Memorize one of
>those transactions so the next time you download for that payee,
>Quicken will categorize the transaction for you.)

Thanks John!
I have accepted them so I'll have to use your second method.

Ric

--
Posted via a free Usenet account from http://www.teranews.com


Posted by QGuy on February 24, 2007, 12:04 am
Please log in for more thread options
wrote:


>If you haven't "Accepted" the transactions yet, Accept one,
>Memorize it, make sure QuickFill is on; then when you accept the
>others, Quicken will give them the same category as the first.
>
>If the transactions have already been Accepted into your Quicken
>register, use Find/Replace to find all the transactions for a
>given payee, then replace the blank category with the category
>of your choice. (And you still should probably Memorize one of
>those transactions so the next time you download for that payee,
>Quicken will categorize the transaction for you.)


John I just tried to memorize a transaction and see there will likely
be problems.

A utility name adds its transaction number at the end of its name.
Obviously each month this transaction number will be different.

Is there some way to get around this? Just memorize the name and not
the number after it? If so, how would I do this?

TIA



--
Posted via a free Usenet account from http://www.teranews.com


Posted by John Pollard on February 24, 2007, 9:53 am
Please log in for more thread options
QGuy@ether.net wrote:
> "John Pollard" wrote:
>
>> If you haven't "Accepted" the transactions yet, Accept
>> one, Memorize it, make sure QuickFill is on; then when
>> you accept the others, Quicken will give them the same
>> category as the first.
>>
>> If the transactions have already been Accepted into your
>> Quicken register, use Find/Replace to find all the
>> transactions for a given payee, then replace the blank
>> category with the category of your choice. (And you
>> still should probably Memorize one of those transactions
>> so the next time you download for that payee, Quicken
>> will categorize the transaction for you.)

> John I just tried to memorize a transaction and see there
> will likely be problems.
>
> A utility name adds its transaction number at the end of
> its name. Obviously each month this transaction number
> will be different.
>
> Is there some way to get around this? Just memorize the
> name and not the number after it? If so, how would I do
> this?

You didn't say what year version of Quicken you are using. If
you have Q2005, or later, you can use "Renaming Rules" to change
the downloaded payee name to any name you choose ... then if you
have a Memorized transaction for the renamed payee, Quicken will
categorize the transaction for you.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup



Similar ThreadsPosted
Assign class to recurring bill October 17, 2006, 12:59 pm
Can Q2006 PH&B assign an entry to a tax year? March 20, 2008, 5:46 pm
Categories with _ November 15, 2006, 12:16 pm
Tax Categories April 15, 2007, 1:28 pm
Deleting categories January 12, 2007, 5:58 pm
Lost categories. January 23, 2007, 2:01 pm
Categories All Over The Place October 19, 2007, 3:53 pm
QP2008 and Categories January 4, 2008, 2:58 pm
Classes or new categories January 5, 2008, 6:32 pm
Categories, Classes, etc. April 24, 2006, 8:08 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap