Maintain cash flow report layouts

Find this screen

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

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

---

Useful info

About maintaining cash flow report layouts

You can create a cash flow layout in the following ways:

• Create a new cash flow report layout.
• Copy an existing layout, and refine it as required.

Note: No cash flow report layout is provided initially and you will need to create a new one the first time.

Before you begin

You must have:

• Created category codes.
• Created nominal accounts.
• Read the help topic, describing how financial statements are constructed.

Note: If you want to include VAT in your cash flow report, you must ensure you have set up the nominal accounts and category codes that you need. For more information, see Designing financial statements.

Cash flow layouts

This allows you to project your cash flow from the present year to five years in advance, based on your Sage 200 budgets. Values are per accounting period, not calendar month.

For each accounting period, you can see:

• Opening balance.

  For the first period this is the actual balances for the nominal accounts, nominated as bank or cash accounts in the cash flow layout. The values used are the actual balance at the end of the period before the first period on the report.

  For all other periods, the opening cash balance is the closing cash position from the previous period.

• Value for each income heading.

  This value is based on the budgets for the nominal accounts associated with the income heading.

• Total cash receipts value (the sum of the values for all income headings).

• Value for each expenditure heading.

  This value is based on the budgets for the nominal accounts associated with the income heading.

• Total cash paid out (the sum of the values for all expenditure headings).

• Closing balance.

  This is the opening balance plus (total cash receipts less total cash paid out).

The Cash Flow report uses the actual balances for the nominal accounts, nominated as bank accounts in the cash flow layout.