Cash Flow Analysis

Back Top Previous Next
cash flow tab

 

Cash Flow Analysis is accessed from the Cash Flow icon in the Management tab on the ribbon, or from the Nav Tree under Management (right click and select Cash Flow).

 

It allows for forecasting cash requirements up to 180 days in advance, allowing preparation and planning of cash requirements.

 

Cash Flow Analysis takes into account the following sources:

Cash in the bank as of today.

Outstanding debtors invoices dated as they are due.

Outstanding creditors invoices (purchases) dated as they are due.

Manually added one-off deposits and withdrawals.

Manually added recurring deposits and withdrawals.

Recurring deposits/withdrawals based on previous transactions for a general ledger account.

 

Examples of other cash flow inputs include wages, rent, phone, lease payments, etc. In other words, anything that will have a major impact on cash requirements.

 

Info

Note: The opening balance amount in Cash Flow Analysis reflects the start of the day balance, and is not a live balance as the current day's transactions have not yet been finalised.

 

Right click options in the list:

 

exportdata

 

Right Click Option

Explanation

View

View the highlighted object.

Edit

Edit the highlighted object.

Export Data

Export data from the grid (based on grid columns added) to a spreadsheet with only one header row.

Export Grid

Exports the grid (based on grid columns added) to a spreadsheet. This is particularly useful if the grid has more than one header row, as it will export all header rows.

Print

Print the list.

Print Preview

Preview the list to be printed.

Copy Cell

Copy the highlighted cell.

Copy Row

Copy the highlighted row.

Copy All

Copy all, which can then be pasted into a spreadsheet.

Show Find panel

Brings up the Find panel:

 

findbox

 

Tip

The Find panel will remain in a pinned list but will disappear from an unpinned list on log off.

Grid Columns...

Allows adding more columns. Also allows removal of columns. Select the column to add, then drag it to the position required in the columns within the grid. To remove, click and drag to the Grid Columns... window, or drag down away from the header area.

 

gridcolumns

 

Further information

Cash Flow Accuracy

Cash Flow Analysis Tab

Cash Flow Exporting

Cash Flow Setup

Contributing Sources