Tutorial - Part I
Below I describe how to use OfxGen to import debits and credits from a site and then create an OFX file that can be imported by Money, Quicken, etc...
- With your web browser opened at the page where you can see the debits and credits, select
them by dragging the mouse from the first debit/credit up to the last one, you want to import.
Try now with the following debits and credits:
Day Comment Value C/D Comment Jun,29 Paycheck 123.00 D Any comment... Jun,30 Order 12 99.00 C Jul,03 Order 345 9.00 C Another comment Day Comment Value C/D Comment Jul,03 Paycheck2 113.00 D Any comment... Jul,04 Order 13 919.00 C Jul,10 Order 445 35.00 C Another comment
- With the selection made, copy it to the clipboard. You do this by typing "CTRL+INSERT" or
"CTRL+C" or clicking on the menu option "Edit->Copy" or "Right Click" the selection and click on Copy.
Now that you have all debits and credits saved in the Clipboard, you may close your browser if you wish.
(OfxGen works ONLY with the data saved in the clipboard)
- Execute OfxGen and click Edit->Options and check "Point" or "Comma" depending on which one
represents the decimal point. Also choose if currency is "US Dollars" or "Real" (Brazil).
Only need to be done once, the program will "remember" your last choice.
- Now click on Edit->Paste HTML.
- If you see all your data inside only one column or you got different information inside the same column
this is NOT good. Try Edit->Paste text..., and then choose "Fixed" to define where each column
- The objective is to have each data in it's own column. Now is time to set the type of each
column by clicking on the column header.
- A column type can not repeat, except for Ignore and Comment which are ignored or concatenated.
- For example, you CAN NOT set two columns DAY or VALUE, but you can set three columns as COMMENT.
- Click on the word "Ignore" of the date's column. Now click on "Date" and a list of date formats is shown.
Unfortunately, none of the pre-defined date format is the one we need.
- Click on the menu option Edit->Options and define your Date as MMM,dd.
In the edit box "Column", type Nov,29 and press TEST.
The program will show you a line with Day=29, Month=11.
Date formats vary depending on your Windows "Regional Settings" (Control Panel)
- Now with date format defined, go back and set the date's column with Date->Date User
- Set other columns as Comment, Value, C/D and Comment
Page 1 - Page 2