Layouts

Analysis Codes Budget

Shows 12 period budget figures from the period selected back.
Total is the total of budgets from earliest period included to the reporting period.

Analysis Codes Budget Comparison

Contains budget and Activity figures for the selected period and year to date. Percentages compare budgets with the activity. This report can be run at the end of any period.

Analysis Detailed

Report information relating to both expense and income Analysis codes on a single report.

Analysis Sequence

Displays cash book transactions. Select a range of Analysis Codes and also select period, current year, all periods or a range of periods. A Filter & Sort can be added to the Analysis Codes. A Branch and Department can be selected. (Accredo Saturn Only) The report shows cash book transactions within the selections.

Analysis Summary

Report information relating to both expense and income Analysis codes on a single report.

Cash Analysis Sequence

Presents cash based dissections. You can select Bank Account and Period, and a range of GL Accounts. Shows the cash flow for CB Transactions.
The Source Code field shows the Customer, Creditor or Bank Account Code of the Source transaction.

Cash Flow

Provides accurate cash based reporting across CB, AR and AP transactions. This uses GL Account code mapping for the AR Sales Groups, AP Expense codes and CB Analysis codes as the basis for the analysis and pulls Receipt/Payment analysis information via the allocations.

The report totals represent the money flowing through the CB bank accounts.

You can select to include GST. If this is not selected, GST is reported in GL GST Accounts. Cash flow effect is reported in the period of the CB Transaction, not when allocated, which reduces unknown values. Unallocated AR and AP sourced transactions are reported in the relevant GL Clearing Account.

On the Selections Form, choose the starting period for the report; it will print that period plus up to 12 more. This defaults to the first period in the CB current year.

Select the starting period for budgets. If you select a Budget, the starting budget period defaults to the current CB period plus 1. Clear Budgets From and Budget Code to exclude budgets. The report is ordered by the GL Accounts.

Opening and closing balances for each period are shown. To show budget figures where there are no actuals, there must be a CB Analysis Code mapped to the GL account.

Note: If some bank account selections are applied, GL budget values are not broken out by Bank Account.

Cash Flow Budget Comparison

Reports cash flow period and year to date compared with budget activity period and year to date.

Cash Flow By Account Class

Reports on cash flow, grouped by Account Classes. Select the time period and budget code. Note that this version of the report assumes grouping by Account classes and reports "flip-signed" for Expense and Asset classes, i.e. withdrawals against these classes show as positive numbers. (See Cash Flow above.)

Cash Flow Period and Year to Date

Reports on cash flow from Bank Accounts by GL Account in Base Currency, with opening and closing balances. You can select Bank Accounts and Period to show, and can optionally include GST. The Cash Flow Direction for each account is shown. You can optionally show figures for the Last Year To Date.

Expense Comparison

Shows expenses for the selected period and the same period last year, year to date and last year to date (that is, to the same period). Percentages compare this period (year) to last period (year). This report can be run as at the end of any period (including future periods for last year comparatives).

Expense Detailed

Often it is necessary to know Expense code details, the detailed report layout provides this. Select Period, Current Year, All Periods or a Range of Periods. Usually Current Period activity is required (default). A Filter & Sort can be applied to both the Expense code band and the detailed Transaction band.

At the end of the year, you can report on the whole year's Expense code analysis for final account preparation.

Each transaction analysed (fully or partly) to the Expense code is listed. Typically the report shows the full amount of the transaction, the amount of the transaction analysed to the Expense code and a running account balance.

Expense Summary

Summarises expense analysis showing the GL Account number with month to date, year to date and last year expense figures as at the selected Period.

Income Comparison

Shows income for the selected period and the same period last year, year to date and last year to date (that is, to the same period). Percentages compare this period (year) to last period (year).

This report can be run as at the end of any period (including future periods for last year comparatives).

Income Detailed

Often it is necessary to know what an Income code total is made up of. The detailed report layout provides this.

Select Period, Current Year, All Periods or a Range of Periods. Usually Current Period activity is required (default). A Filter & Sort can be applied to both the Income code band and the detailed Transaction band.

At year end, you can report on the year's Income code analysis for final account preparation.

Each transaction analysed (fully or partly) to the Income code is listed. Typically the report shows the full amount of the transaction, the amount of the transaction analysed to the Income code and a running account balance.

Income Summary

Summarises the income analysis typically showing General Ledger account number with month to date, year to date and last year income figures as at the selected Period.