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

    • Map your downloaded bank statement

      Bank Statement Mappings allow you to take a portion of the transaction descriptions that are always present in the downloaded bank statement (typically Customer and Supplier names) and select which column you want these transactions placed in when ...

    • How Do I Import My Bank Statement for 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 can therefore save your ...

    • Adding, connecting and using Bank Feeds

      Adding Bank Feeds to your Cashflow Manager and Cashflow Manager Gold subscription. 1. Click [Bank Feeds] on the left hand side menu. 2. Click [Yes] on the prompt to subscribe to Bank Feeds. 3. Click [OK] to close Cashflow and add Bank Feeds to ...

    • 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 ...

    • What Do I Do If I Cannot Reconcile

      1. Check that the Opening Balance per your Records is the reconciled balance from the month before. (To find your Opening Balance, click on [Settings], then click on the Opening Bank Balance tab). 2. Check that the amount you have typed into the Bank ...

    • Popular Articles

    • Completing your EOFY payroll

      Finalising your year-end payroll It's important to note the final pay period for the financial year is the one that is PAID before the end of the financial year. The first pay period of the next financial year is the first one that is PAID during the ...

    • Starting a New Financial Year in Wages

      You can start a new financial year by following the below steps: 1. In the Employees section of Wages, select [Tools] in the top left 2. Select [Financial Year] 3. Select [Start New Financial Year] 4. The financial year ending will read 202X, select ...

    • End of Financial Year Checklist

      Be prepared and organised this end of financial year, with our easy-to-follow checklist. You can view and download the checklist here. We’ve provided seven steps to make your reporting as stress-free as possible, and if you’ve been using Cashflow ...

    • Single Touch Payroll Guide

      As a subscriber of Cashflow Manager, all fees involved with lodging your records via Single Touch Payroll are included with your Cashflow Manager Gold, Wages Manager or Wages 1-4 subscription fee. If you have any questions regarding Single Touch ...

    • Deleting Old Pays from the STP Event Lodgement Screen

      Continue if you have previous pays listed in the Single Touch Payroll screen that you do not want to send. From the [Tools] menu or on the right-hand side of the Employees screen in wages, select [Single Touch Payroll] to open the Single Touch ...