Open Financial Exchange

Last updated
Open Financial Exchange
Filename extension
.ofx
Internet media type application/x-ofx
Developed by Microsoft, Intuit and CheckFree
Initial releaseFebruary 14, 1997 [1]
Latest release
2.3 [2]
Container for Financial information
Extended from SGML, XML, OFC
Extended to QFX

Open Financial Exchange (OFX) is a data-stream format for exchanging financial information that evolved from Microsoft's Open Financial Connectivity (OFC) and Intuit's Open Exchange file formats. [3]

Contents

History

Microsoft, Intuit and CheckFree announced the OFX standard on 16 January 1997. The first OFX specification, version 1.0, was released on 14 February 1997. [3] The specification allows for bank- and application-specific extensions, although only a subset is necessary to describe a financial transaction.

Versions 1.0 through 1.6 relied on SGML for data exchange, but later versions are XML based. According to the main OFX site, "The specification is freely licensed, allowing any software developer to design an interface that will be supported on the front-end."[ citation needed ]

In 2019, OFX's consortium joined Financial Data Exchange (FDX) consortium, [4] [5] that manage nowadays OFX working group. [5]

Specification

The latest reference document (Functional Specification) describing the standard was published in October 2020, in version 2.3, by the FDX consortium's OFX working group. [6]

Support in various countries

Many banks in the US let customers use personal financial management software to automatically download their bank statements in OFX format, but most Canadian, [7] [8] [9] United Kingdom and Australian banks do not allow this, however, many banks do support downloading financial data in OFX, QFX, QIF, or spreadsheet format via their web interface for later import into financial software.

Intuit and QFX

QFX is a proprietary variant of OFX used in Intuit's products. In Intuit products, OFX is used for Direct Connect and QFX for Web Connect. Direct Connect allows personal financial management software to connect directly to a bank OFX server, whereas in Web Connect, the user needs to log in and manually download a .qfx file and import it into Quicken. [10]

See also

Related Research Articles

<span class="mw-page-title-main">GnuCash</span> Personal and small-business financial-accounting software

GnuCash is an accounting program that implements a double-entry bookkeeping system. It was initially aimed at developing capabilities similar to Intuit, Inc.'s Quicken application, but also has features for small business accounting. Recent development has been focused on adapting to modern desktop support-library requirements.

X3D is a set of royalty-free ISO/IEC standards for declaratively representing 3D computer graphics. X3D includes multiple graphics file formats, programming-language API definitions, and run-time specifications for both delivery and integration of interactive network-capable 3D data. X3D version 4.0 has been approved by Web3D Consortium, and is under final review by ISO/IEC as a revised International Standard (IS).

Quicken Interchange Format (QIF) is an open specification for reading and writing financial data to media.

<span class="mw-page-title-main">Intuit</span> American financial software company

Intuit Inc. is an American multinational business software company that specializes in financial software. The company is headquartered in Mountain View, California, and the CEO is Sasan Goodarzi. Intuit's products include the tax preparation application TurboTax, the small business accounting program QuickBooks, the credit monitoring and personal accounting service Credit Karma, and email marketing platform Mailchimp. As of 2019, more than 95% of its revenues and earnings come from its activities within the United States.

FinTS, formerly known as HBCI, is a bank-independent protocol for online banking, developed and used by German banks.

<span class="mw-page-title-main">Microsoft Money</span> Personal finance management software program

Microsoft Money is a discontinued personal finance management software program by Microsoft. It has capabilities for viewing bank account balances, creating budgets, and tracking expenses, among other features. Designed for computers using the Microsoft Windows operating system, versions for Windows Mobile were also released. From its inception in 1991 until 2009, Microsoft Money was commercial software; in 2010, Microsoft Money Plus Sunset was released as a free replacement, which allows users to open and edit Money data files but lacks any online features or support.

COLLADA is an interchange file format for interactive 3D applications. It is managed by the nonprofit technology consortium, the Khronos Group, and has been adopted by ISO as a publicly available specification, ISO/PAS 17506.

Quicken is a personal finance management application originally developed and offered by Intuit, Inc. Intuit sold Quicken to H.I.G. Capital in 2016, and H.I.G. sold Quicken to Aquiline Capital Partners in 2021.

Financial Navigator, Inc was a United States-based software company that develops accounting software targeting single family offices (SFO), multi-family offices (MFO), accounting firms, and high-net-worth individuals. The company was founded in 1983 and is headquartered in Mountain View, CA.

<span class="mw-page-title-main">KMyMoney</span> Accounting software

KMyMoney is a cross-platform double-entry bookkeeping system for personal finance management built on KDE technologies. Its operation is similar to Microsoft Money and Quicken. It supports different account types, categorization of expenses and incomes, reconciliation of bank accounts and import/export to the “QIF” file format. Through plugins, direct download using the OFX and HBCI formats is also possible. CSV imports and exports are also possible via plugins.

QFX may refer to:

Mint, also known as Intuit Mint and formerly known as Mint.com, was a personal financial management website and mobile app for the US and Canada produced by Intuit, Inc..

QFX is Intuit's proprietary version of the standard OFX financial interchange file format. QFX is used in Intuit's "Web Connect" and "Direct Connect" features to transmit and receive financial information over the internet.

Moneyspire is personal finance software and small business accounting software developed by Moneyspire Inc. The software is available in two versions, one for Windows and another for macOS. The software tracks accounts, loans, bills, investments and budgets. Professional looking invoices can also be created and tracked in the Pro edition of Moneyspire. It imports data from QIF, OFX, QFX and CSV files. Moneyspire has the ability to use its financial data files interchangeably between the Mac and Windows versions of the software, thus making the software a viable choice for people who use both PCs and Macs. Moneyspire can also manage accounts from multiple currencies, and automatically track exchange rates and transfers between foreign accounts. Moneyspire also allows downloading of transactions directly from financial institutions via the Moneyspire Connect service.

WorkingPoint is a web-based application providing a suite of small business management tools. It is designed to offer a single point-of-access for all business management needs while offering a user-friendly interface. WorkingPoint’s functionalities include double-entry bookkeeping, contact management, inventory management, invoicing and bill & expense management.

<span class="mw-page-title-main">Requirements Interchange Format</span>

RIF/ReqIF is an XML file format that can be used to exchange requirements, along with its associated metadata, between software tools from different vendors. The requirements exchange format also defines a workflow for transmitting the status of requirements between partners. Although developed in the automotive industry, ReqIF is suitable for lossless exchange of requirements in any industry.

<span class="mw-page-title-main">ODB++</span> Proprietary CAD-to-CAM data exchange format

ODB++ is a proprietary CAD-to-CAM data exchange format used in the design and manufacture of electronic devices. Its purpose is to exchange printed circuit board design information between design and manufacturing and between design tools from different EDA/ECAD vendors. It was originally developed by Valor Computerized Systems, Ltd. as the job description format for their CAM system.

Personal financial management refers to "ways" or "methods" of managing ones own personal finances. It is also known by its acronym, PFM, which refers to the type of software used for personal finance apps. Simply put, PFM refers to software that helps users manage their money. PFM often lets users categorize transactions and add accounts from multiple institutions into a single view. PFM also typically includes data visualizations such as spending trends, budgets and net worth.

References

  1. "Open Financial Exchange FAQ" . Retrieved October 22, 2020.
  2. "OFX.net".[ dead link ]
  3. 1 2 "OFX Work Group - FAQ's". Financial Data Exchange. Retrieved 2023-03-13.
  4. https://financialdataexchange.org/images/Abouts/Evolution-of-Open-Financial-Exchange-image-11.png [ bare URL image file ]
  5. 1 2 https://financialdataexchange.org/FDX/About/About-FDX.aspx?WebsiteKey=deae9d6d-1a7a-457b-a678-8a5517f8a474&hkey=dffb9a93-fc7d-4f65-840c-f2cfbe7fe8a6&a315d1c24e44=5#a315d1c24e44 [ bare URL ]
  6. https://financialdataexchange.org/common/Uploaded%20files/OFX%20files/OFX%20Banking%20Specification%20v2.3.pdf [ bare URL PDF ]
  7. Reiser, David (11 March 2009). "Re: ofx info for scotiabank in canada?". gnucash-user (Mailing list). Retrieved 16 January 2012. It appears the bank regulators have struck. http://faq.quickensoftware.ca/detail.php?buid=QK&qbid=QK1054 indicates that Online Banking Booster (the Intuit name for DirectConnect in Canada) was discontinued for all Canadian banks at the end of October 2008. The banks have apparently all added additional security questions at login that Quicken can't handle, so Intuit just bailed. In the US, Intuit has pushed the use of an additional token (CLIENTUID) as suitable for satisfying regulator's insistence on multifactor authentication. It remains to be seen how well that rolls out.{{cite mailing list}}: External link in |quote= (help)
  8. "Online Banking Booster (OLBB) was discontinued on October 31, 2008. How does this affect me?". Quicken Support. Intuit Canada. 27 May 2011. Retrieved 16 January 2012.
  9. Selhi, Bylo (18 December 2007). "Re: Alternatives to Quicken". Financial Wisdom Forum » Under the Mattress: Protecting Your Money. Post 227689. Retrieved 9 January 2017.
  10. "Connectivity Types - OFX". Intuit. Retrieved 12 March 2023.