I'm using Quicken 8 for DOS.
Since about February, I've been maintaining a cash account, to get a
handle on where all the money taken out of the checking account via
ATM and check cashing goes.
With the advent of the new year, I decided to do a year-end to keep
my data files a managable size, only to discover that Quicken keeps
ALL uncleared transactions from the prior period(s) and there's no
way other than transaction-by-transaction "brute force" to "clear"
cash account transactions (as opposed to the group clearing which is
part of a bank account reconciliation). Quicken doesn't expect one
to "reconcile" a cash account, so doesn't provide the option. What
it gives you is a forced balance adjustment rather than reconciling
(and clearing).
I had the idea of exporting the entire cash account, the export from
Quicken being in the form of an editable text file, editing the file
"en masse" with a search and replace operation to create a "CX" entry
for each transaction, then importing it into a new cash account that
I'd set up as a "reconcilable" (and clearable) "bank" account rather
than a "cash" account, per se. All well and good, EXCEPT ...
In the course of importing the data into the new account, each and
every transfer from the checking account was AGAIN entered in the
checking account, resulting in something like a -$4,000 balance and
the need to delete the duplicate transactions, one by one, from the
checking account to get it straightened out.
Before beginning this, I'd archived the data files, so all I had to
do to fix the mess which Quicken had created was to delete the messed
up files and unarchive the good set, but it leaves me at my starting
point of having all the 1995 cash transactions that I'm trying to get
rid of for the new year in an "uncleared" state which Quicken will
carry over into the new year when I do a year end.
Any suggestions?
--- Via Silver Xpress V4.3 BT004
---------------
* Origin: FOG-Line BBS - 515-964-7937 - 1:290/627 (1:290/627)
|