Import and Export

If you already have financial data stored in another application, such as Excel or Sheets, you can save time re-entering the data into Cash Flow Companion by using the import feature. Similary, if you want to view the data you’ve entered into Cash Flow Companion in another application, you can use the export feature and open the file in the application.


Date Format

To import dates correctly, the import process must know the date representation used by the original data. The date format provided should match the format used by the imported file to ensure the dates are correctly imported. Date Format is a string describing which parts correspond to which date component. The following lists the available format characters and some examples below.

Character Description
y Year, e.g. 12 or 2012.
M Month in year.
d Day in month.
h Hour of day, 1-12
H Hour of day, 0-23
m Minute in hour, 0-59
s Second in minute, 0-59
E Day in week
a AM / PM marker
Z Time Zone

Date Example Date Format
Wednesday, May 1, 2019 EEEE, MMM d, yyyy
05-01-2019 05:58 MM-dd-yyyy HH:mm
May 1, 5:58 AM MMM d, h:mm a
Wed, 1 May 2019 05:58:40 E, d MMM yyyy HH:mm:ss
2019-05-01T05:58:40+0000 yyyy-MM-dd'T'HH:mm:ssZ
05:58:40.717 HH:mm:ss.SSS


Import Income and Expenses

When importing income and expenses, the following fields will be processed: name, account, amount, type, date, notes and repeats. Double check the fields have the correct spelling. If any are excluded or spelt incorrectly, default values will be used.

The amount should be positive to indicate income, or negative to indicate an expense.

See the sample files below:

To import income and expenses, follow the steps below.

  1. Prepare your file for importing, as detailed above
  2. Open the Options menu
  3. Tap Import & Export
  4. Under Import, tap Income & Expenses
  5. Choose the Format. Either CSV, XML or JSON
  6. Enter the Date Format corresponding with your file
  7. Select the Account to import the data into
  8. Tap Import
  9. Locate the file and select it to import


Import Transfers

When importing transfers, the following fields will be processed: name, from, to, amount, type, date, notes and repeats. Double check the fields have the correct spelling. If any are excluded or spelt incorrectly, default values will be used.

The amount should not be negative.

See the sample files below:

To import transfers, follow the steps below.

  1. Prepare your file for importing, as detailed above
  2. Open the Options menu
  3. Tap Import & Export
  4. Under Import, tap Transfers
  5. Choose the Format. Either CSV, XML or JSON
  6. Enter the Date Format corresponding with your file
  7. Tap Import
  8. Locate the file and select it to import


Import Accounts

When importing accounts, the following fields will be processed: name. Double check the field has the correct spelling.

See the sample files below:

To import accounts, follow the steps below.

  1. Prepare your file for importing, as detailed above
  2. Open the Options menu
  3. Tap Import & Export
  4. Under Import, tap Accounts
  5. Choose the Format. Either CSV, XML or JSON
  6. Tap Import
  7. Locate the file and select it to import


Export Income and Expenses

This feature is only available in the Pro version.

To export income and expenses, follow the steps below.

  1. Open the Options menu
  2. Tap Import & Export
  3. Under Export, tap Income & Expenses
  4. Choose the Format - CSV, XML or JSON
  5. Select the desired Date Format
  6. Select the account to export from
  7. Tap Export
  8. Tap Save to Files and select a location to export to


Export Transfers

This feature is only available in the Pro version.

To export transfers, follow the steps below.

  1. Open the Options menu
  2. Tap Import & Export
  3. Under Export, tap Transfers
  4. Choose the Format - CSV, XML or JSON
  5. Select the desired Date Format
  6. Tap Export
  7. Tap Save to Files and select a location to export to


Export Accounts

This feature is only available in the Pro version.

To export your account names, follow the steps below.

  1. Open the Options menu
  2. Tap Import & Export
  3. Under Export, tap Accounts
  4. Choose the Format - CSV, XML or JSON
  5. Tap Export
  6. Tap Save to Files and select a location to export to