iCreateOFX Convert CSV files to OFX
Convert QFX & QBO files to OFX (QFX, QBO Reader)
Convert QIF files to OFX (QIF Reader)



iCreateOFX PayPal API   Convert PayPal transactions to OFX, QBO and QIF FILES via API.

NEW Now Available in Windows Store for Windows 10 PC's

Download PayPal API Download
  1. Convert PayPal Premier transactions to OFX, QBO and QIF files.
  2. Convert PayPal Business transactions to OFX, QBO and QIF files.
  3. This script is also available in iCreateOFX Basic during the 30 day trial and for business licensees thereafter.
The program interface contains seven (7) main areas

PayPal API Main screen
  1. PayPal Direct OFX and QIF Converter
    The Account: This is the PayPal account you wish to download transactions for. You can have multiple accounts setup via the Account Settings dialog (see secondary image).
    1. Account Alias: Select an alias to associate with the account. The alias will be used as the account number in the resultant OFX and QIF files.
    2. API User-name, Password and Signature: Obtain these values from your PayPal Premier and / or business account. For instructions on how to obtain these details see our API Guide. (Not available for personal accounts)
  2. Start and End Dates: Select the timespan for which you want to download transactions for. By default, the start date will be set to 30 days from the date when the program is started. All transactions will be automatically archived for that date range, however, if the same date range is selected again, all transactions available at PayPal will be re-downloaded.
  3. The Memo and Payee Values: These are the details that are included in the QIF and OFX files for the Memo and Payee fields. The Default option is recommended, however, if you require additional / other values, selecting these will ensure they are included. NOTE: for OFX files, the Payee field is limited to 32 characters and thus if you select a value that exceeds this length, it will be truncated.
  4. The Balances:
    1. The Ledger Balance: This represents the total balance in the PayPal account's primary currency.
    2. Currency Balances: If you hold multiple currencies in your PayPal account, these will be listed here in addition to the PayPal FX rate to your primary balance. NOTE: The FX rates are as supplied by PayPal, however, they are merely an estimation of the balance transfer rate and lack precision. You can adjust the rates if your ledger balance is not accurate.
  5. Transaction fees setting: Select an option from here to determine the treatment of PayPal fee(s) in the OFX and QIF file. the first option will include the fee(s) as a separate transaction, the second option will NOT include any fee(s), while the last option will deduct the fees from the transaction amount.
  6. Save to OFX, QBO and QIF: This is the area to save your files from. If your computer has a file association to either file format, then selecting the Auto Start option next to the respective button before saving will invoke the associated program once the file has been written. If the Auto Start option is not enabled, then the program could not find any associated program to the respective file type.
    1. Save OFX and Save QBO: Before you save to OFX files, you can select which OFX version to write the file (that your PFM supports). As a general guide, older PFM's and some with loosely implemented parsers support version 1.02, while others only SGML type OFX of version 1.02 (e.g SplashMoney). The pProgram defaults to version 2.02. In order to save to QBO, press the F3 button. Press again to toggle back to saving to OFX. Note: No support is provided for QBO file saving.
    2. Save QIF no versioning is available for QIF format, simply save to desired file name when prompted.
  7. Connect: This will connect to PayPal to retrieve the transactions between the date ranges set in the start and end date(s).
Download PayPal API Download



Get it on Windows 10

All trademarks and registered trademarks are the property of their respective owners.
Please refer to License for usage rights. Copyright © Phillip Katete 2007 - 2017