iDARMS Frontend (Back Office) — Accounting & Finance Module Acceptance Tests¶
Test series: IDA-ACC-01 to IDA-ACC-10
Objective: Validate that the chart of accounts, journals, ledgers, statements, and financial reports load with correct data, filters, and export behaviour.
Execution ownership¶
Recommended owners: System Super-Admin; Finance/Accountant business owner
Prerequisites: A signed-in administrator, seeded accounting data, and a controlled UAT environment.
Execution control
Use approved UAT data only. Mask personal, authentication, and payment information in screenshots and attachments.
Feature overview¶
The Accounting & Finance module covers:
- Chart of Accounts — account creation, editing, and the expandable accounts list.
- Journal — multi-line journal entry creation, list, and details.
- General Ledger, Trial Balance, Income Statement, Balance Sheet, Cash Book, and Bank Book.
- Reports — Expense, Revenue, Accounts Receivable, Accounts Payable, Budget, Collection, Tax, and Audit reports.
Reports share period/date-range, region, and MMDA filters and provide print, Excel, and PDF export.
Coverage summary¶
| Test ID | Feature | Scenario | Priority |
|---|---|---|---|
| IDA-ACC-01 | Chart of Accounts | Account add/edit and list | Critical |
| IDA-ACC-02 | Journal | Journal entry and list | Critical |
| IDA-ACC-03 | General Ledger | Ledger view | High |
| IDA-ACC-04 | Trial Balance | Balance verification | High |
| IDA-ACC-05 | Statements | Income statement and balance sheet | High |
| IDA-ACC-06 | Books | Cash book and bank book | High |
| IDA-ACC-07 | Reports | Collection, revenue, AR and AP | High |
| IDA-ACC-08 | Reports | Expense, budget, tax and audit | Medium |
| IDA-ACC-09 | Filters | Period, region, MMDA and account filters | High |
| IDA-ACC-10 | Export | Print, Excel and PDF | High |
Implementation observations requiring UAT confirmation¶
| Observation from implementation | Required validation |
|---|---|
| Journal entries must balance (total debit equals total credit) and need at least two lines; unbalanced entries are blocked. | Confirm the approved journal rules. |
Expense, Budget, Tax, and Audit reports run with demo data (USE_DEMO_DATA = true) while their export buttons call real endpoints. |
Confirm whether these reports are in scope for live data. |
| Journal delete uses a Popconfirm with no approval step; journals are saved directly on submit (no approval flow). | Confirm the approved journal control. |
Report export uses ?isExcelPrint=1 for Excel and client-side rendering for PDF; print uses a hidden iframe or window.print(). |
Confirm the approved export behaviour. |
| The trial balance shows a balanced/unbalanced status with opening/period/closing differences. | Confirm the approved balance indicator. |
IDA-ACC-01 — Chart of accounts¶
Feature overview¶
The Chart of Accounts pages at /accountingfinance/addaccount (and edit) and /accountingfinance/listchart manage accounts in a hierarchy.
Preconditions
- A signed-in administrator; account types and parent accounts available.
| Field | Value |
|---|---|
| Priority | Critical |
| Test action | Create an account, edit it, and review the list. |
| Expected result | Accounts are created/updated and appear in the tree. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Add account | 1. Open /accountingfinance/addaccount.2. Complete Account Type, Number, Name, Status, and save. |
"Account has been successfully created." notification appears and the list opens. | PASS |
POST /financial/addnewaccount. |
| Required fields | 1. Submit without type/number/name/status. | Field-level errors appear. | PASS |
|
| Edit account | 1. Open the edit page for an account. | The account pre-fills and updates save. | PASS |
PATCH /financial/editaccount/{id}. |
| List | 1. Open /accountingfinance/listchart. |
The expandable account tree renders with status and adjustment tags. | PASS |
|
| New Account | 1. Click New Account. | The user is navigated to the add page. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-02 — Journal¶
Feature overview¶
The Journal pages create balanced multi-line journal entries, list them, and show details.
Preconditions
- A signed-in administrator; child accounts and beneficiary sources available.
| Field | Value |
|---|---|
| Priority | Critical |
| Test action | Create a balanced journal entry, review the list, and open details. |
| Expected result | Balanced entries save once; unbalanced entries are blocked. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Add journal | 1. Open /accountingfinance/addjournal.2. Add two lines with account, beneficiary, description, and debit/credit. |
Totals display for debit and credit. | PASS |
|
| Balanced save | 1. Ensure totals match and save. | "The journal entry has been created." appears. | PASS |
POST /financial/addnewjournal. |
| Unbalanced | 1. Enter unequal totals and submit. | "Journal is not balanced" error blocks the request. | PASS |
|
| Minimum lines | 1. Try to reduce below two lines. | "Two lines are required" error appears. | PASS |
|
| Journal list | 1. Open /accountingfinance/listjournal. |
Journals render with thread, date, description, account, and amounts. | PASS |
|
| Journal details | 1. Open a journal's details. | Lines and totals render (view-only). | PASS |
|
| Delete | 1. Delete a journal and confirm. | "The journal entry has been removed." appears. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-03 — General ledger¶
Feature overview¶
The General Ledger at /accountingfinance/generalledger shows per-account debit/credit activity and ending balances.
Preconditions
- A signed-in administrator with posted transactions.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Apply filters and review the ledger. |
| Expected result | Ledger accounts and balances render and reconcile. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Ledger load | 1. Open /accountingfinance/generalledger. |
Per-account trees render with Date, Reference, Description, Debit, Credit, and Balance. | PASS |
|
| Filters | 1. Apply period/date range, region, MMDA, search, ratepayer, and account filters. | The ledger filters. | PASS |
|
| Summary | 1. Inspect the summary cards. | Accounts/transactions/opening totals render. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-04 — Trial balance¶
Feature overview¶
The Trial Balance at /accountingfinance/trailbalance shows opening/period/closing balances with a balance status.
Preconditions
- A signed-in administrator with posting data.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Review the trial balance and the balance status. |
| Expected result | Balances render and the balanced/unbalanced indicator matches the totals. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Trial balance load | 1. Open /accountingfinance/trailbalance. |
The hierarchical balance table renders. | PASS |
|
| Balance status | 1. Inspect the status. | "Trial balance is balanced" or "requires review" with differences. | PASS |
|
| Zero balance toggle | 1. Toggle show/hide zero balances. | The view updates. | PASS |
|
| P/L summary | 1. Inspect the profit/loss panel. | Income/expense/profit-loss summary renders. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-05 — Statements (income statement and balance sheet)¶
Feature overview¶
The Income Statement and Balance Sheet pages at /accountingfinance/incomestatement and /accountingfinance/balancesheet present account hierarchies with totals.
Preconditions
- A signed-in administrator with period data.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Open both statements and review the totals. |
| Expected result | The statements render with current/previous period values and balanced totals. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Income statement | 1. Open /accountingfinance/incomestatement. |
Current/previous/variance columns and net profit render. | PASS |
|
| Balance sheet | 1. Open /accountingfinance/balancesheet. |
Assets, liabilities, and equity sections with totals render. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-06 — Cash book and bank book¶
Feature overview¶
The Cash Book and Bank Book pages present receipt/payment (and debit/credit) movements with running balances.
Preconditions
- A signed-in administrator with cash/bank transactions.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Review both books and their filters. |
| Expected result | Books render with opening/closing balances and totals. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Cash book | 1. Open /accountingfinance/cashbook. |
Receipts and payments panes render with running balance and summary cards. | PASS |
|
| Bank book | 1. Open /accountingfinance/bankbook. |
Date, cheque, voucher, particulars, debit, credit, and balance render. | PASS |
|
| Account filter | 1. Filter by account/bank account. | The book filters. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-07 — Collection, revenue, AR and AP reports¶
Feature overview¶
The Collection, Revenue, Accounts Receivable, and Accounts Payable reports summarize transactions with filters and totals.
Preconditions
- A signed-in administrator with transactions and report data.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Open each report and verify the totals. |
| Expected result | Each report renders its grid, totals, and filters. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Collection report | 1. Open /accountingfinance/collectionreport. |
Collection grid, summary, and pagination render. | PASS |
|
| Revenue report | 1. Open /accountingfinance/revenuereport. |
Revenue tree with variance and growth render. | PASS |
|
| Accounts receivable | 1. Open /accountingfinance/accountsreceivable. |
Billed/collected/balance render with summary. | PASS |
|
| Accounts payable | 1. Open /accountingfinance/accountspayable. |
Billed/paid/payable render with summary. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-08 — Expense, budget, tax and audit reports¶
Feature overview¶
The Expense, Budget, Tax, and Audit reports present analytics dashboards.
Preconditions
- A signed-in administrator.
| Field | Value |
|---|---|
| Priority | Medium |
| Test action | Open each report. |
| Expected result | Each report renders its charts, cards, and table. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Expense report | 1. Open /accountingfinance/expensereport. |
Expense tree, charts, and stat cards render. | PASS |
Uses demo data. |
| Budget report | 1. Open /accountingfinance/budgetreport. |
Budget/actual/variance and status render. | PASS |
Uses demo data. |
| Tax report | 1. Open /accountingfinance/taxreport. |
Tax buckets and status render. | PASS |
Uses demo data. |
| Audit report | 1. Open /accountingfinance/auditreport. |
Findings, score, and timeline render. | PASS |
Uses demo data. |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-09 — Filters¶
Feature overview¶
Reports share period/date-range, region, MMDA, and account filters that drive the data queries.
Preconditions
- A signed-in administrator on a report page.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Apply each filter and observe the report. |
| Expected result | The report data updates with the applied scope. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| Period/date range | 1. Select a period and date range. | The report reloads for the period. | PASS |
|
| Region/MMDA | 1. Select a region and/or MMDA (when permitted). | The report scope narrows. | PASS |
|
| Account/ratepayer | 1. Select accounts or ratepayers. | The report filters. | PASS |
|
| Search | 1. Use the reference/bill search. | The report filters by reference. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.
IDA-ACC-10 — Export¶
Feature overview¶
Reports provide Print, Excel, and PDF export actions.
Preconditions
- A signed-in administrator on a report page with data.
| Field | Value |
|---|---|
| Priority | High |
| Test action | Use each export action. |
| Expected result | Print opens, Excel downloads, and PDF renders. |
| Execution result | PASS |
| Evidence reference | Insert link or reference |
| Defect reference | Insert ID or None |
Test scenarios
| Scenario | Test steps | Expected result | Pass/Fail | Remarks |
|---|---|---|---|---|
| 1. Click the print action. | The print preview opens. | PASS |
||
| Excel | 1. Click the Excel export. | An .xlsx file downloads. |
PASS |
isExcelPrint=1. |
| 1. Click the PDF export. | A .pdf file renders/downloads. |
PASS |
Client-side render. | |
| Not-ready state | 1. Export before data loads. | A "not ready to print" message appears. | PASS |
Tester notes
Record actual result, test data identifiers, device/browser/build, and any variance.