User Guide » Getting Started » How to Import Transactions

How to Import Transactions

Importing Transactions is a very fast, very powerful way to populate your system.

You can import transactions from a wide range of sources, including Amazon Seller Central, your bank account, and most payment processing gateways.

To import transactions, it’s as easy as downloading your QIF statements, and uploading them in Transactions > Import… but if you get stuck or need further information please read on.

Import QIF files

To import QIF files from your bank, first log into your bank account online. Then open your Account and locate the Download button or tool. This is usually in your main account screen.

Every bank is different, so we have not provided screenshots for this. If you are unable to find your QIF files, please ask your bank for assistance.

You can also import QIF files from other financial software, including Quickbooks and Sage. Just download your QIF files from your provider, and follow the instructions below to import them.

Import CSV files

Similarly to QIF files, you can often download CSV files from your bank account online.

Note: if both QIF and CSV files are available, it’s preferable to use QIF files, since these usually conform more closely to recognised standards.

You can also download CSV files from PayPal.

You could also generate your own CSV file using spreadsheet software such as Microsoft Excel.

For an example of a CSV file that would be suitable for import, please CLICK HERE TO DOWNLOAD

Not all fields can be imported from a CSV, but the example file will show what sort of information can be imported. You can tailor the CSV to suit your purposes, and then import it, following the instructions below.

The process to Import Transactions

  1. Click on Your Transactions in the main menu
  2. Click the Import button
  3. Select the Account
    • If your data file is from a specific bank account, select the correct account
  4.  Select the files for Import
    • Select your QIF or CSV files for import.
    • You can select multiple files for import at a time. To do this, click SELECT FILES and then hold down CTRL and select all the files you want to import.
  5. Verify the imported transactions
    • Your recently imported files will appear under Your Recent Imports.
    • As the table is filled, check the statistics to ensure that your transactions are being imported.
    • Duplicates are auto-detected, and if identified, they will not be imported. You will see how many transactions are imported, and how many were marked as duplicates.
  6. After you have finished importing transactions, click the button marked View your Recently Imported Transactions
  7.  If you want to undo a recent import, click the yellow  to remove all the transactions related to that import

All Done!

Your import has been processed. As far as possible, 10 Minute Accounts will categorise your new transactions according to the way you’ve categorised similar transactions in the past.

Please check the Statistics to see how many transactions have been categorised.

You may have to recategorise some transactions, or categorise transactions that 10 Minute Accounts is unfamiliar with.

To see the recently imported transactions, go to All Transactions and change the Category to Recently Imported Transactions.

Troubleshooting

If transaction import fails, or it doesn’t seem to recognise your transactions, it will be down to one of the following reasons:

  • You do not have clearly defined date, payee and amount headers in your CSV file
    • Solution: ensure that at least 3 fields are defined: date , payee and amount .
    • Optional: you can also use the following fields: description , fee , notes , reference , currencycode
  • Your CSV file is not formatted using commas (,) to separate fields
    • Solution: Re-export your CSV file with standard formatting
  • Dates are incorrectly recognised
    • Solution: ensure that your original data has dates in a standardized format. Standard formats are:
      • International: yyyy-mm-dd
      • European: dd-mm-yyyy
      • North American: mm/dd/yyyy
    • Note: other date formats, such as 3rd DEC 2017 are detected, and will be converted where possible – but if your date format is in one of these alternative formats, please double check that your transactions have saved correctly

Note: it is highly recommended to use QIF file import, where available, rather than CSV import. QIF files usually conform to international standards, so if you’re having problems importing CSV files, switch to importing QIF if possible

If the above solutions don’t help, or you’d like to talk to someone, please contact support, where we can help you further.

Also see: