Reconciliation Summary (7000/7100)
The client institution and Hecto Financial compare previous-day deposit, cancellation, and withdrawal counts and amounts.
Message Information
| Item | Request | Response |
|---|---|---|
| Transaction type | 7000 | 7100 |
| Scheduled delivery | Approximately 00:35 daily | Immediately after processing |
| Scope | Previous-day transactions across all enabled banks | Client institution's ledger totals |
Hecto Financial
Client Institution
11. Previous-day summary (7000)
1. Previous-day summary (7000)
22. Client summary response (7100)
2. Client summary response (7100)
The client may also implement an on-demand reconciliation request.
Individual Body
| No. | Field | MODE | Length | Offset | Request | Response | Description |
|---|---|---|---|---|---|---|---|
| 1 | Common header | - | 70 | 0 | ● | ○ | Common Header |
| 2 | Successful deposit count | N | 7 | 70 | ● | ⊙ | Number of successful deposits |
| 3 | Successful deposit amount | N | 13 | 77 | ● | ⊙ | Total successful deposits |
| 4 | Cancelled deposit count | N | 7 | 90 | ● | ⊙ | Number of cancelled deposits |
| 5 | Cancelled deposit amount | N | 13 | 97 | ● | ⊙ | Total cancelled deposits |
| 6 | Successful withdrawal count | N | 7 | 110 | ● | ⊙ | Number of successful withdrawals |
| 7 | Successful withdrawal amount | N | 13 | 117 | ● | ⊙ | Total successful withdrawals |
| 8 | Cancelled withdrawal count | N | 7 | 130 | ● | ⊙ | Number of cancelled withdrawals |
| 9 | Cancelled withdrawal amount | N | 13 | 137 | ● | ⊙ | Total cancelled withdrawals |
| 10 | Fee count | N | 7 | 150 | ● | ○ | Unused, 0000000 |
| 11 | Fee amount | N | 13 | 157 | ● | ○ | Unused, 0000000000000 |
| 12 | Filler | AN | 30 | 170 | ● | ○ | SPACE |
Processing
- Hecto Financial sends its previous-day totals for all banks used by the institution.
000in the common-header bank code identifies an all-bank summary.- The client stores the received totals.
- The client independently calculates totals from its ledger.
- The client places its own totals in the
7100response. - If totals differ, compare transactions to identify missing or duplicate posting.
Do Not Echo the Received Totals
The response must contain totals independently calculated from the client institution's ledger. Echoing Hecto Financial's values prevents meaningful reconciliation.
Recommended Reconciliation Rules
- Use one consistent transaction-date basis.
- Keep successful and cancelled deposits as separate totals.
- Include system cancellations in cancelled-deposit totals.
- Count a retried message only once using its original unique key.
- Compare masked transaction number, amount, and status rather than raw personal data.
Need technical support?
Code Samples
HectoFinancial GitHub