Cashbook

The Cashbook File contains all transactions that relate to your various Cashbook accounts – these can be a collection of bank accounts, cash tin accounts, savings accounts, loan accounts. The transactions for each Cashbook account are held as a mixture of two types of transactions:

It is important that all transactions relating to an individual Cashbook account are processed through the Cashbook, or it will not be possible to verify that your records reconcile with your bank accounts. It is essential when bank statements are received, that all outstanding Cashbook transactions are reviewed, and matched with the bank statement. Add new transactions to your Cashbook if they are missing, then produce a reconciliation report which balances to the statement. Cash accounts (like Petty Cash tins) have no outside statement, but equally it is important that they are balanced periodically.

Note: If you use the Nominal Ledger, only transaction records which are not Sales or Purchase transactions (as differentiated by the Posted to Ledger box) are transferred to the Nominal Ledger at the end of the month. Any that have been posted to the Sales or Purchase Ledgers will be posted from those ledgers directly. The Cashbook records can be either transferred to a history file, or deleted by a choice in the Preferences at the Month End Update. Any transaction for the Sales or Purchase Ledgers must have a valid Client Code as only such codes can have Sales/Purchase Ledger account details.

The Cashbook provides a submenu of options, as described in the following table:

Option Description
Cashbook accounts Displays details of any Cashbook account.
Enter Cashbook transactions Allows you to view or enter transactions in the selected Cashbook account.
Manual Posting For use with an external Nominal Ledger system.
Reconcile after statement Allows reconciliation with a bank statement.
Cashbook history transactions Allows you to view transactions that have been moved to the history file.
Print Bank Reconciliation Prints a hard copy of the Reconciliation report worked out using the Reconcile after statement option.
Post to Nominal

Posts any transactions on a chosen Cashbook account, which have not already been posted to the Sales or Purchase Ledgers, to the Nominal Ledger. It is required to be run before ending a period for the Cashbook Ledger.
Note: The system checks for a valid INPUT TAX purchase account reference before proceeding with this routine. This is necessary in case there are Cashbook transactions to post to the Nominal Ledger that include any tax to be recovered. If the code is not found in the current list of purchase account references for your company, the routine is abandoned.
A report can be produced of transactions that have ben posted to the Nominal Ledger (for audit trail purposes) if required.

Print Month End Postings

If you are using an external Nominal Ledger/Accounting system, this details all transactions requiring posting to the Nominal Ledger from any chosen Cashbook account and should be run prior to running the Manual Posting routine.
Note: If you are using the built-in Nominal Ledger, this report is not required, as posting can be done automatically using the Post to Nominal routine. It will, however, show you a report of transactions on any chosen Cashbook account which will be posted to the Nominal Ledger upon the Post to Nominal routine being run, should you wish to check the transactions first to ensure correct coding.

Print Month End Listings Prints a report with details all the transactions, sorted by Nominal account code, for the chosen period on a given Cashbook account.
Print Daybooks Prints a report in straight transaction number order on any chosen Cashbook account.
Print Current Period Daybook

Defaults to the preset starting transaction number for the chosen Cashbook account, up to the current transaction number, and prints a daybook report accordingly without any further user involvement.

Check Client Reminders

Runs a routine to check through the entire client name/address file to find any client codes where a reminder level is set to more than zero, but there are no outstanding value transactions on their account. In this case, the reminder level of that client code is automatically reset to zero.

Related topics

Cashbook accounts

Enter Cashbook transactions

Manual posting

Reconcile after statement

Cashbook history transactions

Print bank reconciliation

Post to Nominal Ledger

Print Month End postings and listings

Print daybooks

Print standard report sets


Table of contents