iCreateOFX Basic - Extended functionality - Generic Scripts.

Generic At the bottom of the Bank Script Stack are two buttons named Generic Scripts and Other Banks. We have discussed the latter (Other Banks' Button) above, and now for a word or two to be said about the Generic Scripts.

Of note here is that if your bank is not listed under the Other Banks button, it may be that the format of your file falls within the generic layouts that are included in the software. To ascertain this, you will have to inspect the structure of your file to see if it equates to these layouts. Below is a brief description of each of the Generic layouts.

Generic Three Column: This consists of the 'Date' in the first column, followed by the 'Description' and finally the 'Amount'.

Generic Four Column: This consists of the 'Date' in the first column, followed by the 'Description' which is then followed by the 'Debit Amount' and finally the 'Credit Amount'.

Generic Five Column: The only addition to this is an extra text column for 'Details / MEMO'.

iCreateOFX CSV: Begining with Version 2, you can save any file loaded into the grid to CSV. The layout is as follows: Date, Details, MEMO, Transaction ID, Amount

NOTE: The order in which notation of Debit or Credit is not critical, however care should be taken NOT to classify a BALANCE column as an Amount column. Additionally, these scripts assume that the file is delimited by a comma AND NOT qualified by double quotes ("").

Sign up for PayPal and start accepting credit card payments instantly.
Fully Functional (FX Functionality)
No Payment details required for trial
No registration required for trial
User Guide Sections
1. The License
2. Loading CSV File
3. The Statement dialog
4. The Grid
5. Writing OFX File
6. Adding Banks
7. Submit header
8. Header Layout
9. Generic Scripts
Validation

Video Guides
Convert OFX to CSV
Submit Header

Useful Links
Pocket Smith
Clarity Accounting
Microsoft Dynamics
Quickbooks
Mint.com

Resources
Microsoft Money (Sunset Edition - US)
Office Accounting Express 2009 (GB)
Office Accounting Express 2009 (US)
Office Accounting 2009 SP1
Office Accounting 2009 SP2
Office Accounting 2009 SP3
All trademarks and registered trademarks are the property of their respective owners.
Please refer to licence for usage rights. Copyright © 2007 - 2010