Scenario:
The bank statement is received in a physical or non‑importable format and must be entered manually.
Action:
User opens Bank Statement Entry, selects bank account, and manually enters statement details such as date, reference number, description, debit/credit amount.
Outcome:
ERP saves the entered bank statement lines and keeps them pending for confirmation and reconciliation.
Scenario:
User receives bank statement in Excel format from the bank.
Action:
User selects Import Statement, uploads Excel file, maps required columns (date, ref no, debit, credit, amount), and validates the data.
Outcome:
ERP imports all statement lines successfully and displays them in the Bank Statement Entry screen.
Scenario:
After reviewing uploaded or manually entered statement data, the user is ready to proceed with reconciliation.
Action:
User clicks Confirm on the Bank Statement Entry screen.
Outcome:
ERP locks the statement data, marks it as Confirmed, and makes it available for Bank Reconciliation.
Scenario:
Uploaded statement contains errors such as duplicate reference numbers, negative amounts, or missing debit/credit flags.
Action:
System performs validations during entry/import and displays error or warning messages.
Outcome:
ERP prevents confirmation until errors are corrected, ensuring clean data for reconciliation.
Scenario:
Bank statements are uploaded periodically (daily, weekly, or monthly).
Action:
User uploads new statement files for the same bank account with unique date ranges.
Outcome:
ERP maintains separate statement batches with upload date, period, and user reference for audit and tracking.
Scenario:
User identifies incorrect entries before confirming the bank statement.
Action:
User edits or deletes statement lines while the statement status is Unconfirmed.
Outcome:
ERP updates the statement data and allows re‑validation before confirmation.
Scenario:
User attempts to reconcile bank transactions without confirming the statement.
Action:
System checks the statement status during Bank Reconciliation access.
Outcome:
ERP restricts reconciliation and prompts the user to confirm the bank statement first.