Advanced Financial Report

From AutoCount Resource Center
Jump to navigation Jump to search

Advanced Financial Report

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:


Filter Option

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

AFR1.png


Cash: these are totals of Beginning Cash (total sum of Cash/Bank accounts) for the respective weeks. Click on the '+' sign to see details.


AFR2.png

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.


Maintain Options

AFR3.png

Note: Changes made here are purely for Cash Flow Forecast reporting purpose, 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 Cash Flow Forecast screen, click on Inquiry.


AFR4.png


Maintain Expenses: click on Add to maintain forecasted expenses payment for different expenses account. To see the effect, go back to Cash Flow Forecast screen, click on Inquiry.


AFR5.png


Maintain AR/AP Forecast Due Date: define Date Range of documents, click on Inquiry, assign Forecast Due Date should it differs from original due date. then click on Save. To see the effect, go back to Cash Flow Forecast screen, click on Inquiry.


AFR6.png


You may click on Preview to view detail report.


AFR7.png


Cash Flow Statement

This feature is available only when Advanced Financial Report module is enabled.

This is to view/print Cash Flow Statement.


Go to G/L > Cash Flow Statement

AFR8(1).png


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


Report Format

Formats available are as below:


AFR9.png

AFR10.png


Options

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


Advanced Options...


AFR11(1).png


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,

AFR12.png

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations