Table of Contents

Upload bank transactions to Reckon One

Learn how to upload electronic bank statements into Reckon One so you can reconcile your bank transactions against your Reckon One transactions (such as invoices, payments, and bills). An alternative way to do this is to connect a bank feed, which automatically pulls your bank transactions into Reckon One, saving you manual effort.

Before you start

Before you start, you'll need to generate and download your bank statement:

  1. Log into your financial institution and export your electronic bank statement or bank transactions as a QIF, CSV or TXT file.
  2. Save it on your computer, ready for uploading to Reckon One.
If you have bank transactions already imported, a manual upload will overwrite any that have yet to be allocated.

File types supported by Reckon One

  1. QIF (Quicken Interchange Format) - This file type is easiest to upload, as it does not require you to map how the data appears in Reckon One after uploading.
  2. CSV (Comma-Separated Values) - requires you to manually map how the data appears in Reckon One after uploading.
  3. TXT (Text file) - requires you to manually map how the data appears in Reckon One after uploading.

Upload your transactions

  1. In the Banking menu, either:
    1. Select Bank accounts, then click on the Actions menu under the bank account you wish to have the transactions appear in, and select Upload transactions or
    2. Select Bank transactions, then click Manual upload.
  2. Select the bank account from the Bank account dropdown menu.
  3. Click on Select File.
  4. Find and select the previously saved QIF, CSV or TXT file, then click Import the file.
  5. If you uploaded a CSV or TXT file, you'll see some options to manually map how the data appears in Reckon One:
    1. Select an option for Columns are separated by:
      1. Comma
      2. Tab character
      3. Specific character - if you choose this, enter the character in the field.
    2. In the Import from row field, enter the row number in your file that corresponds with where the data begins.
    3. Map the headings from your bank statement to those used in Reckon One. You must map the following fields if they are visible (the rest can be optionally mapped):
      1. Date - Choose Date from the dropdown menu at the top of the column that contains dates.
      2. Debit and credit - Choose Debit and Credit from the dropdown menu at the top of the columns containing debit and credit amounts, or if you have an Amount column on your bank statement, choose Amount from the dropdown menu at the top of the column containing amounts.
      3. Description - Choose Description from the dropdown menu at the top of the column containing payee details.
      4. Reference - Choose Reference from the dropdown menu at the top of the Category column.
      5. If your CSV has extra columns (e.g., balance), you can ignore them during mapping.
  6. Click Import the File again.
  7. Transactions will appear in Latest Manual Upload under Upload source located at the top right of the Bank Transactions screen

Summary of transactions

The top right of the bank transactions screen shows:

  • Upload Source. Where the bank transactions came from (either bank feed or manual upload)
  • Date of last import.
  • Completed. Whether the transactions have all been allocated (this is shown in the Completed column - this will say No until all transactions on the screen have been allocated. Once all transactions have been allocated, this will say Yes).

Read more

How did we do?

Bank Payments

Related Articles

Bank Transactions
How to link Bankdata feeds and allocate transactions in Reckon One
Online Banking Centre for Reckon Accounts
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)