Formatting your downloaded bank statement

Formatting your downloaded bank statement

  1. 1. Download a file from your Bank’s website to use as a template. 
  2. 2. Click on the [Add New] button to set your default Financial Institution.
  3. 3. Browse to the Bank file that you downloaded. Open the file. Your data will be displayed on the left side of the pop-up window.
  4. 4. Answer the questions in the bottom left of the pop-up window:
  • - Is there a header? This refers to whether there are column titles in the data. For example date, description etc.
  • - Are the fields separated by tabs or commas? Most banks use commas, try this option first.  
  • - How many fields are there in each row? For example if your data has Date, description, debit and credit, there are 4 fields.
    • Note: sometimes it is difficult to tell if there is no header row. If you see 2 commas together, the second comma indicates another field, even though it is empty. For example, this will occur if the bank file has a separate field for debits [money out] and credits [money in]. 
5. Assign the fields. For each of the fields in your data, select a field type to map to in Cashflow Manager. There drop-down down list in the field called “Field type”.
6. Provide a name for this Bank.
7. Provide the URL that you use to download. This will enable you to navigate to your bank site and download your statement at the time you are doing your bank reconciliation.
8. Click on [Save]
9. Click on [Next]

    • Related Articles

    • How Do I Import My Bank Statement for Bank Reconciliation? UK

      A Bank Reconciliation is simply a process that matches your Money In and Money Out Records with your Bank Account. It is an important process because it provides you with a check as to the accuracy of your records and can therefore save your ...

    • How Do I Reconcile Against My Bank Statement?

      What is a Bank Reconciliation? A Bank Reconciliation is simply a process that matches your Money In and Money Out Records with your Bank Account. It is an important process because it provides you with a check as to the accuracy of your records and ...

    • How Do I Add Another Bank Account?

      There are two ways to add a new bank account to your file. Duplicating your bank account This is a helpful trick if you want to add a new account with the same column headings. - Be in your current account in either money in or out - Click on [Tools] ...

    • How to unlock a month - Bank Reconciliation

      There are 2 ways to unlock a month depending on the colour padlock you have. To remove a red padlock: 1. Select either Money In or Money Out on the left under Cashflow. 2. Go to File in the top left 3. Select Accountant Export 4. Then Unlock Months ...

    • How Do I Create A Business Budget? UK

      The latest version allows you to create Account-based & Business-based budgets. This means you can produce budgets for specific Cashflow “accounts”, or for the entire “business”. Both the Account and Business Budgets can be accessed via the Side ...

    • Popular Articles

    • How Do I Update My Payment Details? UK

      Need to change your credit card details? Log on to our shop and update your subscription so you don't lose access to Cashflow Manager. This takes about five minutes. If you already know your password for the shop, log in at this link my account: ...

    • How Do I Run Cashflow Manager on an Apple Mac? UK

      Cashflow Manager is a Windows-based program. However, the MacBook, MacBook Pro, Mac Mini and the iMac computers have the capability of converting to the Windows PC platform via two methods. Option 1: Using software called “Boot Camp” which can be ...

    • How do I download and install the program from the website?

      Visit the Australian or UK Downloads Centre and select the version you wish to install. If you already have a Cashflow Manager icon pinned to your desktop/taskbar, please remove it before downloading. 1. Click [Save] to save the downloaded file to a ...

    • How Do I Set Up The Inventory Section?

      Inventory Items make it easy to prepare your invoices and provide you with management information to help run your business. Some features of the Inventory are only available in the Cashflow Manager GOLD edition. However, both versions of Cashflow ...

    • How do I set up Customers?

      When you click on the (Invoice) Tab on the Dashboard, the (Customers) tab will appear. If you are in another Invoice section, click on the (Customers) tab to open it. This consists of: Customer List:  The Customer List is the main window of the Sales ...