Tutorial - Part II
- You can leave a column as Ignore or delete it by clicking on the column header and selecting Delete column.
The only difference is visual.
- Eventualy, you will want to delete repeated lines that appear in your data, like title rows in our example.
With our example loaded, click on one of the title rows ("Date" "Comment" ...) selecting it.
Click the header's column and choose the option "Del columns=Date". Both title rows are deleted.
- The check boxes in the first column are used to delete specific unwanted lines, like title and trailer
lines. After checking the rows, click on the header's column and choose to delete the
checked or the not checked rows.
- Now that all columns are defined and you DO NOT have any extra lines,
click on File->Export
Year is an essential info for OFX format. In our example there is no year,
so OfxGen will display a dialog box asking you to confirm the data extracted.
If debits and credits are in order, like in our example, you can check the option "guess" next date
based on this one. With this option on, the program will stop asking you for the dates.
- Finally, the program will ask you for a BankId, Account Id and the final balance.
- The BankId and Account Id are used by Money/Quicken to associate the ofx file
to one of your Money Account, so next time you create a ofx file for that account,
use same numbers or Money will ask you again.
- Save the ofx file and import it with your Application!
- Other table formats OfxGen can handle:
Example 1 Example 2 Day Comment Value Balance 100.00 29 Paycheck 123 123.00- -23.00 29 Order from John 99.00 76.00 30 Paycheck 124 21.10- 54.90 01 Order from Mary 9.00 63.90 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 Jul,03;Paycheck2;113.00;D;Any comment... Jul,04;Order 13;919.00;C Jul,10;Order 445;35.00;C;Another comment
Example 3
Dia CC Histórico ReferValor Unidade C/D Credito/Debito Saldo R$ SALDO MES ANTERIOR 31.215,67 03 1 CONSERTO DE BOMBAS Jun/2006 BOMBAS D 283,91 30.931,76 03 1 I.S.S. Jun/2006 D 13,65 30.918,11 03 1 C P M F Jun/2006 D 61,54 30.856,57 04 1 INSS Jun/2006 D 1.618,30 29.238,27 05 1 INSS TERCEIRIZADO Jun/2006 TRATAM.DE AGUAS LTDA D 31,68 29.206,59 05 1 TV A CABO Jul/2006 NET RIO D 148,32 29.058,27 06 1 CONDOMINIO Jul/2006 201 C 800,00 29.858,27
Page 1 - Page 2