Cash reports

This page describes cash reports, including creation, document assignment, closing, reopening, and balance updates.

Cash report list showing report statuses and balances

⚙️ How to enable the module

Cash reports are available after setup. Assign Cash Report Number Series in Cash Documents Setup and give users N24CMG CASH MGMT.

📋 Cash report list

The Cash Reports page is the central place for managing reports. It shows the report number, register, status, opening and closing dates, opening and closing balances, and report turnover.

📄 Cash report card

The header contains the report status, register, number, dates, currency, turnover, opening balance, closing balance, and responsibility center. Report lines list the posted cash receipts and withdrawals assigned to the report.

✍️ Creating a new report

  1. Create a report. The system selects the user’s assigned register or opens register selection.
  2. The opening balance is set automatically to the closing balance of the previous closed report for the register.
  3. Posted cash documents are assigned automatically while they are posted.

🔒 Closing a cash report

  1. On the report card, select Close.
  2. Enter the closing date.
  3. The system validates that the date is not earlier than the latest document date.
  4. The report changes to Closed and the closing balance is calculated and saved.
  5. Opening and closing balances of later reports are recalculated automatically.
Important

Before closing a report for a foreign-currency register, run Correct Bank Account Exchange Rate from the Cash Registers page. This creates exchange rate adjustment entries and aligns the report balance with the register balance.

🔓 Reopening a closed report

  1. On a closed report, select Reopen.
  2. The system checks that no other report for the register is open.
  3. The report returns to Open and can receive documents again.

🚫 Validations

Situation System behavior
An open report already exists for the register Creating another report is blocked.
The report has no lines Closing is blocked.
The report contains documents Deleting the report is blocked.
The closing date is earlier than a document date The system displays an error.
Another report for the register is open Reopening is blocked.
Note

Pressing ESC on a new unsaved report without a number or opening date cancels it.

📌 Backdated updates

A backdated cash receipt can be assigned to an earlier closed report, or the system can create a report for the receipt. Opening and closing balances of the affected and later reports are then recalculated.

🖨️ Printing a report

Print Report generates the cash report using the report configured in Cash Report Selection.

🏦 Foreign-currency cash

Before closing a report for a foreign-currency register:

  1. Open Cash Registers and select the register.
  2. Run Correct Bank Account Exchange Rate.
  3. The system creates exchange rate adjustment entries in Bank Account Ledger Entries.
  4. Close the cash report after the adjustment is complete.

This keeps the report balance in local currency aligned with the register balance.