This module is used to produce Cash Flow Forecast Report, Cash Flow Statement and Custom Column at Financial Report (See also Profit and Loss Statement).
Go to Tools > Program Control > Module Setting
Check the checkbox of Advanced Financial Report to enable it.
Cash Flow Forecast Report
Go to G/L > Cash Flow Forecast Report
Let’s say we are going to forecast ‘weekly Cash Payments and Receipts’ for 5 weeks:
Date: starting date of the forecast
No. of Column: select number of columns from 1 ~ 10
Frequency: define the frequency of columns, either Daily, Weekly, Bi-Weekly, Monthly, Quarterly or Yearly.
Click on Inquiry
Cash: these are totals of Beginning Cash (total sum of Cash/Bank accounts) for the respective weeks. Click on the ‘+’ sign to see details.
Accounts Receivable: these are totals of outstanding (from all debtors) that will due in the respective weeks. Click on the ‘+’ sign to see details.
Expenses: these are totals of expenses that will be made in the respective weeks. Click on the ‘+’ sign to see details.
Cash Available for Disbursement: these are totals of ‘Cash + Accounts Receivable – Expenses’ in the respective weeks.
Accounts Payable: these are totals of outstanding (from all creditors) that will due in the respective weeks. Click on the ‘+’ sign to see details.
Ending Cash Balance: these are totals of ‘Cash Available for Disbursement – Accounts Payable’ in the respective weeks. The ending cash balance for this week will be the opening cash balance for the subsequent week.
Note: Changes made here are purely for Cash Flow Forecast reporting purposes, these changes do not affect the related accounts and transaction records.
Maintain Adjustment: click on Add to maintain adjustment amount for different sections; these adjustment amounts (could be negative, which means reduce) are forecasted cash movement. To see the effect, go back to the Cash Flow Forecast screen, click on Inquiry.
Maintain Expenses: click on Add to maintain forecasted expenses payment for different expenses account. To see the effect, go back to the Cash Flow Forecast screen, click on Inquiry.
Maintain AR/AP Forecast Due Date: define Date Range of documents, click on Inquiry, assign Forecast Due Date should it differs from the original due date. then click on Save. To see the effect, go back to the Cash Flow Forecast screen, click on Inquiry.
You may click on Preview to view detailed report.
Cash Flow Statement
This feature is available only when the Advanced Financial Report module is enabled.
This is to view/print Cash Flow Statement.
Go to G/L > Cash Flow Statement
Date: define the date as at…
Report Title: (first row) ‘#Company’ means the company name as maintained at Company Profile; (second row) ‘#StartDate’ means the Start Date of the current fiscal year; ‘#EndDate’ means the Date you have defined at the top of this screen.
Save Criteria: to save the report criteria for future use.
Load Criteria: to select and load from earlier saved criteria.
Formats available are as below:
Show Account No.: to show account number of each ledger account
Show Zero Balance: to include accounts with zero balance
Use 2nd Description: to show the 2nd row of account description instead of the first row
Header: to show Page Number, Date & Time, and User ID on the report header
Number Style: option to round up to 10, 100, 1000, or 10000; option for format of negative amount; option to show decimal.
Text Styles: define separately font and color for the components of the report.
Paper: to set the width and height of printing paper. (e.g. 2159 unit = 215.9 mm)
Margin: to set the margin of left, right, top and bottom (e.g. 127 unit = 12.7 mm)
Column Width: to set the width of the columns of Number, Acc No, Percentage and Description (e.g. 230 unit = 23.0 mm)
Account Indentation: to set the indentation of sub-accounts
Row Height: to set the height of rows
Auto adjust column width and font size: to make auto adjustment according to paper size
Show Currency Symbol: to show symbol currency
Reset: to use the default setting
OK: to save the setting
Cancel: to cancel changes and return to previous screen (same as pressing Esc button on your keyboard)
Click on Preview,