Previous Topic

Next Topic

Book Contents

Book Index

CB Transaction Reports - Add Layout

Navigator > Reports > Cash Book > Transaction Reports > Add Layout

You can add and customise layouts. Once you have added a layout, it becomes a report and will be available from the appropriate Reports folder.

See also Report Selections Form.

Layouts

Account Sequence

Sorts and groups transactions by Bank account. Select a range of Bank Accounts and select Period, Current Year, All Periods or a Range of Periods. A Filter & Sort can be added to both the bank account band and to the transactions band within each bank account. The report shows an opening balance, transactions for the selected period and a running account balance.

Banking Items

Generate a report of all AP Payments, AR Receipts and CB Banking Items. Each CB Transactions created from a Banking Summary or from a single AR Receipt or AP Payment is given a Summary ID.

Summary

Generate a report containing details of banking summaries. This shows the banking line items, and tracking details of summary exports including the user, date, time, due date and file details.

Transaction Links

This report shows the links associated with transactions for a range of periods.

Transaction Sequence

Print a list of transactions. Select Period, Current Year, All Periods or a Range of Periods. The report lists transactions by period, in the order they were entered. This report can be selected for a period as a monthly transaction summary report for audit. The source of the transaction is also indicated, possible sources are:

  • CB, withdrawal or deposit entered in CB (includes transfers, automatic payments and banking) and receipts banked from Banking Summary.
  • AR, deposit from AR banked through directly.
  • AP, withdrawal entered in AP as a payment.

A second band is available that shows the analysis for withdrawals and deposits.

Unbanked Items

Reports unbanked Banking Items at a specified period.

Unreconciled Transactions

Prints a list of all unreconciled transactions at a selected period. This can include transactions from last year, if they have not yet been reconciled against the bank statement. You can specify a bank account or range of bank accounts for the report.

Untransferred Transactions

Produces a report of transactions not yet transferred to GL.