Cashflow Manager FAQs

The VAT report is able to be lodged online from directly in the Cashflow Manager program.

To lodge your VAT return online:

  1. Select an account from the Home screen.
  2. Click on the Reports tab.
  3. Select that VAT report and click [Continue] on the bottom right-hand corner of the screen.
  4. Select which accounts you wish to view and the reporting period.
  5. Add any adjustments that you need to make.
  6. Click [Lodge Online]
  7. A box will appear for ‘VAT Details’. Enter your User ID, password and check the start and end dates displayed.
  8. Click [Lodge].
  1. In the ‘Cashflow’ section of the program, click on the ‘File’ menu.
  2. Click [Accountant Export].
  3. Click [Export to Accountant].
  4. Select the account(s) you wish to export. ‘All Accounts’ is the default selection, but you can change this to the current account you are working in, or click on [Select Accounts] to choose which ones you would like to include.
  5. Choose the starting month and year and the ending month and year.
  6. You are now ready to create the export file.
    1. Click on [Browse] The ‘Save as’ window will appear to allow you to choose a location and file name for the export file. The default location is the C:\Users\Username\AppData\Roaming\CFM\Cashflow9\Data folder
    2. The default file name is the name of your current business file with information about the dates you are exporting. For example, if your current file name is ‘Sample’ and you are exporting from January 2016 to March 2016, the file name for the export file will be Sample Jan2016-Mar2016.
    3. The file will be saved as an Accountant Export File with an .ec9 extension.
    4. The months will be locked for each of the accounts included in the export so you do not make any unwanted changes. A red padlock will appear next to the account name in your Cashflow Manager work area to indicate that the month is locked.
  1. If you wish to email the file to your accountant, check the box that says ‘Email File when Export Complete’.
  2. Click on the [Export] button. The program will now create the file. If you select ‘Email File When Export Complete’ the ‘Email Document’ window will appear.
    1. Type in your accountant’s email address in ‘Send To:’ (or select the address by selecting from ‘Show Contact Emails’.
    2. Add a subject for the email e.g. Cashflow Manager Files
    3. Type in any additional text for the email.
    4. Click on the [Send] button.
  1. To record a ‘money in’ transaction, first select the account you wish to add the transaction to.
  2. Click on the ‘Money In’ tab and ensure you are working in the correct month and year.
  3. Type the correct day of the month in the ‘day’ box and press [Enter].
  4. Type in the name of your customer and press [Enter].
  5. Type in the details of your money in transaction and press [Enter].
  6. Add in your receipt number if there is one, or press the [Tab] if you wish to leave this blank.
  7. Enter the amount into ‘total receipts’ and press [Enter].
  8. The curser will go to the ‘VAT’ field and the VAT will be automatically calculated. Press [Enter] to accept the amount, or edit the amount and then press [Enter].
  9. Use the tab or left and right arrow keys to move the amount to the correct allocation column. Alternatively you can press the letter that the column starts with. For example, if the ‘S’ key was pressed, the allocation would jump to the ‘Sales’ column.
  10. The amount will now appear in the ‘Bank Deposits’ column. If you have deposited it into the bank simply press [Enter]. If you have held the money as cash, press the [Tab] button to add the amount to the ‘Receipts not Banked’ and press [Enter].
  11. Your line is now complete and you can move onto your next transaction.

To customise your columns click on the ‘customise columns’ icon. The page that appears will give you the option to customise your ‘Money in’ or ‘Money out’ columns by clicking the tab for the section you wish to modify.

The table lists all the columns that are included in the business template you selected and includes five fields of information, which you need to fill in:

  1. The Column Name, which can be up to 50 characters in length and must be unique
  2. The Accountant’s Code is used to match the codes used by your accountant’s general ledger program. If you don’t know the code your accountant uses, leave this blank.
  3. The Tax Type determines the VAT reporting that applies to the column.
  4. The Profit/Loss status – if the checkbox is ticked, then the column will be included in the Profit and Loss Report; if not, it will appear on the Balance Sheet (Movement) Report.
  5. Hide, which allows irrelevant columns to be hidden from the Money In and Out sections.

The buttons on the right side perform various functions:

  • [Add New] Click on this button to add a new column.
  • [Delete] Click on the line for the column you wish to delete and then click on the [Delete] The column will be deleted unless there is data recorded in that column.
  • [Undo] The [Undo] button will be activated when you delete a column. You can click on this button to ‘undo’ the deletion.
  • [Sort A-Z] Sort your columns alphabetically.
  • [Sort Z-A] Sort your columns in reverse alphabetical order.
  • [Add to All Accounts] Columns in one account can be added to all other accounts.
  • [Up and Down Arrows] Move your selected column in the direction of the arrow, one position for each click.
  • [Save] Click on this button to save the changes you have made. An information box will advise that your changes have been saved.
  • [Cancel] Exit the Customise Columns table. Any changes you have made since you last clicked the [Save] button will not be saved.

To save your changes and then exit the Customise Columns table, click on the [Save] button and then the [Cancel] button.