When in either the Money In or Out sections, you can customise your allocation columns by clicking on the [Customise] option.

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 table lists all columns that have been included from the business ‘template’ selected when you created the account together with any changes you have made, and includes five fields of information:
Column Name: can be up to 50 characters in length and needs to be unique.
Accountant 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.
Tax Type: determines the GST calculation and reporting that applies to the column.
Profit/Loss: If the checkbox is ticked the column will be included in the Profit and Loss report.If the column is not ticked it will appear on the Balance Sheet (Movement) Report.
Hide Column: Select to hide columns from appearing in Money In or Money Out sections.

The buttons at the bottom of the screen perform various functions:
[Add New] Click on this button to add a new column.
[Sort Z-A] Sort your columns in reverse alphabetical order.
[Sort A-Z] Sort your columns alphabetically.
[Save] Click on this button to save the changes you have made. An information box will advise that your changes have been saved.
[Close] Exit the Customise Columns table. Any changes you have made since you last clicked the [Save] button will not be saved.

The buttons at the top of the screen perform various functions:
[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. The [Undo] button is also activated if the Accountants Codes, Tax Type, Profit & Loss and Hide Columns values are edited.
 [Up] and [Down] Move your selected column in that direction, one position for each click. 


Add a New Column

1.Click on the [Customise] tab and select the section (Money In or Money Out) that the column is in.
2.Click on the [Add New] button. A New Column screen will appear. Type in the name of the column. Press your tab key to move to the Tax Type.
3.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. Press your tab key to move to the Accountants Code.
4.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.)
5.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.
6.If you wish to add the column to all accounts, click on the [Add to All Accounts] box.
7.Click [OK]
8.Click on [Save] when you are finished and then [Close] if you wish to exit.

Change a Column Name:
1.
Click on the [Customise] tab and select the section (Money In or Money Out) that the column is in.
2.Click on the Column Name that you wish to change. Type in the new name and click into a different cell.
3.Click on [Save] when you have finished and then [Close] 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 Tax Types for Money In are:
GST: All receipts subject to GST
Exports: All receipts from exports
Other GST-Free: All GST-Free receipts (other than exports)
Input Taxed: Receipts that are imput taxed e.g. residential rents, financial supplies
Non-GST: Receipts that are not to be reported on your GST calculation sheet, e.g. transfers from your savings, salary & wages, amounts received from a hobby, trust and partnership distributions, dividends, loans and interest received (unless you make financial supplies in your business.)

The GST ‘types’ for Money Out are:
GST: All business payments subject to 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] tab 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 [Close] 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.
You can then edit the Accountant’s Code for individual columns as follows:
1.Click on the [Customise] tab 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.
2.Type in the new code
3.Click on [Save] when you have finished and then [Close] if you wish to exit.

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 [Close] if you wish to exit.

Move a Column:
Click on the [Customise] tab and select the section (Money In or Money Out) that the column is in.
[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] tabs will move your selected column in the direction chosen, one position for each click.
The [Undo] button will be activated when you move a column. You can click on this button to ‘undo’ the deletion.
Click on [Save] when you have finished and then [Close] 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:
1.Click on the [Customise] tab and select the section (Money In or Money Out) that the column is in.
2.Click on the column name to select it.
3.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.
4.The [Undo] button will be activated when you delete a column. You can click on this button to ‘undo’ the deletion.
5.Click on [Save] when you have finished and then [Close] 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. To make an allocation 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.

Please Note: Non-Allocation columns (except GST column) to the left of the screen cannot be widened or narrowed in the Money In or Money Out sections.

Did this answer your question?