TurboCASH Accounting Software TurboCASH United Kingdom
Select your Country
OPEN SOURCE ACCOUNTING SOFTWARE
HomeFeatures & ScreenshotsShop onlineCompareFAQForumRegisterContact
Community
Free Downloads
Shop
Other Titles

Using TurboCASH

 







VIEW GENERAL LEDGER REPORTS
VIEW CASH FLOW REPORT
  
The Cash Flow Report will summarise the Receipts batches or journals and Payments batches or journals display the net cash flowed into (or out of) the selected Bank accounts and the Petty Cash account as well as any opening balances and closing balances and funds available.

You may also include the Petty Cash account if it is not created as a Bank account. This report will include any transactions in batches or journals, which have been updated or posted to the ledger. The Cash Flow report is generated on the Cash Flow Report Options screen on which you may select the following to include in the report:
  1. Select to view the transactions for This Year or Last Year. Depending on the selected Year, you may select the accounting periods for a Financial Year using This Year or Last Year Search or lookup facility.

  2. Select the Bank account or a range of Bank accounts on the Bank Accounts search facility.

     

  3. Select the number of Accounting Periods (up to 6 periods) for which the cash flow needs to be displayed.

  4. Select to include the Petty Cash account, if it is not created as a Bank account. You need to select the specific Petty Cash account on the Accounts search facility.
The following is an example of a Cash Flow report generated with details for 1 accounting period (March 2005):

Name of the business. Name of the report. The Accounting period. The account number and name will be listed for the total of the transactions. Accounting period. If more than 1 (2 to 6) number of periods are selected, additional columns will be inserted for each period. Total is the total of the transaction totals for the number of selected Accounting periods (1 to 6). The total Opening balances of the selected Bank Accounts. The total of all the transactions entered in the Receipts batches of the selected Bank Accounts. The total of all the transactions entered in the Payments batches of the selected Bank Accounts. Net Cash Flow is the Total for Cash Received less the Total for Cash Paid Out. Total of the Closing Balances of the selected Bank Accounts. The Opening balance of the selected Petty Cash Account. The total of the float / advances / petty cash replenishments entered in the receipts batch and allocated to the petty cash account. The total of the transactions entered in the Petty Cash Payments Journal. Net Petty Cash Flow - is the Total for Petty Cash In less the Total for Petty Cash Out. Total of the Closing Balances of the selected Petty Cash Account. Total Cash Flow is the total of the Net Cash Flow less the Petty Cash Flow. Funds Available is the total of the Closing Balances of the Bank Accounts and the Petty Cash Account. Total is the total of the transaction totals for the number of selected Accounting periods (1 to 6). System date and time. Page number.

The details for this report are displayed in 3 columns if 1 accounting period is selected if a number of 6 periods is selected an additional 5 columns will be displayed. The first column lists the headings, totals and the account codes and descriptions. The 2nd and any other columns up to the 6th 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 12 sections: Bank Accounts
  1. Opening Balance - The total opening balances for all of the selected Bank accounts created in the Edit - Accounts - Bank Accounts menu option will be summarised. This balance could include opening balances taken on in the general journal for which Bank accounts numbers or codes are selected.

  2. Cash Received - Each account to which transactions is posted in the receipts batches or 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 or 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 R() 8 000 and the total in the payments journals is R() 2 812. The net cash flow into the Bank accounts is R() 5 188 (R() 8 000 - R() 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.

    Petty Cash Accounts (this will only be displayed if you have created the Petty Cash account in the Edit - Accounts - General Ledger menu option and if you have selected to include the Petty Cash in the Cash Flow Options screen.

  6. Opening Petty Cash - This is the opening balance of the Petty Cash account. This is the closing balance of the previous financial year or accounting period. This balance could include opening balances taken on in the general journal for which the Petty Cash account number or code is selected.

  7. Petty Cash In - This is the total Petty Cash float, advance or replenishment (e.g. for a cashed cheque) transactions, which is entered in the Receipts journal and posted to the ledger.

  8. Petty Cash Out - This is the total payment transactions (e.g. Petty Cash Vouchers) which are entered in the Petty Cash Payments journal and posted to the ledger.

  9. Net Petty Cash Flow - This will reflect the net movement of cash, which flowed into or out of the Petty Cash account (Total for Petty Cash In less the Total for Petty Cash Out). It is the total of all the posted entries in the Payments batches less the total of the Petty Cash Payments journal and posted to the ledger. In this example the replenishments or advance in the Receipts journal is R() 100 and the total in the Petty Cash Payments journal is R() 67. The net cash flow into the Petty Cash account is R() 33 (R() 100 - R() 67).

    Should the total of the Petty Cash Payments journal 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 Petty Cash account.

  10. Total Petty Cash - This is the closing balance for the Petty Cash account. This balance is the Opening balance plus the net petty cash flow into the Petty Cash account or less the net petty cash low out of the Bank account.

    Summary of the Cash Flow and Funds Available

  11. Total Cash Flow - This is the total cash, which flowed into the selected Bank accounts and Petty Cash account (if selected). If the figure is displayed as a negative figure, it is the total cash, which flowed out of the selected Bank accounts and Petty Cash account (if selected).

  12. Funds Available - This is the total of the closing balances for the selected Bank accounts and the Petty Cash account (if selected).

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 make sure that if you have any Repeating Entries for the Payments and Receipts batches, that these transactions needs to be copied into Payments and Receipts batches and that it needs to be posted to the ledger.

The amounts which are displayed in <> indicates a credit or negative figure. You may change this negative amount indicator to a minus sign (-) to prefix your amounts or set it to display a D (for Debit) or a C (for Credit) in the Setup - Preferences - Data Parameters menu option.