Cash Book
This report is a chronological listing of the records entered to both the
Cash In and Cash Out registers during the specified period. It also shows opening and closing balances for the period, and total amounts posted in each Currency during the period.
Invalidated cash transactions are not shown.
- 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 period in the Reporting Periods setting is the default value.
- Paym. Mode
- Paste Special
Payment Modes setting, Sales/Purchase Ledger, Cash Book module
- To list cash transactions with a particular Payment Mode, enter that Payment Mode here.
- Customer
- Paste Special
Customers and Suppliers in Customer register
- Range Reporting Alpha
- To list cash transactions made to/from a particular Customer or Supplier, enter their Customer or Supplier Number here.
- Object
- Paste Special
Object register, System module
- Specify an Object to list the cash transactions featuring that Object in the report. If you enter a number of Objects separated by commas, only those transactions featuring all the Objects listed will be shown.
- Cashier, Book-keeper
- The Overview version of the report contains spaces where it can be signed by the Cashier and Bookkeeper. If you enter their names in these fields, they will be printed below these spaces.
- Status
- You can include both approved and unapproved cash transactions in the report. You must select at least one of these options, otherwise the report will be blank.
- Function
- Use these options to control the level of detail shown in the report.
- Overview
- This option is a simple list, showing for each cash transaction its Serial Number, Transaction Date, Customer or Supplier, Specification and Total debit or credit amount in Base Currency 1. The Overview also contains spaces where it can be signed by the Cashier and Bookkeeper.
- Detailed
- In addition to the information included in the overview, this option also shows the Person and the debit or credit amount in Currency.
- Per day
- By default the report lists Cash In transactions in date order followed by Cash Out transactions, also in date order. Check this box if you would like the report to be sorted by date only, so that Cash In and Cash Out transactions for the same day are listed together. As well as the opening and closing balances for the period, this option also shows closing balances for each day.
- Show Currency Amounts
- By default, the report is a list of Cash In and Cash Out records with amounts shown in the home Currency (Base Currency 1) only. If you have some cash transactions in foreign Currencies and you want to see the amounts from these transactions in both Base Currency 1 and in Currency, check this box.
Introduction to Reports in the Cash Book Module
