How Do I Customise Money In And Money Out Columns?

How Do I Customise Money In And Money Out Columns?

How Do I Customise Money In And Money Out Columns?

Select the Customise Columns icon, or select [Tools] in the top left, and select [Customise Columns]

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:

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 [Add New] button. Type in your new column name. Press your tab key to move to the Accountant's Code.
3. 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.
4. 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
5. If you wish to add the column to all accounts, click on the [Add to All Accounts] button.
6. You can move the column to the position you require by clicking on the Sort buttons or the up and down arrow buttons.
7. Click on [Save] when you are finished and then [Cancel] if you wish to exit.
 

Change a Column Name:

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 Column Name that you wish to change. Type in the new name.
3. 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.
1. 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.
2. 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.
3. Type in the new code
4. 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.

1. 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.
2. Click on [Save] when you have finished and then [Cancel] if you wish to exit.
 

 

Move a Column:

1. Click on the [Customise Columns] icon and select the section (Money In or Money Out).
2. [Sort A-Z] Click on this button to sort your columns alphabetically.
3. [Sort Z-A] Click on this button to sort your columns in reverse alphabetical order.
4. The [Up and Down Arrows] will move your selected column in the direction of the arrow, one position for each click.
5. Click on [Save] when you have finished and then [Cancel] if you wish to exit.
 

Delete a 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 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 [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.


    • Related Articles

    • Cashflow Manager Basics

      Cashflow Manager records the money in (Receipts) and money out (Payments) transactions of your business. You can also reconcile your bank and cash transactions to ensure that your records are accurate and in preparation for lodging your GST and BAS ...

    • How Do I Record Money In And Money Out Transactions?

      The Money In Record records all receipts (money you receive) -by cheque, cash, credit card, or direct transfer. You will record the details of receipts, allocate them to a column that indicates what the receipt was for and then record what you did ...

    • Learning Cashflow Manager BAS Basics

      BAS Reporting Cashflow Manager makes reporting your Business Activity Statement (BAS) figures to the Australian Tax Office (ATO) simple. Before you are ready to report your BAS, it’s important that you ensure that your transactions have been entered ...

    • WET- Wine Equalisation Tax explained

      Wine Equalisation Tax is a tax on the last wholesale sale (i.e. a sale to a reseller) of wine in Australia. (Wine includes grape wine, grape wine products, other fruit or vegetable wines, cider, Perry, mead, and sake. Wine equalisation tax is imposed ...

    • Recording GST-only amounts

      How do you record a payment where the total amount is for GST? An example may be Internet Connection fees with the balance being paid before GST started. To record this in Cashflow Manager, record the amount you are paying (i.e. the GST) in the ...

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