XS Finance

Introduction

Installing XS Finance

Launching XS Finance

Using for the first time

Navigation & Basics

Creating a new account

Logging in & out

Managing your accounts

Managing transactions

Scheduled transactions

Budgets

Managing categories

Import &  Export

Charts &  Reporting

Reconcile Accounts

Configuring XS Finance

Registering XS Finance

www.xcitesoftware.com

 

Import & Export

Import & Export

XS Finance supports both importing and exporting data. 

The data can be imported from QIF files and exported in either QIF or CSV formats. To do this, simply select the Import/Export icon from the slider, the import and export window will then be opened.  

QIF Files

 The Quicken interchange format (QIF) is a specially formatted text (ASCII) file that lets you to move Quicken type transactions.

CSV Files 

Comma Separated Values - A text format often used when importing data into spreadsheets.


XS Finance 2.0 will ignore duplicate transactions should they exist in your CSV or QIF file

Import

 You can import QIF data files into XS Finance. To do this, simply select the Import/Export icon from the slider, the import and export window will then be opened, then select the Import menu option.  

  1. Select the Import file. The files shown will be in the IMPORT folder in your installation tree.

  2. Select the Account drop list and select the account that you wish to import the QIF data into.

  3. Check the Transactions field if you require the transactions to be imported

  4. Check the Categories field if you require the categories to be imported

  5. Check the Account List field if you require the accounts to be created.

  6. Check the US Dates field if the QIF dates are in US format.

  7. Finally select the Import button to proceed with the import. 

On completion you will be shown a screen with the number of transactions, categories and accounts imported.

Import Errors

If during import errors are found, the transaction is usually skipped. The completion screen at the end of the import will list all errors XS Finance encountered and the line number the error was on so that this can be fixed.

Export

It is recommended that you frequently use XS Finances’ export facility to backup your important data.

XS Finance allows you export in two different formats, QIF and CSV ( comma separated values). Both have their own advantages depending on the destination of the exported data, but if you intend to import the data back into XS Finance at a later date, please select QIF as your export format. CSV does not contain complete account, category or transaction information, only the basic transaction information and is not currently a supported import type. 

Select the Import/Export icon from the slider, the import and export window will then be opened, then select the Export menu option to open the Export window.

  1. Type a Account name. This will be the name of the file stored in your EXPORT  folder in your installation tree after the export is successfully completed.

  2. Select the Account drop list and select the account that you wish to export.

  3. Check the Transactions field if you require the transactions to be exported - QIF only

  4. Check the Categories field if you require the categories to be exported - QIF only

  5. Check the US Dates field if the dates are to be exported in US format

  6. Select the Start Date and End date fields to set the date range for transaction export.

  7. Select either QIF or the CSV field to select the desired export format. 
    QIF is useful when importing to XS Finance or another application, and CSV  is useful when importing into a spreadsheet application

.