Microsoft Cash Sundown Version imports OFX, QIF information. It additionally imports QBO and QFX information. There are some variations between QIF and OFX import (see under), however general both QIF or OFX are tremendous to make use of for import.
Use the Transactions app to transform your transaction information to required by your accounting software program file format.
Convert to the OFX format
OFX information are Open Monetary Alternate information. This can be a most popular format for Xero as transactions are introduced solely in a method.
Convert CSV, Excel (XLS, XLSX), TXT, PDF, QBO, QFX, OFX, QIF, MT940 information to the OFX format: Bank2OFX
Convert CSV, Excel (XLS, XLSX), TXT, information to the OFX format: CSV2OFX
Convert PDF information to the OFX format: PDF2OFX
OFX format has the transaction ID (reference ID) when QIF doesn’t. Reference ID (when equipped by your financial institution) means that you can skip already imported transactions.
ProperSoft converters assist reference ID and if not equipped, generate it to be distinctive to ensure the import for all transactions.
OFX information must be created in another way for various software program (Microsoft Cash for Us, non-US, previous Microsoft Cash 99, 2000, and likewise different software program like Sage).
Convert to the QIF format
QIF format supported by Xero. Ensure that to make use of the anticipated date format (primarily based in your nation settings). If you use 2QIF converter, choose QIF goal as "MS Cash or different" and set the anticipated output date format:
Convert CSV/Excel/TXT, PDF, OFX, QIF, QFX, QBO, MT940 information to the QIF format: Bank2QIF
Convert CSV/Excel/TXT information to the QIF format: CSV2QIF
Convert PDF information to the QIF format: PDF2QIF
QIF import considerably higher when utilizing “Get better accounts” as a substitute of “Downloaded statements”.
Find out how to Import QBO and QFX information
QBO and QFX information are prolonged OFX information. As MS Cash follows the OFX specification, it ought to import QBO and QFX information as OFX information. To import a QFX or QBO file, strive the next in MS Cash:
begin MS Cash and choose File-Import-Downloaded Assertion
choose All information on the file dialog
choose a QBO or QFX file