Click on the Customise Columns icon.

The page that appears will give you the option to customise your ‘Money In’ or your ‘Money Out’ columns by clicking on the tab for the section you require.

The Column Name can be up to 50 characters in length and needs to be unique.

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 it blank.

The Tax Type determines the GST calculation and reporting that applies to the column.

The Profit/Loss status of the column:If the checkbox is ticked then the column will be included in the Profit and Loss report.If the column is not ticked then it will appear on the Balance Sheet (Movement) Report.

The Hide Column is used to remove used, but irrelevant, columns 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] button. 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.


Add a New Column:
Click on the Customise Columns icon and select the section (Money In or Money Out) that the column is in.
Click on the [Add New] button. Type in your new column name. Press your tab key to move to the Accountant's Code.
If you know the Accountant's code, type it in. (This is not essential unless you are going to export your information to your Accountant. It can also be recorded later.) Press your tab key to move to the Tax Type.
A drop-down box will appear at the side of the Tax Type. Click on the arrow and select the correct GST tax type for that column.Tab to the Profit/Loss status and ensure the box is ticked if the column forms part of your profit and loss, or un-ticked if it does not. Ask your accountant if you are unsure.
If you wish to add the column to all accounts, click on the [Add to All Accounts] button.
You can move the column to the position you require by clicking on the Sort buttons or the up and down arrow buttons.
Click on [Save] when you are finished and then [Cancel] if you wish to exit.


Change a Column Name:
Click on the Customise Columns icon and select the section (Money In or Money Out) that the column is in.
Click on the Column Name that you wish to change. Type in the new name.
Click on [Save] when you have finished and then [Cancel] if you wish to exit.

Change a Column’s GST Tax Type:
Cashflow Manager has a uniquely simple system to help you calculate your GST. You simply allocate a GST ‘Tax Type’ that matches the boxes on the Business Activity Statement to your columns.
When entering Money In you record the gross amount (including GST) into the appropriate column and the GST will be automatically calculated from the GST ‘Tax Type’ allocated to the column.

The GST ‘types’ for Money Out are:
GST: All business payments subject to the GST (other than Capital Purchases)

Capital Purchases: Purchases of plant & equipment, property or other assets. There are separate GST ‘types’ for Capital Purchase that are taxable, those where you are not charged GST (GST-free) and those related to Input Taxed Income.

GST-free: Payments to non-registered entities, or where you have not been charged GST.

Input Taxed: Payments that you have made in respect of input taxed income.

Non-GST: Payments that are not to be reported on your GST calculation sheet, e.g. salaries & wages, owners’ drawings, or other acquisitions that are not for use in your business.

The GST ‘Tax Type’ of each column determines the GST calculation and reporting of any amounts entered into the column.

  1. Click on the Customise Columns icon and select the section (Money In or Money Out) that the column is in.

   2. Click on the Tax Type for the column you wish to change. A drop down button will         appear. Click on the button and select the type you require.
   3. Click on [Save] when you have finished and then [Cancel] if you wish to exit.

 

Change Accountant’s Codes:
Cashflow Manager can communicate with your Accountant's General Ledger program, which uses numbers instead of column headings for processing your data.
Select your Accountant’s General Ledger program by clicking on the [Options] icon and then Accountant’s General Ledger Format. You can then edit the Accountant’s Code for individual columns as follows.
Click on the [Customise Columns] icon and select the section (Money In or Money Out) that the column is in. Click on the Accountant's Code for the column you wish to change.
Type in the new code
Click on [Save] when you have finished and then [Cancel] if you wish to exit.

Note: to change the Accountant’s Code for Bank and Cash on Hand accounts, go to Options and select Accountant’s General Ledger Format.


Change the Profit/Loss Indicator of a Column:
The Profit/Loss indicator determines whether the column totals are reported in the Profit and Loss Report or the Balance Sheet (Movement) Report.
If the Profit/Loss Field is ticked then that column is designated as a Profit/Loss column.This means that this column will be included in the Profit and Loss Report. If the column is not designated as a Profit and Loss column then it will be included in the Balance Sheet (Movement) Report.
Click on [Save] when you have finished and then [Cancel] if you wish to exit.


Move a Column:
Click on the [Customise Columns] icon and select the section (Money In or Money Out).
[Sort A-Z] Click on this button to sort your columns alphabetically.
[Sort Z-A] Click on this button to sort your columns in reverse alphabetical order.
The [Up and Down Arrows] will move your selected column in the direction of the arrow, one position for each click.
Click on [Save] when you have finished and then [Cancel] if you wish to exit.
You can also move a column from within the Money In and Money Out sections. Place your mouse over the column you wish to move. A box will highlight the column ‘header’. Hold down your left mouse button and drag the column to its new location. Release your left mouse button.


Delete a Column:
Click on the Customise Columns icon and select the section (Money In or Money Out) that the column is in.
Click on the column name to select it.
Click on the [Delete] button to remove the column. Please note that if data has been recorded in that column at any time then the column cannot be deleted.
The [Undo] button will be activated when you delete a column. You can click on this button to ‘undo’ the deletion.
Click on [Save] when you have finished and then [Cancel] if you wish to exit.


Change a Column's Width:
This function is carried out from within the Money In or Money Out sections. Columns have a maximum width on the screen. For example, if you want the Details column to be wider, there is a maximum width on the screen, but the information you type in (up to a maximum 150 characters) will print in your reports e.g. your Transaction Listing.
To make a column wider, position your mouse cursor over the line at the side of the column. When the cursor changes to the following: Hold down your left mouse button and drag until the column is the width you require.

Did this answer your question?