|
Posted by R. C. White on January 23, 2007, 10:56 am
Please log in for more thread options Hi, Ed.
Sorry to be so nosy about your finances, but we can't help if we don't know
what you're trying to do. If we know (a) where you are now and (c) where
you'd like to end up, we probably can help you with (b) how to get from (a)
to (c). ;^} But if we are confused about either (a) or (c), then we get
lost trying to figure out (b). :>(
> In the past, I had problems with previous versions where I could not
> order the transactions in my checking by check number.
In the checking register, click on the header of the column you want to sort
on. Click at the top of the Num column to sort by check number; click again
to toggle between ascending and descending. The small black triangle icon
tells us which is the current order. And recognize that you may have
entries with text (EFT, DEP, etc.) or nothing at all in this column, so they
will be sorted to the top or bottom of the list. By default, I think, check
registers are sorted by Date, so if your checks were written out of
numerical sequence, switching between Date and Num will change the listing.
Remember Y2K? And all the confusion and publicity before and after January
1, 2000? Intuit - and everybody else - had to adjust their programming,
especially for 2-digit year coding, which had worked since the dawn of the
computer age. For years surrounding Y2K, Quicken (and you) might have
recorded a date as "12/01/99" and that might have been interpreted as
"12/01/2099". That kind of situation could have caused some transactions to
have been recorded out of sequence - in the wrong century. Since you
started using Quicken in '99, you might have been caught up in that
confusion and some of your early transactions may need to be re-recorded
with the proper 4-digit dates.
> figured I'd start a new file... Fresh. I input the ballance of my
> checking manually and it is currently reconciled with my paper
> statement. The old file's last transaction was Oct 2005
WHICH balance? WHICH statement? From the 10/31/05 bank statement? From
your checkbook? From your former Quicken file? The old file's last
transaction was on WHICH DAY in Oct 2005? The balance on Oct 1 is not
likely to be the same as on Oct 31 - or Oct 22.
> I reconcile monthly so it was a
> surprise to me to see the balance on Oct 2005 in both files be so
> different.
We can't see the statement. You can, so YOU will have to look carefully to
identify the reconciling items. If a check you wrote in Sep 2005 didn't
clear until Nov 2005, your opening balance will need to be adjusted for
that.
It still is not clear to me whether you want your new Quicken file to start
as of 10/31/05, or 1/1/06, or at the beginning date of your former Quicken
file - or some other date. If you want it to start at the beginning, then
you will have to do something like: load your old Quicken file; use
Quicken's File | Export and send all your prior data to a QIF file; then
load your NEW Quicken file and use File | Import to bring in all that data.
You can choose to export/import data from only a specific time period, or
other selection.
But if your NEW file is to start with some recent date (11/1/05?), then why
would you Import prior data? Except possibly for previously-acquired assets
that you still have, such as a car, a home, or investments. If something
like that is your concern, please be more specific in your question.
> The only reason I want to import is that it would be nice to have the
> data... what I should do is rename the accounts to it does not affect
> my current checking account.
You've lost me here. Is your current checking account NOT the same as the
one on 10/31/05?
Maybe all you really want to do is start a new Quicken File as of 11/1/05
(or some other recent date), while keeping the old file for historical
reference. To do that, just start a new Quicken File with a name like
ED2007, or rename the old one ED2005 and use ED again for the new one. Use
ED2007 for your current and continuing transactions; when you want to check
on something in the past, use File | Open to load ED2005 temporarily.
DO NOT trip over Quicken's terminology: A "file" may include only a single
checking "account", but it usually includes several asset and liability
"accounts" (checking, saving, auto, investment, loans, etc.), as well as
many income and expense "categories" (salary income, rent expense, and so
on). Quicken "accounts" continue indefinitely, year after year;
"categories" accumulate until the end of a year, then start over for the
next year. As a long-time Quicken user, I'm sure you know this, but it
helps to restate the obvious now and then, just to be sure that we are
speaking the same jargon.
RC
--
R. C. White, CPA
San Marcos, TX
(Retired. No longer licensed to practice public accounting.)
rc@grandecom.net
Microsoft Windows MVP
(Currently running Vista Ultimate x64)
> ok ok ok ... more info:
>
> I've been using Quicken since '99 and now have 2007Pro.
>
> In the past, I had problems with previous versions where I could not
> order the transactions in my checking by check number. The numbers
> would go in order but scrolling down more showed yet another series of
> checks which should have been in the middle of the previous set. I
> figured I'd start a new file... Fresh. I input the ballance of my
> checking manually and it is currently reconciled with my paper
> statement. The old file's last transaction was Oct 2005... and i
> can't remember that far back... I reconcile monthly so it was a
> surprise to me to see the balance on Oct 2005 in both files be so
> different.
>
> The only reason I want to import is that it would be nice to have the
> data... what I should do is rename the accounts to it does not affect
> my current checking account.
>
> -Ed
>
>
>
> R. C. White wrote:
>> Hi, Ed.
>>
>> You'll have to ask the guy who input the beginning balance! ;^}
>>
>> So far as I know, a Quicken "file" does not have a "balance". Each of
>> the
>> Accounts within the Quicken file has a balance. If there is only a
>> single
>> Account, then I suppose that could be referred to as the balance of the
>> file, but that is not really the way to look at it.
>>
>> Do you mean the beginning balance of your checking account? Or your
>> stockbroker's account? Or your loan balances? You said you've been
>> using
>> "Quick"; do you mean Quicken? Or QuickBooks? Which version are you
>> using
>> now?
>>
>> Where did your new Quicken file get "The Beginning ballance of my current
>> file"? My guess is that YOU input the balance, either directly or as the
>> result of several entries. Where did you get the numbers you input? Did
>> the beginning balance take into account any outstanding checks or other
>> reconciling items as of the new file's start date?
>>
>> Why did you start a new file? Did you start with post-2004 transactions,
>> or
>> did you record some historical data, too? Did you simply re-create your
>> old
>> file, with all its history, to clean out any deadwood?
>>
>> Yes, you could load your old Quicken file, Export all transactions - or
>> all
>> from one or more specific accounts, or for a specific period - and then
>> Import them into your new file. But I don't know if that would
>> accomplish
>> what you want, because I don't know what you are trying to do.
>>
>> RC
>>
>> > So I've been using Quick since '98 but started a new file Jan 2005.
>> > The Beginning ballance of my current file does not equal the ending
>> > ballance of my old file... you think it would but for some reason it
>> > does not ... it's like *way* off... I have no idea why Is there a
>> > way I can just import the transactions from the old file... does it
>> > make sense to do so? WOuld it mess-up my current ballance?
>> >
>> > THanks
>> > -Ed
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap