Fujitsu Services
FUJ00085352
FUJ00085352
NETWORK BANKING gg NI Ref: CS/SPE/O11
RECONCILIATION RB
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
Document Title:
Document Type:
Release:
Document Status:
Originator & Dept:
Contributors:
Internal Distribution:
External Distribution:
Approval Authorities:
BANKING END TO END RECONCILIATION
Recoi€iliation Report Specification (ATS)
BI3 S80
This document specifies the reconciliation report output to
satisfy the end to end reconciliation of the Network Banking
Stream
WITHDRAWN
Richard Hicks, Fujitsu Services RASD
Richard Brunskill: Fujitsu Services, Linda Austin: Post Office
Ltd.
Fujitsu Services: Tom Northcott; Dave Johns; John Moran;
Michael King; Angela Shaw; Mark Farry; Janusz Hollender;
Nick Lawman; Mark Taylor; Tony Drahota; Mik Peach; Anne
Chambers.
Post Office Ltd.: Linda Austin; Jason Crellin; Chris Allen; David
Gray; Tony Baines; Bob Booth; Victoria Noble
Name Position Signature Date
Bill Reynolds S80 Programme Manager
Gareth Jenkins Fujitsu. Services RASD
Design Authority
Victoria Noble
Post Office Ltd. / BDA
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE, Page: 1 of 3
Fujitsu Services
NETWORK BANKING
Ri
o
ECONCILIATION REQ@Q
Version: WD
FUJ00085352
FUJ00085352
N Ref: CS/SPE/O11
COMMER‘ IDENCE Date: 03-Mar-2016
0.0 Document C
0.1. Documen
ory
Version No.
Date
Reason for Issue
Associated
CP/PinICL
0.1
OH. oe
First draft for review
0.2
01
Second draft for review following Post Office
Ltd. discussion workshop and other comments
from reviewers.
0.3
02/08/01
Third draft for review following Post Office Ltd.
discussion workshop and other comments from
reviewers.
04
27/09/01
Fourth draft for review following Post Office
Ltd. discussion workshop and other comments
from reviewers.
0.5
03/12/01
Fifth draft for review following Post Office Ltd.
discussion workshop and other comments from
reviewers.
1.0
19/12/01
REMOVED FROM APPROVAL CYCLE
Ll
08/01/02
REMOVED FROM REVIEW CYCLE
2.0
16/01/02
REMOVED FROM APPROVAL CYCLE
2.1
22/01/02
Sixth draft for review following amendments
incorporated as a result of IBM_ interface
changes and late Post Office Ltd. comments
received against Version 1.0 (now removed)
CR27
2.2
27/02/02
Seventh draft for review following amendments
as a result of two workshops between Fujitsu
Services and Post Office Ltd. on 6&7 February,
and 20/21 February 2002 and _ informal
comments received from Fujitsu Services.
3.0
21/03/02
Eighth draft for approval following review
comments
3.1
12/07/02
Draft for review following:
¢ Correction of typos
e Inclusion of 3 definitions outstanding from
V3.0
4.0
29/07/02
Final Version for approval
Post Office Ltd. comments: Marion Dale added
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE, Page: 2 of 3
Fujitsu Services
NETWORK BANKING
RECONCILIATION RB
Version: WD
Ref: CS/SPE/O11
COMMER‘ IDENCE Date: 03-Mar-2016
FUJ00085352
FUJ00085352
jitsu Services comments:
ny Drahota to approval authority
Change of date format within ‘Receipt
Time’ on NB102 sections from hhmmss to
hh:mm:ss (cosmetic change to report only —
not requiring review)
e ICL replaced with Fujitsu. Services
throughout
41
01/11/02
Draft for review
Changes are highlighted.
CP 3348
5.0
09/12/02
Comments responded to with out the need for
any changes
5.1
10/12/03
Draft for review of changes only
Changes are highlighted:
© NB1O03 report expanded
¢ NBIOI extended for BI3 S70
¢ Removal of ‘NBE’
CP 3539
CP 3556
6.0
24/12/03
Minor typing errors corrected.
Issued for approval.
6.1
29/09/04
Draft for review of changes only:
e Removal of NB103 report due to Impact
(S80).
e CAP no longer populated
© Minor typing errors corrected
7.0
15/11/04
Changes as a result of comments:
¢ Outlet renamed to Branch
¢ Release clarified in section 2
© Clarified in section 2 that this document
covers NBS, DCS and ETS
e Report titles: the word “TIP” replaced by
“POL FS”
¢ Section 3.3.1 Point 21, Transaction Types
updated.
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE Page: 3 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING $
RECONCILIATION REQQ
N Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
[B101 Report Layout diagram had the
phras® “Barclays etc” against the client
ading. Barclays is an Institution within the
INK network therefore the client name is
corrected to read “LINK”. This change is
repeated in each subsequent report Layout
e.g. pages 22, 25, 27 etc.
¢ Minor typing errors corrected
Issued for approval.
WD 03-Mar-2016 I WITHDRAWN: Replaced by CCN1200
SVM/SDM/SD/0020. Specified in CCN1200
attachment 4. Finally withdrawn as a result of
check carried out under internal CP1730.
0.2 Review Details
Review Comments by :
Review Comments to :
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 4 of 3
o
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING N Ref: CS/SPE/O11
RECONCILIATION REQ@Q
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
Mandatory Review Authority Name
Fujitsu Services RAS A ~ I Gareth Jenkins *
Fujitsu Services DeSfgn Tom Northcott
Fujitsu ServicayC John Moran *
Post Offigg td. Tony Baines *
Optional Review / Issued for Information
Fu, "anne Manager Bill Reynolds
Fujitsu Servic€S Design Manager Kevin Watson
Fujitsu Services Testing ITU Janusz Hollender
Fujitsu Services CS SSC Mik Peach *
Fujitsu Services CS SSC Anne Chambers
Post Office Ltd. Bob Booth *
Post Office Ltd. Chris Allen
Post Office Ltd. David Gray
Post Office Ltd. Jason Crellin *
Post Office Ltd. Linda Austin
Post Office Ltd. Victoria Noble
( * ) = Reviewers that returned comments
0.3. Associated Documents
Reference Version I Date Title Source
PA/TEM/001 7.0 2™ April 2002 I Fujitsu Services Document PVCS
Template
NB/SPE/002 Network Banking DRS On- _ I Fujitsu
line Workstation Services
Specification PVCS
NB/PRO/002 Network Banking Fujitsu
Reconciliation & Incident Services
Management PVCS
Unless a specific version is referred to above, reference should be made to the current
approved versions of the documents.
0.4 Abbreviations/Definitions
Abbreviation Definition
Authorised Client
This signifies projected settlement awaiting the Confirmed Client
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE,
Page: 5 of 3
Fujitsu Services
FUJ00085352
FUJ00085352
NETWORK BANKING $
RECONCILIATION REQ
x Ref: CS/SPE/O11
WD
03-Mar-2016
Version:
COMMER‘ IDENCE Date:
Transaction Awaiting
Confirmation
a system perspective, an ‘S’ transaction — Not
letwork Banking Reports.
Bank_Transaction_}
sequence number assigned by the message originator
cept Horizon), to assist in identifying a transaction uniquely.
St®s unchanged through the life of the transaction.
C4 Procegging The System Processing Date on which the ‘C4’ was received by
the DRS. Where a C4 is included on report NBIO1, the C4
Processing Date is the same as the Run Date for report NB101.
C4 Seti ate The Settlement Date provided on the C4 transaction.
Confirmed Client From a ‘Client’ perspective, a transaction that has been authorised
Transaction to either debit or credit an account. From a system perspective, a
“C4 transaction.
Counter Confirmations
From a Branch / Post Office Ltd. perspective, a successfully
completed transaction at the counter. From a system perspective,
a ‘C12’ transaction.
Exceptioned Client
Transaction
From a Client perspective, a transaction reconciliation difference
highlighted and notified to the DRS. From a system perspective, a
‘D’ transaction.
Exception Types
Within all reports the ‘Exceptions’ category will include:
¢ ‘Incomplete States’, i.e. those transactions where one or more
transaction component is missing — a C4 without a C12 etc
Genuine exceptions where transaction components belonging
to the same high level transaction have been exceptioned, e.g.
C12 (amount) not = to C4 (amount).
e Transaction corruptions
Horizon_Txn_Num
Unique transaction number to be used in all messages between
Horizon and the FI’s relating to the transaction. Generated by
Horizon and provided in the request message initiating the
transaction.
‘New’ Transactions
Transactions that have had a change of state since they were last
reported, or have never been reported except in NB102 section 6.
Note that if a transaction appears in NB102 section 6 it is future
dated as is reported in that section for information only. Once
future dated transactions become current dated, they must be
reported as though they have not appeared on the reports before.
‘Old’ Transactions
Transactions that have NOT had a change of state since they were
last reported.
POL FS Transactions
From a Branch / Post Office Ltd. perspective, a transaction that
has been sent from TPS to Post Office Ltd. POL FS. From a
system perspective, a ‘C112’ transaction.
Receipt Date
Receipt Date is the Date as printed on the transaction Receipt at
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE, Page: 6 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING g
RECONCILIATION REQQ
x Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
t forms part of all transactions.
Receipt Time Time is the Time as printed on the transaction Receipt at
er. It forms part of all transactions.
Reconciliation Date is the date attributed to a transaction to
allow Post Office Ltd. to reconcile. It will be set the first available
Bank Settlement date from the transaction elements (C112, C12,
C4, S & D) that make up a Network Banking transaction. If no
Bank Settlement date is available, the Reconciliation Date will be
set to the processing date that the Data Reconciliation Service first
recorded any element of the transaction being received. If a
Settlement date subsequently becomes available, the first available
Bank Settlement date will replace the processing date. However,
once a transaction has been accounted for on the reconciliation
reports, the Reconciliation Date will never change.
Reconciliation Da’
Routing Gateway Identifies a system, where the authorisation for a specific
transaction should be sought.
Run Date This is the System Processing Date for which the report refers, i.e.
all transaction components processed by the DRS on System
Processing Date dd/mm/yyyy are accounted for on this report.
Settlement Date Settlement Date is often the same as Run Date but some Financial
Institutions may assign a Settlement Date in the future: e.g. the
following Monday may be set on transactions processed on the
preceding Friday, Saturday and Sunday.
AIS Application Interface Specification
CAP Cash Account Period
cs Customer Service (Fujitsu Services)
DCS Debit Card System
DRS Data Reconciliation Service
ETS Electronic Top-Up Service
FI Financial Institution
FTMS File Transfer Management Service
MSU Management Support Unit (Fujitsu Services)
NBS Network Banking Service
PIN Personal Identification Number
POL FS Post Office Ltd. Financial System
RASD Requirements, Architecture & Strategy Development
TDA Technical Design Authority
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 7 of 3
Fujitsu Services
NETWORK BANKING
RECONCILIATION REQQ
FUJ00085352
FUJ00085352
o
NI Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
TPS LANs; rocessing Service
0.5 Changegih thy ersidn
Version Changes
7.0 » Changes as a result of comments:
Outlet renamed to Branch
Release clarified in section 2
Clarified in section 2 that this document covers NBS, DCS and
ETS
Report titles: the word “TIP” replaced by “POL FS”
Section 3.3.1 Point 21, Transaction Types updated.
The NB101 Report Layout diagram had the phrase “Barclays
etc” against the client heading. Barclays is an Institution within
the LINK network therefore the client name is corrected to
read “LINK”. This change is repeated in each subsequent
report Layout e.g. pages 22, 25, 27 etc.
Minor typing errors corrected
0.6 Changes Expected
Changes
None.
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE, Page: 8 of 3
FUJ00085352
FUJ00085352
Fujitsu Services Ref: CS/SPE/O11
Version: ~WD
COMMER‘ IDENCE Date: 03-Mar-2016
0.7 Table of Cont
1.0 INTRODUCYT 10
2.0 SCOPE 10
2.1 REC TL ON REPORTS SPECIFIED 11
3.0 RE 'T SPECIFICATIONS 12
3.1 IMARY REPORT 14
: fy 14
NBO000: Report Layout 15
NB000: Data Definition 16
3.2 NB101: NETWORK BANKING SETTLEMENT STATEMENT 17
3.2.1 NBIO1: Rules 17
3.2.1.1 NBIOL: Report Layout 18
3.2.1.2 NBI1O1: Data Definition 19
3.2.2. End of Report 19
3.3 NB102: EXCEPTION SUMMARY 20
3.3.1 NB102: Rules 20
3.3.11 'NB102: Section 1: All Uncleared Confirmed, Unconfirmed & POL FS exceptions 23
3.3.1.2 'NB102: Section 2: Uncleared Exceptioned Client Transactions 24
3.3.13 NB102: Section 3: Uncleared Corruptions 26
3.3.14 NB102: Section 4: Uncleared Timing Differences 28
3.3.1.5 'NB102: Section 5: Uncleared Confirmed, Unconfirmed & POL FS exceptions >24 hours 30
3.3.1.6 NB102: Section 6: Uncleared Future Dated Transactions by Client 32
3.3.1.7 NB102: Section 7: All Cleared Confirmed, Unconfirmed & POL FS exceptions 33
3.3.1.8 NB102: Section 8: Cleared Exceptioned Client Transactions 34
3.3.1.9 NB102: Section 9; Cleared Corruptions 36
3.31.10 'NB102: Section 10: Cleared Timing Differences 38
3.31.11 'NB102: Section 11: Cleared Confirmed, Unconfirmed & POL FS exceptions > 24 hours 40
3.3.1.12 NB102: Section 12: Cleared Future Dated Transactions by Client 42
3.3.1.13 Incomplete and Discrepancy State: Report Matrix 4B
3.3.1.14 Exception State: Report Matrix 44
4.0 SYSTEM STATES 45
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 9 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg
RECONCILIATION RB
N Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
compiled to specify all Fujitsu Services outputs from the Data
RS) to enable a generic end to end reconciliation of Network
processing.
This document defines the format and content of all reconciliation reports for S80
Impact (post migration), which satisfies the Network Banking reconciliation
requirement including NBS, DCS and ETS. It does not attempt to define within the
operating systems how the transactions are processed.
The following Network Banking requirements are satisfied by this document:
© Reconciliation: [NBR0040], [NBR0042], [NBR0183], [NBR0212], [NBR0227],
[NBR0229], [NBR0278], [NBR0294], [NBR0389].
Settlement: [NBR0230], [NBR0456].
e Error Resolution: [NBR0260]
It is assumed that each of the Post Office Ltd. clients, as dictated by Routing Gateway
(assumed to be at this point the Banks / LINK) will require a separate reconciliation
report set.
Within this report set, separate reports will be provided as per the following table:
Report Number Deposit Transactions [Withdrawal Transactions
NBIOL Combined Report
NB102 Combined Report
NBO000 is a combined report for all Routing Gateways.
The format and content of each client’s report is considered to be identical when
allowing for these specific requirements. It should therefore be understood that the
specifications documented here are applicable to each client report set (specific client
requirements outside of this reporting specification are not covered within this
document)
There must be a separate set of reports to provide for transactions for which the
Routing Gateway and/or Transaction Type is not known.
Balance Enquiries and PIN changes are explicitly excluded from the report set as “Not
Required by Post Office Ltd.’
No report will mix currency, so if ever the transactions selected to appear on a set of
reports are not of a single currency, then a separate set of reports will be produced for
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 10 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg
RECONCILIATION RE@Q
x Ref: CS/SPE/O11
Version: WD
Date: 03-Mar-2016
COMMER‘
each currency. All al in 4
currency
single transaction will always use the same
2.1 Reconcitiationeports Specified
DR®Summary
Network Banking Settlement Statement
Exception Summary
Rows aiid columns are described in detail, together with the mathematical calculations
required to achieve reconciliation.
All general aspects relating to the production and transmission of the reports are
described.
This document does not attempt to define the business processes undertaken within
Fujitsu Services and Post Office Ltd. with respect to the resolution of any exceptions,
which may arise, nor does it scope the requirement for any systems that may be
required to assist in this process. This information can be found in the associated
documents, reference:
e¢ NB/SPE/002: Network Banking DRS On-line Workstation Specification
¢ NB/PRO/002: Network Banking Reconciliation & Incident Management
NB: It should be noted that where a system ‘State’ definition is quoted, this takes
precedence over any narrative which has only been provided to help understand the
business processes.
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 11 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg NI Ref: CS/SPE/O11
RECONCILIATION RB
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
3.0 General Ri eciéications
A separategget of ref rts is produced for each Post Office Ltd. client as identified by
the Rou way (QINK being a single client). The specification is general to all
es and values the accounting sense for reporting purposes to allow
otals to be correctly derived, will be:
Vf
solute volume
Net value
Where no value reported show “0.00”
Where no volume reported show 0
-ve values will be shown in brackets e.g. (nnn.nn)
2. Each report will show the following general information:
Report title — including the client name (derived from Routing Gateway.)
Transaction Type — (if applicable)
Report ‘Run Date’ - i.c., the period for which the report refers
Production date and time
Fujitsu Services report number
Fujitsu Services reference
3. Where ‘Received’ and ‘Reconciliation Date’ are quoted against time parameters:
e ‘Received = New’: defines transactions that have had a change of state since
they were last reported, or have never been reported, except in NB102 section
6
e ‘Received = Old’: defines transactions that have NOT had a change of state
since they were last reported
4. Reports: NB000, NB101 and NB102 will be produced DAILY. They will be
delivered by 08.00hrs the day following the Run Date to:
¢ Post Office Ltd. / POL FS gateway: The Host writes the reports to a directory.
These are picked up by FTMS and posted to the POL FS gateway (as per
other Host to external systems applications).
e Fujitsu Services CS / MSU, DRS Workstation.
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 12 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg
RECONCILIATION REQQ
x Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
eptions’ category will include:
ie. Mose transactions where one or more transaction
a C4 without a C12 ete
ere transaction components belonging to the same high
have been exceptioned, e.g. C12 (amount) not = to C4
ithin this document, field sizes are shown within ‘Report Layout’ and
‘ithin the ‘Data Definition’
7. All reports are run against a consistent data set.
8. All reports will be produced as ASCII text files — one for each report. The report
layout will be fixed format with space characters providing the blank space. This
will allow for ‘Excel’ input, using fixed field width facilities. The formatting (lines
& shading referred to in this document) will not be included within the file. Every
line will have the character ‘newline’, Hex '0A’, as the last character. Each report
will have the text “End of Report” as the last line.
9. See also comments in Section 2: ‘Scope’
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 13 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg IN Ref: CS/SPE/011
RECONCILIATION RB
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
3.1 NB000: Suma’ ep'
This report ises econciliation reports produced by the DRS. It also
aN that were not produced by the DRS because there was no data
ules
y application type, Routing Gateway, and report number.
2. Where ar is produced, the filename will be shown.
3. Where for a routing gateway, there is some data to report, but for a specific report there is
no data, then the filename will be replaced by [NO DATA].
4. Where for a routing gateway there is no data at all, the application type cannot be shown
and the file name will be replaced by [NIL RETURN].
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 14 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END Ref: O11
RECONCILIATION REPORTING
s Ww!
COMMERCIAL IN CONFIDENCE ey
3.1.1.1 NBO000: Report Layout
NBO000: DRS Summary Report Produced on: dd/mnvyyyy at hh:hh:ss
Run Date: dd/mm/yyyy Type: All
Application I Routing Gateway Report Number Report Section Filename
Type Number
APP. 9999999999 NB999 99 appyyyymmddgggeggeeeeNBnnnsstttcur. TXT.
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE Page: 15 of 3
Fujitsu Services
RECONCILIATION REPORTING
NETWORK BANKING END TO END
}-Mar-2016
3.1.1.2
NB000: Data Definition
Ref: O11
s Ww!
COMMERCIAL IN CONFIDENCE B
FUJ00085352
FUJ00085352
NBO000: DRS Summary Report
Produced on: (Date / Time of report production)
Run Date: (The period for which the report refers) ion Type All
Application I Routing Gateway Report Number Report Section Filename
Type Number
Application I Routing Gateway Shows each report I Shows each Where there is data for a report the filename will be
Type (e.g. number, Will be “-“ for number for each report section shown:
NBS or reports NB102 sections, routing gateway for each report
DCP). 6 and 12 as there are number appyyyymmddggegegegegNBnnnsstttcur. TXT, where
Will be “-“ single reports for all © app is a 3 character application code (e.g. NBS or
where no routing gateways. gateway® Shown against DCP)
application I Repeated for each each routing gateway ;
type is routing gateway within I number * _ yyyymmdd is the report run date
known. —_I application type © gggeseeeee is the routing gateway number. For
Repeated for reports NBI02 Sections 6 and 12 use
each “0000000ALL”
application
type. e® NBnnnss is the report number and section
* ttt is the transaction group. For NB101, and NB102,
this will be ‘ALL’.
© cur is the currency e.g. GBP.
Where for a routing gateway, there is some data to
report, but for a specific report there is no data, then
show [NO DATA]. Where for a routing gateway there
is no data at all (the application type is “-“) show [NIL
RETURN].
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE Page: 16 of 3
Fujitsu Services NETWORK BANKING
FUJ00085352
FUJ00085352
g NI Ref: CS/SPE/O11
RECONCILIATION RB
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
3.2 NBIOL: Net
This report i “CH
g Settlement Statement
sactions received against each ‘C4 Settlement Date’ as
reported tathe D! r the most recent processing date. The report will be used by
3.2.
. as a Wsis for settlement of Network Banking transactions with the
nS.
1 is run daily
NB101 is repeated for each Routing Gateway
NB101 will show ‘C4’ transactions received for ONE day only — breaking these
down into individual ‘C4 Settlement Dates’ There will be one line for each ‘C4
Settlement Date’
NBI1O1 will show Deposit and Withdrawal transactions in separate columns,
(headed ‘Receipts’ and ‘Payments’ respectively) derived from ‘Txn_Type’
NB1O01 will show a final settlement column derived in the following way:
¢ Volume: Volume of Deposits plus Volume of Withdrawals
e Value: Value of Deposits minus Value of Withdrawals
¢ Where the net total is negative i.e. the Value of Withdrawals exceeds the Value
of Deposits, the total will be shown as (xxx.xx)
Where the volume for a given ‘C4 Settlement Date’ is nil, the date will not be
reported.
“C4 Settlement Dates’ are shown in reverse chronological order.
Where there is more than one institution with the same Routing Gateway, the
values for the institutions will be shown individually provided the transaction
volume for that institution is greater than zero.
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 17 of 3
Fujitsu Services
NETWORK BANKING END TO END Ref:
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE
Ww!
B-Mar-2016
3.2.1.1 NB101: Report Layout
FUJ00085352
FUJ00085352
NB 101: Network Banking Settlement Statement
lient: IK
Produced on: dd/mm/yyyy at hh:mm:ss
Run Date: dd/mm/yyyy
saction Type: Deposit & Withdrawal
Currency: GBP
Ree Payments Net Settlement Institution Name
C4 Settlement Date Volume ie Volume Value Volume Value
dd/mm/yyyy 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 I X(40)
dd/mm/yyyy 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 I X(40)
Sub Total 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99
dd/mm/yyyy 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 I X(40)
dd/mm/yyyy 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 99,999,999 I 9,999,999,999.99 I X(40)
Sub Total 99,999,999 I 9,999,999,999,99 99,999,999 I 9,999,999,999,99 99,999,999 I 9,999,999,999.99
TOTAL 999,999,999 I 9,999,999,999.99 999,999,999 I 9,999,999,999.99 999,999,999 I 9,999,999,999.99
End of Report
3.2.1.2 NB101: Data Definition
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 18 of 3
Fujitsu Services
NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE
Ref:
O11
NB 101: Network Banking Settlement Statement Client:
“Routing Gateway’)
Produced on: (Date / Time of report production)
Run Date: (The period for which the report refers)
pe: Deposit & Withdrawal
‘Currency: (Derived from ‘currency’)
Receipts Payments Net Settlement Institution Name
C4 Settlement Date Volume Value Volume Value
Date 1 No. of C No. of C4] Value of C4 I No. of C4 Value of C4 Institution within
Deposits Rec'd Withdrawals Withdrawals Deposits Rec'd I Deposits Rec'd — Routing Gateway
Rec'd Ree’d +No of C4 Value of C4
Withdrawals Withdrawals Rec'd
Ree’d
Date 1 No. of C4) Value of C4]No. of C4 Value of C4 I No. of C4 Value of C4 Institution within
Deposits Rec’d I Deposits Rec'd Withdrawals Withdrawals Deposits Rec’d I Deposits Rec’d — Routing Gateway
Rec'd Ree’d +No of C4 Value of C4 Repeat Date 1 for each
Withdrawals Withdrawals Rec’d I “CPeat Pate ! Tor cae!
. Institution with non zero
Rec'd
volume.
Sub Total Total for Date I Total for Date 1 I Total for Date I Total for Date 1 I Total for Date I Total for Date 1
1 1 1
Repeat Date and Sub Total rows for each date that there is data to report.
TOTAL
Total All Dates
Total All Dates I Total All Dates
Total All Dates
Total All Dates
Total All Dates
End of Report
FUJ00085352
FUJ00085352
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 19 of 3
Fujitsu Services NETWORK BANKING
FU.
$
RECONCILIATION RB
NI Ref: CS/SPE/O11
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
FUJ00085352
}J00085352
3.3
3.3.1
NB102: Except ary
.
.
.
.
.
.
.
.
is dividC@into twelve sections
Uncleared Confirmed, Unconfirmed & POL FS exceptions
eared Exceptioned Client Transactions
Uncleared corruptions
Uncleared Timing Differences
Uncleared Confirmed, Unconfirmed & POL FS exceptions >24 hours
Section 6: Uncleared Future Dated Transactions by Client
Section 7: All Cleared Confirmed, Unconfirmed & POL FS exceptions
Section 8: Cleared Exceptioned Client Transactions
Section 9: Cleared corruptions
Section 10: Cleared Timing Differences
Section 11: Cleared Confirmed, Unconfirmed & POL FS exceptions >24 hours
Section 12: Cleared Future Dated Transactions by Client
Liability _issues_are_not_covered_ within this document, nor_are_ the business
processes involved in the resolution of any exception.
NB102: Rules
NB102 is run daily
NB102 is repeated for each Routing Gateway.
For each report section, the column ‘Values’ will be partitioned into 8 sub columns
to contain the values for: ‘C12’, ‘S’, ‘C4’, ‘C112’ & the four values from a ‘D’
which are: Amount Requested, Amount Authorised, Amount Confirmed, Amount
Discrepancy. The reports will populate all values that are available.
For reporting purposes, within NB102 sections 2, 3, 4, 5, 8, 9, 10 & 11, the
column headed “CAP” will be blank.
For reporting purposes within NB102 sections 2, 3, 4, 5, 8, 9, 10, 11, the column
headed ‘Discrepancy Type’ will report the “D’ discrepancy type.
Where no ‘D’ transaction element has been received, the ‘Discrepancy Type’ will
be blank
Where an exception is set to F99 by Fujitsu Services , clearance of this exception
within the appropriate NB102 section, (e.g. section 2 exceptions shown as cleared
within section 8), will always refer to the previously reported state regardless of
any change of state which may have occurred within the DRS.
All Uncleared Confirmed, Unconfirmed & POL FS exceptions are reported as
summary totals by exception type - (NB102 section 1)
Uncleared Exceptioned Client Transactions are listed individually - (NB102
section 2)
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 20 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING gg NI Ref: CS/SPE/O11
RECONCILIATION RE
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
9. Uncleared Trans@@gi ‘ions exceptions are listed individually - (NB102
10. Uncleared, ces are listed individually — (NB102 section 4)
confirmed & POL FS exceptions >24 hours are listed
section 5)
ated Transactions are reported as summary totals by Client
by ting Gateway — (NB102 Section 6)
d Confirmed, Unconfirmed & POL FS exceptions are reported as
tals by exception type - (NB102 section 7)
‘ed Exceptioned Client Transactions are listed individually — (NB102 section
15. Cleared Transaction corruptions are listed individually — (NB102 section 9)
16. Cleared Timing differences are listed individually — (NB102 section 10)
17. Cleared Confirmed, Unconfirmed & POL FS exceptions >24 hours are listed
individually — (NB102 section 11)
18. Cleared Future Dated Transactions are reported as summary totals by Client
identified by Routing Gateway — (NB102 Section 12)
19. Within each section, exception summary totals / individual transactions are to be
grouped and sub totalled by reconciliation date with a total provided for the entire
section.
20. For reporting purposes:
¢ Timing Differences: relate to differences in the reconciliation date / settlement
date allocated where a settlement date on a transaction element is not the same
as the reconciliation date first reported on that transaction.
e Future Dated Transactions: relate to those transactions that have a
Reconciliation Date ahead of the Run Date of the report. For example, most
Clients will settle Friday, Saturday and Sunday transactions on the following
Monday. This means that each transaction completed on these days will have a
Reconciliation Date ahead of the Run Date of the report. These transactions
are expected to clear naturally once the Reconciliation Date and the Run Date
are in sync, however in the rare eventuality that a Reconciliation Date is
considerably ahead of the Run Date, Post Office Ltd. may wish to clear the
exception manually. In this case, Fujitsu Services will set the transaction to
‘F99".
21. For reporting purposes, within NB102 sections 2, 3, 4, 5, 8, 9, 10 and 11 the
column headed ‘Transaction Type’ will be populated by the following codes:
03 - Withdrawal; Magstripe & PIN Verification (NBS)
04 - Withdrawal with balance; Magstripe & PIN Verification (NBS)
05 - Withdraw Limit; Magstripe & PIN Verification (NBS)
13 - Withdrawal; Signature Verification (NBS)
14 - Withdrawal with balance; Signature Verification (NBS)
15 - Withdraw Limit; Signature Verification (NBS)
22 - Cash Deposit; No Verification (NBS)
27 - Cheque Deposit; No Verification (NBS)
31 - Purchase; Magstripe & PIN Verification (DCS)
32 - Refund; Magstripe & PIN Verification (DCS)
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 21 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING g NI Ref: CS/SPE/O11
RECONCILIATION REQQ
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
Al - Pure e Verification (DCS)
- No Verification (ETS)
osit; ICC (NBS)
ithdrawal; ICC (NBS)
drawal with balance; ICC (NBS)
Withdraw Limit; ICC (NBS)
~ Cheque Deposit; ICC (NBS)
71 - Purchase; ICC (DCS)
e 72 - Refund; ICC (DCS)
22. For Network Banking reconciliation reporting, System States 8, 9, 10, 11, 16, 17,
18, 19, 20, 21,22,23, E05, E06, E07, E14, E22, £24, E31, E32, E33, E38 are
never expected within report NB102 because ‘S’ transactions are not used in NB.
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE, Page: 22 of 3
Fujitsu Services
COMMER‘
NETWORK BANKING
RECONCILIATION R
NI
o
IDENCE
FUJ00085352
FUJ00085352
Ref: CS/SPE/O11
Version: WD
Date: 03-Mar-2016
3.3.1.1 NB102: Section Ly ar ‘onfirmed, Unconfirmed & POL FS exceptions
3.3.1.1.1 NB102: S, rt Layout
NB102 Section 1 Client: — LINK Produced on:
Confirme: dd/mm/yyyy at hh:mm:ss
FS exceptit
Run, Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation Volume Values (8 sub columns)
Type Date
State 1 etc dd/mm/yyyy 99999999 9999999999.99
State 2 ete dd/mm/yyyy 99999999 999999999999
Sub total 999999999. 9999999999.99
State E02 ete dd/mm/yyyy 99999999 9999999999.99
Sub total 999999999. 9999999999.99
Total Section 1 9999999999 9999999999.99
End of Report
3.3.1.1.2 NB102: Section 1 - Data Definition
NB102 Section 1: All Uncleared
Confirmed, Unconfirmed & POL
Client: (Derived from Routing
Gateway.)
Produced on:
(Date and time of report
FS exceptions production)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from
the report refers) Withdrawal “currency’)
Exception Type / Reconciliation
Date
Volume
Values (8 sub columns)
Value of each transaction
component
One row for each system state
where exceptions are being
reported grouped within
reconciliation date with a sub total
for each reconciliation date and a
grand total for the section. Where
no data is being reported against
an exception state, the row for that
exception state is to be suppressed.
Where dates are shown for the
same exception type, list in
descending order
System State: 1-2, 4-11, 16-18,
E20-24, E32, E34 -E36, E38
Received = New + Old
Reconciliation date: < = Run Date
E01-02 E04-06, E10-12, El4,
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE,
Page: 23 of 3
Fujitsu Services
NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE
Qe
3.3.1.2 I NB102: Section 2: Uncleared Exceptione,
3.3.1.2.1 NB102: Section 2 — Report Layout
tions
> }-Mar-2016
FUJ00085352
FUJ00085352
NB102 Section 2: Uncleared
Exceptioned Client Transactions
Client:
L
Produced on: dd/mm/yyyy at_ hh:mm:ss
Run Date: dd/mm/yyyy
Deposit &
Currency: GBP
Exception I Reconciliation Transaction I Bank TxnId I Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Type Date Id Type Type columns)
EI3 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E13 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
State 12 dd/mm/yyy. Char (32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) I 9999999999.99
Sub Total 9999999999.99
E13 dd/mm/yyyy Char 32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) I 9999999999.99
Sub Total 9999999999.99
Total Section 2 9999999999.99
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 24 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE. oe }-Mar-2016
3.3.1.2.2 NB102: Section 2 — Data Definition
NB102 Section 2: Uncleared Client: rom Rol Produced on: (Date and time of production)
Exceptioned Client Transactions I Gateway.)
Run Date: (The period for which Transaction it & Currency: (Derived from ‘currency’)
the report refers)
Exception Type / He saction Bank Txn Id Receipt Date Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Type columns)
One row for each exception, Horizon_Txm Bank_Transact I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
with specific system states Num ion_Id ction_Date ction_Time eason_Codes transaction
listed in order, grouped within component
reconciliation date with a sub
total for each reconciliation
date and a grand total for the
section. Where dates are shown
for the same exception type, list
in descending order.
System State: 12-15, 20-23, E03, E07 — E09, E13, E25 — E26, E33, E37
Received = New + Old
Reconciliation date: < = Run Date
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 25 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END Ref: /01
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE. <)>
3.3.1.3 I NB102: Section 3: Uncleared Corruptio
3.3.1.3.1 NB102: Section 3 — Report Layout
NB102 Section 3: Uncleared Client: LI Produced on: dd/mm/yyyy at_ hh:mm:ss
Corruption’s
Run Date: dd/mm/yyyy Deposit & Currency: GBP
Exception Reconciliation Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8(8
Type Date Id Type Type sub columns)
E28 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
E29 dd/mm/yyyy Char 32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E31 dd/mm/yyy: Char (32) Code (99) Char (6) dd/mm/yyy: hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
E31 dd/mm/yy: Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99.
Sub Total 9999999999.99.
Total Section 3 9999999999.99
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE. Page: 26 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE oe }-Mar-2016
NB102: Section 3 — Data Definition
NB102 Section 3: Uncleared Client: (Deri from Rt ng Produced on: (Date and time of production)
corruption’s Gateway.)
Run Date: (The period for which Transaction osit & Currency: (Derived from ‘currency’)
the report refers)
Exception Type / Hori” Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Type Type columns)
One row for each corruption, Horizon_Txn_ I Txn_Type Bank_Transact I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
with specific system states Num ion_Id ction_Date ction_Time eason_Codes transaction
listed in order, grouped within component
reconciliation date with a sub -
total for each reconciliation System State: E27 —31
- Received = New + Old
date and a grand total for the Reconciliation date: < = Run Dat
section. Where dates are shown I “CconeHiation date: <~ Kun Date
for the same exception type, list
in descending order.
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 27 of 3
Fujitsu Services
NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE
)3-Mar-2016
3.3.1.4 I NB102: Section 4: Uncleared Timing Diffgr:
3.3.1.4.1 NB102: Section 4 - Report Layout
Ref: QS
FUJ00085352
FUJ00085352
NB102 Section 4: Uncleared
Timing Differences
Client: LI
Produced on: dd/mm/yyyy at_ hh:mm:ss
Run Date: dd/mm/yyyy
Deposit &
Currency: GBP
Exception Reconciliation Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Type Date Id Type Type columns)
E39 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
E39 dd/mm/yyyy Char 32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E39 dd/mm/yyy: Char (32) Code (99) Char (6) dd/mm/yyy: hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
E39 dd/mm/yy: Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99.
Sub Total 9999999999.99.
Total Section 4 9999999999.99
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE Page: 28 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE oe }-Mar-2016
NB102: Section 4 — Data Definition
NB102 Section 4: Uncleared Client: (Deri from Rt ng Produced on: (Date and time of production)
Timing Differences Gateway.)
Run Date: (The period for which Transaction osit & Currency: (Derived from ‘currency’)
the report refers) i
Exception Type / Hori” Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Type Type columns)
‘One row for each timing Horizon_Txn_ I Txn_Type Bank Transact I Receipt_Transa I Receipt_Transa Discrepancy _R I Value of each
difference, grouped within Num ion_Id ction_Date ction_Time eason_Codes transaction
reconciliation date with a sub component
total for each reconciliation -
date and a grand total for the System State: E39
Received = New + Old
section. Where dates are shown Reconciliation date: < = Run Dat
for the same exception type, list I “CCOneMauo ©: un Date
in descending order.
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 29 of 3
Fujitsu Services
NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE
Ref:
/01
33-Mar-2016
3.3.1.5 NB102: Section 5: Uncleared Confirmed,
3.3.1.5.1 NB102: Section 5 — Report Layout
el POL FS exceptions >24 hours
FUJ00085352
FUJ00085352
NB102 Section 5: Uncleared
Confirmed, Unconfirmed & POL
FS exceptions >24 hours
Client:
Produced on: dd/mm/yyyy at_ hh:mm:ss
Run Date: dd/mm/yyyy
Currency: GBP
Exception I Reconciliation I Horizon Txn I Transaction I Bank TxnId I Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Type Date Id Type Type columns)
State 1 dd/mm/y; Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
State 2 dd/mm/yyy. Char (32) Code (99) Char (6) dd/mm/yyy: hh:mm:ss Code (99) _ I 9999999999,99
State 6 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy: hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
State 6 dd/mm/yyyy Char 2) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) _ I 9999999999.99
Sub Total 9999999999.99.
Total Section 5 9999999999.99
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 30 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE oe }-Mar-2016
NB102: Section 5 — Data Definition
NB102 Section 5: Uncleared Client: (Deri ing Produced on: (Date and time of production)
Confirmed, Unconfirmed & POL I Gateway.)
FS exceptions >24 hours
Run Date: (The period for which Currency: (Derived from ‘currency’)
the report refers)
Exception Type / Reconciliation a Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Date Id Type Type columns)
One row for each exception, with Horizon_Txn_ I Txn_Type Bank_Transacti I Receipt_Trans I Receipt_Trans Discrepancy_R I Value of each
specific system states listed in order, I Num on_Id action_Date action_Time eason_Codes transaction
grouped within reconciliation date component
with a sub total for each
reconciliation date and a grand total
for the section. Note: an extra
constraint for system states 2 & 18 is
that the Branch must have harvested
(TPS) successfully. Should a Branch
be confirmed as non-polling, system
states 2 & 18 for that Branch on the
date(s) in question should not be
included on this report. Where dates
are shown for the same exception
type, list in descending order.
Received = Old
Reconciliation date: < Run Date
System State: 1, 2, 4, 5, 6, 7, 8, 9,
10, 11, 16, 17, 18, E01-02 E04-06,
E10-12, E14, E20-24, E32,
(i.e. where transaction components have remained in the above incomplete states for >24 hours)
E34 -E36, E38
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 31 of 3
Fujitsu Services
COMMER‘
NETWORK BANKING
RECONCILIATION R
o
IDENCE
NI
FUJ00085352
FUJ00085352
Ref: CS/SPE/O11
Version: WD
Date: 03-Mar-2016
3.3.1.6
3.3.1.6.1
NB102: Secti
NB102: S
n 6 -
art
rt Layout
uture Dated Transactions by Client
All Clients
Produced on:
dd/mm/yyyy at hh:mm:ss
Transaction Type: Deposit &
Withdrawal
Currency: GBP
Reconciliation Date Volume Values (8 sub columns)
LINK dd/mm/yyyy, 99999999 9999999999.99
Lloyds dd/mm/yyyy 99999999 9999999999.99
Total Section 11 9999999999 9999999999.99
End of Report
3.3.1.6.2. NB102: Section 6 - Data Definition
NB102 Section 6: Uncleared
Future Dated Transactions by
All Clients Produced on:
(Date and time of report
Client production)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from
the report refers) Withdrawal “currency’)
Client / Reconciliation Date
One row for each Client derived from
Routing Gateway where transactions have
been received with a reconciliation date
ahead of the run date. Where dates are
shown for the same exception type, list in
descending order.
Volume [Values (8 sub columns)
System State: All States excluding F99
Reconciliation date: > Run Date
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE,
Page: 32 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING $ NI Ref: CS/SPE/O11
RECONCILIATION R
Version: WD
COMMER‘ IDENCE Date: 03-Mar-2016
3.3.1.7 NB102: Section 74 firmed, Unconfirmed & POL FS exceptions
3.3.1.7.1 NB102: S rt Layout
NB102 Section Client: = LINK Produced on:
Confirmed, Une POL dd/mm/yyyy at hh:mm:ss
FS excepti
Run Date:' Transaction Type: Deposit & Currency: GBP
Withdrawal
Except Reconciliation Volume Values (8 sub columns)
Type ate
State 1 etc dd/mm/yyyy 99999999 9999999999.99
State 2 ete dd/mm/yyyy 99999999 9999999999.99
Sub total 999999999. 9999999999.99
State E02 ete dd/mm/yyyy 99999999 9999999999.99
Sub total 999999999. 9999999999.99
Total Section 1 9999999999 9999999999.99
End of Report
3.3.1.7.2 NB102: Section 7 - Data Definition
NB102 Section 7: All Cleared Client: (Derived from Routing Produced on:
Confirmed, Unconfirmed & POL I Gateway.) (Date and time of report
FS exceptions production)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from
the report refers) Withdrawal “currency’)
Exception Type / Reconciliation Volume Values (8 sub columns)
Date Value of each transaction
component
One row for each system state For last reported System States: 1-2, 4-11, 16-18, E01-02, 04-06,
where exceptions are being
reported grouped within
reconciliation date with a sub total
for each reconciliation date and a
grand total for the section. Where
no data is being reported against
an exception state, the row for that
exception state is to be suppressed.
Where dates are shown for the
same exception type, list in
descending order.
E10-12, E14, E20-24, E32, E34 -36,
Set to F99: New
Reconciliation date: < = Run Date
E38
End of Report
3.3.1.9
NB102: Section 8: Cleared Exceptioned Client Transactions
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE,
Page: 33 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE D )3-Mar-2016
3.3.1.9.1 NB102: Section 8 — Report Layout
NB102 Section 8: Cleared Client: = LINK roduced on: dd/mm/yyyy at hh:mm:ss
Exceptioned Client Transactions
Run Date: dd/mm/yyyy TransactiongT yP@ Deposi Currency: GBP
Withdrawal
Exception I Reconciliation ransaction I Bank TxnId I Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Type Date Type Type columns)
E13 dd/mm/yyyy ‘Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99.
E13 dd/mm/yyyy Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
State 12 dd/mm/yyyy Code (99) Char (6) dd/mm/yy: hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
E13 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yy: hh:mm:ss Code (99) 9999999999.99.
Sub Total 9999999999.99.
Total Section 8 9999999999.99
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE Page: 34 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE <)*
NB102: Section 8 — Data Definition
NB102 Section 8: Cleared Client: (Deriver muting roduced on: (Date and time of production)
Exceptioned Client Transactions I Gateway.)
Run Date: (The period for which TransactiongTyI posit Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Horiz Transaction Bank Txn Id Receipt Date Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Type Type columns)
One row for each exception, I Horizon_Txn_ )Txn_Type Bank_Transacti I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
with specific system states
listed in order, grouped
Num
on_Id
ction_Date
ction_Time
eason_Codes
transaction
component
within reconciliation date
with a sub total for each
reconciliation date and a
grand total for the section.
Where dates are shown for
the same exception type, list
in descending order.
For last reported System States: 12-15, 20-23, E03, E07 — E09, E13, E25 — E26, E33, E37
Set to F99: New
Reconciliation date: <= Run Date
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 35 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/0:
RECONCILIATION REPORTIN!
0
COMMERCIAL IN CONFIDENCE D )3-Mar-2016
3.3.1.10 INB102: Section 9: Cleared Corruptions
3.3.1.10.1 NB102: Section 9 — Report Layout
NB102 Section 9: Cleared Client: Produced on: dd/mm/yyyy at hh:mm:ss
Corruption’s
Run Date: dd/mm/yyyy sacti ye: it & Currency: GBP
Exception Reconciliation ransaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Type Date Type Type columns)
E28 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
E29 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yy: hh:mm:ss Code (99) 9999999999.99.
State 31 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
Sub Total 9999999999.99
E31 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
Total Section 9 9999999999.99
End of Report
© 2004 Fujitsu Services COMMERCIAL IN CONFIDENCE Page: 36 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE <)*
NB102: Section 9 — Data Definition
NB102 Section 9: Cleared Client: (Deriver muting roduced on: (Date and time of production)
corruption’s Gateway.)
Run Date: (The period for which TransactiongTyI posit Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / it nsaction I Bank TxnId I Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Reconciliation Date Type Type columns)
One row for each corruption, Horizon_ Txn_Type Bank_Transact I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
with specific system states Num ion_Id ction_Date ction_Time eason_Codes transaction
listed in order, grouped within component
reconciliation date with a sub
total for each reconciliation For last reported System States: E27 -31
fc Set to F99: New
date and a grand total for the ee a
A Reconciliation Date: <= Run Date
section. Where dates are shown
for the same exception type, list
in descending order.
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 37 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/0:
RECONCILIATION REPORTIN!
0
COMMERCIAL IN CONFIDENCE D )3-Mar-2016
3.3.1.11 I NB102: Section 10: Cleared Timing Diffgyel
3.3.1.11.1 NB102: Section 10 - Report Layout
NB102 Section 10: Cleared Client: Produced on: dd/mm/yyyy at hh:mm:ss
Timing Differences
Run Date: dd/mm/yyyy ye: it & Currency: GBP
Exception Type I Reconciliati Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
on Date Id Type Type columns)
E39 dd/mm/yyyy Char 2) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E39 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E39 dd/mnv/yy: Char (32) Code (99) Char (6) dd/mmv/yy: hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
E39 dd/mm/yy: Char (32) Code (99) Char (6) dd/mm/yy: hh:mm:ss Code (99) 9999999999.99.
Sub Total 9999999999.99.
Total Section 10 9999999999.99.
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 38 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE <)*
3.3.1.11.2_ NB102: Section 10 — Data Definition re
NB102 Section 10: Cleared Client: (Derive ii ‘roduced on: (Date and time of production)
Timing Differences Gateway.)
Run Date: (The period for which I Transactior@PypSQQeposit Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Horizol Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Id Type Type columns)
One row for each timing Horizon_Txn__ I Txn_Type Bank_Transact I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
difference, grouped within Num ion_Id ction_Date ction_Time eason_Codes _I transaction
reconciliation date with a sub component
total for each reconciliation
date and a grand total for the For last re ported System States: E39
section. Where dates are shown I ee pain Dat
for the same exception type, list I “°cone!ation Date: un Date
in descending order.
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 39 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE <)~
3.3.1.12 NB102: Section 11: Cleared Confirmed, Bim e POL FS exceptions > 24 hours
3.3.1.12.1 NB102: Section 11 — Report Layout
NB102 Section 11: Cleared Client: Produced on: dd/mm/yyyy at hh:mm:ss
Confirmed, Unconfirmed & POL
FS exceptions > 24 hours
Run Date: dd/mm/yyyy + Deposit & Currency: GBP
Exception Type I Reconciliation Horizon Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Date Txn Id Type Type columns)
State 1 dd/mm/yy: Char (32) Code (99) Char (6) dd/mm/yy: hh:mm:ss Code (99) 9999999999.99
State 2 ddimm/yy’ Char (32) Code (99) Char (6) ddimm/yy’ hh:mm:ss Code (99) I 9999999999.99
State 6 dd/mm/yy Char (32) Code (99) Char (6) dd/mm/yy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99.
State 6 dd/mm/yyyy Char 32) Code (99) Char (6) dd/mm/yyy, hh:mm:ss Code (99) _ I 9999999999.99
Sub Total 9999999999.99.
Total Section 11 9999999999.99
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 40 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO E) Ref: E/01'
RECONCILIATION REPORTING
COMMERCIAL IN CONFIDENCE <)*
NB102: Section 11 — Data Definitio
NB102 Section 11: Cleared Client: (Deriver uting roduced on: (Date and time of production)
Confirmed, Unconfirmed & POL I Gateway.)
FS exceptions > 24 hours
Run Date: (The period for which osit & Currency: (Derived from ‘currency’)
the report refers)
Exception Type / Reconciliation nsaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Date Type columns)
One row for each exception, with Txn_Type Bank_Transact I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
specific system states listed in _Num ion_Id ction_Date ction_Time eason_Codes transaction
order, grouped within component
reconciliation date with a sub total
for each reconciliation date and a
grand total for the section. Note:
an extra constraint for system
states 2 & 18 is that the Branch
must have harvested (TPS)
successfully. Should a Branch be
confirmed as non-polling, system
state 2 & 18 for that Branch
the date(s) in question should not
be included on this report. W1
dates are shown for the same
exception type, list in descending
order.
Set to F99: New
‘today’s’ reports.”
on
here
For last reported System States: 1, 2, 4, 5, 6,7, 8,9, 10, 11, 16, 17, 18, E01-02 E04-06,
E10-12, El4, E20-24, E32, E34 -E36,
Transactions that were included on report NB102 Section 5 on ‘yesterday’s’ reports and are not included in NB102 Section 5 on
E38
End of Report
© 2004 Fujitsu Services
COMMERCIAL IN CONFIDENCE
Page: 41 of 3
Fujitsu Services
REC!
NETWORK BANKING END TO END
‘ONCILIATION REPORTING.
Commercial in confidence
FUJ00085352
FUJ00085352
Ref: CS/SPE/11
Version: 5.0
Date: 11-DEC-2002
3.3.1.13 NB102: Section 12: Cleared Future Dated Transactions by Client
3.3.1.13.1 NB102: Section 12 -
Report Layout
NB102 Section 12: Cleared
Future Dated Transactions by
Client
All Clients
Produced on:
dd/mm/yyyy at hh:mm:ss
Run Date: dd/mm/yyyy
Transaction Type: Deposit &
Withdrawal
Currency: GBP
Client Reconciliation Date Volume Values (8 sub columns)
LINK dd/mm/yyyy 99999999 9999999999.99
Lloyds dd/mm/yyyy 99999999 9999999999.99.
Total Section 11 9999999999 9999999999.99
End of Report
3.3.1.13.2 NB102: Section 12 -
Data Definition
NB102 Section 12: Cleared
Future Dated Transactions by
All Clients
Produced on:
(Date and time of report
Client production)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from
the report refers) Withdrawal “currency’)
Client / Reconciliation Date
One row for each Client derived from
been received with a reconciliation date
ahead of the run date. Where dates are
descending order.
Routing Gateway where transactions have
Volume
[___ Values (8 sub columns)
System State: All States
All transactions that were included on report NB102 Section 6
shown for the same exception type, list in
on ‘yesterday's’ reports and are not included in NB102 Section
6 on ‘today’s’ reports.
End of Report
© 2002 Fujitsu Services
Commercial in Confidence
Page: 42 of 3
Fujitsu Services
NETWORK BANKING END TO END
RECONCILIATION REPORTING
Commercial in confidence
FUJ00085352
FUJ00085352
Ref: CS/SPE/11
Version: 5.0
Date: 11-DEC-2002
3.3.1.14
Incomplete and Discrepancy State: Report Matrix
This table identifies the NB102 series report section where incomplete and discrepancy
States are reported in detail.
Incomplete Transaction Components Exception report
State NB102 Section
C112 C12 C4 Ss D Uneleared I Cleared
1 v 1&5 7&1
2 V Vv 1&5 T&1I
4 Vv 1&5 7&1
5 Vv 1&5 7&1
6 Vv Vv 1&5 T&1l
7 Vv V 1&5 7&1
8 V 1&5 7&1
9 V v 1&5 7T&ll
10 ¥ y 1&5 7&1
in V V Vv 1&5 T&1l
12 V 2 8
B Vv Vv 2 8
14 Vv Vv 2 8
15 Vv Vv Vv 2 8
16 Then ¥ Vv 1&5 T&11
17 al Then ¥ Vv 1&5 7&1
18 a Then ¥ V 1&5 7&1
20 V Then V z 8
21 v Vv Then V 2 8
22 \ V Then V 2 8
23 v V Vv Then V 2 8
Shaded lines represent System States not expected to be reported within the Network
Banking report set
© 2002 Fujitsu Services
Commercial in Confidence
Page: 43 of 3
Fujitsu Services
FUJ00085352
FUJ00085352
NETWORK BANKING END TO END Ref: CS/SPE/11
RECONCILIATION REPORTING
Commercial in confidence
Version: 5.0
Date: 11-DEC-2002
3.3.1.15 Exception State: Report Matrix
This table identifies the NB102 series report section where an exception is reported in
detail.
Exception Description Exception report NB102
State Section
Uncleared Cleared
EOL Additional C112 1&5 7&1
E02 Additional C12 1&5 T&11
E03 Additional D 2 8
E04 Additional C4 1&5 7&ll
E05 Additional S 1&5 7T&ll
E06 S after C4 1&5 7T&il
E07 S after D 2 8
E08 C4 afier D 2 8
E09 D after C4 2 8
E10 C112 after final state 1&5 7&1
Ell C12 afier final state 1&5 7&1
E12 C4 after final state 1&5 7&1
E13 D after final state 2 8
El4 S after final state 1&5 7T&ll
EIS Not Used
E16 Not Used
EI7 Not Used
E18 Not Used
E19 Not Used
E20 Amount of C112#C12 1&5 T&ll
E21 Amount of C112#C4 1&5 7&ll
E22 Amount of C112#S & C112#0 1&5 7T&ll
E23 Amount of C12#C4 1&5 7T&ll
E24 Amount of C12#S & C12#0 1&5 7&1
E25 Amount of C112#D. 2 8
E26 Amount of C12#D 2 8
E27 Incomplete/corrupt C112 3 9
E28 Incomplete/corrupt C12 3 9
E29 Incomplete/corrupt C4 3 9
E30 Incomplete/corrupt D 3 9
E31 Incomplete/corrupt S 3 9
E32 Amount of C4#S & C4#0 1&5 7T&ill
E33 Amount of D#S 2 8
E34 C112 arrived after state F99 1&5 7&1
E35 C12 arrived after state F99 1&5 7T&ll
E36 C4 arrived afier state F99 1&5 7T& ll
E37 D arrived after state F99 2 8
E38 S arrived after state F99 1&5 7&il
E39 Settlement Date # Reconciliation Date 4 10
Shaded lines represent System States not expected to be reported within the Network
Banking report set
© 2002 Fujitsu Services
Commercial in Confidence
Page: 44 of 3
FUJ00085352
FUJ00085352
Fujitsu Services NETWORK BANKING END TO END Re! CS/SPE/11
RECONCILIATION REPORTING
Version: 5.0
Commercial in confidence Date: 11-DEC-2002
4.0 System States
wen
lorizicrzi ce bs
Preswaion lives, en: reve
(n eemplteCorpl or go: E27 E28 €29 £10 EN
Valle on erty Se means not equ) SU Acton
Side Con Agert_NBE_TPS Wen vail, go Se I—_ AnouncAcon Anourtacton I _ AnourtActon Setement Ose cton I Seti
sat! 0 B14 2 : z . :
1 oe € &2 2 1% 10 ri Foe
2 co 3 Ee Eo E09 E06 I ctzwOH ES A Ste te: LESS Fo
Fr 3 iz ok atte 10 E11 £12 613 E14 I cHiawcIZE20 ——_chiawouezt Ch Ste Dies DEES :
4 ce 72 G04 E09 E06 : : : - F99
5 cma m6 7 8 : : F9
6 oR ita fo Ee 3 18 m1 I cHtzaciz{ : 5 F39
T ot on Fol 3 G4 E09 E06 I CHteHORERL Ste tec DEEDS F39
+ 8 9 10 16 20. es - - : - F99
9 8 ong fol 11 17 21s [ontaws achiowez : - 8 Sete Coc LES F99
oe 8 11 EO 18 2 £06 I CI2¥s aCloweae = zi S Sete Ceo 9 F:9
1 oe 8 ote For Em 19 2 eS I cIteWCIZEI Claws acioW ERA 8 Sete Coc REDS Fs9
12 ° 14.13 E08 03, E07 : : : - F29
8 oR 15 Ei Eos E09 EO? I CiLWO(CIO}E2e - Sete ter OLED F99
14 © ote Eo 16 E08 Exe €07 I cigwo(ci2y eas = 0 Sate Dever OLES9 F9
6 cb atte fot Em eos goo or I cHtzACIZE —_cHteAO(CI2) E26 : Sete Otc OFE23 Fs9
16 8104 WT 18 E04 £09 E05 I CAMs & CAND. - : t See Rec DEEDS F393
” Sica ota EOI 19 Eo Eo eS I CITZACHEA OWS BONDED a A Ste Rex LEDS F39
tec sic8 19 EQ Et E09 £05 I CIQHONEZS CHWS BCHNDESZ (Sete two: DEEDS F99
Fra 19 lz ice rte Bio E11 E12 £12 E14 I ctt2AcIZEI0 CieWOHEZD CHWS CHHDERZ I CA See tw OLE :
20 80 21 2 eee &05 I DANGERS : : sete Dewar OLE39 F99
2 8 o112 Ent 25 Eos e005 [CHOW ACIIQwE —_DIAHS.ENS Sate ote OLES9 Foo
2 oR sD 25 OQ EOS EUS EOS I CIB ACIMEN ONSEN is sete ter OL E29 £39
Bok 9p ote Ent Ee Eos G56 0S I CHZHCIZER CHWS ACIIQWDEZ —_DYAWSEDS Sate Ror OLE F393
EDT tonal 112 ss 5 Fe
xe, Acional O12 aa : : : F39
Anal D = . Fag
04 Adonalo4 ee : a : F99
£06 Asia 3 i - - F39
E06 Sater OA ~ > Foe
Eo? Sater D alee F29
E08 Chater D eae : : Fs9
09D ater C8 ae i = £39
10" O12 ter ral ste 5 Fae
ENT 12 ar tl tea ae . : . : F99
12 OM ater ral tee ee - : F9
13. ater al te ae : e F99
E14 Sar al sale _ : : : F393
EIS Netused > >
E16 Netused ae : z :
EIT Notused Pale ea : : :
E18 Notused : : :
E19 Notused EET : - - - -
E20 Aneurtf CTT2HOTE =e fe : : : : Fe
E21 nur C1204 ae : : F39
22 curt C1248 BCH : : F29
EZ Aart C1244 : a : F39
£24 neural 12H &C12H ae : : F99
E25. Aart C1240 hele : : - : F39
£26 pcr C120 ee - - : : £39
E27 eompleetCor C112 ~etetebe F99
£28 ncomplete/Corugt 12 aa : = Fe
£29 Incomplete C4 Paes 5 5 : F39
E20 ncomplee/Corrgt 0 - Fs9
ES1_reompleteCorugt 8 ~ieiete : 599
EF Anu CHAS & 0 = Leb 5 5 Fee
E33 Ancurtot OFS, a : : : £39
E2812 arved ar oe 99 Tl F99
06.12 ave arco 29 : : : Fo
96. A ave oer se 29 = hehe : F : cs £99
EST. D arrears F993 aie en : : : F39
38 8 arve ae te F39 : F39
E9_Selert ae #Reconaon Dab ~t-1-]-] = : Fe
Final _F99 MSU rested Ea 66 66 G7 z z :
© 2002 Fujitsu Services Commercial in Confidence Page: 45 of 3