The latest version of this document can be found at: http://www.wco.com/~sdakin/qmate/userguide.html.
A couple of important notes:
QMate is a Quicken companion for the Palm Connected Organizer. It is not a replacement for Quicken, but rather designed for Quicken users who have a Palm handheld device and want to enter Quicken-specific data with a facile means of synchronizing that data with their Quicken data file(s). To that end, the only data you enter in QMate is that which you would enter in your Quicken register. Also, QMate emphasizes transaction functionality over account functionality as explained below in "Using QMate." QMate also works with Microsoft Money.
QSync is the name of the conduit which runs on your Wintel PC or Mac and generates .QIF files which you can import into Quicken or MS Money. The Windows version of QSync requires that you use version 2.0 or 3.0 of the HotSync Manager. See "Installing QMate and QSync."
To install QMate onto your Palm device, please follow these instructions:
As stated above, QSync requires you to use HotSync Manager version 2.0 or 3.0. The download page has everything you need to install in order to use QMate and its conduit. To install QSync on your Windows machine, please follow these instructions:
That's all there is to it. To use QSync, run the HotSync Manager and perform a HotSync. But before you do that, you might want to enter some account and transaction information into QMate so QSync will have something to work with. See the "Using QMate" section for details on how to do this.
Installing QSync for the Mac is simple: after unstuffing the download archive, double-click the QSync application icon and you're ready to go. I recommend leaving the Auto-run checkbox unchecked until you understand what it does and how to bypass it. This and the rest of the settings in QSync for the Mac are described below in Using QSync for Mac.
The first thing you will see when you run QMate is the Accounts form. There are two primary forms in QMate: one for accounts and the other for transactions. Once you enter your account information, you will spend most of your time in the Transactions form. Before you can enter any transactions, you must create one or more accounts.
To create a new account, tap the "New" button on the Accounts form. You will be presented with a dialog which allows you to specify the account name (up to 32 characters), account type (Bank, Cash, Credit Card, Asset or Liability), default currency and balance.
QMate supports up to 32 accounts. You can change information for an account by selecting the account on the Accounts form and tapping the "Details..." button. This is how you can keep your QMate account balances current with your Quicken ones.
Once you've entered your account information, navigate to the Transactions form. This can be accomplished in one of two ways: select an account and tap the "Transactions" button, or double-tap on the desired account.
The Transactions form is very similar to the Accounts form with only a couple of differences: 1) at the top is an account pop-up which controls which transactions are displayed; 2) selecting (single tapping) a transaction brings up the Transactions Details dialog; and 3) there is a "Show" button which allows you to change how transactions are displayed.
To enter a new transaction, tap the "New" button on the transaction form. This brings up the New Transaction dialog. There is help associated with the New Transaction dialog which can be accessed by tapping the "i" icon in the dialog's title bar. This help dialog explains the basics. Some advanced topics not covered in the online help are discussed here.
QMate supports QuickFill(tm) for fast category entry. To take advantage of this feature, you must import your list of Quicken categories into QMate. The process for doing this is desribed in the Using QSync section below.
To make entering often repeated transactions easier QMate supports memorized transactions. Once a transaction is memorized QMate will use QuickFill(tm) in the payee field to quickly match the desired transaction. Once you exit the payee field after a match is found, QMate will fill in the rest of the transaction fields with the values used in the previous entry of that memorized transaction. There is one difference between the way QMate and Quicken fill out fields after a memorized transaction has been "matched." In QMate, if your memorized transaction contains a number field value (non-special value) and the account into which you are entering the new transaction is not a credit card account type, QMate will automatically enter the next number in sequence for that account. To see the list of transactions which are presently memorized, press the "Payee" button on the New/Edit Transaction dialog. This will display the Select Payee dialog which allows you to view, delete and use items from your memorized transactions list.
To memorize a transaction simply select the Memorized checkbox in the New/Edit Transaction dialog box prior to pressing "OK". That transaction will then be memorized. To delete a memorized transaction, use the Delete button on the Payee Selection dialog or deselect the Memorized checkbox prior to pressing "OK" in the Edit Transaction dialog.
Split transactions are a way of breaking down a transaction into parts, each part of which can have a separate amount, category and memo. The main category (what is used as the category in a non-split transaction) is not used in the split case (since each split has its own category) but the main memo field may be used (in addition to any memos used for the splits).
To enter a split transaction in QMate, tap the Split... button on the New/Edit Transaction dialog. This will display the Split Transaction dialog. If you enter an amount on the New/Edit Transaction dialog before tapping on the Split... button then the amount for the entire transaction will remain fixed as you enter splits. If you do not enter an amount before tapping the Split... button then the amount will tabulate as you enter splits.
Any payee and amount information you entered on the New/Edit Transaction dialog is displayed at the top of the Split Transaction dialog. When you enter the Split Transaction dialog for any non-split transaction, the first split line will read "<new split>" with the amount matching what you entered for the transaction (or 0.00 otherwise). Adjust the amount and enter a category and memo (the latter only if desired) and tap the Save button. The "<new split>" line will be updated and a new one created for you. Any remaining transaction amount is entered as the amount for the next split. You may enter up to 6 splits for a transaction (this is a QMate limitation).
To delete a split, select it in the splits list and tap the Delete button.QMate will prompt you to confirm the deletion. To delete all of the splits and convert the transaction to a non-split transaction, tap the Clear button. Again, QMate will prompt you for confirmation.
When you are finished entering splits for a transaction tap the OK button. This will automatically save any modified split information and return you to the New/Edit Transaction dialog. The category for a split transaction will read "<split>" and cannot be modified.
To move a transaction from one account to another, select a transaction on the Transactions form. This will display the Edit Transaction dialog for that transaction. Change the selection in the account pop-up and tap "OK." The account balance for the two affected accounts will be updated according to the transaction amount, taking into account the currencies of the two accounts.
QMate also supports account transfer transactions. There are two ways to enter a transfer:
An important note about transfer categories is that in QMate only one of the accounts will contain a entry for the transaction, but both balances will be updated as per the rules of transfers. The reason only one account contains an entry for each transaction is that some versions Quicken will automatically add a corresponding entry for the account which does not contain the actual transfer transaction. To support the largest number of Quicken users possible I have opted for the present design.
QMate supports mutliple currencies, up to 32, including conversion rates. Each account in QMate can use a different currency symbol. Similarly, each transaction can have a different currency used for the amounts it contains. By default, transactions inherit the currency specified for the account in which they are created. To change the currencies QMate uses along with their conversion rates, choose Edit Currencies from the Lists menu. You can enter up to three characters for any currency. You also specify a base currency on this dialog. QSync will use the information in the Edit Currencies dialog to convert all amounts to your base currency when you perform a HotSync.
You may not want to store transactions on your Palm device indefinitely. Once you've synced your QMate transactions, you can quickly delete them by selecting the "Options:Purge..." menu item. In the purge dialog you can specify what criteria QMate should use to determine the transactions that should be purged. The criteria include account (individual or all), cleared and synced status and number of days old. Additionally you can instruct QMate to interpret the settings of the cleared, synced and number of days old settings in one of two ways. Selecting the "And" button means that all specified criteria must be met for a transaction to be purged; selecting the "Or" button means that if any of the specified criteria is met then QMate will purge the transaction. Use the purge feature carefully as it cannot be undone.
If you want to resync transactions for any reason, you can quickly clear the synced status of all transactions by selecting the "Options:Synced/Cleared Status..." menu item and selecting the "No" option next to the Synced label. Similarly, if you want to prevent all transactions from being synced, set the synced status by selecting the "Yes" option next to the Synced label. Selecting "No Change" will leave the Synced status unchange for all transactions. The cleared status can be updated in the same way. The synced and cleared status can also be set or cleared for individual transations via the Transactions Details dialog.
QSync saves the .QIF files it generates in the QMate output directory you specify in the QSetup program. If you're using Quicken 6, 98 or 99 and have selected the Single QIF File Format setting then QSync will save all transactions to a single file called "QMate.QIF". To ensure that this feature operates correctly, your QMate and Quicken account names must match exactly. If you're not using the Single QIF File Format setting, then the file names QSync uses for the .QIF files match your QMate account names. For example, if you have accounts called "Checking" and "VISA" entered in QMate then you will end up with two .QIF files after a HotSync: "Checking.QIF" and "VISA.QIF". Depending on the setting you specify in QSetup, QSync will either append transaction information to any existing .QIF file or overwrite the .QIF file with any new information. To import the transactions in these QIF files into Quicken, use Quicken's import command (File->File Operations->Import menu command) and select the QIF file(s) that QSync generated.
To import transactions from Quicken into QMate, use Quicken's export command to create a QIF file containing the transactions you wish to import into QMate (your Quicken manual and online help will have more information on how to perform this step). Important: the filenames you use for the data exported from Quicken must match your QMate account names exactly (not including the ".qif" extension). For example, if you have a QMate account called "Checking" then the QIF file to import into that account must be called "checking.qif" (case doesn't matter). Also, the import files must be located in the input directory you specified in QSetup when you installed QSync (rerun QSetup as often as you like to change this or any other setting). After each QIF file is imported it is moved to a subdirectory of your input directory called "Imported" (QSync will create it automatically, if necessary). This prevents the files from being imported more than once and alleviates the need for you to move or delete them manually. Files already stored in the Imported directory (e.g., those which have already been imported) will be overwritten with newer imported files. If you experience any problems importing files, first check your HotSync log for any helpful messages and feel free to send me an email if the problem persists.
QSync looks for a file called CatList.qif in your QMate input directory during a HotSync. It understands the file format that Quicken uses for importing and exporting categories. To create a CatList.qif file please follow the following steps:
After following the above steps, you will have a properly formatted file that QSync will use to import categories into QMate during the next HotSync. If you have problems importing that categories after you have created the CatList.qif file, please check your HotSync log for messages and see the synchronization tips I have posted online.
Note: QSync will only import category information into QMate if the category list on your Palm device is empty. This is the case after you install QMate and run it for the first time or when you select the "Delete Categories..." command from the Lists menu in QMate.
Importing Memorized Transactions
To import memorized transactions, follow the instructions in the previous section for creating a category export file from Quicken. Call the file "memorized.qif" and place it in your QMate input directory. Also, instead of checking the Category List checkbox select only the Memorized Transactions checkbox. Perform a HotSync and the transactions in that file will be available in QMate as memorized transactions.
Note about QSync for the Mac: an updated conduit is in the works and will be ready soon.
The are two settings panels in QSync Mac. The first pertains mostly to QMate. The second, accessible from the "Expense..." button pertains to the Palm Expense application. The main QSync Settings panel allows you to configure the following options:
QMate database folder
The Mac version of HotSync doesn't support third party conduits but it will create a backup file of Pilot databases on your Mac. QSync takes advantage of this by reading the QMate accounts and transactions contained in the QMate databases that are generated by the HotSync program. The two files that QSync needs are "QMateAccountsDB.pdb" and "QMateTransactionsDB.pdb" ("QMateCategoriesDB.pdb" may be present on your system but is not used at this time). HotSync saves these files in the backup folder contained in your Pilot user folder. Use the finder's find file command to locate the files if necessary.
Output folder
This instructs QSync where to save the QIF files it generates. Choose a location that is convenient for you when importing these files into Quicken. If you leave this field blank then QSync will output the QIF files in the folder from which you ran it.
Date format
For most users, MM/DD/YYYY will be the correct format.
QIF File Mode
If you intend to import your QIF files to Quicken after each HotSync, choose Overwrite. If you intend to perform more than one HotSync in between importing your QIF files to Quicken then you should use Append. In the latter case, make sure you delete the QIF files after importing them to avoid duplicate transactions in Quicken. If you're using Quicken 98, select the Quicken 98 QIF File Format checkbox to have QSync save all of your transactions to a single file called "QMate.qif" that you can import into Quicken. When you import this QIF file into Quicken, all of the transactions will be entered in the appropriate account (provided the account names match exactly).
Quit when finished generating QIF files
This instructs QSync to automatically quit after it has finished generating QIF files for the unsynced transactions. If this feature is turned off, QSync will display a dialog that tells you how many accounts were processed and how many transactions were transferred. You can find a more detailed report in the QSyncLog file (see below).
Auto-run
If you check this option then QSync will not display its settings dialog when you run it. Instead it will automatically generate QIF files and quit. This is a time-saving measure to help make QSync as quick and easy to use as possible. If you want to display the settings panel after turning this option on, simply hold down the command key as you run QSync and the auto-run feature will be bypassed for that run.
The Expense Settings panel allows you to specify which fields of the Expense records should be included in the comma separated values (CSV) file that QSync generates. You can also indicate whether you want the field names to be included as the first line in the CSV file.
Synchronizing QMate data
Synchronizing Expense data
Importing categories using QSync Mac
Using Quicken 98 for Mac you can create a CatList.qif file using these steps:
In Quicken 6 for Mac, you can use these steps to create a CatList.qif file:
After creating the CatList.qif file use the following steps to import the categories into QMate:
Note: QSync will translate the CatList.qif file to a QMateCategoriesDB.pdb file each time you tell it to process the files in your input folder. Your QMate categories will only be installed or updated, however, when you use Install App and HotSync to install the QMateCategoriesDB.pdb file onto your Palm device. To accelerate the running time of QSync, you can move your CatList.qif to a location other than your QMate database folder after you successfully import your categories.
Each time you run QSync it outputs to a file how many accounts were processed and how many transactions were transferred (and skipped) for each of those accounts. The output file is called "QSyncLog" and can be found in the folder you specified as your Output folder.
Account balances and transaction amounts are limited to roughly $99 million. Anyone needing to enter values larger than that probably doesn't need the assistance of a program like QMate but are encouraged to send me the excess so they can use QMate :-). Entering values greater than 99 million results in undefined behavior (i.e., I'm not considering it a bug).
The Windows version of QSync only runs on Windows 95, 98 or NT.
If you'd like to support my continued efforts on this program please see the QMate registration page.