Old Reports -> General Ledger -> Cash Flow

Parent Previous Next

This option allows you to generate a cash flow report to enable you to see the cash amounts that have moved into or out of your business. You may select to generate this report for all your bank accounts, or a selected bank account.

This report will display a summary for each of your accounts of the monies received in or paid out of your bank accounts or selected bank accounts for the selected periods.

This report may be generated for this year and last year and may be generated for up to six periods in the past from the period selected.

This report will display the total opening balances of your selected bank and petty cash accounts. It will also display the summary of the monies received, the summary of the monies paid out, the total closing balances and the net cash flow and the funds available in the selected bank and petty cash accounts.

Print Cash Flow Reports

To Generate a Cash Flow Report:

1.Click on the Tools  → Old Reports → General Ledger → Cash Flow menu.

The Cash Flow Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Select the following options:

a)Which Year - You may select This Year, or Last Year, to generate the cash flow report.

b)From Bank Account ... To - You may select one or more bank accounts to be included in the cash flow report.

c)Reporting Dates - Select the start period from which you wish to include in the cash flow report.

d)Periods - You may select any number of periods between the ranges 1 to 6. The report will generate the first period of the selected period,and the number of selected periods 2 to 6 will be the period(s) preceding the selected period.

e)Include Petty Cash - Tick this field, if you wish to include a summarised total of the Petty Cash Account opening balances and the monies paid in (e.g. advance, float or replenishment) and paid out of the Petty Cash Accounts.

Petty Cash Accounts should be created as bank accounts. The Include Petty Cash should not be used.

f)Accounts - If you click on this field, the lookup facility displaying a list of your General Ledger Accounts will be displayed. Select the applicable Petty Cash Account which you wish to include in the cash flow report.

4.Click on the OK button to send the report to the medium selected in the Send Report to field.

View Cash Flow Reports

The following is an example of a Cash Flow report generated with details for six (6) accounting period (July 2012):

The details for this report are displayed in three (3) columns, if one accounting period is selected. If six (6) periods are selected, an additional five (5) columns will be displayed. The first column lists the headings, totals and the account codes and descriptions. The second and any other columns, up to the sixth column, will list the summarised transactions posted to each bank account, and petty cash account, if selected. The last column will list or display the total for each of the accounts for the selected accounting periods.

This report will display the information in the following five (5) sections:

1.Opening Balance - The total opening balances for all of the selected Bank accounts created in the Edit → Accounts menu as Bank Account type will be summarised. This balance could include opening balances taken on in the general journal for which Bank Account numbers or codes are selected.

2.Cash Received - Each account to which transactions is posted in the receipts batches (journals) of the selected bank accounts, will be listed and the total amounts for each account will be displayed for each of the selected accounting periods.

3.Cash Paid Out - Each account to which transactions is posted in the payments batches (journals) of the selected bank accounts will be listed, and the total amounts for each account will be displayed for each of the selected accounting periods.

4.Net Cash Flow - This will reflect the net movement of cash which flowed into or out of the selected Bank accounts (Total for Cash Received less the Total for CASH Paid Out). It is the total of all the receipts batches less the total of all the payments batches of the selected Bank accounts. In this example the deposits in the receipts journal is 8 000 and the total in the payments journals is 2 812. The net cash flow into the Bank accounts is 5 188 (8 000 - 2 812).

Should the total of the payments journals be more than the total of the receipts journals, a negative figure will be displayed. This will indicate a net cash flow out of the Bank accounts.

5.Total Bank Balance - This is the total of the closing balances for all of the selected Bank accounts. This Bank balance is the Opening balance, plus the net cash flow into the Bank account, or less the net cash low out of the Bank account. Should the Opening bank balance be an overdraft (a credit balance is displayed), the Opening balance, minus the net cash flow into the Bank account, or plus the net cash low out of the Bank account, will reflect the closing balance.

When using this report you need to take into account that there may be transactions on bank statements which will only be included when you finalise the bank reconciliation.

You also need to ensure that, if you have any repeating transactions for the Payments and Receipts Journals, that these transactions are copied into Payments and Receipts Journals. These transactions must also be posted to the ledger.


Created with the Personal Edition of HelpNDoc: Full-featured Documentation generator