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

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 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, personal finance app Mint, the small business accounting program QuickBooks, the credit monitoring 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.

<span class="mw-page-title-main">XBRL</span> Exchange format for business information

XBRL is a freely available and global framework for exchanging business information. XBRL allows the expression of semantic meaning commonly required in business reporting. The standard was originally based on XML, but now additionally supports reports in JSON and CSV formats, as well as the original XML-based syntax. XBRL is also increasingly used in its Inline XBRL variant, which embeds XBRL tags into an HTML document. One common use of XBRL is the exchange of financial information, such as in a company's annual financial report. The XBRL standard is developed and published by XBRL International, Inc. (XII).

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.

A chemical file format is a type of data file which is used specifically for depicting molecular data. One of the most widely used is the chemical table file format, which is similar to Structure Data Format (SDF) files. They are text files that represent multiple chemical structure records and associated data fields. The XYZ file format is a simple format that usually gives the number of atoms in the first line, a comment on the second, followed by a number of lines with atomic symbols and cartesian coordinates. The Protein Data Bank Format is commonly used for proteins but is also used for other types of molecules. There are many other types which are detailed below. Various software systems are available to convert from one format to another.

<span class="mw-page-title-main">TurboTax</span> US tax preparation software

TurboTax is a software package for preparation of American income tax returns, produced by Intuit. TurboTax is a market leader in its product segment, competing with H&R Block Tax Software and TaxAct. TurboTax was developed by Michael A. Chipman of Chipsoft in 1984 and was sold to Intuit in 1993.

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.

QuickBooks is an accounting software package developed and marketed by Intuit. First introduced in 1992, QuickBooks products are geared mainly toward small and medium-sized businesses and offer on-premises accounting applications as well as cloud-based versions that accept business payments, manage and pay bills, and payroll functions.

A Web Map Service (WMS) is a standard protocol developed by the Open Geospatial Consortium in 1999 for serving georeferenced map images over the Internet. These images are typically produced by a map server from data provided by a GIS database.

Financial Navigator, Inc is 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, is 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.

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.[ dead link ]
  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
  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
  6. https://financialdataexchange.org/common/Uploaded%20files/OFX%20files/OFX%20Banking%20Specification%20v2.3.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.