t 1 Introduction
t 2 Setting Digits
t 3 Working with Accounts
   s 3.1 Creating a New Account
   s 3.2 Opening an Existing Account
   s 3.3 Saving an Account
   s 3.4 Closing an Account
   s 3.5 Refreshing the Accounts Window
   s 3.6 Editing an Account
   s 3.7 Deleting an Account
   s 3.8 Reconciling an Account
   s 3.9 Starting a New Fiscal Year
   s 3.9.1 Auto-opening Accounts
   s 3.11 Backing up Accounts
   s 3.12 Printing Accounts
   s 3.13 Setting Account Icons
t 4 Working with Ledgers
   s 3.2 Opening an Existing Account
   s 3.4 Closing an Account
   s 3.3 Saving an Account
   s 3.8 Reconciling an Account
   s 4.1 Viewing Cleared Transactions
   s 4.2 Viewing Memos
   s 4.3 Viewing Categories
   s 4.3.1 Viewing Multiple Categories
   s 4.4 Finding Transactions
   s 4.5 Using an External Calculator
t 5 Working with Transactions
   s 5.1 Adding Transactions
     ss 5.1.1 Number/Code Field
     ss 5.1.2 Date Field
     ss 5.1.3 Payee/Details Field
     ss 5.1.4 Amount Field
     ss 5.1.5 Category Field
     ss 5.1.5.1 Income Tax Category
     ss 5.1.6 Memo Field
     ss 5.1.6.1 Multiple Categories
     ss 5.1.7 Save Payee/Details Option
     ss 5.1.8 Save Memos Option
     ss 5.1.8.0 Save Last Date Option
     ss 5.1.8.1 Enter key tabs
     ss 5.1.9 Beep on Transaction Option
   s 5.2 Deleting Transactions
   s 5.3 Undeleting Transactions
   s 5.4 Editing Transactions
   s 5.5 Sorting / Reordering Transactions
   s 4.4 Finding Transactions
t 6 Working with Fixed Transactions
   s 6.1 What are Fixed Transactions?
   s 6.1.1 Creating Fixed Transactions
   s 6.2 Date-of-Month Transactions
   s 6.3 Weekday Transactions
   s 6.4 Prompt for Next Cheque
   s 6.4.1 Opening Fixed Transaction Ledgers
   s 6.5 Editing Fixed Transactions
   s 6.6 Using ET_Month
t 7 Creating Reports
   s 7.1 Menu Items
     ss 7.1.1 Select Editor...
     ss 7.1.2 Create Script...
     ss 7.1.3 Rebuild Script Menu
     ss 7.1.4 Process all (Accounts)
     ss 7.1.5 Select... (Accounts)
     ss 7.1.6 <Accounts> Items
     ss 7.1.7 <Format Scripts> Items
   s 7.2 Transactions Report
     ss 7.2.1 Process All (Transactions)
     ss 7.2.2 Select... (Transactions)
     ss 7.2.3 Categories...
   s 7.3 Script Commands
     ss 7.3.1 CRLF
     ss 7.3.2 DATE
     ss 7.3.3 FORMAT
     ss 7.3.4 SEND
     ss 7.3.5 TEXT
     ss 7.3.6 TIME
t 8 Converting Quicken Data
   s 8.1 Creating a Quicken QIF File
   s 8.2 Converting a Quicken QIF File
   s 8.3 QIF File Format
   s 8.4 Languages Other than English
t 9 Setting Colours/Fonts
t 14 DAT Files
t 10 Known Bugs/Limitations
t 11 Registration
   s 11.1 How Do I Register?
t 12 Warranty
t 13 Copyright Notices
t 15 Contacting the Author
t 16 Future Plans
<end>
1 
\Introduction
E-Teller is a bank and credit card account management utility.

Among its many features are:

  ú multiple opened ledgers
  ú customizable report layouts
  ú flexible fixed transactions

E-Teller is not free.  Please see the Registration topic for information on registering E-Teller.
xref 11 Registration
xref 11.1 How Do I Register?
xref 7 Creating Reports
xref 6.1 What are Fixed Transactions
prev 13
next 2
&
2 
\Setting Digits
By default, Rexx starts using exponents after 9 digits.  If you're exceptionally wealthy or if, for whatever reason, you require higher numbers than 999,999,999.99, then you can pass a parameter to e-teller.exe, q2et.exe, and etreport.exe which instructs these programs to change the limit at which Rexx begins using exponents.  Thus, passing a parameter 12 would raise the 999,999,999.99 limit mentioned above to 999,999,999,999.99.  If no parameter is passed to any of these programs, then each will use the default.

If you require larger numbers, open the Settings notebook for the appropriate application and enter the desired number in the Parameters entry field.
prev 1
next 3
&
3 
\Working with Accounts
This section describes the operations that are specific to the Accounts window.
next 3.1
prev 2
&
3.1 
\Creating a New Account
Select the 'New' item from the 'Accounts' menu to create a new account.

When creating a new account, you supply a minimum of four pieces of information:

  ú Name
  ú Number
  ú Starting Balance
  ú Date
  ú Type

Name (required)
is the name which appears in the Accounts window and in the Report 'Options' menu.

Number (optional)
is an optional account number

Starting Balance (required)
is used by E-Teller when you first reconcile your account.  Before the account is first balanced, Starting Balance is, in fact, the Ending Balance.

Date (required)
is used by E-Teller in searching for transactions and in printing reports.  Dates must adhere to the yy/mm/dd format which E-Teller uses in order to sort transactions.

Type (required)
is used by E-Teller to decide upon an appropriate action when crediting and debiting an account.  There are only two types of accounts:

  ú Bank
  ú Credit Card
xref 3.8 Reconciling an Account
xref 7 Creating Reports
prev 3
next 3.2
&
3.2 
\Opening an Existing Account
To open an account, double-click on its icon in the Accounts window or select the icon and press <enter>.  An opened account is denoted by the cross-hatch background.

If you try to open an already opened account, you will be asked if you wish to refresh the account's ledger window.  Selecting 'Refresh' essentially rereads the transactions into the ledger.

In versions of E-Teller earlier than 1.6, users could drag the icon to the ledger container.  Since, as of 1.6, each ledger has its own window, drag and drop is no longer supported.
prev 3.1
next 3.3
xref 4 Working with Ledgers
&
3.3 
\Saving an Account
Rarely is it necessary to save the account ledger data since many of the common activities, such as crediting and debiting accounts, are automatically written to file.  There are two exceptions to this:

  ú editing transactions
  ú deleting transactions

If you forget to save after any of these activities, E-Teller will notify you before the ledger window is closed or E-Teller shuts down.  
prev 3.2
next 3.4
xref 5.4 Editing Transactions
xref 5.2 Deleting Transactions
xref 5.3 Undeleting Transactions
xref 5.5 Sorting/Reordering Transactions
&
3.4 
\Closing an Account
It is seldom necessary to close an account manually.  The exception is when you select either the 'New fiscal year...'  or 'Edit...'  items from the Accounts menu.  Otherwise, all ledger windows will be closed when you quit E-Teller, but not before asking if you want to save the data if necessary.

You can close accounts manually, however.  

If you have only one ledger window opened and it has the focus, simply press Alt-F4.  If the accounts window has the focus, then either right-click on the account icon and select 'Close' or select the appropriate icon and press the 'Close' (Ctrl-F4) menu item in the Accounts menu.

If more than one ledger window is opened and you want to close them all without quitting E-Teller, right-click on a blank area in the accounts window and select the 'Close' or 'Close all' menu items.  Alternatively, select the 'Close all' item (Ctrl-Shift-F4) if you haven't right-clicked on the window.  In all cases, if a ledger needs to be saved, you'll be prompted before the ledger is closed.
prev 3.3
next 3.5
xref 3.6 Editing an Account
xref 3.9 Starting a New Fiscal Year
&
3.5
\Refreshing the Accounts Container
Generally you shouldn't have to refresh the accounts in the accounts window unless you manually change an account's name or type in the *.clr file and you want the change to be reflected in the window, in which case you will click on the 'Refresh' item in
 the 'Accounts' menu.  

If you edit an account through E-Teller, then the refresh will be called automatically for you.
prev 3.4
next 3.6
xref 3.6 Editing an Account
&
3.6
\Editing an Account
To edit all but the starting balance of an account, click on the 'Edit...' item from the Accounts menu.  When you've done editing the account data, click 'OK' and the changes will be saved to the account's *.clr file.

If either the name or type of account is changed, then the change will be reflected in the account window.
prev 3.5
next 3.7
&
3.7
\Deleting an Account
To delete an account from within E-Teller, either right-click on the account's icon and select 'Delete' from the popup menu.  If you do not right-click on the icon, then the currently selected account will be deleted.

In either case, you will first be prompted before the account files are actually deleted.
prev 3.6
next 3.8
xref 10 Known Bugs/Limitations
&
3.8
\Reconciling an Account
Reconciling an account is simply balancing the ledger with a bank or credit card statement.

To reconcile the account, either click on the scale icon or select 'Reconcile...'  from the Accounts pull-down menu (also available by right-clicking on the Accounts container).  

NB:  The scale toggle button will assume a 'balanced' position during the reconciliation process and the 'Reconcile...'  menu item will have a checkmark beside it.  

To end the reconciliation process, click on the scale toggle button or uncheck the 'Reconcile...'  menu item.  

To reconcile an account, proceed as follows:  

1) click on the scale button
2) enter the new balance
3) enter any interest payments / charges
4) enter any service charges
5) click 'OK'
6) double-click on the ledger entries that are to be cleared
7) click on the scale button

If the account has been balanced (based upon the previous month's ending balance, the current month's new balance and the cleared debits / credits), then you will be asked to confirm that you want to save the account to disk.  If you elect to save, only the uncleared items will be displayed.  If you elect not to save, then you will be prompted to save the account before leaving E-Teller.  

If the account has not been balanced due to a discrepancy in totals, you will be prompted to select one of four push buttons in the Reconciliation Error dialog box:  

  ú Yes
  ú No
  ú Cancel
  ú Ignore

where:

YES
instructs E-Teller to present you with the credit/debit window where you will enter information for the balance adjustment entry.

NO
instructs E-Teller NOT to present you with the credit/debit window and to make no attempt at further reconciliation (in other words, your account will remain unbalanced).  

CANCEL
instructs E-Teller to return to the reconciliation process.  

IGNORE
instructs E-Teller to fake the balance, i.e.  adjust the ending balance as though the account had actually been reconciled.
prev 3.7
next 3.9
&
3.9 
\Starting a New Fiscal Year
Click on the 'New fiscal year...' item from the 'Accounts' menu to begin a new fiscal year for a specific account.  What essentially occurs when you select this operation is that all of the cleared transactions in the *.clr file are deleted.  If you are absolutely certain that this is what you want to do, then click on the 'Proceed' button in the confirmation dialog box.  If you change your mind while in the entry window, you can click on Cancel to abort the operation.  Once you click 'OK' then the cleared transactions will be removed and the balance in the Balance entry field will become the new starting balance.  If you inadvertently do select 'OK' (thereby deleting all of the cleared transactions) and have a backup of the account files, then simply copy those files from the backup diskette into E-Teller's directory.

It is highly recommended that you not change the value of the Balance entry field, since this represents the ending balance of the last reconciliation process. 
prev 3.8
next 3.10
xref 3.11 Backing up Accounts
&
3.9.1
\Auto-opening Accounts
Check the 'Auto open' item in the 'Accounts' menu if you want E-Teller to open the last closed account automatically when it starts up.

If this feature is enabled, a checkmark will appear next to the 'Auto open' menu item.  The status of the checkmark is saved to e-teller.ini when you quit E-Teller.
prev 3.9
next 3.11
&
3.11
\Backing up Accounts
If you would like E-Teller to back up all of the account and *.dat files when you exit E-Teller, check the 'Backup on exit' menu item in the 'Accounts' menu.

If this feature is enabled, a checkmark will appear next to the 'Backup on exit' menu item and a dialog box will popup before E-Teller shuts down with three push buttons:

  1) A:
  2) B:
  3) Cancel

If you want to backup up to drive A:, then click on A:.  If you want to skip the backup for this session, press 'Cancel'.  The status of the checkmark is saved to e-teller.ini when you quit E-Teller.
prev 3.10
next 3.12
&
3.12
\Printing Accounts
Please see Creating Reports
prev 3.11
next 3.13
xref 7 Creating Reports
&
3.13
\Setting Account Icons
E-Teller no longer uses default icons for bank and credit card accounts although they are included in the archive.  

To have iconic (?)  representations of your accounts, you must explicitly specify an icon (either one supplied or another of your own making/choice) by clicking on the 'Set icon...'  item in the Accounts menu of the accounts window.  The *.ico file you select is saved to the .CLR file in a section entitled [Icon].  

NB: et_fix.dat and et_fixed.dat's icons cannot be changed.
prev 3.12
next 4
&
4
\Working with Ledgers
This section describes operations specific to the Ledger window.
prev 3.12
next 3.3
&
4.1
\Viewing Cleared Transactions
By default, cleared transactions are not loaded into the ledger window when the account is initially opened in order to decrease the reading and formatting time.

If, for whatever reason, you want to view or edit cleared transactions, either click on the Cleared toggle button (the one with the asterisk) or select the 'Cleared' item from the 'Display' menu in the ledger window.  When you're done with viewing the cleared transactions and want to return to the default view, simply click on the toggle button or menu item a second time.  The transactions in the ledger will be removed and the uncleared transactions read into the ledger again.

You cannot permanently enable the cleared display.

NB: For obvious reasons, you cannot view cleared transactions in a fixed transaction ledger.
prev 3.3
next 4.2
xref 5.4 Editing Transactions
xref 6 Working with Fixed Transactions
&
4.2
\Viewing Memos
By default, the memo field in the ledger is hidden.  If you would like to view the memo field, either click on the memo toggle button (the yellow note) or click on the 'Memos' item in the 'Display' menu in the ledger window.  To hide the memo field again, click on the toggle or menu item a second time.

Like the category option, the status of this menu item is written to e-teller.ini when clicked.
prev 4.1
next 4.3
xref 4.3 Viewing Categories
&
4.3
\Viewing Categories
By default, the category field in the ledger is hidden.  If you would like to view the category field, either click on the category toggle button (the house and balloons) or click on the 'Categories' item in the 'Display' menu in the ledger window.  To hide the category field again, click on the toggle or menu item a second time.

Like the memo option, the status of this menu item is written to e-teller.ini when clicked.
prev 4.2
next 4.3.1
xref 4.3.1 Viewing Multiple Categories
xref 4.2 Viewing Memos
&
4.3.1
\Viewing Multiple Categories
By default, the multiple category field in the ledger is hidden.  If you would like to view the multiple category field, either click on the multiple category toggle button (the large house) or click on the 'Multiple categories' item in the 'Display' menu in the ledger window.  To hide the multiple category field again, click on the toggle or menu item a second time.

The status of this menu item is written to e-teller.ini when clicked.
prev 4.3
next 4.4
xref 4.3 Viewing Categories
xref 4.2 Viewing Memos
&
4.4
\Finding Transactions
To search for specific transactions or a group of transactions, either click on the find push button (the magnifying glass) or the 'Find...' item in the 'Display' menu in the ledger window.

You must provide three pieces of information before a search can be executed:

  1) Field to search
  2) Search criterion
  3) String to search

The default field is 'Particulars', and the default criterion is 'Contains'.  Once you've provided the necessary information, E-Teller will search through the transactions in the ledger for matches.  As a successful search occurs, a count of found transactions as well as a total of the credit and debit fields will appear in the status area of the window (bottom).  To view all of the transactions after a search, click on the 'Undo' push button.  When you're done searching, click 'Cancel'.  If you've forgotten to undo the search results, E-Teller will display all of the transactions at this point.

NB: Searches are case insensitive
NB: You cannot search a ledger which contains deleted transactions.  If you attempt to do so, you will be prompted to delete the transactions permanently or abort the search operation.
prev 4.3
next 4.5
xref 5.2 Deleting Transactions
xref 5.3 Undeleting Transactions
&
4.5
\Using an External Calculator
To invoke an external calculator program, click on the calculator push button or the 'Calculator' item in the 'Display' menu in the ledger window.

When you invoke an external calculator for the first time, E-Teller looks for the program pmdcalc.exe in the os2\apps subdirectory on the drive which contains your os2.ini file.  If it is unable to locate the program, you will be prompted with a file dialog box to select a calculator program.  Once a calculator has been found or selected, the path and name of that calculator program will be saved to e-teller.ini.
prev 4.4
next 5
&
5
\Working with Transactions
This section describes operations specific to transactions.
prev 4.5
next 5.1
&
5.1
\Adding Transactions
To credit or debit an account, select the appropriate push button or item in the 'Transactions' menu in the ledger window.

If the account type is 'Bank', then the credit / debit menu items will be exactly that, with a '+' and '-' accelerator respectively.  If the account is a 'CreditCard' account, the menu items will be named 'Payment' and 'Charge' with '-' and '+' accelerators respectively to reflect the type of transactions which take place with credit cards as opposed to bank accounts.

When crediting or debiting accounts, you provide the following information:

  ú Number/Code (optional)
  ú Date (required)
  ú Payee/Details (optional)
  ú Amount (required)
  ú Category (optional)
  ú Memo (optional)

For a detailed description of each, see the sub-entries.
prev 5
next 5.1.1
&
5.1.1
\Number Field
Enter an optional five-digit cheque number or five-character code in this field.  

Character strings are converted to upper-case, and those that exceed the five character limit are truncated.

If the transaction is a cheque, the number will be written to e-teller.ini (provided it is not less than the one which e-teller.ini currently contains) and incremented by one the next time you write a cheque.  Since numbers are limited to five digits, the maximum number permitted for a cheque is 99999.  Once you've reached this number, E-Teller will begin at 1 for the next cheque.

If the number field contains a code rather than a number, and if that code is not already in the category.dat file, it, along with the payee / details data will be added to the category.dat file for future reference.

If you select an item in the Number combobox, and if there is payee / details data attached to it, when the Number field loses focus the payee / detail data will be written to the payee / details field.  

If the payee / details data is found in the info.dat file, then the amount, category (if any), and memo (if any) data will be written to their respective fields.
prev 5.1
next 5.1.2
xref 14 DAT Files
xref 14.1 Deleting DAT File Items
&
5.1.2
\Date Field
Enter the date of the transaction in this field.

The date you enter must adhere to the yy/mm/dd format (complete with forward slashes).  If you mix up the year and/or month and/or day, E-Teller will do its best to spot the error and inform you of a problem.  If you substitute the forward slashes for any other character, E-Teller will inform you of the error.
prev 5.1.1
next 5.1.3
&
5.1.3
\Payee/Details Field
Enter the optional payee or details information for the transaction in the Pay to... / Details field of the debit / credit window.

This field is limited to 25 characters.  Any string longer than 25 characters will be truncated.

If you wish to save the payee / details, amount, and category data to the info.dat file for future use, click on the 'Save Pay to.../Details' checkbox in the credit / debit window.  If the data is saved to info.dat and you select the previously saved payee / details data from the Pay to... / Details combobox, then the amount, category (if any), and memo (if any) data will be written to their appropriate fields.

For help on setting the default behaviour of the 'Save Pay to... / Details' checkbox, see 'Save Payee/Details Option'

NB: Regardless of the user-defined default setting, the 'Save Pay to... / Details' checkbox remains disabled and unchecked as long as the Pay to... / Details field is empty.
prev 5.1.2
next 5.1.4
xref 14 DAT Files
xref 14.1 Deleting DAT File Items
xref 5.1.7 Save Payee/Details Option
&
5.1.4
\Amount Field
Enter the amount of the transaction in this Amount field of the credit / debit window.

You may add commas where appropriate if you like or let E-Teller add them for you before adding the transaction to the ledger.  Do not enter a currency symbol.  If you do, E-Teller will reject the transaction.
prev 5.1.3
next 5.1.5
xref 2 Setting Digits
&
5.1.5
\Category Field
Enter an optional category for the transaction in the Category field of the credit / debit window.

Every new category you enter in the Category field is automatically saved to the category.dat file.  Sub-categories are permitted.  Thus,

   Computer: Hardware
   Computer: Software
   Computer: Training

are all valid.  E-Teller uses categories primarily in the report feature and can make use of such sub-categories in grouping categories based upon a common parent.  This is accomplished by virtue of the fact that categories are first sorted alphabetically before being sent to a report.
prev 5.1.4
next 5.1.5.1
xref 14 DAT Files
xref 14.1 Deleting DAT File Items
xref 7 Creating Reports
&
5.1.5.1
\Income Tax Category
If the category you select or enter in the Category field is to be used for income tax purposes, then check the 'Income tax category' checkbox in the credit / debit window.  The string '<tax>' will be appended to the category in the category.dat file and will appear in the Category field, as well, making it easy to a) detect an income tax-related category and b) have the same category act as both an income tax-related transaction and a regular transaction - useful, for example, if a 'Charity' category is generally income tax related, but not in all cases.

You can use the income tax-related category to generate a report of transactions that must appear in your income tax return.

If you want to update your category.dat, account *.clr and *.ldg files to support the income tax category, then open the appropriate files with a plain text editor.  For those income tax categories and transactions, add the '<tax>' string after the category and category line (the one with the L prefix.  E.g.

   D1994/01/01   <- date
   N001          <- number
   PJohn Doe     <- payee
   T-1400        <- amount
   MFirst & Last <- memo
   LRent <tax>   <- category
   ^             <- separator

NB: It is important that both the category.dat and account *.clr *.ldg files be updated.
NB: The checkbox remains unchecked and disabled as long as the Category field is empty.
prev 5.1.5
next 5.1.6
xref 7.2.3 Categories (Report)
&
5.1.6
\Memo Field
Enter an optional memo in the Memo field of the credit / debit window.

By default, memos are not automatically saved along with the payee / details, amount, and category data in the info.dat file.  To save the memo along with the remainder of the above-mentioned data, click on the 'Save memos' checkbox in the credit / debit window.

NB: The 'Save memos' checkbox is enabled only if all of the following conditions are satisfied:

1) The Pay to... / Details field contains data.
2) The Save Pay to... / Details checkbox is checked.
3) The Memo field contains data
prev 5.1.5
next 5.1.6.1
xref 14 DAT Files
xref 14.1 Deleting DAT File Items
xref 5.1.8 Saving Memos Option
xref 5.1.3 Payee/Details Field
xref 5.1.7 Save Payee/Details Option
&
5.1.6.1 
\Multiple Categories
Multiple categories are, essentially, different categories used for a single transaction.  For example, if you withdraw $200 but would like a record of where various portions of that money went, you can click on the 'Multi...' push button in the credit / debit window and assign amounts to various categories, e.g.

   Groceries $130
   Personal Expenses $50
   Gifts $20

If multiple categories have been entered for a transaction, the string '<Multi>' will appear in the category field.

NB: Multiple categories can be included in reports, but they cannot be listed separately - they remain subcategories, as it were, of category <Multi>.
prev 5.1.6
next 5.1.7
&
5.1.7
\Save Payee/Details Option
To set the default status of the 'Save Pay to... / Details' checkbox in the credit / debit window, click on the 'Save payee / details' item in the Transactions | Options menu.

The status of this menu item is saved to e-teller.ini whenever you click on it.
prev 5.1.6.1
next 5.1.8
xref 5.1.3 Payee/Details Field
&
5.1.8
\Save Memos Option
To set the default status of the 'Save memo' checkbox in the credit / debit window, click on the 'Save memos' item in the Transactions | Options menu.

The status of this menu item is save to e-teller.ini whenever you click on it.
prev 5.1.7
next 5.1.8.0
xref 5.1.6 Memo Field
&
5.1.8.0
\Save Last Date Option
By default, E-Teller uses the system date for the first new transaction you enter and the latest date thereafter for every subsequent transaction during the current session.  If you prefer E-Teller to use the latest date of the last session, then click on the 'Save last date' item in the Transactions | Options menu of the ledger window.  If checked, E-Teller will write the latest date of the current session to e-teller.ini and default to that date on the next invocation.
prev 5.1.8
next 5.1.8.1
xref 5.1.6 Memo Field
&
5.1.8.1
\Enter Key Tabs
The 'Enter key tabs' item in the Transactions | Options menu in the ledger window is designed to alter the behaviour of the <enter> key when adding or editing transactions.  

By default, <enter> is equivalent to clicking on the 'OK' button.  If you habitually use the numeric keypad when entering transactions or would otherwise prefer not to have <enter> automatically add the transaction to the ledger, click on the 'Enter key tabs' menu item.  If this item is checked, then pressing either the keyboard or keypad <enter> will be equivalent to pressing <tab>.

The status of the item is saved to e-teller.ini whenver you click on the menu item.
prev 5.1.8
next 5.1.9
&
5.1.9
\Beep on Transaction Option
If the 'Beep on transaction' option in the Transactions | Options menu in the ledger window is set, then two tones will sound from the computer speaker whenever a transaction is added to the ledger or whenever an edit is confirmed.  To disable this beep, uncheck the menu item.  The default is checked.

The status of the 'Beep on transaction' menu is automatically saved to e-teller.ini whenever you click on it.

NB: The 'Beep on transaction' option cannot be disabled in the non-registered version.
prev 5.1.8
next 5.1.2
xref 11 Registration
&
5.2
\Deleting Transactions
To delete a transaction from a ledger, either right-click on the transaction and select the 'Delete' menu item in the popup menu, or scroll to the transaction and select the 'Delete' item (Ctrl+D) in the 'Transactions' menu.

NB: You cannot delete cleared transactions from within E-Teller.
prev 5.1
next 5.3
xref 10 Known Bugs/Limitations
xref 5.3 Undeleting Transactions
&
5.3
\Undeleting Transactions
To undelete a recently deleted transaction, select the 'Undelete' item from the 'Transactions' menu and double-click on the deleted transactions displayed in the ledger.

To terminate the undelete operation, click on the 'Undelete' menu item again.

You can undelete deleted transactions as long as the ledger is neither closed nor refreshed.

NB: The 'Undelete' menu item remains disabled as long as the ledger does not contain any deleted transactions.
NB: If you undelete all of the displayed transactions, E-Teller will automatically uncheck and disable the 'Undelete' menu item.
prev 5.2
next 5.4
xref 5.2 Deleting Transactions
xref 3.4 Closing an Account
xref 3.2 Opening an Existing Account
&
5.4
\Editing Transactions
To edit a transaction, either double-click on it, right-click on it and select the 'Edit...' item from the 'Transactions' menu, or scroll to the transaction and select the 'Edit...' item or press <enter>.  To confirm any changes, click 'OK' in the credit / debit window.

You can also edit specific transaction fields by holding down the Alt key and left-clicking on the appropriate field.  The 'Balance' and 'Clr' fields cannot be edited in any way.

If you edit a cleared transaction, a dialog box will remind you that your are about to edit a cleared transaction, and that changing the amount may invalidate the ending balance for the account.
prev 5.3
next 5.5
xref 10 Known Bugs/Limitations
xref 6.5 Editing Fixed Transactions
&
5.5
\Sorting/Reordering Transactions
As of version 1.7, continuous sorting is no longer supported - it was causing too many unpredictable results when tabulating the running balance.  In other words, clicking on the 'Sort' item in the 'Transactions' menu of the ledger window no longer toggles sorting for existing and future transactions.  Instead, clicking on the 'Sort' menu item sorts the displayed transactions, recalculates the balance based upon the new sort order, and then prompts you to save the sorted transactions to file.  The order in which the transactions appear is the order in which they are saved and read into the ledger.

New transactions are always appended to the end of the ledger.

You can also move transactions in a ledger by dragging them to a different location.  Since automatic sorting is not an issue as of version 1.7, such transactions can be moved virtually anywhere within a ledger.

NB: For a move to be successful, ensure that a line appears *in between* two transactions (and not around one).
prev 5.4
next 4.4
&
6
\Working with Fixed Transactions
This section describes operations specific to fixed transactions.
prev 4.4
next 6.1
&
6.1
\What are Fixed Transactions?
Fixed transactions are those that remain constant from month to month or at pre-defined periods within a month, such as rent cheques, mortgage payments, or paycheques that are automatically deposited into your bank account.

As the above suggests, there are two different types of fixed transactions:  date-of-month and weekday
prev 6
next 6.1.1
xref 6.2 Date-of-Month Transactions
xref 6.3 Weekday Transactions
&
6.1.1
\Creating Fixed Transactions
Creating fixed transactions is similar to creating regular transactions except that they require at least one extra step, at most, three, possibly four.

If you check the 'Fixed transaction' checkbox in the credit / debit window, E-Teller will treat the new transaction as a fixed transaction and bring up the Fixed Transaction window after you click 'OK'.

The Fixed Transaction window is where you specify whether the transaction is a date-of-month or weekday one.  If you check the 'Fixed date of the month' checkbox in this window, then you need do nothing else.  If you want E-Teller to prompt you for the next cheque number the next time ET_Month processes the et_fixed.dat file, then check the 'Prompt for next cheque' checkbox.
prev 6.1
next 6.2
xref 6.3 Weekday Transactions
xref 6.4 Prompt for Next Cheque
xref 6.6 Using ET_Month
xref 14 DAT Files
&
6.2
\Date-of-Month Transactions
Date-of-month transactions occur on specific dates within a month.  An example of such a transaction would be a rent cheque which is due on the first of the month.

If the fixed transaction occurs on the same date of the month, then click on the 'Fixed date of month' checkbox in the Fixed Transaction window.
prev 6.1.1
next 6.3
xref 6.4 Prompt for Next Cheque
xref 6.3 Weekday Transactions
xref 6.6 Using ET_Month
&
6.3
\Weekday Transactions
Fixed weekday transactions occur at specific intervals during a month.  An example of such a transaction would be a paycheque which is deposited into your account every second Friday.

If this is the case, then uncheck the 'Fixed date of the month' checkbox in the Fixed Transaction window.  You then must select a weekday upon which the transaction habitually takes place as well as a frequency.  The weekday automatically defaults to the current weekday reported by the system date, and the frequency defaults to 'Monthly'.  If either is unsatisfactory, click on the appropriate radio button.

There are four possible frequency settings:

  ú Weekly
  ú Biweekly
  ú Triweekly
  ú Monthly

If, based upon the weekday and frequency settings, the transaction will reoccur more than once during the current month, then it will be added to both et_fixed.dat and et_fix.dat to be processed by ET_Month.

In versions of E-Teller previous to 1.7, there was a potential problem in weekday transactions with a monthly frequency if there were five of a given weekday in a month.  If such a transaction fell on the first of those 5 days, then a second transaction would be added to the ledger, which, of course, was incorrect.  As of version 1.7, ET_Month ensures that only one such transaction is added to a ledger and verifies that the next transaction will, indeed, be added the following month when et_fix.dat is regenerated as opposed to the fifth weekday of the previous month.  If it is not, then the number which ET_Month uses to calculate the transaction dates will be incremented by seven.
prev 6.2
next 6.4
xref 6.6 Using ET_Month
xref 6.1 Date-of-Month Transactions
xref 6.4 Prompt for Next Cheque
xref 14 DAT Files
&
6.4
\Prompt for Next Cheque
This checkbox in the Fixed Transaction window instructs ET_Month to prompt you for the next cheque when it recreates et_fix.dat at the start of each new month or when it regenerates et_fix.dat after you've edited a fixed transaction.  This is useful for post-dated rent cheques, for example.

If ET_Month finds the string 'prompt' next to a cheque number, then it will bring up a prompt dialog box in which will be displayed the payee and last cheque number.  After you enter then next cheque in the series and click 'OK', the transaction will be added to the et_fix.dat file to be processed later and the cheque number in et_fixed.dat will be updated with the number just entered into the prompt box.
prev 6.3
next 6.4.1
xref 6.6 Using ET_Month
xref 6.5 Editing Fixed Transactions
xref 14 DAT Files
&
6.4.1
\Opening Fixed Transaction Ledgers
If either or both et_fix.dat and et_fixed.dat exist in E-Teller's directory when you first start E-Teller, then two extra accounts will be added to the accounts window, named 'Daily Trans.' for the et_fix.dat file and 'Fixed Trans.' for the et_fixed.dat file.

To open a fixed transaction ledger for editing purposes, double click on its icon as you would for any other account.

You will notice that some of the fields in the ledger are different for fixed transaction ledgers.  For example, the Date is entitled 'Date/Day', Balance is replaced by a field called 'File', and the Clr field is renamed 'Frequency'.  This is to provide you with information regarding the type of fixed transaction.

Date/Day
contains the date of the month upon which date-of-month transactions take place or the weekday for weekday transactions.

No
contains the usual information in addition to 'prompt' if the 'Prompt for next cheque' is enabled for a given transaction

File
contains the filename (less extension) of the account to which the transaction will be added.  Since filenames are usually made up of the beginning of the actual account name, it should be relatively easy to distinguish to which account the transaction belongs.

Frequency
contains the frequency of a weekday transation, either Weekly, Biweekly, Triweekly, or Monthly.
prev 6.4
next 6.5
xref 6.6 Using ET_Month
&
6.5
\Editing Fixed Transactions
Editing fixed transactions is similar to editing regular transactions.  There are a few exceptions, however.

Although the credit / debit window is invoked if you double-click on a fixed transaction within the ledger, the number, date, and amount fields are hidden.  In addition, the 'Fixed transaction' push button is automatically checked and disabled.  If you're editing either the date, weekday, or frequency for the transaction, or changing it from a date-of-month to weekday (or vice versa) transaction, then click 'OK' in the credit / debit window and wait for the fixed transaction window.

Unlike when you first create a fixed transaction, when editing such transactions a spin button appears in the fixed transaction window entitled 'Begin on:'.  Depending on the type of transaction, this spin button has a different purpose.  For date-of-month transactions, the date of month will display the date of the month for the transaction.  Changing the number effectively changes the date upon which the transaction is to take place.  For weekday transactions, the number represents the date (for the current month) upon which the ET_Month should begin tabulating the next transaction date.  Thus, if the weekday is Friday and you want to change it to Monday, then you necessarily have to change the 'Begin on:' number to a date which corresponds to the Mond
ay you want ET_Month to begin counting.

Because ET_Month uses this number to tabulate the date of a transaction before it is added to et_fix.dat, it is important that you select a date in the current month which corresponds to the weekday you've selected.  There is no way for ET_Month to verify whether you've selected a proper date, so if you select an incorrect date, then the transaction in et_fix.dat will necessarily be incorrect.

If you edit a weekday transaction or change a date-of-month transaction to a weekday one, then E-Teller will ask you if you want to regenerate et_fix.dat before it closes the fixed transaction ledger.  This is to ensure that any changes you make to weekday transactions are added to et_fix.dat if necessary.  If you click on the 'Regenerate' button, ET_Month will process et_fixed.dat and add any entries that should be added to et_fix.dat.  Once the procedure is done, the transactions contained within et_fix.dat will be displayed in the fixed transaction ledger, at which point you will delete those that you do not want ET_Month to process for the current month.  When you're done deleting unwanted fixed transactions, save the ledger and exit the window as you would for regular ledgers.
prev 6.4
next 6.6
xref 6.6 Using ET_Month
xref 14 DAT Files
xref 3.3 Saving an Account
xref 3.4 Closing an Account
&
6.6
\Using ET_Month
ET_Month generally works independently and in the background.  The exception to this is if it encounters a transaction for which you've requested to be prompted for the next cheque number.

For ET_Month to be effective, it should reside in your E-Teller directory, and a shadow should be placed in your startup folder.

If a shadow of ET_Month is located in your startup folder, then it will look in the et_fix.dat file for any transactions that require processing depending on the system date.  If you haven't booted OS/2 in a few days, don't worry, because ET_Month processes all the transactions it finds with a date earlier or equal to the system date.  As transactions are processed, they are removed from the et_fix.dat file so that they don't get processed more than once a month.

At the beginning of the month, ET_Month looks in the et_fix.dat file for any unprocessed transactions.  If it finds any, it processes them.  It then regenerates et_fix.dat based upon the information contained in et_fixed.dat, first running through the date-of-month transactions and then the weekday ones.  If you failed to boot OS/2 on the first of the month, don't worry, because ET_Month ensures that the date for both the et_fix.dat and et_fixed.dat files reflect the month reported by the system date.
prev 6.5
next 7
xref 6.4 Prompt for Next Cheque
&
7
\Creating Reports
E-Teller provides a fairly flexible way of creating reports of your accounts, based upon a format you specify.  It does this by reading format scripts you create (two were provided in the archive).

All format scripts must reside in a subdirectory beneath E-Teller's directory called 'Formats' and must have a .fmt extension.

In addition to user-defined formats, E-Teller Report can limit the data in a report by using search criteria which you specify, include all of the transactions in a specific account, create a category-only report, create one large report of all the accounts it finds in the current directory, or create a large report of specific accounts you specify.
prev 6.6
next 7.1
xref 7.3 Script Commands
xref 7.1.4 Process all Accounts
xref 7.1.5 Process Selected... (Accounts)
xref 7.2.1 Process All (Transactions)
xref 7.2.2 Select... (Transactions)
xref 7.2.3 Categories
&
7.1
\Menu Items
This section describes some of the less obvious menu items in the E-Teller Report window.
prev 7
next 7.1.1
&
7.1.1
\Select Editor...
E-Teller Report uses an external editor for saving, editing, and printing the reports it creates.

When you first start E-Teller Report, a file dialogbox appears in which you specify the default editor for *all* editing, saving, and printing tasks.  A good candidate is epm.exe.  The program you select is saved to e-teller.ini.
prev 7.1
next 7.1.2
&
7.1.2
\Create Script...
There are five sections to all format scripts:

[Name] [Title] [Header] [Footer] [Layout]

[Name] 
contains at least one item, the name which appears in the Scripts menu. An optional accelerator can be specified, e.g.

  [Name]
  ~Ledger report
  {Ctrl}L

Mnemonics (~) are recognized, so the above would appear with a line under the L in the Options menu.  It is your responsibility to ensure that there are no conflicts in mnemonics.

Accelerators can be any combination of {Ctrl}, {Shift}, or {Alt} strings plus one character. Thus, the above would appear as Ctrl+L beside the 'Ledger report' menu item.  An optional parameter can be used, e.g.

  {Ctrl}L case

which would mean that only an upper-case L would activate the menu item.  It is your reponsibility to ensure that the accelerators you specify do not conflict with any other accelerators in the various menus.

[Title]
contains formatting commands and strings that are to appear at the top of the report.

[Header] 
contains formatting commands and strings that are to appear as column headings in all reports except category reports which use the [Header] section whenever a new category is written to file.  To see what I mean, create a report with the category.fmt format script provided in the archive.

[Footer] 
contains formatting commands and strings that appear at the end of a report except in category reports.  It uses the [Footer] section at the end of each category it writes to file.  See the category.fmt script to see what I mean.  

[Layout] 
contains formatting commands and strings for the actual transactions which are written to file.  Unlike the other sections, this one has specific codes which decide what information in a transaction should be displayed and where.  
prev 7.1.1
next 7.1.3
&
7.1.3
\Rebuild Script Menu
Format scripts contain a section called [Name] in which the name of the script and an optional accelerator are situated.  The name is what appears in the Scripts menu, and, if an accelerator has been specified, it, too, is installed.  If you create a new format script or change the name and/or accelerator of an existing one, use 'Rebuild script menu' to rebuild the script menu items.  
prev 7.1.2
next 7.1.4
xref 7.1.2 Create Script...
&
7.1.4
\Process all (Accounts)
E-Teller Report can now process all of the accounts it finds in the current directory.  Thus, if there are three accounts and you want a report created of all three, select this option (after you've selected a format script).  
prev 7.1.3
next 7.1.5
xref 7.1.5 Select... (Accounts)
xref 7.2 Transactions Report
&
7.1.5
\Select... (Accounts)
If you prefer to create a report of more than one account but not all of those listed in the Accounts menu, then choose this menu item.  Select the accounts from the listbox, and click OK.  Only the accounts which you have selected will be processed.  
prev 7.1.4
next 7.1.6
xref 7.1.4 Process all (Accounts)
xref 7.2 Transactions Report
&
7.1.6
\<Accounts> Item
The accounts which are found when E-Teller Report is first invoked appear in the Accounts menu, and each is provided with an individual numbered mnemonic.  It is important, therefore, to start etreport.exe from the E-Teller directory, or to specify it's working directory if you create an object for it.
prev 7.1.5
next 7.1.7
&
7.1.7
\<Format Scripts> Item
Each format script found when E-Teller Report is first invoked appears in the Scripts menu.  You must select a format script in order to create a report.  All format scripts must reside in a subdirectory called 'Formats'.  If you place them anywhere else, etreport.exe will not find them.

As of version 1.6b of E-Teller Report, any script with a filename default.fmt will be automatically selected when E-Teller Report is started, a useful feature if you habitually use one script to print reports.
prev 7.1.6
next 7.2
&
7.2
\Transactions Report
Unlike the similarly named items in the items in the 'Accounts' menu which deal specifically with accounts, the 'Transactions' menu items are geared specifically to transactions within accounts.
prev 7.1
next 7.2.1
xref 7.1.4 Process all (Accounts)
xref 7.1.5 Select... (Accounts)
&
7.2.1
\Process All (Transactions)
This option generates a report of all the transactions found in both the *.clr and *.ldg account files using the format you've specified.  No transaction masking is performed.
prev 7.2
next 7.2.2
xref 7.2.2 Select... (Transactions)
xref 7.2.3 Categories...
&
7.2.2
\Select... (Transactions)
This option generates a report of transactions which correspond to the field, criterion, and search string you specify for both the *.clr and *.ldg account files.  Any transaction which does not correspond to the case insensitive string is ignored.
prev 7.2.1
next 7.2.3
xref 7.2.1 Process All (Transactions)
xref 7.2.3 Categories...
&
7.2.3
\Categories
This option is unique in that it is geared specifically towards categories.  

When you first click on this menu item, you are shown a list of all categories contained within the category.dat file in addition to an '<All>' and '<Tax>' item.  You can either select specific categories, <All>, or '<Tax>'.  If you select '<All>', all categories to which a transaction is attached will be included in the report.  If you select '<Tax>', then only those categories which are flagged as tax-related will be sent to the report.  In all cases, any transaction which does not have a category attached to it will be ignored in the report.

Use the category.fmt script (or a modification) when creating reports of categories only since the category report groups transactions within their respective category, and the category.fmt script identifies each category once and tabulates the total credits and debits for each category sent to the report - particularly useful for income tax-related transactions.

If a transaction has the '<Multi>' category, and if the 'Multi' parameter for the 'Send' command is included in the script's [Layout] section, then the multiple categories will be included in the report rather than simply the '<Multi>' category.
prev 7.2.2
next 7.3
xref 5.1.6.1 Multiple Categories
&
7.3
\Script Commands
Format scripts use a limited set of commands to determine what should be sent to a report and how what is sent should be formatted.  Most are Rexx commands.

If you frequently use the same script to print reports, then give it the name default.fmt.  If E-Teller Report finds a script with this name, it will automatically select it at startup.

It is recommended that you examine the two scripts which were provided in the archive to get a feel of how to write your own.
prev 7.2
next 7.3.1
&
7.3.1
\CRLF
CRLF

Description:
Sends a CR/LF (newline) to the report at the current write position.

Parameters:
None
prev 7.3
next 7.3.2
&
7.3.2
\DATE
DATE

Description:
Sends a date stamp to the report at the current write position.

Parameters:
None
prev 7.3.1
next 7.3.3
&
7.3.3
\Format
FORMAT

Description:
Specifies format parameters for subsequent calls to TEXT

Parameters:
left|right|{center|centre} <x>

Where:
LEFT
formats the string left <x> characters, appending <x> spaces to the right if the string is shorter than <x> or truncating the string if it is longer.

RIGHT
formats the string right <x> characters, appending <x> spaces to the left if the string is shorter than <x> or truncating the string if it is longer.

CENTER|CENTRE
is used in the [Title], [Header], and [Footer] sections only, and centres the string within a range specified by <x>.
prev 7.3.2
next 7.3.4
xref 7.3.5 Text
xref 7.3.4 Send
&
7.3.4
\Send
SEND

Description:
Sends an unformatted string at the current write position.

Parameters [Title] Section:
  ú "<quoted string>"
  ú Account
  ú Category
  ú Multi
  ú Prompt

Where:
"<quoted string>"
sends the string within quotes to the report at the current write position (internal quotes are ignored)

Account
sends the account name (as it appears in the accounts window) to the report at the current write position

Category
sends the category (if applicable) to the report at the current write position

Multi
sends the multiple category values (one per line).  This parameter is not available in the TEXT command.

Prompt
prompts the user for a string and then sends it to the report at the current write position

Parameters [Header] [Footer] Sections:
  ú "<quoted string>"
  ú Account
  ú Category
  ú Prompt
  ú Balance
  ú CreditBalance
  ú DebitBalance

Where:
Balance
sends a running balance of all credits and debits for each transaction sent.

CreditBalance
sends a running total of all credits for each transaction sent.

DebitBalance
Sends a running total of all debits for each transaction sent.

Parameters [Layout] section only:
  ú Account
  ú Balance
  ú Category
  ú CreditBalance
  ú DebitBalance
  ú Prompt
  ú "<quoted string>"
  ú Credit
  ú Debit
  ú Date
  ú Memo
  ú Number
  ú Particulars

Where:
Credit
sends the value of the transaction if it is none negative, a null string if it is.

Debit
sends the value of the transaction if it is negative, a null string if it is not.

Date
sends the date of the transaction (not to be confused with the DATE command).

Memo
sends the memo for the for the transaction or a null string if there is no memo.

Number
sends the three-digit/character number for the transaction or a null string if there is no number.

Particulars
sends the Pay to.../Details information for the transaction or a null string if there are no particulars.
prev 7.3.3
next 7.3.5
xref 7.3.5 Text
&
7.3.5
\Text
TEXT

Description:
Sends the parameter to the report at the current write position, formatting the string in accordance with the most recent FORMAT command

Parameters:
Identical to those for the SEND command
prev 7.3.4
next 7.3.6
xref 7.3.3 Format
xref 7.3.4 Send
&
7.3.6
\Time
TIME

Description:
Sends a time stamp to the report at the current write position

Parameters:
None
prev 7.3.5
next 8
xref 7.3.2 Date
&
8
\Converting Quicken Data
This section describes how to convert Quicken (c) data to E-Teller format, using the q2et.exe conversion utility.

As of version 1.7 of E-Teller, account files follow a similar format to Quicken QIF files (but not identical).  As a result, converting QIF files is significantly more reliable.
prev 7
next 8.1
&
8.1
\Creating a Quicken QIF File
To convert a Quicken (c) data file into QIF format, follow these steps:

1) Start Quicken
2) Open the account register you want to convert.
3) Select 'Export' from the Print menu.
4) Enter a filename for the exported data.
5) In the Export window, ENSURE THAT *ONLY* THE 'Export Transactions' IS SET TO YES.  All other options MUST be set to NO!
6) Ensure that the date range encompasses all of the account transactions.  
7) Select "Continue".
prev 8
next 8.2
&
8.2
\Converting a Quicken QIF File
Converting a Quicken (c) QIF file to E-Teller format is a completely automated 
process, unless a syntax error is detected.

To convert a Quicken (c) QIF file to E-Teller format, follow these steps:  

1) Select File | Import Quicken file... (Ctrl-I)
2) Select the newly created export QIF file.
3) Once the data has been read, Q2ET will automatically verify the syntax.  If an error is detected, q2et will start epm.exe and display the line number beneath the 'Message' text where the error has occurred along with some kind of indication of what the error is.  Use the line number and the status display in EPM to find the line and correct the error.  Once corrected, save and close the file and select the 'Verify syntax' item in the 'File' menu.
4) Once the syntax has been verified and the q.tmp file found to be error free, q2et will automatically display the New Account window.  Enter the relevant data which is not supplied in the QIF file, e.g. account number, and/or make any appropriate changes.
5) Click OK.

NB: It is *strongly* recommended that you not alter the starting balance for a newly created account file from a QIF file.  The number displayed is, in fact, a total of all the cleared transactions which were found in the QIF file and which will be save to the .CLR file.
prev 8.1
next 8.3 
xref 8.1 Creating a Quicken QIF File 
& 
8.3 
\QIF File Format 
Quicken (c) QIF files generally follow these conventions:  

  !Type:Bank 
  D 1/ 1/94 
  T1,000.00 
  CX 
  POpening Balance 
  L[chequing] 
  ^ 
  D12/19/93
  N123
  T-700.00 
  CX
  PJohn Doe 
  Mfirst and last 
  LRent 
  ^ 
  D01/01/94
  NATM
  T-130.00
  PWithdrawal
  LGroceries
  SGroceries
  $-100.00
  SPersonal
  $-30.00
  ...

Where:
!Type 
can be 'Bank', 'CCard', or any other type of account.  E-Teller uses only two types, 'Bank' and 'CreditCard'.  Q2ET will attempt to identify the account type.  If it is not one of 'Bank' or 'CCard', Q2ET will inform you and default to 'Bank'.

D 
is the prefix identifying the date

T 
is the prefix identifying the total

C 
is the prefix identifying a cleared transaction.  If the transaction has not been cleared, this line will be omitted in the QIF file.

N 
is the prefix identifying the cheque or code number.  If the transaction has not been cleared, this line will be omitted in the QIF file.

P 
is the prefix identifying the particulars.  If the transaction has not been cleared, this line will be omitted in the QIF file.

M 
is the prefix identifying the memo.  If the transaction has not been cleared, this line will be omitted in the QIF file.

L 
is the prefix identifying the category.  If the transaction has not been cleared, this line will be omitted in the QIF file.  Q2ET takes the value of the first transaction as the account name.

S
is the prefix identifying a split category.  If the transaction does not have a split category, then neither will the S... nor the $... lines be included in the QIF file.

$
is the prefix identifying the amount of a split category.

^ 
is the transaction separator.
prev 8.2
next 8.4
&
8.4
\Language Other than English
If your copy of Quicken does not utilize the format outlined above for language reasons or whatever, send me a dummy transaction like the one displayed above (opening balance entry + one entry with *all* the fields filled in) and I'll send you a uuencoded language-dependent copy of Q2ET.
prev 8.3
next 9
&
9
\Setting Colours/Fonts
In versions earlier than 1.6 of E-Teller, it was possible to set the foreground colour of the accounts and ledger containers by using a secondary window.  In emending E-Teller for 1.6, I tried to make it as compact as it could possibly be.  As a result, certain frills had to be trimmed or excised.  I'm afraid the Set Colours window was one of those frills.  In other words, only the background colour of the accounts and ledger containers can be changed.  To do so, drag a colour from the System Color Palette to the container.  

The selection for the accounts window is saved automatically when you close E-Teller.  This is not the case with the ledger window for various reasons.  To save the new colour setting, you must explicilty instruct E-Teller to save the setting to e-teller.ini by clicking on the 'Save settings' item in the 'Display' menu.

To change the font of the accounts container, drag a font selection from the System Font Palette on to the container.  The new font selection is saved automatically when you close E-Teller.

Because the ledger container is in detail view, it is unable to recognize a font selection dragged on to it.  Because of this, a workaround has been implemented.  To change the font, first click on the 'Set ledger font' item in the 'Display' menu.  Above the progress bar will appear "Drag font here.  Click 'Set ledger font'."  Drag the font selection to this area of the window and click on the 'Set ledger font' (which will have a checkmark next to it).  You will then be asked if you want to save the font selection.  Selecting 'Save' saves both the font and the background colour.  'Cancel' abandons the selection.
prev 8.4
next 14
&
14
\DAT Files
No more than 5 files with an extension .dat will reside in E-Teller's directory at any one time.

Two are reserved for ET_Month's exclusive use, et_fix.dat and et_fixed.dat, whereas the other three are used by E-Teller when crediting and debiting accounts, and one of those three is used by E-Teller Report.  These are:

  ú number.dat
  ú info.dat
  ú category.dat

Both number.dat and info.dat have four sections:

  ú [Credit]
  ú [Debit]
  ú [Payment]
  ú [Charge]

Where:
[Credit]
contains items for bank account credits

[Debit] 
contains items for bank account debits

[Payment] 
contains items for credit card account payments

[Charge] 
contains items for credit card account charges

NB: these section headings are case sensitive

Category.dat contains, simply, a list of all categories you've defined.
prev 9
next 14.1
xref 14.1 Deleting DAT File Items
&
14.1
\Deleting DAT File Items
To delete items from number.dat, info.dat, and category.dat, right-click on the number, payee / details, and category fields respectively.

In the secondary listbox will appear the contents of the appropriate file.  Select the item(s) you wish to delete, and click the 'Delete' button.  To make the changes permanent, click 'OK'.  To abandon the changes, click 'Cancel'
&
prev 14
next 10
&
10
\Known Bugs/Limitations
There is a confirmed bug with the VX-Rexx dll 2.0a whereby the routine which should be triggered after a direct edit has been registered (Ctrl+left-click) is not.  As a result, E-Teller has no way of knowing (as it did in the past) what has been edited and when the editing has been completed.  So, where, before, I could call on the recalculation routine to recalculate the running balance if a credit or debit had been edited, I can't with 2.0a.  You can, however, force a recalculation by clicking on Transactions | Recalculate in the ledger window.

There is also a bug in dragging a record to the system shredder, one which results in an access violation.  Because of this, I have had to disable dragging to the shredder.
prev 9
next 11
xref 3.7 Deleting an Account
xref 5.2 Deleting Transactions
xref 6.3 Weekday Transactions
xref 12 Warranty
&
11
\Registration
This product is released as Shareware.  You are granted permission to use E-Teller for a period not exceeding 30 days for evaluation purposes only.  If you decide to continue using E-Teller, you are required to register the program by sending a one-time registration fee of $25 US ($30 CAN) to:  

   Paul H. Caron
   c/o Mr.  J-P Caron
   A10-420 Westmount Avenue
   Sudbury, Ontario
   P3A 5V4 
   CANADA

Previously, upgrades to major releases of E-Teller required additional payments.  As of version 1.7, this is no longer the case.  Your registration fee is a one-time payment which covers all subsequent releases of E-Teller.  Current registered users are not required to make any further payments.  As a result of this change the registration cost for E-Teller has risen by $5, which is still a reasonable fee, I think.

You are encouraged to distribute E-Teller as long as you maintain the integrity of the original archive and do not distribute any of the programs contained therein separately as individual applications.  You may omit VROBJ.DLL *on condition* that you provide clear instructions on where a potential downloader may find the latest version of the DLL, and that you make it clear that the DLL is required.  You are not permitted to charge a fee for the use of E-Teller.  You are permitted to charge a small fee for distributing E-Teller, as long as that fee is to cover media and handling costs and that it does not exceed $5 US.
prev 10
next 11.1
xref 11.1 How Do I Register?
&
11.1
\How Do I Register?
To register E-Teller, fill out the 'register.txt' form provided in the archive and send it along with your cheque or money order.

Once I've received the registration fee, I will e-mail you your registration number.  Select the 'Product information' item from the 'Help' menu in the accounts window, and click on the 'Register' button.  Enter the registration number provided into the entry field, and click 'OK'.
prev 11
next 12
xref 11 Registration
&
12
\Warranty
E-Teller and its accompanying software and documentation is supplied with no warranty whatsoever either expressed or implied.  Neither its author nor Watcom International can be held directly or indirectly responsible for any loss or damage to your data or system caused by the use or misuse of E-Teller.  All software and documentation is supplied AS IS.  

If you use this program, you understand that you do so AT YOUR OWN RISK.  
prev 11
next 13
&
13
\Copyright Notices

   E-Teller (c) 1994 Paul H. Caron
   VX-Rexx (c) Watcom International
   OS/2 (c) IBM
   Quicken (c) Intuit
prev 12
next 1
&
15
\Contacting the Author
If you find a bug or have suggestions for improvements I can be reached at

   G9026163@mcmail.cis.McMasterCA

(at least for the next little while)
&
16
\Future Plans
Unless there are any glaring omissions in E-Teller or bugs, E-Teller will remain as it is for the next little while.  E-Teller Report, on the other hand, will be revised.

I realize that, in its current incarnation, E-Teller Report is still rather limited and, perhaps, a little too complicated.  I hope to expand its functionality and increase its ease of use in subsequent releases.  If anyone has any brilliant ideas, please, make them known.  Bear in mind, however, that I would like the report feature to remain as versatile and as user-configurable as possible.
&
