Open topic with navigation

Maintain cash flow report layouts

To maintain a cash flow report layout

Open: Nominal Ledger >Utilities > Ledger Set Up > Financial Statement Layouts.

1. Select the report type, Cash Flow.
2. To create a layout:
   • To create a new layout, click New.
     • Enter a unique name for the layout.
   • To copy an existing layout, select the layout to copy and click Copy.
3. To edit a layout, select the Layout Name and click Edit.
4. A new line is automatically displayed. To add more lines, press the down arrow key or click in the space under the last line.
5. Select the Type of information to display on the line:

Text lines	These lines contain text only, titles, subtitles or notes that you want to include. A text line could even be a blank line or a line of dashes, used to split the report into sections.
Account Groups	Used to define a group of accounts that you want to print on the report in one section usually with a group title and possibly with a subtotal. Add Account Groups where required by specifying: If you want to display a Single Account Group or Multiple Account Groups. The Category code from a list. Note: To use the cash flow report, group budgets should not be used for any income and expenditure nominal accounts to be reported on. If you are displaying a Single Account Group, click on the box and select the code from the list. If you want to display Multiple Account Groups, click on the box to display a list of available codes, then select the codes that you want to display. Title.
Sub Totals	Sub Totals are normally used with each account grouping to show the sub-total for that group. They can also be used to show the subtotal for many groups together. Add Sub Totals where required, by specifying: The Title. The Sub Total Level, 1-9. This tells the system what account values to add together to print in a subtotal. Level 1 adds up all the accounts already processed that have not yet been included in another subtotal of any level. Level 2 adds up all the accounts already processed, not already included in a subtotal level 2 or higher. It will include any that have been rolled up into a subtotal level 1, but not any higher level. Level 3 will add up all accounts not already included in a subtotal level 3 or higher.

6. Click Nominal Accounts to associate cash and bank nominal accounts with a cash flow report to calculate the cash flow opening balance.
• Select the nominal account numbers.
• Click OK.
7. Select a Budget Shift control value to specify the number of periods with which to shift the underlying budgets to reflect credit days.

For example, if you select a shift of 1, then you can take into account that cash will be received one period after budget. If you select a shift of 2, then you can take into account that cash will be received two periods after budget.

Note: The Budget Shift applies only to incomes and expenses, not to actuals.

8. Click Print to print the layout draft.
9. Click Close to return to the Financial Statement Layouts window.
10. To delete a layout, select the Layout Name and click Delete.

Go to top