These reports are almost exactly the same as the Report Listings & Analyses in the
nominal ledger. Even though you may not
be using the nominal ledger, you still have the same requirement for general
account and transaction reports.
Print Control
You can define up to eight printing styles for your system
through the CONFIG user — see the System
User Guide. These control not only
the print style such as the number of characters per inch, but also the length
and width of the report. The styles so
far defined are shown at the bottom of the screen when you are prompted.
Data Items
You are asked to enter up to 10 data items (depending on the specific report) to print on each report.The file structure for the file concerned (cash book accounts or transactions) shows in the right-hand window when you take the option for any particular report. However, you can use the <F4–Select> key in the usual way to select a specific data item to print. It is the data item numbers which you enter, although the names are shown alongside too.
An example of the entry screen used for report definition is shown below.
In addition to the data items in the file itself, you can select from a further set of items, which are derived from the data in each file up to the period number chosen for the report at run time. Use the <F7–Options> key to view these items, which are also described below.They are numbered from item number 161 upwards.
It is preferable to use, for example, item 165 — the accumulated actual balance — than to use item 47, the current balance. The current balance always shows the full year regardless of which period you ask to print, whereas item 165 accumulates only up to the period number you choose when you print.
Additional Cash Book Accounts File Items
Item Description
161 Accumulated Budget. The sum of each period’s budget from the start of the year to the report period number — i.e. the year-to-date budget
162 Accum Budget Variance. The difference between the budget to-date item 161 and the actual movement to-date, which is item 165
163 Period Budget. The budget figure for the report period requested
164 Period Budget Variance. The difference between the period budget item 163 and the actual result for the period, which is item 167
165 Accumulated Actual. The sum of each period’s actual results from the start of the year to the report period — i.e. the actual year-to-date result
166 Accumulated Actual Variance (Previous year actual). This is the variance between the year-to-date result in item 165, and the comparative value for the same period range last year, item 169
167 Period Actual. The movement for the period — the current period’s results
168 Period Actual variance (Previous year actual). This is the variance between the current period’s result in item 167 and the comparative value for the same period last year, item 170
169 Previous Year Actual Accumulated. This is the sum of the actual results from the start of last year to the same period last year as the report period
170 Previous Year Actual Period. The results for the same period last year
Note
The references to
budgets retain compatibility with the nominal ledger. The cash book itself does not support budgets.
The OPTIONS Button
The Options button allows configuration facilities for the
printing of the report – selecting margins and fonts and was discussed above.
Trial Balance
The trial balance shows all the cash book accounts with their current debit or credit balance, and sums the debits and credits to prove that the ledger itself balances.
The trial balance can print sub-totals at certain break points, and you define these in the cash book System Profiles — see the System User Guide. For example, you might want to print sub-totals after the income accounts, expenditure accounts, the bank and cash accounts, and the control accounts.
Although the trial balance is designed in a manual system to check that a nominal ledger balances, it is also used to give the figures from which profit and loss statements and balance sheet reports are prepared. A cash book system on its own should balance too. You may want to print items 165 and 167 as well, to give you the year-to-date and current period movement figures.
The audit trail is designed to print three aspects of each cash book account:
A header line of information from the account record
Transaction details which apply to this account (you can choose which transactions to print at run time)
An analysis table derived from the transactions, if you ask for this at run time
You can define up to ten items from the cash book accounts
file to print in the header, and up to ten items to print from each transaction
record. You have no control over the
layout of the analysis table, other than whether to print it or not.
Transactions
As well as the data file items from the transactions file you can choose to print from five other items derived from the transaction data, as shown in the table below.
You also have the option to sort the transactions for each account by date before you print them.With the ability to enter data for any period at any time, this option is advised, since it helps to show you where the period movement figures come from.
Additional Cash book Transaction File Items
Item Description
161 DB/CR-AMOUNT — this prints the transaction value in one of two columns headed debit and credit. Were you to print the amount itself, it would print in a single column regardless of whether debit or credit
162 RUNNING-BAL —this gives a running balance from the start of the year.A balance is calculated for each transaction regardless of whether it is printed or not, so that the balance which prints against a line represents the true account balance after applying that and all previous transactions
163 ALT-ACCOUNT — this prints the other account code as a cross-reference for double entry journals (found only in the nominal ledger)
164 DB-ACC-NAME - This prints the debit account name if the transaction contains a debit account
165 CR-ACC-NAME - This print the credit account name if the transaction contains
a credit account
Account Listing
Account Status
These two reports are general reports specified in the same
way. You can print the additional cash
book account data items 161–170 (as described above) on these reports as well —
use the <F7–Options> key to give you a list of these.
Receipt Heading
Payment Headings
These reports list just those income and expenditure
accounts which are specifically marked for entry against receipt or payments
columns.
Transaction Listing
This is a report of the journal entries in your system. A blank line separates the entries for one journal from those of the next.
As well as the normal transactions file items, you can also choose to print the debit and credit account names in separate columns by choosing data items 164 and 165, as shown at the bottom of the screen. Special Item 161 allows printing of the transaction amount but split into debit and credit columns. If subtotalling the journals then you need to print this item instead of the amount data item (usually item 5).
Article ID: 1168
Created On: Thu, Jun 28, 2012 at 12:10 PM
Last Updated On: Mon, Jun 19, 2023 at 6:27 PM
Online URL: https://kb.datafile.co.uk/article/reports-analyses-cashbook-1168.html