# Phase 7A manual test script: consolidation and drill-down

For the HQ Administrator (or an HQ Finance officer), about 20 minutes. The rules are also proved by
`tests/Feature/ConsolidationTest.php`, which is the Release R3 exit test:
- each branch column is that branch's own books;
- remittances are eliminated on both sides;
- an entry posted on one side only shows as unmatched;
- regions, schedules and access.

**Logins (demo church):**
- **admin@demo.church.test**: with the password you set on 18 Oct;
- **auditor@demo.church.test** (read-only): also opens it.

The demo church has Headquarters, Lekki and Enugu, and a remittance from Lekki to Headquarters with a part payment.

## A. The whole church

1. [ ] **Headquarters (Directs) › Consolidation**. The trial balance opens for the whole church today, with the
   columns Grace Assembly (Demo), Lekki Branch, Enugu Branch, Eliminations and Consolidated.
2. [ ] The green box says "The consolidated figures tie to the sum of the branches", with two ticks.
3. [ ] The four lines marked **inter-branch** each have the branch figures and the opposite figure under
   Eliminations, and nothing under Consolidated:
   - 12040 Due from Branches;
   - 23020 Remittances Payable;
   - 42010 Branch Remittances Received;
   - 54080 Remittances to HQ.

   **Eliminations** at the bottom says 2 journals were matched.
4. [ ] Open **Income and expenditure**, then **Financial position**, then **Cash flows**. Each has its green
   box:
   - the surplus agrees with the church's statement;
   - assets equal liabilities, funds and surplus in every column;
   - opening, movement and closing cash equal the branches.

## B. Drill down

5. [ ] On the trial balance, click Grace Assembly's figure on **12040 Due from Branches**. The general ledger
   opens for that account, for Headquarters alone. The closing balance is the figure you clicked.
6. [ ] Click a journal number (JV-LEK-…): the journal opens, with its lines in both branches and its history.

## C. Something one-sided

7. [ ] In Enugu, record a general journal: Dr 12040 Due from Branches ₦7,500, Cr 11010 Cash on Hand ₦7,500,
   "Cash sent to HQ". A second person posts it.
8. [ ] Back in **Consolidation**, the trial balance still ties, but **Eliminations** shows a red box:
   "Unmatched inter-branch differences: ₦7,500.00", with the journal and Enugu. The ₦7,500 stays in
   Consolidated on line 12040.
9. [ ] Reverse that journal (a second person posts the reversal). The red box goes.

## D. Downloads and schedules

10. [ ] Download the trial balance as **Excel** and **PDF**. The notes underneath say which checks tie and how
    many journals were eliminated.
11. [ ] **Reports** → **Email reports on a schedule**: the list of reports now includes "Consolidated trial
    balance", "Consolidated income and expenditure" and so on. Choose one and send it to yourself.

## E. Access

12. [ ] As a branch treasurer, `/directs/consolidation` says "Not found".