Registers

Find, Filter, Import and Export Cash Book Entries

The Cash Book list is the operator table for non-sale cash movement. It supports date filtering, field search, pagination, import, selected export, selected delete and refresh.

Menu path
Manage -> Cash Book
Verified from
Posnic demo and current POS source reviewed on 2026-09-08
Technical source evidence

frontend/modules/settings_write.html view_expenses table toolbar and filters, frontend/static/script/js/modules/js/expenses.js expensesTable exportExpense deleteSelectedExpense, frontend/static/Import_sample_files/expenses.csv

Cash Book listWhen no entries exist, the page prompts the operator to create the first entry or import a CSV file.
New entry sourceEntries created from this form appear in the Cash Book list.
Report exportUse the report when the owner needs date-range evidence across branches.

List Controls

ControlSource surfaceUse it for
Rows per pageview_expenses_per_pageShow 5, 10, 25, 50 or 100 entries.
Date rangeview_expenses_daterangeFilter entries by business date/time.
Field selectorview_expenses_fieldsSearch Type, Category, Recipient or Approved By.
Search inputview_expenses_inputEnter the matching text for the selected field.
Importexpense_importImport Cash Book rows from a CSV file.
Export selectedexpenses_exportbtnExport checked rows from the table.
Delete selectedselected delete toolbarDelete checked rows when permitted.
Refreshrefresh toolbarReload the list after saving or changing filters.

Filter the List

  1. Open Manage -> Cash Book.
  2. Choose the date range when checking a shift or month.
  3. Select a field: Type, Category, Recipient or Approved By.
  4. Enter the search value.
  5. Click Apply.
  6. Review entries and totals shown in pagination.
  7. Click Clear before starting a different search.

Import Cash Book CSV

Use import when moving a controlled set of expense rows into Posnic. The sample file in the POS source uses amount, type, category, recipientname, approvedby and description columns.

  • Use this header row: amount,type,category,recipientname,approvedby,description.
  • Use type values credit for Money In and debit for Money Out when preparing CSV.
  • Keep amount numeric.
  • Use category names consistently before importing many rows.
  • Keep recipientname and approvedby short enough for the Cash Book form rules.
  • Import a small test file before importing a full month.
  • Open Reports -> Money -> Cash Book after import to review the result.

Export Selected Entries

  1. Filter the list to the rows you need.
  2. Tick the checkbox beside each entry.
  3. Confirm the selected count is correct.
  4. Click Export Selected.
  5. Open the exported file and compare amount, type, category, approved-by and note.
  6. Use the report export instead when the owner needs every entry in a date range.

Delete Selected Entries

Delete is controlled by expense delete permission. Use it only for duplicates or test entries approved for cleanup.

  • Export first if the business keeps evidence of corrections.
  • Do not delete a real cash movement to make close totals look easier.
  • If Recycle Bin is enabled, deleted records can be reviewed there according to the shop policy.
  • If Recycle Bin is off, deletion may not be recoverable from the normal UI.
  • Prefer edit when the entry is real but one field is wrong.

Related Manual Pages

Registers Create Cash Book Entry The Add Cash Book Entry panel is the daily form for non-sale cash movement. The required fields are date, amount, type and note; optional fields make the entry easier to audit later. Registers Review Cash Book Entries Saved Cash Book rows can be opened for detail review, edited when a field is wrong, reset during editing, or deleted when the row is a duplicate or test entry. Settings Recycle Bin Recycle Bin keeps deleted records searchable and restorable when the feature is enabled and the user has permission. Reports Cash Book Reports Cash Book and Expense Reports explain non-sale money movement. They are essential when profit and loss includes Cash Book entries.