# Phase 4C manual test script: statements and reports

For the treasurer or accountant. About 25 minutes. The rules are also proved by
`tests/Feature/StatementsAndReportsTest.php`:
- the direct and indirect cash flows agree with each other and with the cash balances;
- prior-year figures are correct;
- the notes agree to the statement;
- the service, source and reconciliation figures are correct;
- every report downloads in every format.

This script checks what people see.

**Staff app:** http://localhost/church_acct_app/public/app
**Login:** demo church **treasurer@demo.church.test** (no two-factor). See `docs/test-logins.md`.
For the letterhead, an administrator or content editor sets the church's name, logo, address, phone and
email under **Website › Settings**. In the demo church the administrator uses the password you set on 18 Oct.

## A. Letterhead and downloads

1. [ ] (Administrator) **Website › Settings**: make sure the church name, address, phone and email are filled
   in and a PNG or JPEG logo is chosen.
2. [ ] **Reports › Statement of Financial Position**: the top of the report shows the logo, name, address
   and contacts. Choose a branch with its own address: the branch name and address are shown instead.
3. [ ] Press **Excel**: the file opens in Excel with the church name at the top, real numbers (they add
   up with =SUM), negatives in brackets and bold totals.
4. [ ] Press **PDF**: an A4 PDF on the letterhead, landscape when the report is wide. Press **CSV**: it
   still downloads as before.
5. [ ] Change the dates or the cost centre, press **Run**, then **PDF**: the PDF uses the same filters.
6. [ ] Open a receipt PDF (Giving › a posted batch › a receipt), a payment voucher PDF and a bank
   reconciliation PDF. Each carries the same letterhead.

## B. Statements

7. [ ] **Statement of Income & Expenditure**: a **Prior year** column after Total, with the same dates a
   year earlier. The notes say which dates.
8. [ ] **Statement of Financial Position**: two columns, the date chosen and the last 31 December.
9. [ ] **Notes to the Statement of Financial Position**: Note 1 Cash and Bank, Note 2 Receivables and so
   on, each with its accounts. Each note's total matches the accounts on the statement, and Total funds
   matches Total Funds there.
10. [ ] **Statement of Cash Flows** for this year:
    - operating, investing and financing sections, each with what was received and paid;
    - cash at the start plus the net movement equals cash at the end, which matches the cash and bank
      accounts in Note 1 without Fixed Deposits (those are investments, not cash);
    - the reconciliation at the bottom ends on the same "Net cash from operating activities" as the top
      section;
    - no WARNING notes.

## C. Other reports

11. [ ] **Tithes and Offerings by Service**: one block per service name, categories underneath, a column
    for each month with giving, and totals.
12. [ ] **Income by Source**: columns such as Service giving, Sales, Journals. The "Total income" figure
    equals Total Income on the Statement of Income & Expenditure for the same dates.
13. [ ] **Bank Reconciliation Statements** for this year: each reconciliation set out as bank balance,
    receipts and payments not yet on the statement, adjusted balance, cash book and difference. Unsigned
    ones say NOT SIGNED OFF in red.
14. [ ] **Reports › Email reports on a schedule**: the new reports can be chosen, and a "Send now" in
    Excel or PDF arrives on the letterhead.

## Sign-off

| Section | Checked by | Date | Notes |
|---|---|---|---|
| A Letterhead and downloads | | | |
| B Statements | | | |
| C Other reports | | | |