N/L Cash Book
This report is a more detailed version of the
Cash Report. Where the Cash Report provides daily debit, credit and overall balances for the Account shown on flip A of the specified Payment Mode, the N/L Cash Book is an itemised list of the postings made to the Payment Mode Account. The report is compiled using information in the
Transaction register in the Nominal Ledger and is a list of the Transaction rows that post to the Payment Mode Account. It will therefore include
Cash Notes, Cash Receipts and Cash Payments that use the specified Payment Mode as well as Cash In and Cash Out records.
- Period
- Paste Special
Reporting Periods setting, System module
- Specify a report period, in the format "01-02-05:28-02-05". If you are using four-digit years as in the illustration, the leading digits will be inserted automatically. If your report period is a single day, just enter the date once and this will be converted to a period format automatically. The first row of the Reporting Periods setting is the default value.
- Payment Mode
- Paste Special
Payment Modes setting, Sales/Purchase Ledger, Cash Book module
- Enter a Payment Mode: the report will list the Transactions posting to the Account shown on flip A of this Payment Mode during the report period.
- The report will not be printed if you do not specify a Payment Mode.
- Object
- Paste Special
Object register, Nominal Ledger/System module
- Enter an Object Code in this field if you want the report to list Transaction rows (postings) with a certain Object. If the field is empty, all postings to the Payment Mode Account, with and without Objects, are included. If you enter a number of Objects separated by commas, only those postings featuring all the Objects listed will be shown.
- Object Type
- Paste Special
Object Types setting, Nominal Ledger
- Enter an Object Type Code in this field if you want the report to list postings to the Payment Mode Account with Objects belonging to a certain Object Type.
- Report No.
- In some countries, the N/L Cash Book should be printed with a Report Number at the top. Specify here the Report Number that you want to use.
- Print Transaction Code
- If you use this option, Transaction Numbers will be shown in the report together with their prefixes as shown in the 'Transactions: Browse' window. Transactions entered directly to the Nominal Ledger, for example, will be shown as "2005.3" while those created from a Sub System will be shown as, for example, "S/INV.050003". If you do not want these prefixes to be shown in the report (i.e. in the examples, to omit "2005." and "S/INV."), do not check this box.
- Show Object
- Check this box to print the Objects used in each Transaction row.
- Show Currencies
- In the case of Transaction rows in a foreign Currency (i.e. not Base Currency 1 or 2), check this box if you want to show amounts in Currency as well as in the home Currency.
- Show References
- By default, the report shows the Text of each Transaction. Use this option if you would like the Reference and the Text to be shown.
- Long Lines
- Three options are available for dealing with long descriptions when printing on paper. The Don't Break option is always used when printing to screen. If you preview the report to screen, choose 'Recalculate and Print' from the Operations menu to invoke the Long Lines option (i.e. do not click the Printer icon).
- If you use a landscape Page Setup and/or reduce the page magnification, the space available for long descriptions (i.e. the width of the description column) is increased.
- Don't Break
- The full length of the description is printed on one line. If it interferes with figures in the next column, these are moved to the next line.
- Break
- The full length of the description is printed, spread over several lines if necessary.
- Cut
- The final characters of the description are not printed, so that it fits onto one line in the allocated column.
- Amounts in
- Use these options to specify whether the figures in the report should be in Base Currency 1, Base Currency 2 or in the original Currency of the cash transaction. You should only use this last option when all cast transactions posting to a particular Payment Mode Account are in the same Currency (i.e. when you have specified a Currency in the Payment Mode Account record).
Introduction to Reports in the Cash Book Module
