Copyright: Copyright ® 1995-1997 Response Mechanics


MYM2QIFW Help Contents
MYM2QIFW Help Contents V5.13

This help file contains processing descriptions for both the MYM DOS and MYM Windows translations. The "Proceed to Step…" jumps are an attempt to thread through the topics exclusively to the appropriate discussions. Some links will inevitably result in crossing over from MYM Windows discussion to MYM DOS discussion, or visa versa. When this happens please click on the "Contents" help application button and start over into the appropriate thread.

Welcome

Installation

Registration Options

Processing Steps

Troubleshooting

Additional information is located at http://www.respmech.com/mym2qifw


WELCOME	See also Installation and Processing Steps.

MYM2QIFW is a MS Windows program that converts MYM DOS V9->V11 and MYM Win V1&V2 data to Quicken Interchange Format (QIF); including Money, Portfolio, and Linked accounts, all Transfers, Account Allocations in Splits, and CFree payments.  Portfolio and Linked account data is translated as if the cash balance was maintained in the Portfolio accounts all along.

MYM2QIFW is being distributed as Serialware.
Using this program requires your acceptance of the terms and conditions below.

License Agreement Terms and Conditions

1. You should use this program unregistered for evaluation.

2. You must register this program, before you use it to process complete account registers. MYM2QIFW will only print 10% or 10 transactions per account until a key is entered below.

3. You may freely distribute the program archive, containing all of the original files, to your friends, BBS Systems, FTP archives, etc.

4. You may not modify the program executable or any other file contained in the archive, charge any fee for the distribution of this program, or take any action that would violate the copyright protection of the author.

5. You may obtain a refund if you are not satisfied with the translation of your data.

6. The author grants no warranties, express or implied, by statute or otherwise, regarding the program, it's fitness for any purpose, or it's quality. The liability of the author shall be limited to the amount paid by the customer for this program. In no event shall the author be liable for any special, consequential, or other damages that may result from the use of this program.


Installation	See also Registration Options and Processing Steps.

MYM2QIFW Archive File List

m2qsetup.exe	MYM2QIFW Setup program

readme.txt	Installation instructions

mym2qifw.exe	Translator program

mym2qifw.hlp	Help file (this file)

file_id.diz	Program description

vbrun300.dll	MS Visual Basic V3 run time dynamic link library

msafinx.dll	Dynamic library that contains the IIF function

gauge.vbx	Progress bar display routine

cmdialog.vbx	Common dialog interface

Support Files

Expand each of the mym2q50x.exe, m2qdll.exe, and vbrun300.exe archives into a temporary directory. Then run the M2QSetup.exe program, which will copy vbrun300.dll, msafinx.dll, gauge.vbx, and cmdialog.vbx to your \Windows\System directory, keeping the newest version if these files are already present there.

Create a directory, such as "\mym2qifw" and put the remaining MYM2QIFW archive files into it.  The mym2qifw.hlp and mym2qifw.exe files should always reside in the same directory.

There are some additional files required to do the MYM Windows data translation.

The latest version of the files are available at http://www.respmech.com/mym2qifw.htm

Running MYM2QIFW

Execute mym2qifw.exe from within Windows (Run).


Registration Options	See also Installation and Processing Steps.

You may follow the processing steps to completely evaluate the translation done by MYM2QIFW.  The export files that you create in Step 1 and Step 2 can be used again after MYM2QIFW is registered. Then when you are satisfied that MYM2QIFW is working for you, register by one of the methods below.

Register by encrypted email -> $21.00

Register by postal mail -> $21.00

Register on-line CompuServe -> $23.00

Register by Credit Card -> $26.00


Register by encrypted email -> $21.00

The buttons at the bottom of the form will be enabled when the required information is filled in. Click on either button to write a text message and open it in Notepad. Then "select all" of the text, copy it to the Windows clipboard, and then paste it into an email message addressed as shown at the top of the text. We can be reasonably certain that any mischievous programs, running on mail servers and looking for credit card numbers, will not find one in the encrypted mail message, produced by MYM2QIFW, while it is on it's way.

I will return a corresponding key number, by email, right away.


Register by postal mail -> $21.00

Send your name, postal address, E-mail address, your installed MYM2QIFW Serial Number, and check or money order to the address below. I will accept payment in your local currency, provided that it's traded on the major money markets. Please observe the exchange rates.

Ranny Meier, P.E.

Response Mechanics  MYM2QIFW

1050 White Road

Chesterfield MO 63017-2958

Send E-Mail messages to:  70451.2340@CompuServe.com


Register on-line Compuserve -> $23.00

Go to the Software Registration Forum (GO SWREG). Then register ID 4858 and CompuServe will charge the registration fee to your CompuServe account, and also E-mail a notice to me. You will need to E-mail the Serial Number, from your installed copy of MYM2QIFW, directly to me [70451,2340].


Register by Credit Card -> $26.00

You can register ID 11879 with MC, Visa, Amex, or Discover by calling Public (software) Library at 800-242-4775 or 713-524-6394 or by FAX at 713-524-6398 or by CIS E-mail to 71355,470. You can also mail credit card orders to PsL at P.O.Box 35705; Houston, TX 77235-5705. When you register, be sure to send your Serial Number to PsL. They will forward it to me, and I will immediately mail your software Key to you. Operators are available from 7:00 a.m. to 6:00 p.m. CST Monday-Thursday and 7:00 a.m. to 12:30 p.m. on Friday.


Processing Steps	See also Registration Options and Installation.

MYM DOS Processing Steps

The MYM DOS translation involves exporting a file from each account register, translating those files to QIF files, and then importing the QIF files. Money and Portfolio accounts are translated. Transfers between accounts are indicated as such in the QIF files. Some MYM DOS data sets import so that all transfers import correctly, and each account balance matches to the penny. Some others will have some accounts that do not have account numbers (like a petty cash account for example), and unless MYM2QIFW is able to determine the other account from the Payee field, the transfer indicators need to be disabled.

MYM Windows Processing Steps

The MYM Windows translation to QIF has some advantages. First MYM2QIFW directly accesses the MYM Windows database, without the need for Export files. MYM2QIFW does not depend on any account numbers in memo fields to determine transfer accounts, because the "internal" account numbers in the MYM Windows database are used. Secondly the MYM Windows Portfolio registers do have an "Action" field that is similar to that in QIF.


MYM Windows Processing	See also Registration Options and Installation.

Expect the entire translation process to take from 3 to 4 hours, including reconciling after import. Some items are set up manually. Please report back any problems and/or suggestions.

Step 1:	Pack MYM Windows data.

Step 2:	Select Read and Write Paths.

Step 3:	Check Account Names.

Step 4:	Check Category Names.

Step 5:	Translate Transactions into QIF files.

Step 6.0: 	Setting up a New Quicken or MS Money 'File'.

Step 6.1:	Automatically setting up accounts.

Step 7:	Import the category list.

Step 8:	Import the account register data.

Step 9:	Reconcile the accounts.


Step 1: Pack MYM Windows data.

There are some required files needed to do the MYM Windows translation.

When a record is deleted in MYM Windows; it is marked as deleted but is not actually removed from the database. It is important to run the Tools/Utilities - Pack Tables command from the MYM Windows drop down menu, immediately before running MYM2QIFW. Following that run the Tools/Utilities - ReIndex Tables command.

The account and category names need to be checked for invalid characters before running MYM2QIFW. This is also a good time to adjust the names to the 15 character limit.

Proceed to Step 2:


Step 2:  Select Read and Write Paths.

The MYM Windows data files are typically in a directory like "c:\mymwin2\mdata\", where "mdata" would be the name of the data set that you want to translate. The MYM2QIFW program may start a directory named "c:\mym2qifw\". To select the "MYM Data Files Path" select the drive that the MYM data resides on, and then double click on the "root drive letter" (c:\) at the top of the "Directories:" list box. From there double click on each sub-directory in the path to the directory where the MYM Windows data set, that is to be translated, is located. When the MYM Windows data directory is highlighted; click on the "MYM Path" button.

Create a temporary directory to use for the "Output Files Path". Select this directory by first double clicking on the "root drive letter" at the top of the "Directories:" list box, and then double click on each sub-directory in the path to the "Output Files Directory". The mym2qifw.log, mymaccts.qif, category.qif, mymmemos.txt, and all of the account register QIF files will be written to this directory.

Proceed to Step 3: or go back to Step 1:


Step 3: Check Account Names.

It is important that each account name be unique because they will be used to indicate transfers between accounts in the QIF files. If any of the account names are not unique; the transfers could go to the wrong account when the data is imported. The account names are truncated to 15 characters by the MYM2QIFW program because that is all that can be used in Quicken.

Proceed to Step 4: or go back to Step 2:


Step 4: Check Category Names.

It is important that each category name be unique so that it's allocations are not mixed with those of another category. The category names are also truncated to 15 characters, due to the limit in Quicken. There can be 15 characters for the top level category and another 15 characters for a subcategory (FifteenCharacters:FifteenCharacters).

Proceed to Step 5: or go back to Step 3:


MYM DOS Processing Steps	See also Registration Options and Installation.

Expect the entire translation process to take from 3 to 4 hours, including reconciling after import. Some items are set up manually. Please report back any problems and/or suggestions.

Step 1:	Export MYM Account Summary Files.

Step 2.1:	Export MYM Money Account Register Files.

Step 2.2:	Export MYM Portfolio Account Register Files.

Step 3:	Select Files to be processed.

Step 4:	Match exported files to their corresponding account.

Step 5:	Translate Transactions into QIF files.

Step 6.0: 	Setting up a New Quicken or MS Money 'File'.

Step 6.1:	Automatically setting up accounts.

Step 7:	Import the category list.

Step 8:	Import the account register data.

Step 9:	Reconcile the accounts.


Step 1:  Export MYM Account Summary Files.

Please observe the Account and Category Name Limitations, before exporting your MYM data.

Either use the \mym2qifw directory or create an empty directory for the MYM Export files.

Go to Money Accounts.  Then select <F4> Print.  Use Summary for the Type of Report.  Use the Printer print destination, and the Report format, and print the report out on paper. Go to Portfolio Accounts and do the same.

Use .csv filename extension on export files.

Go to Money Accounts again. Then select <F4> Print.  Use Summary for the Type of Report. Use the Disk print destination, with filename mas.csv, and the Export format.

Go to Portfolio Accounts and do the same, except using filename pas.csv.

Proceed to Step 2.1.


Step 2.1: Export MYM Money Account Register Files.

Please observe the Account and Category Name Limitations, before exporting your MYM data.

From within the DOS version of Managing Your Money (MYM), select from the main Money menu; Check Register.  Then select <F4> Print. Choose to print the Register as opposed to printing Checks.  Sort the account by date if it is not already. Press <Ctrl><PageUp> to go to the earliest transaction and note the Begin Date. The Print Check Register dialog should be filled out as follows:

Print 'All' transactions.

Only include transactions between 'Begin Date' and 'End Date'.

Include Category allocations? 'Yes'   Account allocations? 'Yes'

Include Memos? 'Yes'   Include Checkfree Confirmation #? 'Yes'

Sort Alert transactions into Check Register? 'No'

Then select <F10> Print, using the Disk print destination, a filename like my Recommended Export Filenaming Method, and the Export format.

Repeat for each Money Account Register that will be imported into Quicken. For best results, use the same 'Begin Date' and 'End Date' for each Money Account Register exported.

There are limits on the number of accounts and transactions that will be processed.

Proceed to Step 2.2 or go back to Step 1.


Step 2.2: Export MYM Portfolio Account Register Files.

Please observe the Account and Category Name Limitations, before exporting your MYM data.

Go to Portfolio Accounts.

Select <F8> Disaggregate Portfolios (note do not save MYM on exit after doing this).

Select the first Portfolio Account. Select <F10> Display Assets. Select <F4> Print.

Choose Full Detail and select <F10> Print.

Print to a file in Export format, using filenames like my Recommended Export Filenaming Method.

Select the next Portfolio Account.

Repeat for each Portfolio Account.

There are limits on the number of accounts and transactions that can be processed.

Proceed to Step 3 or go back to Step 2.1.


Step 3: Select Files to be processed.

Select the Drive and Directory where you stored the MYM Export files created in Step 1:

Filename Extension

If you used any filename extension, on the MYM Export files, other than .csv such as .txt; then select that type from the drop down list labeled List Files of Type: in the lower left corner of the Step 3: Select Files screen in MYM2QIFW.

Account Summary Export Files

Select the Money Account Summary Export File, created in Step 1:, in the File Names: list box. Then press the Add File button just to the right of the Money Account Summary Export File: box. If you are going to translate any Portfolio accounts, then select the Portfolio Account Summary Export File in the same manner.

Account Register Export Files

For best results; process all of the MYM export files at one time (see 'Default Automatic Method'). There should only be one Money Register Export file used for a Linked account. There can be several Portfolio Register Export files for the same Linked account. Typically there might be two; one for the Un-Sold and one for the Sold assets.

Output Files Path

I recommend using the same directory where the MYM Export files are located, which might be \mym2qifw as recommended in Step 1.

Press Continue to begin reading the Export files

MYM2QIFW will check the Account Names for having only characters that Quicken will accept.

Proceed to Step 4.1 or go back to Step 2.2.


Step 4.1: Match exported files to their corresponding account.

Indicate the Account from the list on the right side of the screen that corresponds to the MYM Register Export File that is shown at the left. This is done by either picking the Account from the list, so that it is highlighted, and then pressing the Match button near the top of the screen, or just double-clicking on the Account in the list.

Money side of Linked Accounts Indicator (_C).

Note that MYM2QIFW renames any Linked Money Accounts by appending a "_C" to the end of the account name. This is because Quicken does not allow, or need, duplicate account names like MYM uses for Linked accounts. All Money and Portfolio accounts are "Linked" in Quicken, and a transfer can be created between any Portfolio and Money account.

There is a purpose for matching the Account Names to the Export files.

Proceed to Step 4.2 or go back to Step 3.


Step 4.2: Verify Matching.

All Account Names should appear as unique, in the matching list. MYM2QIFW should have automatically made the account names unique, if they were not already.  When you are checking the "Verify Matching" screen in MYM2QIFW, if any two accounts have the same name, it will be ambiguous as to which account it really is. You may actually know, because of the order that they are in and the account number. However do not proceed with this situation, because the transfers will not come across correctly, and the account balances will thus be off. Quicken uses the Account Name to indicate transfers (category allocation to another [account]). Be sure that the first 13 characters of each account name are unique. If they are not, go back and edit the Account Names in MYM, and then re-export the Account Summary Export files. The Account Register Export files will not need to be re-exported.

Proceed to Step 5 or go back to Step 4.1.


Step 5: Translate data into QIF files.

Press the Process button to begin the translation of the MYM export data files.

MYM DOS transaction processing:

Specific control of the Portfolio transactions Action type is available by clicking on Options at the 'Step 5: Translate' screen in MYM2QIFW. Generally I recommend not invoking this option, and leaving the default "Automatic Method" selected except for unusual situations. If you decide to use the Manual Prompt method, please send me a note explaining the reason. See the Portfolio Transactions section.

MYM Windows transaction processing:

There are several Options available by clicking on the Options button. In a situation where NationsBank online banking data is downloaded weekly and then translated and imported into Quicken or MS Money; the Start Date and End Date can be adjusted, in order to translate a portion of the MYM data set. If you plan to use any Linked CMA Accounts in Quicken, then please select the "Prompt to create Money side QIF file" option. Normally Unique Indexes are used when joining the data tables. Long MYM memos are exported to a file named Mymmemos.txt. Generally the transfer indicators are included and used in conjunction with the Special Handling For Transfers import function.

Log File:

When the translation processing completes; press the View Log button to open the 'mym2qifw.log' file in Windows Notepad. Print the log file on paper for reference while importing the QIF files as described in Step 8. You may want to copy the text, of the log file, from Notepad and paste it into a Word processor in order to make it fit the printed page better.

Proceed to Step 6.0 or go back to MYM DOS Step 4.2 or MYM Win Step 4:.


Step 6.0:  Setting up a New Quicken or MS Money data 'File'.

The process is only slightly different for creating a new data file in Quicken or MS Money.


Step 6.0:  Setting up a New Quicken 'File'.

Start Quicken and close the Quicken New User Setup dialog, if it opens. Select File/New from the drop down menus. Select a directory for the Quicken data set and enter a Filename in the Create Quicken File dialog. You most likely will want to de-select the Home and Business check boxes at the lower left of the dialog box.

Creating the 'Seed' account:

Select List/Account (or press the Accts button) and then press the New button in the Account List window. The Create New Account dialog should open (it may have already opened if this is the first visit to the Account List). Select the Cash button and then enter temp for the account name or any other name (it will be deleted later).  Do not use an account name that is the same as any category name. Do not enter any beginning balance for this temp account.

Proceed to Step 6.1 or go back to Step 5.


Step 6.0:  Setting up a New MS Money data file.

Select New from the File menu. Select a directory where you want to store the new MS Money data set. Enter a filename for the new data set. Click on OK.

MS Money will prompt to create a seed account with the New Account Wizard. Pick any type of account, and enter any account name except one that is the same as any of the category names. Enter zero for the initial account balance.

Proceed to Step 6.1 or go back to Step 5.


Step 6.1:  Automatically setting up Accounts.

The process is only slightly different for importing the account list into Quicken or MS Money.


Step 6.1:  Quicken Import Options

Quicken supports an option to import one all-inclusive QIF file, which when imported will set up all categories, accounts, memorized transactions, and create all account register transactions.

The original option to import the category.qif, mymaccts.qif, and all account register QIF files individually is still available.


Step 6.1:  Quicken all-inclusive QIF file import

This update writes all of the data to one QIF file.

To use this "allinone.qif" file, please open an empty new Quicken data set.

The categories option can be set when creating the new Quicken data set, to deselect both "business" and "home" types, so that only the categories from the MYM data set are used. Otherwise just select OK if and when a warning message appears warning about duplicate category names.

Also create the dummy "seed" account in Quicken, with any name that is different than those used in the MYM category and account names. QuickenV6 still requires that "some account" is selected in the import dialog before importing can begin.

Also select all of the import dialog options: Transactions, Account list, Category list, Memorized Transactions, and Special handling for transfers.

Quicken will prompt when it encounters each account during import. It will also prompt each time a new security is found. Generally just select yes at all of these prompts.

Proceed to Step 9 or go back to Step 6.0.


Step 6.1:  Automatically setting up accounts in Quicken.

Select Import from the File menu.  Select only Accounts List and deselect the other boxes, in the Import Items box. Select the temp account in the Quicken account to import into: drop down list. Type the following into the QIF File to Import: text box (or select it with Browse...'):

OutputPath\mymaccts.qif

Now select the OK button, and all of your MYM accounts will be created in Quicken!  Before importing the Category and Register data in Steps 7 & 8 below, go through and set all of the options for each of the imported accounts in Quicken. The options will include a check box for Taxable or Non-Taxable, IRA, etc. You should set any tax buckets for transfers in and out. MYM2QIFW writes the MYM Account Number into the Description field in the QIF. This way the Account Numbers show up in the Quicken Account list. You may want to copy those numbers into the Account Number field in the Account Info section in Quicken. If you are using any Linked CMA accounts in Quicken, then they must be created at this point. There is an important thing to note about the Linked Money Account name when importing from MYM Windows.

Proceed to Step 7 or go back to Step 6.0.


Step 6.1:  Automatically setting up accounts in MS Money.

Select Import from the File menu. Select the directory where the MYM exported files are located. Select only the mymaccts.qif file at this step. Click on the Import button; and all of the accounts will be created in MS Money. Unfortunately MS Money does not import the Account description or Account Number.  Therefore the account numbers need to be entered manually at this step.

Proceed to Step 7 or go back to Step 6.0.


Step 7:  Import the category list into Quicken or MS Money.

The process to import the category list is only slightly different for Quicken or MS Money.


Step 7:  Import the category list into Quicken.

Select Category List and deselect the other boxes in the Import Items box on the QIF Import window. For this step it does not matter which account is selected in the Quicken account to import into: box. Now would be a good time to delete the temp account that was created at the beginning of Step 6.  Type the following into the 'QIF File to Import:' text box (or select it with 'Browse...'):

OutputPath\category.qif

Proceed to Step 8 or go back to Step 6.1.


Step 7: Import the category list into MS Money.

Select Import from the File menu. Select the directory where the MYM exported files are located. Select only the category.qif file only at this step. Click on the Import button; and all of the categories will be created in MS Money.

Proceed to Step 8 or go back to Step 6.1.


Step 8:  Import the account register data into Quicken or MS Money.

The process to import the MYM Account Register Export files is only slightly different for Quicken or MS Money.


Step 8:  Import the account register data into Quicken.

Select Transactions and Special handling for transfers and deselect the other boxes in the Import Items box on the QIF Import window. Next fill in the QIF File to Import: and Quicken account to import into: text boxes with corresponding pairs of Account Name and QIF File as listed in the following log file:

OutputPath\mym2qifw.log

Note that only the .qif files, and not the mym2qifw.log file, are imported into Quicken.

The QIF file names are based on the names that you gave to the MYM Register export files. The Browse button in the Quicken QIF Import dialog box can be used to select the QIF files. If you used my recommended filenaming method; then just change one character in the name shown.

Print out your mym2qifw.log file and refer to it while importing the accounts into Quicken. Be careful to only import each QIF file only once. Some QIF files will be listed in both the Money and Portfolio sections of the Log file. Some QIF files may appear in the Portfolio section more than once. The QIF file is listed in the mym2qifw.log file on each line where a MYM Register export file, that contributed to the Portfolio account data, is listed (see the example.log file).

Account Names for the Money side of Linked Accounts are appended with a _C.  QIF filenames for Linked Accounts where there are no Portfolio Side Export files, are appended with a _P.

If you use the MYM Export file naming scheme shown in the 'example.log' file, then I recommend importing maxx.qif first, then pasxx.qif, and then pauxx.qif to avoid importing any QIF file twice.

Proceed to Step 9 or go back to Step 7.


Step 8:  Import the account register data into MS Money.

Select Import from the File menu.  Select all of the MYM Register Export QIF files, that you want to import, by holding down the <Ctrl> key while selecting them in the Import dialog window.  MS Money will prompt just prior to importing each file; for the account to import it into.

It is important to select all of the Account Register QIF files at once for this import step, in order for MS Money to properly handle the transfer transactions. The result is similar to the Quicken Special Handling For Transfers function. Refer to the MS Money Help for more information.

Print out the mym2qifw.log file, and refer to the Account Name and QIF File columns. When prompted; select the Account Name that is listed next to the QIF File in the mym2qifw.log file.

Proceed to Step 9 or go back to Step 7.


Step 9:  Reconcile the imported accounts.

Please delete any .qif files that are not listed in the mym2qifw.log file or that contain no transactions. Normally there will be none of these because MYM2QIFW deletes them. These files result only if MYM2QIFW exits abnormally after having processed a Linked Money Account where all of the data was recorded in the Portfolio side QIF file.

Please delete any .mbs files that are left in the output directory selected in Step 3. Again MYM2QIFW normally deletes these files. They will only be found if for some reason MYM2QIFW exits abnormally.

The Opening Balance transactions, created by Quicken during Step 6.1, can be deleted, if a Beginning Balance transaction was included in the data exported from MYM. These Beginning Balance transactions will be included with the MYM Export data if you used a Begin Date on or before the first date in the account. Otherwise edit the Date and Amount on the Opening Balance transaction to be that for the account just prior to the first transaction.

It will be difficult to determine the Opening Balance for any accounts that were exported with different start dates, and that also have transfers of amounts between them. This is because the account with the later Begin Date may have transfer transactions, from the other account, created with dates prior to the Begin Date, due to Special Handling for Transfers.

Please let me know how it goes, about any problems, and/or suggestions, etc.

Go back to Step 8.


Additional Comments:


Account and Category Name limitations:

Quicken Account and Category names can not include the following characters: [ ] / | ^ so please edit, from within MYM, any names that include them. Additionally Quicken account names can not contain a colon or a dash. See the MYM and Quicken help.

The first 13 characters of each Account Name need to be unique. The Money and Portfolio Account Names for each side of MYM Linked accounts will be the same.

Automatically make Account Names unique.

MYM2QIFW will adjust the Account Names, to make them unique, just prior to Step 4: in the case of MYM DOS translation, and just prior to Step 2: in the case of MYM Windows translation, if you have not already made the adjustments in MYM before exporting the files.

MYM2QIFW will change any Account Names where the first 13 characters are not unique. This is required because Quicken only allows 15 characters in the Account Names, and the names must appear as unique after the "_C" is appended on the Money Account Names of Linked Accounts. MYM2QIFW makes the Account Names unique by replacing the first characters of the name with consecutive integer characters.

Manually make Account Names unique.

You may prefer to just edit the Account Names in MYM to a maximum of 13 characters, before exporting the Account Summary Files. This may result in more meaningful names.

I did notice that if any category name is the same as an account name, that Quicken will not import any transaction with allocations to that category. Be sure that the 'Seed' account, set up in Step 6.0 does not have a name that is the same as any category name.

Account Numbers

Do not edit the Account Numbers in MYM, because the Account Number reference in the memo fields will not be updated. MYM2QIFW depends on the Account Number to know which account is on the 'other side' of a transfer.

Manually edit Category Names

The Category names should also be adjusted to 15 characters long. You can use 15 characters for the top level category and another 15 characters for a subcategory (FifteenCharacters:FifteenCharacters).

Please make all changes to the account and category names in MYM before exporting the data files. When the account names are edited; the Account Summary Export files need to be re-exported. When the category names are edited; then any Account Register Export files, that have transactions with allocations to the changed categories, will have to be re-exported. A search utility can be used to find which Account Register Export files are affected.


My recommended Export Filenaming method:

Number the Accounts on the printed Account Summary reports (from Step 1), starting with '1' for the first Money account, and again with '1' for the first Portfolio account. Then use 'ma01.csv', 'ma02.csv', etc. for the Money Export filenames, and 'pau01.csv', 'pau02.csv', etc. for the Portfolio Un-sold assets Export filenames, and 'pas01.csv', 'pas02.csv', etc. for the Portfolio Sold assets Export filenames.

See the example mym2qifw.log file, that is a result of using this filenaming method.

Part of the reason that I adopted this Export filenaming method, is that it is easy to just change one character in the name shown in the QIF File to Import: box of the QIF Import window, as each QIF file is imported into Quicken.


About MYM DOS versions Account Transfers:

For transactions where the entire amount is 'allocated' to another account, i.e.; a transfer, then MYM2QIFW will create an account allocation in the QIF file; if a MYM memo line indicates a transfer.

The earlier versions of MYM will create a memo line, like this example, for transfers:

Transferred by ATM to account #CASH 2

Version 10 of MYM will create a memo line, like this example, for transfers:

Transferred: CheckFree, acct# 1234 567 891 234

MYM2QIFW will, for any memo line that begins with the word Transferred, look for an account number starting just after the '#' and to the end of the memo line. Anything that is between Transferred and '#' does not matter. MYM2QIFW will then try to match the account number to an account name, based on the info in the account summary file. When matched it will create an account allocation in the QIF file.

Do not edit or change the account numbers in MYM because the memo field will not update.

Please note: If your MYM memo fields do not indicate a transfers, all of your transactions will still be listed in the QIF file, and will import into Quicken.

Note that MYM DOS treats Account Allocations in Splits differently than does Quicken.


Account Types:

All MYM accounts of the type 'Checking', 'Savings', 'Money Market', or 'CMA' are marked as type '!Type:Bank' in the resulting QIF file. The MYM 'Cash' is marked as 'Cash', the MYM 'Charge' is marked as 'CCard' in the QIF file. The MYM account types 'Noncash' and 'IRA/Keogh/401K' are marked as '!Type:Oth A' in the QIF file. The MYM type 'Home Equity' is marked as '!Type:Oth L' in the QIF file.


Special Handling for Transfers:

For any transaction that has an Account Allocation or Transfer with a negative amount; Quicken will omit it and adjust the transaction total accordingly when importing the QIF file. This is done to avoid having duplicate entries in a register. For positive Transfer amounts Quicken creates a transaction in both accounts, on each side of the transfer. Do not be alarmed if it seems like some of the transfers are missing, until all of the accounts have been imported.

Note that MYM DOS treats Account Allocations in Splits differently than does Quicken.


Account Allocation in Splits:

MYM DOS does not treat Account Allocations in Splits as transfers, as they are in Quicken. As much as we would like to write the QIF file such that they import into Quicken as transfers, there is not a fail proof way of doing so, while still taking advantage of the Special Handling for Transfers feature in Quicken.

We could attempt to hunt down the transaction in the destination account, based on the Date, Amount, and Payee, and change the category to [source account]. This would require that the user process both accounts at the same time, and make the source account harder to reconcile because the account allocation amount would be split out to a separate transaction.

Instead MYM2QIFW will simply leave the Account Allocation as a Split amount. Note that MYM has recorded the amount, on the other side of the transfer, as a regular transaction. MYM2QIFW will change the Account Allocation Name in the Split by prefixing it with "X>". This will prevent the Special Handling for Transfers feature of Quicken from omitting negative Account Allocation amounts. Note that you will have to Customize any budget reports or graphs created in Quicken, for time periods including the imported MYM data, by excluding the "X>" type categories because they are actually transfers instead of expenses.


Portfolio Transactions Action Field:

MYM2QIFW needs to determine, for each asset, what is called an Action in quicken. I had been aggregating reinvested assets (Ducklings in MYM speak) under the Duck, so that I can calculate performance. When you disaggregate them that relationship is lost.

The explicit control methods for the 'action field' on portfolio transactions are described below. Generally I would recommend not invoking the optional prompt method.

Default Automatic Method:

If the Portfolio account is linked, and the 'money side' export files are processed at the same time, MYM2QIFW will be able to look back into the 'Money Side' data to make the distinction between Buy or ReinvDiv type 'actions'. Otherwise MYM2QIFW will write it as a 'ShrsIn' action if the Variance is positive and greater than 9/10 of one Standard Deviation, or the Standard Deviation is less than the Mean, otherwise it will assume that it is a reinvestment and mark it as a 'ReinvDiv' action. You should view the transactions in your Portfolio accounts after importing, and change the 'Action' field on any that MYM2QIFW marked incorrectly. Alternatively you can make adjustments to the QIF file before importing it.

When MYM2QIFW processes Linked Money Account Register Export files, it saves data, pertinent to the Portfolio side, in temporary files with a '.mbs' extension in the output directory. When MYM2QIFW exits normally it deletes these files. If any files are found in the output directory with the '.mbs' extension, after processing is complete; they should be deleted.

Prompt Method:

Before each Portfolio account is processed a prompt appears where a choice can be made between Automatic and Semi-Automatic determination of Action type or any one Action type for all of the assets in the account.  A running sum is made of transaction amounts that are marked Buy or Sell that would have been marked ShrsIn, ShrsOut, or ReinvDiv by the Automatic method.  This summed amount is used to make a MYM_Import adjusting entry with today's date.

Note that when Automatic or Semi-Automatic methods are selected in the Action Types box, that when a reinvestment transaction is found, the selection from the Reinvestment Type box will be written to the QIF file.


Portfolio Accounts with Linked CMA accounts

Quicken V5 has two methods available to handle the cash in Portfolio accounts.

The first method is the most common, and allows the cash balance to be maintained directly in the Portfolio register. The method is nice for most brokerage accounts even if they have check writing privilege that is only used occasionally. One expense or income allocation per transaction can be made in these Portfolio accounts. The default processing options will put all of the transactions, for a MYM Portfolio account, into one QIF file.

On the other hand if you have a brokerage account that you use extensively for your primary checking account, and you want to be able to make split allocations for income and expense transactions, then you will need to use the "Linked CMA account" option in Quicken V5. If you will have any of these Linked accounts in Quicken, then select the "Prompt to create Money side QIF file" processing option. Then MYM2QIFW will stop at each Portfolio account and prompt to identify the type of portfolio account. Then if the "Allocations in CMA" option is selected, MYM2QIFW will use action types, in the Portfolio side QIF ("paxx.qif")file, like ShrsIn, ShrsOut, ReinvSh, etc. that do not affect the cash balance. Also all transfers and expense and income allocation type transactions will be written into a separate corresponding Money side QIF ("maxx.qif") file.

IMPORTANT: Check "mym2qifw.log" file for instructions when using linked CMA accounts.

Please look for specific instructions in the "mym2qifw.log" file, if the "linked money side accounts" processing option was selected. Import the maxx.qif files into the indicated money side account. Check for any manual edits that are required in the "mymaccts.qif" file, prior to importing it.

In order to use Linked CMA accounts in Quicken, those Portfolio accounts must be edited in Quicken after importing the "mymaccts.qif" file. This is done by selecting the "Include a Linked Checking Account for Cash Management" option on the account edit Summary dialog. Import the "maxx.qif" type files into the newly created Linked Money side accounts. Quicken will add a "-cash" to the account name if it creates a new account to link to.

The Linked Money Account must have the original name for the Portfolio account, as listed in the mymaccts.qif file. This is in order to cause all of the transfers of amounts between other money accounts to be imported, as the reference in the other accounts is to the original Portfolio account name like [transfer account]. In the case of the MYM DOS translation; please remember that the "paxx.qif" file will import into the investment account with the "-P" added to the name, and the "maxx.qif" file will import into the Money account with the original Portfolio account name.


Required files for MYM Windows translation:

A GPF error can occur is there are versions of the ".dll" files in the \Windows\System directory, or in the PATH, that have a date earlier than those listed below:

Filename	Bytes	Date	Description
xbs200.dll	296,832	08-15-95	Installable ISAM
vbdb300.dll	95,200	04-25-95	VB Data Access library
msajt112.dll	17,440	04-25-95	Jet Engine library
msajt200.dll	995,136	08-15-95	Jet Engine V2.5 library
The ".dll" files listed above need to reside in the \Windows\System directory to do the MYM Windows data translation. Please replace any ".dll" files that are found with an earlier date than those listed above. After replacing any ".dll" files; Windows should be restarted. The ".dll" library code loaded into memory will remain there, and potentially cause errors, until Windows is restarted.

Please be sure that the required files, listed here and in the Installation section, are in place before processing the MYM Windows data.


MYM Linked Accounts:

As you may know, Quicken does not need a Money side account for a Linked Portfolio account, unless checks are written against the cash balance. If a money side account is used to record the checks written, the cash balance is maintained at Zero by transferring cash from the Portfolio side account. Other than that, any transfers of cash into or out of the Portfolio account are recorded directly in the Portfolio register. Amounts can be transferred between any money account and any portfolio account (they are all linked).

The 'money side' of the portfolio account will only contain any checks that were written against the cash balance, along with a matching transfer from the 'portfolio side' to the 'money side' account for each check written. In cases where there were no check written, there would be no 'money side' QIF file required. All transfers and allocations from other accounts will go directly into the 'portfolio side' account. All dividends and proceeds from sale of assets will be recorded in the 'portfolio side' account. The 'portfolio side' account will have the original name and the 'money side' account (if required) will be renamed by appending "_C" to the end of the name (C for Checks). If a 'money side' Linked account register export file is processed without processing the 'portfolio side' register export file at the same time, a QIF file named with a "_P" appended will be created. This file will contain the data from the 'money side' account that belongs in the 'portfolio side'  account in Quicken. It is recommend that all export files be processed in one run.

The Linked accounts in MYM were used to handle CMAs. With Quicken we can transfer or allocate money directly between any Money and Portfolio account. If for instance part of your paycheck goes to a savings plan; the split allocation can point to a Portfolio account. To write checks on a Portfolio account; Quicken requires you to create two transactions in a Bank type account; one for the expense and one to transfer the money from the Portfolio account to the Bank type account. In Quicken this Bank type account that is used for the check writing privileges on a CMA account, should always have a zero balance and the Portfolio account will have the Cash Balance.


QIF files for the Portfolio side of Linked Accounts:

A Portfolio side QIF file may be created for a linked account even if there were no Portfolio side MYM Export files for that account.

MYM2QIFW normally uses whatever you named the first MYM Portfolio Register Export File for the account. In the case where there is none, MYM2QIFW still needs a Portfolio side QIF file, because the cash balance will be on the Portfolio side in Quicken. MYM2QIFW just appends a '_P' to the whatever you named the MYM Money Register Export file name. Be sure to import any QIF file, listed next to an account name appended with '_P', into the Portfolio side of the account. See the example.log file.


CheckFree:

The people at CheckFree require that all automatic recurring payments be stopped in MYM, and then restarted in Quicken.  Quicken will only allow CheckFree payments to be set up no sooner than 5 days in advance.  I suppose that if it is timed right, this can be done without missing any monthly payments.  I did have to send an E-Mail to CheckFree to get one of my payments in MYM stopped, because it was less than 5 business days to the pay date, when I switched over. There is not an import for setting automatic or "fixed" CheckFree payments.

MYM2QIFW does translate all of the historical CheckFree payments.  The CheckFree confirmation number is put in the first line of the Address in the QIF file, because this is where they go with CFree payments made in Quicken.  To see this number in Quicken, change the reference field (check number, CFree, ATM, etc.) to "print", and then save the record. Next select Print Checks to view the 'check look alike' view with the addresses shown. After viewing the confirmation number, change the reference field back to CFree. This seems awkward, and maybe Quicken will change that someday.  Quicken does change the reference field from Xmit to EPmt when transmitting CheckFree payments initiated in Quicken.  In that way we can tell which ones have already been transmitted. All of the historical CheckFree payments, from MYM, will retain the CFree designation in the reference field, when the QIF files are imported.

The CheckFree option is not activated in QuickenV5 by default. A setting in the initialization file must be changed in order to activate CheckFree, unless CheckFree was used in a previous version of Quicken that is upgraded to QuickenV5.


Items that are set up manually:

CheckFree merchants, CheckFree fixed and automatic recurring payments, and Loans are not imported, and must be set up manually after the import process is complete.  The historical MYM loan payment transactions are written to the QIF files and imported.  Some versions of MYM DOS do not write the principle and interest split allocation amounts to the Register Export files, so they are not imported.

Currently the Memorized Transactions (Quick List) and the Home Inventory items are not translated. There is an option in Quicken that when set will capture all new transactions to the memorized and/or scheduled list.

The QIF specification does not support Security Types and Symbols. Each security needs to be edited after import to set these properties.


Purpose for Matching the Accounts to the Export files:

MYM does not include the Account Name or Account Number in the Register Export files.

MYM2QIFW records the Account Number, Account Name, and Account Type, and determines which accounts are Linked, by reading the Account Summary files.

MYM2QIFW processes all of the Money Account Export files first before the Portfolio Account Export files, so that the pertinent data can be stored in temporary binary files on disk. Also MYM2QIFW opens two QIF output files (instead of just one) when processing an Export File for a Linked Account.

Thus the Matching allows MYM2QIFW to process the Money Account Export files first, and to know if the Export file is for a Linked Account.


Quantity Limitation:

Currently there is memory allocation large enough for processing 500 Accounts and 500 Categories. Also 2000 assets in a single Portfolio register, and 4000 Purchase or Sale transactions in a single Linked Money register. There is no limitation on the number of transactions in Un-Linked Money accounts registers. Please let me know if these memory allocations should be increased.


Windows Recorder:

While testing this program I found the Windows Accessory called Recorder very useful. I used it both to make all of the file selections in MYM2QIFW, and also to make selections and enter the QIF filenames in Quicken. If you find yourself doing repetitive task in Windows, give the Recorder a try.


Successes, problems, and/or suggestions, etc.:

Please let me know.  E-mail to 70451.2340@CompuServe.com, call me at 314-542-3642, or send me postal mail.  Please include the following information with problem reports:

Any time there is a problem with MYM2QIFW running abnormally; please press <Ctrl+Shift+D> at the "QIF Types and MYM Version Options" screen. This will cause debugging information to be written to the mym2qifw.log file.

Please paste the text from the resulting mym2qifw.log and mymaccts.qif files into an email message to me, when reporting problems associated with the way that MYM2QIFW is processing your exported MYM data.

Please paste the text from the sysinfo.txt file into an email message, when reporting any problem with the Serial Number changing.

Thank you,
Ranny
MYM2QIFW Author


Example mym2qifw.log file

================================================================================

Saturday, July 29, 1995     12:41 PM     MYM2QIFW V4.5 Account Processing Log

MYM Ver 11 detected.

There were 22 money, and 17 portfolio accounts, of which 17 were linked.

The info for  39 accounts was written to d:\mym2qifw\mymaccts.qif

Money Account Register Processing Results:

MYM Export   Account Name    QIF File       Total  Splits  TXFR

--------------------------------------------------------------------------------

ma01.csv     DELTA CREDIT    ma01.qif        353     37     95

ma02.csv     WESTERN FCU     ma02.qif         65      7      8

ma03.csv     CASH INCOME     ma03.qif         41      0     21

ma04.csv     Delta 41 Overdr ma04.qif         13      0      7   Notice that the

ma05.csv     Mut Beacon BEG  pas04.qif        12      0      8   Account Names

ma06.csv     Mut Qualified   pas05.qif        11      0      8   have been trun-

ma07.csv     Mut Shares MUT  pas06.qif        11      0      8   cated to 15

ma08.csv     Fidelity Contr  pau01.qif        10      0      7   characters.

ma09.csv     Heartland Valu  pas02.qif        11      0      7

ma10.csv     Oakmark Fund O  pau07.qif        12      0      7

ma11.csv     The Kaufmann K  pau03.qif         8      0      7

ma12.csv     PBHG Growth Fu  pau08.qif         9      0      7

ma13.csv     Seligman Comm   pau09.qif         4      0      2

ma14.csv     Wasatch Aggrss  pau10.qif         3      0      2

ma15.csv     401(A) (K)      pau12.qif         4      0      0

ma16.csv     Skyline Specia  pas11.qif        13      0     10

ma16.csv     Skyline Speci_C ma16.qif          1      0      0 <- Money Side QIF

ma17.csv     Quantitative U  pas13.qif         6      0      3

ma18.csv     Janus Twenty J  pas14.qif         3      0      1

ma19.csv     Montgomery Eme  pas15.qif         5      0      4

ma20.csv     Scudder Latin   pas16.qif         5      0      3

ma21.csv     DECU            ma21.qif          1      0      0

ma22.csv     Schwab One      ma22_P.qif        7      0      6  <- Note QIF name

ma22.csv     Schwab One_C    ma22.qif          5      0      0

--------------------------------------------------------------------------------

Portfolio Account Register Processing Results:

MYM Export   Account Name    QIF File     Total   Buy  Sell  Reinv

--------------------------------------------------------------------------------

pas02.csv    Heartland Valu  pas02.qif        6     3    3    0

pas04.csv    Mut Beacon BEG  pas04.qif        2     1    1    0

pas05.csv    Mut Qualified   pas05.qif        2     1    1    0

pas06.csv    Mut Shares MUT  pas06.qif        2     1    1    0

pas11.csv    Skyline Specia  pas11.qif       66     8   33   25

pas13.csv    Quantitative U  pas13.qif       40     4   20   16

pas14.csv    Janus Twenty J  pas14.qif       34     1   17   16

pas15.csv    Montgomery Eme  pas15.qif       36     4   18   14

pas16.csv    Scudder Latin   pas16.qif       28     3   14   11

pau01.csv    Fidelity Contr  pau01.qif       24     8    0   16

pau02.csv    Heartland Valu  pas02.qif       22     9    0   13

pau03.csv    The Kaufmann K  pau03.qif       32    32    0    0

pau04.csv    Mut Beacon BEG  pas04.qif       13     9    0    4

pau05.csv    Mut Qualified   pas05.qif       13     9    0    4

pau06.csv    Mut Shares MUT  pas06.qif       13     9    0    4

pau07.csv    Oakmark Fund O  pau07.qif       33     9    0   24

pau08.csv    PBHG Growth Fu  pau08.qif       27     8    0   19

pau09.csv    Seligman Comm   pau09.qif        2     2    0    0

pau10.csv    Wasatch Aggrss  pau10.qif        1     1    0    0

pau12.csv    401(A) (K)      pau12.qif        6     3    0    3

pau15.csv    Montgomery Eme  pas15.qif        1     1    0    0

--------------------------------------------------------------------------------

The name and type of 97 categories was written to d:\mym2qifw\category.qif

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

MYM2QIFW by Ranny A. Meier, P.E.                       Compuserve ID: 70451,2340

           1050 White Road, Chesterfield, MO  63017-2958

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Troubleshooting and FAQ:	Include log files with problem report.

The quantity of register transactions in the log file does not match that reported by the import function:

The imported account balances do not match those in MYM:

There is a "File not found" error message:

There is an "invalid use of null" or "null value in index" error message:

There is a "GPF in XBS200.DLL" error message:

Duplicate Key Error

"Error #6 at line #0 in module ProcTran"

The Home Inventory account did not translate:

The key number is entered and a "No Match" is shown:

All of the transactions are imported with today's date:


The quantity of register transactions in the log file does not match that reported by the import function:

The number of transactions listed in the log file is not expected to be the same as the number reported by the import function. This is due to the Special Handling For Transfers, which omits some transfer transactions when importing the QIF files.


The imported account balances do not match those in MYM:

The account balances are not expected to be correct until all of the account registers have been imported. This is because the Special Handling For Transfers omits some transfer transactions when importing the QIF files.


There is a "File not found" error message:

This error message means what it says. One common file that is commonly missing is the msafinx.dll file. This is because a function called IIF was added to MYM2QIFW about mid Dec95, which requires this file. The msafinx.dll file was not included in the archive until Jan96.


There is an "invalid use of null" or "null value in index" error message:

We have seen this error occur when translating the MYM Windows data. This occured once when a security symbol was missing. This is a required relational field in the data tables. This error also occurred once when there were some "empty" records in the transactions table. The problems can be corrected by opening the data tables in a general purpose database application or MS Excel, and then repairing the data. Please back up the MYM data before making any edits with other applications.


There is a "GPF in XBS200.DLL" error message:

This can occur when a earlier version of this ".dll" file is loaded into memory at the time that MYM2QIFW runs. Please be sure that the required files are present in the \Windows\System directory.

Another related problem is Error #3170 "Can not find installable ISAM", which will occur if the xbs200.dll file is not found in the \Windows\System directory, and the MYM Windows translation is attempted.


Duplicate Key Error

In the past we found that the duplicate key errors occurred about the time of where the data was upgraded from one version of MYM DOS  to the next version of MYM DOS. Then these errors were carried forward into MYM Windows. Does that sound possible for your situation.

Generally these duplicates are far enough apart in date order, that the transactions splits are not affected. For that reason we added a processing option to MYM2QIFW called "Primary Indexes - Not Unique". Select this option and try the processing. The processing will be much slower without the indexes.


Error #6 at line #0 in module ProcTran
"Error #6 at line #0 in module ProcTran"

This "OverFlow" error seems to occur on MYM Windows accounts that have more than 3000 transactions, indicating an internal limitation in the xbs200.dll installable ISAM. Please try to process half of the transactions at a time, by using the "Start Date" and "End Date" processing options.


The Home Inventory account did not translate:

Quicken does not allow data to be imported into the "read only" home inventory account. The data can be exported from this account.


The key number is entered and a "No Match" is shown:

It is likely that the serial number has changed. This happens when the system configuration changes significantly, or when a system parameter changes that is expected to be constant by the serial number module. Please send the new serial number and also the sysinfo.txt file.


All of the transactions are imported with today's date:

The QIF import expects the dates to be of the form month/day/year, where the forward slash is used for the separator. If the QIF file has dates with the form month-day-year, where the dash is used for the date separator, then all of the imported transactions will be created with the current date. The Windows Control Panel Regional Settings can control the date format in Windows applications.


Glossary


vbrun300.dll

The MS Visual Basic runtime dynamic link library.


cmdialog.vbx

An extension that provides Visual Basic with the ability to use the Windows common dialogs (cmdialog.dll).


mym2qifw.exe

The MYM DOS -> QIF MS Windows translator program.


Serial Number

This number is a function of your system configuration. Drag the mouse cursor over the Serial Number to highlight it. Then press <Ctrl+c> or <Ctrl+Insert> to copy the Serial Number to the Windows Clipboard. Then Paste the number into an E-Mail or Postal letter when you register MYM2QIFW.

The first time a corresponding Key is entered and matched; MYM2QIFW will store the Serial number for your installation of MYM2QIFW and the corresponding Key in a file named  mym2qifw.ini located in your Windows directory. Also the words Key Matched will appear above the Key number box.

The first three digits of the serial number just indicate the MYM2QIFW version, and the digits after the decimal point just indicate the destination application. The key number is only matched to the remaining digits.

In the event that the serial number has changed; please press <Ctrl+Shift+Alt+F4> to create a sysinfo.txt file. Then each time that the serial number changes; press the same key combination again to append to the same sysinfo.txt file. When there are at least two instances of the system information recorded in the sysinfo.txt file, then please send the file to me. I will be able to determine, by comparison, what part changed and remove it from the serial number module.


Key Number

A relatively unlimited number of account transactions may be processed when a Key Number, that corresponds to the Serial Number is entered into the Key Number box. During evaluation (before a Key is entered) a maximum of 10 transactions per account register will be written to QIF files. The complete mymaccts.qif file is created, with or without a Key, however.

If you receive a Key number by E-Mail, then I recommend using Copy and Paste to put the Key number into MYM2QIFW. After you copy the number from the message to the Windows clipboard, then click in the Key box on the first screen of MYM2QIFW, and then press <Ctrl+v> or <Shift+Insert> to Paste it.


Serialware

Software that is fully activated by entering a Key number that corresponds to the installed Serial number.


Quicken Interchange Format (QIF)

Overview

You can export transactions from a Quicken account register to a specially formatted text file and import data to a Quicken register from the same type of text file.  This text file MUST be formatted as a Quicken Interchange Format (QIF) file.  For Quicken to translate data from a text file into the Quicken register as transactions, the data must be in the QIF format.

Procedure

Basic Procedures:

Each transaction must end with a ^ symbol

Each item in the transaction must appear on a separate line

When Quicken exports an account register, it adds a line at the top of the file that identifies the type of account. Here are the header lines Quicken adds to the exported files:

!Type:Bank
!Type:Cash
!Type:CCard
!Type:Invst
!Type:Oth A
!Type:Oth L

You can add a line to a file to be imported into Quicken account to force Quicken to import all transfers, regardless of whether Ignore Transfers is selected when the file is imported.  Use a text editor or word processor to put the following line right after the header line at the top of the file:

!Option:AllXfr

Items for non-investment accounts

Each item in a bank, cash, credit card, other liability, or other asset account must begin with a letter that indicates the field in the Quicken register.  The non-split items can be in any sequence:

D Date
T Amount
C Cleared status
N Number(check or reference number)
P Payee
A Address (up to five lines; the sixth line is an optional message)
L Category (Category/Subcategory/Transfer/Class
S Category in split (Category/Transfer/Class)
E Memo in split
$ Dollar amount of split
^ End of the entry

Items for investment accounts

D Date
N Action
Y Security
I Price
Q Quantity (Number of shares or split ratio)
C Cleared Status
P. Text in the first line for transfers and reminders
M Memo
O Commission
L Account for the transfer
$ Amount transferred
^ End of the entry

Repeat the S, E, and $ lines as many times as needed for additional items in a split.  If an item is omitted from the transaction in the QIF file, Quicken treats it as a blank item.


E-Mail address

70451.2340@CompuServe.com


mymaccts.qif

A QIF file that contains a list of Account Names and Numbers, that will cause all of the accounts to be set up when the file is imported.


category.qif

A QIF file that contains a list of Category Names that were used for budget amount allocations in the transactions that were processed by MYM2QIFW.


MYM Export Files

Comma Separated Values

The MYM Export files are delimited by commas, with strings surrounded by double quotes. This format is called Comma Separated Values. It is not mandatory that the files exported from MYM be named using the .csv filename extension. When they are named this way however, they will all be listed together in the file selection box during MYM2QIFW Step 3: Select Files.

Use the EXPORT format

It is mandatory that the files are exported in the MYM Export format, and not in the MYM Report format, when completing Step 1: and Step 2:.

Export files are read by Fixed Field method

MYM2QIFW reads the MYM Export files by Fixed Field Format, and does not use the delimiters. Therefore it is important not to edit the MYM Export files in any way that will shift the position of data on the lines in the file.


Customize

I think that the feature that I like best in Quicken is the wonderful way that the Reports can be so easily customized to include the information that you want to see.