The Cash Book screen opens with the most frequently used columns as defaults, but you can amend this by using the Configure Columns functionality which can be found under the Cog icon at the top right-hand side corner of the Cash Book screen.
β
The Nominal Account Code and Nominal Account Name columns are also hyperlinks which means that you can hover over a record within either of these columns and click on the hyperlink so you are taken to the Cash Book Record screen to view more details about the account selected or make any necessary changes.
Open the Cash Book screen:
Click Financials then click Cash Book.
Note: All the bank and cash type accounts are listed on the screen. You can narrow down your search by using the advanced filters. You can also search on the columns directly by pointing the mouse to the name of the column and click on the icon and choose from the available filter list, then click OK.
Once you have found the account you wish to work with, you can follow the steps below for viewing and editing and setting up Bank Feeds.
View more details of a selected account:
On the Cash Book screen click on the underlined or hyperlinked text on the Nominal Account Code or Nominal Account Name column to see more information about your account.
Note: The selected nominal account opens in view mode with the Details tab in focus providing more information about the account you have selected on the Details, Bank Details, Turnover and Visual analysis tabs.
View Bank Details of a selected account
On the Cash Book screen click on the underlined or hyperlinked text on the Nominal Account Code or Nominal Account Name column to see more information about your account.
Note: The selected nominal account opens in view mode with the Details tab in focus.
Click on the Bank Details tab.
Note: The Bank Address Details section hold the address data of your account while the Reconciliation Options section allows you to set up an Auto Match Date Tolerance for when you are reconciling your bank statements with your cash book account.
You can set up Bank Feeds under the Account Details section following our step-by-step guide for Setting up Bank Feeds article.
View Turnover and Visual Analysis of a selected account
On the Cash Book screen click on the underlined or hyperlinked text on the Nominal Account Code or Nominal Account Name column to to see more information about your account.
Note: The selected nominal account opens in view mode with the Details tab in focus.
Click on the Turnover Analysis tab.
Note: The Turnover Analysis displays the periods in your database and holds the total turnover value for your selected account.
For more information on the turnover analysis, please refer to our The Turnover Analysis on a cash or bank type account explained article.
Click on the underlined or hyperlinked value for a period to be taken to the Nominal Transaction Enquiry where you can view each transaction on your selected account.
The Visual Analysis tab offers you a Bar or Line Chart view of your total turnover value for your selected account.
Edit a cash book account
On the Cash Book screen click on the underlined or hyperlinked text on the Nominal Account Code or Nominal Account Name column to to see more information about your account.
Note: The selected nominal account opens in view mode.
Click on the Edit button at the bottom of the screen to set the record into edit mode.
Amend any of the fields which are enabled for you.
Click Save.
βNote: If you can see the Close button instead of the Edit button, it means that you don't have access to edit nominal records.
If you wish to set up bank statement importing using a csv file, please refer to our Everything you need to know about Bank Reconciliation using AI Auto Matching main article which guides you through all the steps.
Cash Book Summaries section for the Actual column explained on the Details tab:
Details | Description |
Actual |
|
Actual |
|
Actual |
|
Actual |
|
Actual Unreconciled |
|
Actual Reconciled |
|
Cash Book Summaries section for the Incl. Batched column explained:
Details | Description |
Incl. Batched |
|
Incl. Batched |
|
Incl. Batched |
|
Incl. Batched |
|
Incl. Batched |
|
Incl. Batched |
|
