Skip to main content

Next Generation - The Cash Book screen

The Cash Book screen uses the same screen that we use for our record lists and enquiries for consistency purposes, and it shows financials details relating to a specific bank or cash account.
​
The Cash Book module aids in simplifying the entry of missing transactions and all functionality relating to the Cash Book is available from the Action Panel.

Access the Cash Book screen:

  1. Click Financials then click Cash Book.

    • Note: All Bank and Petty Cash type nominal accounts are displayed for you.

Cash Book default screen:

Sections

Description

Record Count

  • Shows the number of bank and or cash accounts listed in the grid for the provided filter criteria.

  • Updates depending on the filter criteria.

  • Updates when you select a record.

Search field
​

  • You can search on the Nominal Account Code and Name.

  • Tip: You have to know the first few characters or numbers to be able to search as these searches are what we refer to as Begins With searches.

  • You can search for the beginning of each word in the available quick search fields, no matter where they are.

  • Example:

    • If you wish to search for an Account Name of "The Access Group", you can now enter the words "The", "Access", or "Group" and Financials will intelligently find this result.

Saved Filters List

  • A list of any saved filters that are available.

  • Filters are saved using the advanced filter panel, for more information please refer to how to use the advanced filter.

Advanced Filter
​

image.png
  • Opens the advanced filter panel for advanced filtering.

  • Number indicator displays the number of applied filter criteria to the Cash Book screen.

  • For more information, refer to the advance filter articles we linked above.

Cog

image.png
  • Contains a list of actions which can be carried out on the enquiry.

    • Configure Columns - Customise the displayed columns in the best order to suit your needs. For more information please refer to Configure Columns.

    • Clear Criteria - Clears all the filter criteria that you have added directly for a column displayed. Doesn't clear the filter you have added to the Advanced Filter panel.

    • Reset Sorting - Removes any sorting that you've set on all displayed columns.

    • Reset Default Column Width - Resets all column widths to their default size.

    • Export to Excel - All - Exports all the records on the Cash Book screen for the columns displayed on the screen.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

        • The current limit is set at 500,000 rows to protect the performance.

        • You can run several exports at the same time, even from the same screen and you'll be notified individually as each one is completed.

    • Export to Excel Current View - Exports the currently displayed or loaded records and columns, the default is to load 100 records.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

      • Once you scroll past the 100th record, this loads another 100 records. This is done to make sure that you don't come across any performance issues when you have hundreds of thousands of records.

Hide Grouping

  • You can select to group by any column when this option is on by dragging a column into the drag and drop columns header for grouping field.

  • You can group multiple columns.

  • You can also sort on columns when you are grouping.

  • You can turn this option off to allow for more space for your transactions by clicking on Hide Grouping.

  • You can turn grouping back on by clicking on Show Grouping.

The Grid

  • Default columns are displayed when the Cash Book screen opens. You can change by manually dragging and dropping the columns to where you want them or alternatively you can customise your columns using the Configure Columns.

  • Each column is sortable, and you can sort on multiple columns at the same time.

  • You can filter on all columns by pointing to the column label and clicking on the

    image.png

    icon to open the filter window.

  • You can increase and decrease the column width and the settings are saved for you so you to only have to do this action once.

  • The Totals at the bottom right-hand side of the screen are made up of the Balance Home and Unreconciled Home totals of the displayed records.

    • When you select a record, the Totals will reflect the totals of the selected record only.

    • When you select a record which has a different currency to your database's currency, you can see a currency switcher in the Totals section at the bottom of the enquiry screen.

Hyperlinks - Nominal Account Code and Nominal Account Name

  • You can click on the hyperlinks on the account code or name columns to view the account record. The record opens in View mode and if your security permissions has edit permissions, you can edit the account.

    • If you don't have access to edit supplier records, instead of an Edit button, you will see a Close button on the supplier record.

Action Panel -
Access Corrections and other options

Did this answer your question?