Fe)
FUJITSU
End to End Reconciliation Reporting
FUJ00080386
FUJ00080386
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Document Title:
Document Type:
Release:
Abstract:
Document Status:
Author & Dept:
End to End Reconciliation Reporting
Service Description
Release Independent
This document specifies the reconciliation report output to satisfy
the end to end reconciliation of the Banking and related services,
Automated Payment System (APS) and Transaction Processing
System (TPS).
Approved
Pete Jobson
External Distribution: As Approver list
Security Risk
Assessment Confi
YES, security risks have been assessed, see section 0.9 for details.
irmed
Approval Authorities:
Name
Stephen Godfrey
Role
Fujitsu Service Owner; Reconciliation Service
Signature Date
See Dimensions for record
Dionne Harvey
Post Office Ltd IT Contracts Manager
See Dimensions for record
Note. See Post Office Account HNG-X Reviewers/Approvers Role Matrix (PGM/DCM/ION/0001) for guidance.
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED
2017
(COMMERCIAL IN CONFIDENCE)
Ref: ‘SVM/SDM/SD/0020
Version: 4.0
Date: 04-Sep-2017
Page No: 10f1
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
0 Document Control
0.1 Table of Contents
0.1 Table of Contents.
0.2 Document History.
0.3 Review Details...
0.4 Associated Documents (Internal & External).
0.5 Abbreviations.
0.6 Glossary.
0.7 Changes Expecte:
0.8
0.9
1
2 SCOPE.
3 NETWORK BANKING RECONCILIATION REPORTS SPECIFIED.
34 General Banking and Related Services Report Specifi
3.2 NB0O0: Summary Repott.....
3.2.1. NBOOO: Rules...
3.2.2 NB101: Network Banking Settlement Statement.
3.2.3 NB101: Rules...
3.3 NB102: Exception Summary
3.3.1 NB102: Rules.............
3.4 System States....
4 APS RECONCILIATION...
44 Reconciliation between Client Transmission
42 Accounting Sense.......
4.3
44 APS Reconciliation / Reporting Point
4.4.1 Description..
4.4.2 APSS2133 - APS Daily ‘Account Balancing Report.
45 APS Reconciliation / Reporting Point
4.5.1 Description...
4.5.3 APSS2136b - “Daily TPS/ ‘APS. Transaction Recon:
4.5.4 APSS2136c - Daily TPS / APS Transaction Reconciliation Detail Exception Report.
46 APS Reconciliation / Reporting Point
4.6.1 Descriptio
46.2 APSS2139 ly
47 APS Reconciliation Point
4.7.1 Descriptio
4.7.2 I APSS2140 - APS Harvester Transaction Totals Summary.
4.7.3. APSS2140b - APS Harvester Transaction by Office.
48 APS2134 - APS Validation Status Report.
49 APS Report Delivery.
4.10 xternal Transactions.
5 TPS RECONCILIATION REPORTS SPECIFIED.....
5.1 TPSC250 - Host Detected Transaction Control Errors.....
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
Page No: 2oft
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
5.2 TPSC254 — Harvester Exceptions.
5.3 TPSC257 — POLSAP Incomplete Summaries Repo:
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
PageNo: 3of 1
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
0.2 Document History
Version No. Date Summary of Changes and Reason for Issue Associated Change -
CP/PEAK/PPRR
Reference
a4 22/11/08 First draft for review. NIA
1.0 02/02/07 Issued for approval. NA
14 27/10/08 Change of owner and Reviewers for CCN
12 07/05/11 Post HNG-X Migration and change of owner NIA
13 22-Jun-2011 Revisions following internal review
2.0 22 Jun 11 Document Approved
24 23 Nov 11 Release 5.5 Review
3.0 4 May 12 Annual Review
34 18 March 2013 I Annual Review
32 14 Oct 2016 I Clarifications added
4.0 04-Sep-2017 _I Approval version [replaces CS/SPE/011]
0.3 Review Details
Review Comments by
“} POADocumentManagementI
Review Comments to
pete jobsort”
Mandatory Review
Role Name
POL IT Contracts Manager Dionne Harvey
Senior Commercial Manager Carol Dunford; Post Office Account Commercial Mailbox
SC (for Configuration Management) Stove Parker seca, ]
Senice Architect Phil Boardman
Role Name
Commercial Manager Krishna Topan
Business Continuity Almizan Khan
Network Operations Manager Roger Stearn; Chris Harrison
‘Systems Mgt & Global Cloud Catherine Obeng
Infrastructure Operations Manager Andrew Hemingway
Senior Operations Manager Alex Kemp
Quality and Compliance Bill Membery
cilso ‘Stephen.Godfrey
Document Manager Matthew Lenton
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) Version: 40
Date: 04-Sep-2017
Page No: 4oft
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
POA BAS Lead Steve Bansal
Management Information Service Mark L Jones
Issued for Information — Please
restrict this distribution list to a
minimum
Position/Role Name
(*) = Reviewers that returned comments
0.4 Associated Documents (Internal & External)
Reference Version Date Title Source
PGM/DCM/TEM/0001 Fujitsu Services Post Office Account HNG- I Dimensions
(00 NOT REMOVE) X Document Template
SVMISDM/PRO/0012 Reconciliation and Incident Management- I Dimensions
Joint Working Document
SVMISDM/SD/0015 Reconciliation Service Description Dimensions
NB/SPE/002 Network Banking DRS On-line Workstation I Dimensions
Specification (Pwy)
Unless a specific version is referred to above, reference should be made to the current approved
versions of the documents.
0.5 Abbreviations
Abbreviation Definition
APS Automated Payment Service
c12 A transaction record from the Horizon Counter or Self-Serve Kiosk
C112 A transaction record from the Horizon Counter or Self-Serve Kiosk that has been delivered to
POLSAP
C4 A record of confirmation from a Financial Institution
cts Client Transmission Summary
D A transaction record received from a Financial Institution that advises of a discrepancy
pcp Debit/Credit Card Payment
pcs Debit/Credit Card System
DRS Data Reconciliation Service
ETS Electronic Top-Up Service
F99 transaction state that indicates that a reconciliation error has been reported but POL has advised
that the issue has subsequently been resolved. This state is set using the DRS Workstation
application that is used by Fujitsu Security Operations team.
Fl Financial Institutions
Ice Integrated Circuit Card
MA Merchant Acquirer
PIN Personal Identification Number
PODG Post Office Data Gateway
POLDG Post Office Limited Data Gateway — This is a platform that sits outside the Horizon system that is
accessible by POL back office staff, PODG has a number of routes that deliver data files to and
from this platform.
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
Page No: Soft
Fe)
FUJITSU
FUJ00080386
FUJ00080386
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
POLSAP Post Office Ltd. Consolidated SAP System
s A transaction record that is generated by the Debit Card Management server that advises DRS
when the expected Settlement date is.
TIP An identifier that is printed on some of the reconciliation reports. The meaning of this identifier is
described in the descriptive text that immediately follows the report layout definition later in this
document
TMs Transaction Management Service
TPS Transaction Processing Service
0.6 Glossary
Term
Bank_Transaction_ld
Definition
Message sequence number assigned by the message originator, to assist in
identifying a transaction uniquely. Stays unchanged through the life of the
transaction.
C4 Settlement Date
The Settlement Date provided on the C4 transaction
Credence
Post Office Ltd. Management Information Service
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 are of different value, e.g. C12 (amount) not = to C4 (amount).
Transaction corruptions
HNG-X_Txn_Num
Unique transaction number to be used in all messages between HNG-X and the Fis
relating to the transaction. Generated by HNG-X 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.
POLSAP Transactions
From a Branch / Post Office Ltd. perspective, a transaction that has been sent from
TPS to Post Office Ltd. POLSAP. From a system perspective, a ‘C112’ transaction.
POLSAP
Post Office Ltd Consolidated SAP System
Receipt Date
Receipt Date is the Date as printed on the transaction Receipt at the Counter. It
forms part of all transactions.
Receipt Time
Receipt Time is the Time as printed on the transaction Receipt at the Counter. It
forms part of all transactions.
Reconciliation Date
The 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.
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
©Copyright Fujitsu Services Ltd 2006-
2017
FUJITSU RESTRICTED Ref: SVM/SDM/SD/0020
(COMMERCIAL IN CONFIDENCE) Version: 40
Date: 04-Sep-2017
PageNo: 6 of 1
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
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.
Txn_Type See Appendix A - Transaction Types
0.7 Changes Expected
ee
0.8 Copyright
© Copyright Fujitsu Services Limited 2006-2017. All rights reserved. No part of this document may be reproduced,
stored or transmitted in any form without the prior written permission of Fujitsu Services.
0.9 Security Risk Assessment
Security risks have been assessed and it is considered that there are no security risks relating specifically to this
document.
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
Page No: 7 oft
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
1. Introduction
This document has been compiled to specify Fujitsu Services outputs from the Data Reconciliation
Service (DRS) Automated Payment Service (APS) and the Transaction Processing Service (TPS) so as
to enable a generic end to end reconciliation of
1. Banking and Related Services transactions, which includes DCS and ETS
2. Automated Payment System (APS)
3. Transaction Processing System (TPS)
2 Scope
This document defines the format and content of all reconciliation reports for HNG-X, which satisfies the
DRS, APS and TPS reconciliation requirement. It does not attempt to define within the operating
systems how the transactions are processed.
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 SVM/SDM/PRO/0012: Reconciliation and Incident Management - Joint Working Document
3 Network Banking Reconciliation Reports
Specified
For Network banking services each of the Post Office Ltd. Clients, as dictated by Routing Gateway, will
require a separate reconciliation report set.
Within this report set, separate reports will be provided as per the following table:-
Report Deposit Withdrawal
Number Transactions Transactions
NB101 Combined Report
NB102 Combined Report
NBOOO 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.
Non-Financial transactions such as 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 each currency. All the amounts in a
single transaction will always use the same currency
e NBOOO: DRS Summary
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
Page No: 8of1
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
e NB101: Network Banking Settlement Statement
e NB102: Exception Summary
Rows and 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.
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.
3.1 General Banking and Related Services Report
Specifications
A separate set of reports is produced for each Post Office Ltd. Client as identified by the Routing
Gateway (VocaLink being a single Client). The specification is general to all reports sets.
1. For volumes and values the accounting sense for reporting purposes to allow settlement
totals to be correctly derived, will be:
Absolute volume
Net value
Where no value reported show “0.00”
Where no volume reported show 0
-ve values will be shown in parenthesis 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.e., 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: NBOOO, NB101 and NB102 will be produced DAILY. They will be delivered by
08.00hrs the day following the Run Date to:
e Post Office Ltd. Delivered by PODG to POLDG.
e Fujitsu Services CS, DRS Workstation. A copy of all the reconciliation files is gathered
onto the SSC server and extracted via the RDT version of PODG to be delivered
automatically to the Security Operations group mailbox
5. Within report NB 102 the ‘Exceptions’ category will include:
e ‘Incomplete States’, i.e. those transactions where one or more transaction component is
missing — a C4 without a C12 etc
e 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
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
PageNo: Sof 1
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
6. For clarity within this document, field sizes are shown within ‘Report Layout’ and not within
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 and shading referred to in this
document) will not be included within the file. Every line will have the character ‘newline’,
Hex 'OA', 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’
3.2. NB000: Summary Report
This report summarises all reconciliation reports produced by the DRS. It also summarises all reports
that were not produced by the DRS because there was no data to report.
3.2.1 NBO000: Rules
1. Reports are listed by application type, Routing Gateway, and report number.
2. Where a report 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].
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].
©Copyright Fujitsu Services Ltd 2006- FUJITSU RESTRICTED Ref: ‘SVM/SDM/SD/0020
2017 (COMMERCIAL IN CONFIDENCE) _ Version: 4.0
Date: 04-Sep-2017
Page No: 10 of 1
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.2.1.1. NBOOO: Report Layout
NBOO0: DRS Summary Report
Client:
All
Produced on; dd/mm/yyyy at hhchhsss
Run Date:_dd/mm/yyyy
Transaction Type: All
FUJ00080386
FUJ00080386
Application I Routing Gateway Routing Gateway Name Report Number Report Section Filename
Type Number
APP. 9999999999 30 character name NB999 99 appyyyymmddgggeeeeegeNBnnnsstttcur. TXT
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref: ‘SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013
PageNo: 11 of 66
Re)
FUJITSU
End to End Reconciliation Reporting
FUJ00080386
FUJ00080386
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.2.1.2 NBOOO: Data Definition
NB000: DRS Summary Report Client: All Produced on: (Date / Time of report production)
Run Date: (The period for which the report refers) Transaction Type: All
Application I Routing Gateway Routing Gateway Name Report Number Report Section Filename
Type Number
Application I Routing Gateway Routing Gateway name. Shows each report Shows each Where there is data for a report the filename will be
Type (e.g. number. Will be “-* for I Will be “ALL CLIENTS* number for each report section shown:
NBS or reports NB102 sections I for reports NB102 sections 6 I routing gateway for each report
DCP). 6 and 12 as there are and 12 as there are single number appyyyymmddgggagagaggNBnnnsstttcur. TXT,
Will be“ I single reports for all reports for all routing where
where no routing gateways. gateways. Shown against * app is a 3 character application code (e.g.
application Repeated for each each routing gateway Banking and Related Services or DCP)
type is routing gateway within I number .
known. application type * yyyymmdd is the report run date
Repeated for * gggggggggg is the routing gateway number.
each For reports NB102 Sections 6 and 12 use
application ‘0000000ALL’
type.
e NBnnnss is the report number and section
© ttt is the transaction group. For NB101, and
NB102, this will be ‘ALL’.
e curis 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
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref: ‘SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013,
Page No: 12 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.2.2 NB101: Network Banking Settlement Statement
This report identifies ‘C4’ transactions received against each ‘C4 Settlement Date’ as reported to
the DRS for the most recent processing date. The report will be used by Post Office Ltd. as a
basis for settlement of Network Banking transactions with the Financial Institutions (Fis).
3.2.3 NB101: Rules
NB101 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’
4. NB101 will show Deposit and Withdrawal transactions in separate columns, (headed
‘Receipts’ and ‘Payments’ respectively) derived from ‘Txn_Type’
5. NB101 will show a final settlement column derived in the following way:
e Volume: Volume of Deposits plus Volume of Withdrawals
e Value: Value of Deposits minus Value of Withdrawals
e« 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)
eNn>
6. Where the volume for a given ‘C4 Settlement Date’ is nil, the date will not be reported.
7. ‘C4 Settlement Dates’ are shown in reverse chronological order.
8. 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.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN Ref: ‘SVMISDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
Page No: 13 of 66
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.2.3.1. NB101: Report Layout
NB 101: Network Banking Settlement Statement Client:
LINK
Produced on: dd/mm/yyyy at hh:mm:ss
Run Date: dd/mmv/yyyy
Transaction Type: Deposit & Withdrawal
Currency: GBP
Receipts Payments Net Settlement Institution Name
C4 Settlement Date Volume Value 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
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref: SVM/SDM/SD/0020
Version: V3.1
Date 18 March 2013
Page No: 14 of 66
FUJ00080386
FUJ00080386
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.2.3.2 NB101: Data Definition
NB 101: Network Banking Settlement Statement
Client: (Derived from ‘Routing Gateway’)
Produced on: (Date / Time of report production)
Run Date: (The period for which the report refers)
Transaction Type: Deposit & Withdrawal
Currency: (Derived from ‘currency’)
Receipts Payments Net Settlement Institution Name
C4 Settlement Date Volume Value Volume Value Volume Value
Date I 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 I Withdrawals Withdrawals Deposits Rec’d I Deposits Rec’d- _I Routing Gateway
Ree’d Ree’d +No of C4 Value of C4
Withdrawals Withdrawals Ree’d
Ree’d
Date I 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 Ree’d I Withdrawals Withdrawals Deposits Ree’d I Deposits Rec’d- I Routing Gateway
Rec'd Rec'd +No of C4 Value of C4 Reveat Date 1 for each
Withdrawals I Withdrawals Rec'd I, °Peat -ate I lor cae
, Institution with non zero
Ree’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 I Total All Dates Total All Dates I Total All Dates I Total All Dates Total All Dates
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref: SVM/SDM/SD/0020
Version: V3.4
Date 18 March 2013
Page No: 15 of 66
FUJ00080386
FUJ00080386
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3. NB102: Exception Summary
This report is divided into twelve sections:
Section 1: All Uncleared Confirmed, Unconfirmed & POLSAP exceptions
Section 2: Uncleared Exceptioned Client Transactions
Section 3: Uncleared Corruptions
Section 4: Uncleared Timing Differences
Section 5: Uncleared Confirmed, Unconfirmed & POLSAP exceptions >24 hours
Section 6: Uncleared Future Dated Transactions by Client
Section 7: All Cleared Confirmed, Unconfirmed & POLSAP exceptions
Section 8: Cleared Exceptioned Client Transactions
Section 9: Cleared Corruptions.
Section 10: Cleared Timing Differences
Section 11: Cleared Confirmed, Unconfirmed & POLSAP exceptions >24 hours
Section 12: Cleared Future Dated Transactions by Client
ey
Liability issues are not covered within this document, nor are the business processes
involved in the resolution of any exception.
3.3.1 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.
4. For reporting purposes, within NB102 sections 2, 3, 4, 5, 8, 9, 10 & 11, the column headed
‘CAP’ will be blank.
5. 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
ena
6. 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.
7. All Uncleared Confirmed, Unconfirmed & POLSAP exceptions are reported as summary
totals by exception type - (NB102 section 1)
8. Uncleared Exceptioned Client Transactions are listed individually - (NB102 section 2)
9. Uncleared Transaction corruptions exceptions are listed individually - (NB102 section 3)
10. Uncleared Timing Differences are listed individually — (NB102 section 4)
11. Uncleared Confirmed, Unconfirmed & POLSAP exceptions >24 hours are listed individually
— (NB102 section 5)
12. Uncleared Future Dated Transactions are reported as summary totals by Client identified by
Routing Gateway — (NB102 Section 6)
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref: ‘SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
Page 16 of 66
No:
FUJ00080386
FUJ00080386
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Fe)
FUJITSU
13. All Cleared Confirmed, Unconfirmed & POLSAP exceptions are reported as summary totals
by exception type - (NB102 section 7)
14. Cleared Exceptioned Client Transactions are listed individually —- (NB102 section 8)
15. Cleared Transaction corruptions are listed individually — (NB102 section 9)
16. Cleared Timing differences are listed individually — (NB102 section 10)
17. Cleared Confirmed, Unconfirmed & POLSAP 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.
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
‘FQ’.
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 Txn Type codes as defined in Appendix A
Transaction Types
For Banking and Related Services reconciliation reporting, System States 8, 9, 10, 11, 16,
17, 18, 19, 20, 21, 22, 23, E05, E06, E07, E14, E22, E24, E31, E32, E33, E38 are never
expected within report NB102 because ‘S’ transactions are not used in NB.
20.
22.
3.3.1.1. NB102: Section 1: All Uncleared Confirmed, Unconfirmed & POLSAP
exceptions
3.3.1.2 NB102: Section 1 - Report Layout
LINK
NB102 Section 1: All Uncleared
Confirmed, Unconfirmed & POL
FS exceptions
Client:
Produced on:
dd/mm/yyyy at hh:mm:ss
Run Date: dd/mm/yyyy
Transaction Type: Deposit &
Withdrawal
Currency: GBP
Exception Reconciliation Volume Values (8 sub columns)
Type Date
State I ete dd/mm/yyyy 99999999 9999999999.99
State 2 ete dd/mmv/yyyy 99999999 9999999999.99
Sub total 999999999. 9999999999.99.
State E02 ete dd/mm/yyyy 99999999 9999999999.99
Sub total 999999999 9999999999.99
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref: ‘SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
17 of 66
Page
No:
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
[Total Section 1_ I 9999999999 I 9999999999.99 I
End of Report
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref: SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
Page 18 of 66
No:
FUJ00080386
FUJ00080386
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.2.1 NB102: Section 1 - Data Definition
NB102 Section 1: All Uncleared I 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 System State: 1-2, 4-11, 16-18, E01-02 E04-06, E10-12, E14,
where exceptions are being E20-24, E E34 -E36, E38
reported grouped within Received = New + Old
reconciliation date with a sub total I Reconciliation date: <= Run Date
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
End of Report
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref. ‘SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
Page 19 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.3 NB102: Section 2: Uncleared Exceptioned Client Transactions
3.3.1.3.1 NB102: Section 2 — Report Layout
NB102 Section 2: Uncleared Client: = LINK Produced on: dd/mm/yyyy at_ hh:mm:ss
Exceptioned Client Transactions
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Type Date Id Type Type columns)
EB dd/mm/yyyy Char (2) 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:m Code (99) 9999999999.99
State 12 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
E13 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
Total Section 2 9999999999.99
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013
Page 20 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.3.2 NB102: Section 2 — Data Definition
NB102 Section 2: Uncleared Client: (Derived from Routing Produced on: (Date and time of production)
Exceptioned Client Transactions _I Gateway.)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Horizon Txn I Transaction I Bank TxnId I Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Reconciliation Date Id Type Type columns)
‘One row for each exception, 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: 2-15, 20-23, E03, E07 — E09, E13, E25 — E26, E33, E37
s Received = New + Old
date and a grand total for the Reconciliation date: < = Run Dat
section. Where dates are shown I “Cconetlation cate: <™ Kun ate
for the same exception type, list
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013
Page 21 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.4 NB102: Section 3: Uncleared Corruptions
3.3.1.4.1 NB102: Section 3 — Report Layout
NB102 Section 3: Uncleared Client: = LINK Produced on: dd/mm/yyyy at_ hh:mm:ss
Corruption’s
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation I Horizon Txn 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 (2) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E29 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
E31 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
E31 dd/mm/yyyy 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
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013,
Page 22 of 66
No:
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
3.3.1.4.2
NB102: Section 3 — Data Definition
NB102 Section 3: Uncleared
corruption’s
Client:
Gateway.)
(Derived from Routing
Produced on: (Date and time of production)
Run Date: (The period for which
the report refers)
Transaction Type: Deposit &
Withdrawal
Currency: (Derived from ‘currency’)
Exception Type / Horizon Txn Transaction Bank Txn Id Receipt Date Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Id Type Type columns)
‘One row for each corruption, I 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 Sustem State: ev on t
date and a grand total for the Reconciliation date: <= Run Date
section. Where dates are shown .
for the same exception type, list
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
23 of 66
Page
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.5 NB102: Section 4: Uncleared Timing Differences
3.3.1.5.1 NB102: Section 4 - Report Layout
NB102 Section 4: Uncleared Client: = LINK Produced on: dd/mm/yyyy at_ hh:mm:ss
Timing Differences
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Type 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) 9999999999.99
E39 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
E39 dd/mm/yyyy 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
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013
Page 24 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
NB102: Section 4 — Data Definition
NB102 Section 4: Uncleared Client: (Derived from Routing Produced on: (Date and time of production)
Timing Differences Gateway.)
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Horizon Txn Transaction Bank Txn Id Receipt Date 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 7
date and a grand total for the I Svstem State: E39
° Received = New + Old
section. Where dates are shown. R iliation date: <= Run Dat
for the same exception type, list econeniation date: une
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 25 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.6 NB102: Section 5: Uncleared Confirmed, Unconfirmed & POLSAP exceptions >24 hours
3.3.1.6.1 NB102: Section 5 — Report Layout
NB102 Section 5: Uncleared Client: ~~ LINK Produced on: dd/mm/yyyy at hh:mm:ss
Confirmed, Unconfirmed & POL
FS exceptions >24 hours
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP.
Withdrawal
Exception Reconciliation I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy I Values (8 sub
Type Date Id Type Type columns)
State 1 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy Code (99) 9999999999.99
State 2 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy Code (99) 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/yyy’ Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
Total Section 5 9999999999.99
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 26 of 66
No:
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
3.3.1.6.2
NB102: Section 5 — Data Definition
NB102 Section 5: Uncleared Client: (Derived from Routing Produced on: (Date and time of production)
Confirmed, Unconfirmed & POL I Gateway.)
FS exceptions >24 hours
Run Date: (The period for which Transaction Type: Deposit & Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Reconciliation I Horizon Txn I Transaction I Bank TxnId_ I Receipt Date I Receipt Time CAP Discrepancy I 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
ae a ota or cat erand total Sistem State 1, 2, 4-11, 16-18, E01-02 E04-06, E10-12, E14, E20-24, E32, E34-E36, E38
for the section, Note: an extra cccived = Old
oot fi ;. I Reconciliation date: < Run Date
constraint for system states 2 & 18 is I ™ : eae . .
that the Branch must have harvested I {-¢- Where transaction components have remained in the above incomplete states for >24 hours)
(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.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version V3.4
Date: 18 March 2013,
27 of 66
Page
No:
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.7 NB102: Section 6: Uncleared Future Dated Transactions by Client
3.3.1.7.1 NB102: Section 6 - Report Layout
NB102 Section 6: Uncleared All Clients Produced on:
Future Dated Transactions by dd/mm/yyyy at hh:mm:ss
Client
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP.
Withdrawal
Client Reconciliation Date Volume Values (8 sub columns)
LINK dd/mm/yyy' 99999999 9999999999.99
Lloyds dd/mm/yyyy 99999999 999999999999
Total Section 11 9999999999, 999999999999
End of Report
3.3.1.7.2 NB102: Section 6 - Data Definition
NB102 Section 6: Uncleared All Clients Produced on:
Future Dated Transactions by (Date and time of report
Client production)
Run Date: (The period for which} Transaction Type: Deposit & Currency: (Derived — from
the report refers) Withdrawal ‘currency’)
Client / Reconciliation Date Volume [Values (8 sub columns)
One row for each Client derived from System State: All States excluding F99
Routing Gateway where transactions have Reconciliation date: > Run Date
been received with a reconciliation date
ahead of the run date. Where dates are
shown for the same exception type, list in
descending order.
End of Report
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref. ‘SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
Page 28 of 66
No:
Fe)
FUJITSU
End to End Reconcil
FUJ00080386
FUJ00080386
ition Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.8
exceptions
3.3.1.8.1
NB102: Section 7: All Cleared Confirmed, Unconfirmed & POLSAP
NB102: Section 7 — Report Layout
NB102 Section 7: All Cleared
Confirmed, Unconfirmed & POL
FS exceptions
Client: = LINK
Produced on:
dd/mm/yyyy at hh:mm:ss
Run Date: dd/mm/yyyy
Transaction Type: Deposit &
Withdrawal
Currency: GBP
Exception Reconciliation Volume Values (8 sub columns)
Type Date
State I ete dd/mm/yyyy 99999999 999999999999
State 2 etc dd/mm/yyyy 99999999 9999999999.99
Sub total 999999999 9999999999.99
State E02 cic I dd/mmv/yyyy 99999999 999999999999
Sub total 999999999, 9999999999.99
Total Section 1 9999999999 999999999999
End of Report
3.3.1.8.2 NB102: Section 7 - Data Definition
NB102 Section 7: All Cleared
Confirmed, Unconfirmed & POL
FS exceptions
Client: (Derived from Routing
Gateway.)
Produced on:
(Date and time of report
production)
Run Date: (The period for which
the report refers)
Transaction Type: Deposit &
Withdrawal
Currency: from
‘currency’)
(Derived
Exception Type / Reconcili:
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, E04-06,
where exceptions are being El0-12, E14, £20-24, E32, E34-36, E38
reported grouped within Set to F99: New
reconciliation date with a sub total I Reconciliation date: <= Run Date
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.
End of Report
©Copyright Fujitsu Services FUJITSU RESTRICTED (COMMERCIAL Ref. ‘SVM/SDM/SD/0020
Ltd 2013 IN CONFIDENCE)
Version: V3.1
Date: 18 March 2013
29 of 66
Page
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.9 NB102: Section 8: Cleared Exceptioned Client Transactions
3.3.1.9.1 NB102: Section 8 — Report Layout
NB102 Section 8: Cleared Client: = LINK Produced on: dd/mm/yyyy at hh:mm:ss
Exceptioned Client Transactions
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Type Date Id Type Type columns)
EB dd/mm/yyyy Char (2) 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) 9999999999.99
State 12 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
E13 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
Total Section 8 9999999999.99
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013
Page 30 of 66
No:
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
3.3.1.9.2
NB102: Section 8 — Data Definition
NB102 Section 8: Cleared
Exceptioned Client Transactions
Client:
Gateway.)
(Derived from Routing
Produced on: (Date and time of production)
Run Date: (The period for which
the report refers)
Withdrawal
Transaction Type: Deposit &
Currency: (Derived from ‘currency’)
Exception Type / Horizon Txn Transaction Bank Txn Id Receipt Date Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Id Type Type columns)
One row for each exception, Horizon_Txn__ I Txn_Type Bank_Transacti I Receipt_Transa I Receipt_Transa Discrepancy_R I Value of each
with specific system states Num on_Id ction_Date ction_Time eason_Codes transaction
listed in order, grouped component
within reconciliation date For last reported System States: 12-15, 20-23, E03, E07 — E09, E13, E25— E26, E33, E37
with a sub total for each Set 10 F99: N
reconciliation date and a Re _ ili ti a te: <= Run Dat
grand total for the section. econeniation dates <= Suni’
Where dates are shown for
the same exception type, list
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013,
31 of 66
Page
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.10 NB102: Section 9: Cleared Corruptions
3.3.1.10.1 NB102: Section 9 — Report Layout
NB102 Section 9: Cleared Client: = LINK Produced on: dd/mm/yyyy at hh:mm:ss
Corruption’s
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Reconciliation I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Type Date Id Type Type columns)
E28 dd/mm/yyyy Char (2) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) I 9999999999.99
E29 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) 9999999999.99
State 31 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy’ hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
E31 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
Total Section 9 9999999999.99
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013,
Page 32 of 66
No:
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
3.3.1.10.2 NB102: Section 9 — Data Definition
NB102 Section 9: Cleared Client: (Derived from Routing I Produced on: (Date and time of production)
corruption’s Gateway.)
Run Date: (The period for which
the report refers)
Transaction Type: Deposit &
Withdrawal
Currency: (Derived from ‘currency’)
Exception Type / Horizon Txn Transaction Bank Txn Id Receipt Date Receipt Time CAP Discrepancy Values (8 sub
Reconciliation Date Id Type Type columns)
‘One row for each corruption, I 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 For last reported System States: E27 -31
F, Set to F99: New
date and a grand total for the I Be econciliation Date: <= Run Date
section. Where dates are shown . .
for the same exception type, list
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.1
Date: 18 March 2013,
33 of 66
Page
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.11 NB102: Section 10: Cleared Timing Differences
3.3.1.11.1 NB102: Section 10 - Report Layout
NB102 Section 10: Cleared Client: ~~ LINK Produced on: dd/mm/yyyy at_ hh:mm:ss
Timing Differences
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP
Withdrawal
Exception Type I Reconciliati I Horizon Txn Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
on 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/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) _ I 9999999999,99
Sub Total 9999999999.99
E39 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyy hh:mm:ss Code (99) 9999999999.99
Sub Total 9999999999.99
Total Section 10 9999999999.99
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 34 of 66
No:
Re)
FUJITSU
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
3.3.1.11.2 NB102: Section 10 — Data Definition
NB102 Section 10: Cleared Client: (Derived from Routing I Produced on: (Date and time of production)
Timing Differences Gateway.)
Run Date: (The period for which
the report refers)
Transaction Type: Deposit &
Withdrawal
Currency: (Derived from ‘currency’)
Exception Type / Horizon Txn Transaction Bank Txn Id Receipt Date 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 reported System States: E
4 oe Set to F99: New
section. Where dates are shown Reconciliation Date: <= Run Date
for the same exception type, list . “
in descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
35 of 66
Page
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.12 NB102: Section 11: Cleared Confirmed, Unconfirmed & POLSAP exceptions > 24 hours
3.3.1.12.1 NB102: Section 11 — Report Layout
NB102 Section 11: Cleared Client: ~~ LINK Produced on: dd/mm/yyyy at hh:mm:ss
Confirmed, Unconfirmed & POL
FS exceptions > 24 hours
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP.
Withdrawal
Exception Type I Reconciliation Horizon Transaction Bank Txn Id Receipt Date I Receipt Time CAP Discrepancy Values (8 sub
Date Txn Id Type Type columns)
State 1 dd/mm/yyyy Char G2) Code (99) Char (6) dd/mmiyyy. hh:mm:ss Code (99) _ I 9999999999.99
State 2 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) _ I 9999999999,99
State 6 dd/mm/yyyy Char (32) Code (99) Char (6) dd/mm/yyyy hh:mm:ss Code (99) _ I 9999999999.99
Sub Total 9999999999.99
State 6 dd/mm/yyyy Char 32) Code (99) Char (6) dd/mmiyy: hh:mm:ss Code (99) _ I 9999999999,99
Sub Total 9999999999.99
Total Section 11 9999999999.99
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 36 of 66
No:
FUJ00080386
FUJ00080386
o “
FUJITSU End to End Reconciliation Reporting ES
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 37 of 66
No:
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
3.3.1.12.2 NB102: Section 11 — Data Definition
NB102 Section 11: Cleared Client: (Derived from Routing Produced on: (Date and time of production)
Confirmed, Unconfirmed & POL I Gateway.)
FS exceptions > 24 hours
Run Date: (The period for which I Transaction Type: Deposit & Currency: (Derived from ‘currency’)
the report refers) Withdrawal
Exception Type / Reconciliation I Horizon Txn I 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_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 anda I SOTO RSo Na
grand total for the section. Note: . } . « a . . :
an extra constraint for system Transactions that were included on report NB102 Section 5 on ‘yesterday’s’ reports and are not included in NB102 Section 5 on
states 2 & 18 is that the Branch ‘today’s’ reports.”
must have harvested (TPS)
successfully. Should a Branch be
confirmed as non-polling, system
state 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.
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, E38
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. SVM/SDM/SD/0020
Version: V3.4
Date: 18 March 2013,
Page 38 of 66
No:
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
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 All Clients Produced on:
Future Dated Transactions by dd/mm/yyyy at hh:mm:ss
Client
Run Date: dd/mm/yyyy Transaction Type: Deposit & Currency: GBP.
Withdrawal
Client Reconciliation Date Volume Values (8 sub columns)
LINK dd/mm/yyy' 99999999 9999999999.99
Lloyds dd/mm/yyyy 99999999 999999999999
Total Section 11 9999999999, 999999999999
End of Report
3.3.1.13.2 NB102: Section 12 - Data Definition
NB102 Section 12: Cleared All Clients Produced on:
Future Dated Transactions by (Date and time of report
Client production)
Run Date: (The period for which Transaction Type: Deposit & Currency: (Derived from
the report refers) Withdrawal ‘currency’)
Client / Reconciliation Date Volume [Values (8 sub columns)
One row for each Client derived from System State: All States
Routing Gateway where transactions have All transactions that were included on report NB102 Section 6
been received with a reconciliation date on ‘yesterday’s’ reports and are not included in NB102 Section
ahead of the run date. Where dates are 6 on ‘today’s’ reports.
shown for the same exception type, list in
descending order.
End of Report
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN _ Ref. SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date 18 March 2013
PageNo: 39 of 66
FUJ00080386
FUJ00080386
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
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 T&I
2 V Vv 1&5 T&I
4 V 1&5 T&I
5 v 1&5 7&1
6 Vv V 1&5 7&1
7 v V 1&5 7&1
8 V 1&5 7&1
9 V V 1&5 7&1
10 V V 1&5 7&1
u V v v 1&5 7&1
12 Vv 2 8
13 V Vv 2 8
14 Vv Vv 2 8
15 V V V 2 8
16 Then ¥ V 1&5 T&1
17 Vv Then V y 1&5 T&11
18 V Then ¥ V 1&5 T& 11
20 V Then ¥ 2 8
21 V V Then V 2 8
22 Vv V Then ¥ 2 8
23 V v NV Then ¥ 2 8
Shaded lines represent System States not expected to be reported within the Banking and Related
Services report set
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN _ Ref: ‘SVMISDM/SD/0020
CONFIDENCE) Version; V3.1
Date: 18 March 2013
PageNo: 40 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
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
E01 Additional C112 1&5 7T&ll
E02 Additional C12 1&5 T&L
E03 Additional D 2 8
E04 Additional C4 1&5 7&1
E05 Additional S 1&5 7&1
E06 S after C4 1&5 7T&il
E07 S after D z 8
E08 C4 after D 2 8
E09 Dafter C4 2 8
E10 C112 after final state 1&5 T&1
Ell C12 after final state 1&5 7T&U
El2 C4 after final state 1&5 7T&l
El3 D after final state 2 8
El4 S after final state 1&5 T&M
E15 Not Used
E16 Not Used
El7 Not Used
E18 Not Used
E19 Not Used
E20 Amount of C112#C12 1&5 7&l
E21 Amount of C112#C4 1&5 7T& ll
E22 Amount of C112#S & C112#0 1&5 7&1
E23 Amount of C12#C4 1&5 7&1
E24 Amount of C12#S & C12#0 1&5 7&ll
E25 Amount of C112#D 2 8
E26 Amount of C124#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 2) 9:
E32 Amount of C4#S & C4#0 1&5 T&il
E33 Amount of D#S 2 8
E34 C112 arrived after state F99 1&5 7&ll
E35 C12 arrived after state F99 1&5 7T&ll
E36 C4 arrived after state F99 1&5 T&L
E37 D arrived afier state F99 2 8
E38 S arrived after state F99 1&5 7&1
E39 Settlement Date # Reconciliation Date 4 10
Shaded lines represent System States not expected to be reported within the Network Banking report set
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 41 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
en
lciical a 8
‘xeataton Jarves ten preva
(on reomplaerComp err go 27 es €29 60, ES
lie on ry Se means tog) BU Adon
hi _CarAget NOE TPS ‘then vai goio Sab I Anaurtacon I anourezcten I craton Setonert Ose Aeon I sets
ant” 0 E14 et
+e 6&2 12 10 Fe0
ze 3 £02 Eos 09, Foe I Chawowize hte Ores ORE fo
fra 3c ce atte fio ett er2 €19 Eu] crtzecize2) —_ertawonent Ch Ste toe R29
4 o 72 e04 £09 06 : 8
6 oe wie Tou} Foo
6 mR en Eo coo 3 16 1 I Ghtawcize0 : Fs
7 cH one I 2 E04 09 EOE I crtzace zt Ch See oe 9 Fo
+ § 9 10 16 2 £06 Fo
° son ei 11 17 m1 fovtews acrizmexe See tee CRED Fo
woes 11 E02 18 22 E06 I Crews aro ED : ‘ao Dee CRETD Fs9
nce 8 ate eri ea 19 2 eos] ciizecizezo Grows ACEMEN Sao Dae CRED 9
® D 1412 Eov EoD oT 9
2b 16. E02 em E00 cor I —CIOWD(CIR)ERS Ste Cie 19 9
oan Eo 16 e08 09 E07 I chiowoqcia) exe D Sate eRe O19 0
sc Dome Et E00 ent 02 E07 I ciizacizez — _CHISWD(CIR) ERS : D soe Dee ORE 9
16 act 17 18 etd €09 €05 I cuws ecumere Ch Sate ec DRE29 9
7 sted 63 Eni 19 ene coo e06 I chtzwcuez! Cus ACHMED (Ct Ste Pe ORE29 Fa
te) 6 sica 19. Eig ou E09) Eos I cIzACHEZS —_cuMs BcAM Ee = (Sete Ce: DN Foo
Fri 19 ceca cate E10 eM €12 19 E14 I CrtzMcize20 ————CI2WCHERD CaS RCHADIED? I See Rec DLED®
2 80 Zz eos G00 ene I OWED 0 Sete Dec Ot fos
a sm cH Ect 22 cor €03 ene [crtaws crime — DAWSER 0 Ste Oc Ot 29 0
2c sp 22 G2 Eos E00 EOE I CIOWBACIAIWEM —— DAWSED ete Dic 09 Fe
Bons i or_£02 cos 09 G05 I crtzwcize20 cttw actizwite —OMAwaiets I Sete De OCE99 fs,
Ht Asana C112 > 7
2. Aditenal C12 : Fo
0. Addbenal 0 : fo
04 Adena CA : 9
06 Adda § F0
Ee Sate CA > P29
er Sate 0 9
ot Chater 9
09 Dater cl 29
E10” C12 aro 79
E11 C2 tert see : : 9
END Cl aer tna ae F09
E10 Ofer tna sea =e : Fa
E14 Sater fal ce i
E16 Nad >
E16 Need :
E17 Nese ee :
E18 Notes = = - -
£19 Noted aa : :
E20 Anatol CWO i
E21 Anatol C112WCA ate Fo
£22 poco C1248 &C1I2M fs
£23 pnautot C12WCA fo
E24 Amat CIWS &CTEHO Fo
£25. mroutal C112¥0 - 9
E26 Amour C12WO : 29
EZT_cmptsCargh CTD 729
£21 InconpetOaragt C2 fo
£29 rconpeterCart F00
00 eampevCargt 9
Est eomplebOorugt 3 9
EXE Amal COWS & Za
0pm tO f8
Et C112 ied ae Se FD > 7
D6 C12 ried at ste 20 ate : 0
D6 Chae ater a 29 =e 0
7 Davedaer F29 eras 0
Est Saeed arse £00 : : fs
£59” Setenort Oss ¥ Recon Oa = a
al Fo MOU resoled Bree ee oT oe
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN _ Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date 18 March 2013
PageNo: 42 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
4 APS Reconciliation
The diagram below shows the flow of transaction details APS to APS Client.
Counter
APS Transaction Data Flows Systems
APS Transactions & Branch AllTransactions &
APS Transaction Summary ‘Database. Transaction Summary
feconciationRepons APS Host rancatons a TRSHost.
Fujitsu) I AP Clients I I POL I I POLSAP I I Credence I
Figure 1 — APS Transaction Data Flows
End of Day Daily summaries are calculated at the BRDB to ensure that reconciliation can be performed
between TPS and the Counter Estate.
Transaction data is transferred from the Branch Database to the APS Host, this includes an APS
Transaction Summary from each branch.
TPS passes a file of all TPS-Harvested APS transactions to the APS host for reconciliation.
The reconciliation procedure is run and produces a number of reports detailing the reconciliation
between the APS client payments and the corresponding transactions from TPS.
The APS Host system passes summaries of transactions that have been passed to APS Clients. This
report is called the Client Transmission Summary (CTS) report.
4.1 Reconciliation between Client Transmission files and
cTs
The end to end transaction flows are supported by validation processes which verify that the transactions
processed by the APS Host are consistent with the transactions included in each Client Transmission
File and with the CTS sub-file sent to Post Office Ltd.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 43 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
This validation is carried out for the volume of normal transactions and the value of all transactions only
in each of these files. A Validation Status report (section 4.8) will be produced as part of this validation
process and the results of this notified to Post Office Ltd.
4.2 Accounting Sense
Reconciliation reporting operates on a seven day a week basis regardless of the Client file transmission
schedule (which may, for example, exclude weekends and bank holidays). In principle, reconciliation
reporting totals volume and value for transactions. It includes reversals by adding volume and
subtracting value.
Thus, for In-pay transactions:
e Volume is positive and added (net result: add)
e Value is positive and added (net result: add)
e Reversal volume is positive and added (net result: add)
e Reversal value is positive and subtracted (net result: subtract)
For Out-pay transactions:
e Volume is positive and added (net result: add)
e Value is negative and added (net result: subtract)
e Reversal volume is positive and added (net result: add)
e Reversal value is negative and subtracted (net result: add)
Reporting has to be able to show a representation of negative value. To be consistent with other
reconciliation reporting, this will be done with the use of parenthesis rather than the use of a prefix sign,
€.g. (23.42) represents the value -23.42.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 44 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
4.3 APS Reconciliation / Reporting Points
Four reconciliation points are identified.
The first Reconciliation Point is the main APS Host reconciliation and reporting point. It confirms the
APS accounts are balanced for the processing day and provides a balance statement, a Client delivery
summary report and a transaction exception report.
The second Reconciliation Point is transaction reconciliation between:
e the APS transactions at Branches;
« the APS transactions delivered by TPS to POLSAP;
e the APS transactions delivered by APS to Clients.
It provides a reconciliation summary report, transaction exception Client account and detailed reports.
The third Reconciliation Point reports on non-harvested branches. This reconciliation point is no longer
used.
The fourth Reconciliation Point is an intermediate point to help the operational management. It is not
necessary to meet requirements; it confirms consistency between:
e the APS transactions at branches;
« the APS transactions delivered to APS Clients.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 45 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
4.4 APS Reconciliation / Reporting Point 1
4.4.1 Description
At the beginning of a normal processing day (about 8am), the APS Host is expected to have delivered all
APS transactions for previous processing days to Clients. However, there may be some transactions
quarantined because they have failed an APS validation check.
During normal branch hours action is taken to resolve these transactions and, once resolved, the most
likely outcome is that the transaction is returned into the normal delivery stream. However, the APS Host
system does cater for instances where an APS transaction cannot be returned to normal processing and
needs to be processed manually. Therefore, during normal branch hours exception transactions may be
returned to normal processing or, possibly in very rare circumstances, put into manual processing.
During the evening of the processing day APS transactions from counters are delivered to the APS Host.
The transactions are validated by the APS Host and are put into quarantine if validation fails.
The APS Host delivers valid APS transactions to APS Clients. Transactions are delivered to clients
according to the delivery schedule agreed with each client (Daily, weekly, specific days etc).
Transactions that are not due for delivery are stored until such time that they are due.
This reconciliation point is at the end of the processing day when all these transaction flows are
reconciled and reported.
4.4.2 APSS2133 - APS Daily Account Balancing Report
Objectives: To confirm that the APS transaction account balances for the processing day.
Users: Post Office Ltd and Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day.
Outline contents:
APS Daily Account Balancing Report
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
APS TPS
Description Number Value (£) Number Value (£)
Opening Balance 9,999,999 — 999,999,999.99 B/Fwd
Pathway Harvested Transactions 9,999,999 999.999,999.99 9,999,999 999,999,999.99
Transactions Received from HAPS 9,999,999 — 999,999,999.99
Receipt Sub Total 9,999,999 999,999,999.99
APS Transactions Delivered to HAPS. 9,999,999 — 999,999,999.99
APS Transactions Delivered to Clients 9,999,999 999,999,999.99
APS Transactions Delivered to Manual 9,999,999 — 999.999,999.99
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 46 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
APS Transactions Delivered to TIP 9,999,999 999,999,999.99
Delivery Sub Total 9,999,999 999,999,999.99
Delayed APS Transactions 9,999,999 999,999,999.99 C/Fwd
Reconciliation Error 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Sort order: As shown above.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Opening Balance: These are the figures that were shown as “Delayed APS Transactions” on the
previous day's report
Pathway Harvested Transactions (Pathway should read BRDB but this is hard coded in the
report): The APS transactions (total number and total value) for all Clients delivered by the Branch
database to both APS and TPS for the current day. This includes transactions that were quarantined on
the current Trading Day
APS Transactions Delivered to Clients: The APS transactions (total number and total value) delivered
to the Clients for that processing day’s transmission. The totals may include transactions that were not
delivered to clients because the Delivery Agreement did not require a file delivery to be made.
APS Transactions Delivered to Manual: The APS transactions (total number and total value) that have
failed validation and Customer Services are to resolve manually using the APS Workstation tool.
APS Transactions Delivered to TIP: The APS transactions (total number and total value) delivered to
POLSAP for the current processing day. This is identical to the value of Pathway Harvested
Transactions delivered to TPS since it is assumed that all transactions received by TPS will be delivered
to POLSAP (If there is a failure to deliver to POLSAP then this will be recorded in the Incomplete
Summaries report that is described in section 5.3).
Delivery Sub Total: The total number and total value of APS Transactions Delivered to BRDB, APS
Transactions Delivered to Clients and APS Transactions Delivered to Manual.
Delayed APS Transactions: The total number and total value of APS transactions that are in
quarantine due to validation failures. The Delayed APS Transactions appears as the Opening Balance in
the next days’ APS Daily Account Balancing Report.
Reconciliation Error: For APS: the Receipt Sub Total minus the Delivery Sub Total minus the Delayed
APS Transactions. For TPS: The Harvested Transactions (TPS) minus the APS Transactions delivered
to POLSAP.
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
HAPS: HAPS is no longer part of the solution and all values and volumes relating to HAPS transactions
will therefore be zero.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 47 of 66
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
FUJ00080386
4.4.3 APSS2133b - APS Client Summary Report
Objectives: To provide a summary of the transactions, which have been delivered by APS during the
processing day. The summary is produced by the clearing agent (i.e. the organisation to which Fujitsu
Services deliver the transactions). For each clearing agent, a breakdown is provided by Client account
for each transaction date. Transactions delivered to Manual are processed manually and consequently
are not reported here.
Users: Post Office Ltd and Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day
Outline contents:
APS Client Summary Report
Processing Date: dd/mm/yyyy
Report Date:
Report Time:
dd/mm/yyyy
hh:mm:ss
Client Sub Total
Clearing Agent Client, Client Account Name —_Transaction Transaction Totals
Account Date
Number Value (£)
APSDustbin ssss Client 6 dd/mm/yyyy 9,999,999 999,999,999.99
dd/mm/yyyy 9,999,999 999,999,999.99
Client Sub Total 9,999,999 999,999,999.99
Clearing Agent Total 9,999,999 999,999,999.99
PODGGeneric nnn Client 1 dd/mm/yyyy 9,999,999 999,999,999.99
dd/mm/yyyy 9,999,999 999,999,999.99
Client Sub Total 9,999,999 999,999,999.99
0000 Client 2 dd/mm/yyyy 9,999,999 999,999,999.99
Client Sub Total 9,999,999 999,999,999.99
Clearing Agent Total 9,999,999 999,999,999.99
PODGGirobank ppp Client 3 dd/mm/yyyy 9,999,999 999,999,999.99
dd/mm/yyyy 9,999,999 999,999,999.99
9,999,999
999,999,999.99
qqaq Client 4 dd/mm/yyyy 9,999,999 999,999,999.99
Client Sub Total 9,999,999 999,999,999.99
rrr Client 5 dd/mm/yyyy 9,999,999 999,999,999.99
Client Sub Total 9,999,999 999,999,999.99
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref. SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date 18 March 2013
Page No:
48 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Clearing Agent Total 9,999,999 999,999,999.99
Grand Total 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Sort order: The sort order will be ascending on Clearing Agent. Within each of these, the sort order will
be ascending by Client Account and within that by Transaction Date in reverse chronological order.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Clearing Agent: This is an historic term that has very little meaning left since the functionality for
delivery of AP Client files to clients and their agents has been subsumed to PODG.
Client Account: The number of the Client account for which APS transactions have been delivered.
Client Account Name: The name of the Client account for which APS transactions have been
delivered.
Transaction Date: The chronological date on which the transaction was committed on the HNG-X
Counter system. The entry on this report is normally the current transaction day but can include earlier
dates due to late harvesting or delayed APS Transactions (see section 4.4.2).
Transaction Totals: The total number and total value of APS transactions received by the APS Host
system for the Client account for the transaction date.
Client Sub Total: The sum of the total number and total value of APS transactions delivered to the
clearing agent for the specific corresponding Client account for all transaction dates.
Clearing Agent Total: The sum of the total number and total value of APS transactions delivered to the
clearing agent for all the corresponding Client accounts for all transaction dates.
Grand Total: The sum of the total number and total value of APS transactions delivered to all clearing
agents for all transaction dates. This should match the figure for “APS transactions delivered to Clients”
on APS Daily Account Balancing Report (see section 4.4.2).
Reconciliation Error: The Grand Total minus the APS Transactions delivered to HAPS on the APS
Daily Account Balancing Report (Always zero) minus APS Transactions Delivered to Clients on the APS
Daily Account Balancing Report (see section 4.4.2). Since HAPS is always zero then this figure should
also always be zero.
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
HAPS: HAPS is no longer part of the solution and all values and volumes relating to HAPS transactions
will therefore be zero.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 49 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
44.4 APSS2133c - APS Delayed Transactions Report
Objectives: To provide details of all transactions which have not been delivered by Fujitsu Services
because they have been delayed/quarantined within the APS Host system. Initial Customer Support
resolution will cause the transactions to be returned for normal processing or sent to manual for manual
processing. TPS quarantined APS transactions will show up as a discrepancy on the APS Daily Account
Balancing Report (see section 4.4.2). TPS quarantined transactions are identified and reported in
sections 5.1 and 5.2 below.
Users: Post Office Ltd and Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day.
Outline contents:
APS Delayed Transactions Report
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Transaction Date Transaction Details Value (£ Error Message
dd/mm/yyyy APS Transaction Details 1 999,999,999.99 Reason for Delay 1
APS Transaction Details 2 999,999,999.99 Reason for Delay 2
APS Transaction Details 3 999,999,999.99 Reason for Delay 2
dd/mm/yyyy APS Transaction Details 4 999,999,999.99 Reason for Delay 1
APS Transaction Details 5 999,999,999.99 Reason for Delay 3
TOTAL (Count) 999,999,999.99
Reconciliation Error (Count) 999,999,999.99
Sort order: Chronological order on Transaction Date. Within this, the sort order will be ascending on
Transaction Details.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The chronological date on which the transaction was committed on the HNG-X
Counter system. The entry on this report is normally the current transaction day but can include earlier
dates due to late harvesting or delayed APS Transactions (see section 5.1.2).
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 50 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Transaction Details: Details of the APS transactions which have been delayed. The Transaction Details
will appear in the order shown below and will be:
Clearing Agent.
Client Account & Name.
Client Code.
Item.
FAD Code.
Time.
Customer Reference.
Receipt Reference.
Receipt Serial Number.
Reversing/ Reversed Receipt Reference.
Reversing/ Reversed Receipt Serial Number.
Transaction Type.
Error Message: The reason the APS transaction has been delayed. This includes problems concerning
transaction validation checks.
Reconciliation Error: The Total for the Count and Value of transactions minus the Delayed APS
Transactions (Number and Value) on the APS Daily Account Balancing Report (see section 5.1.2).
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.5 APS Reconciliation / Reporting Point 2
4.5.1 Description
Normally, APS transactions flow through the TPS Host to POLSAP and through the APS Host system
within the same working day. However, the rules associated with the processing of APS transactions
within the TPS Host and the APS Host systems are different. Consequently, transactions may be placed
in exception status by APS but be accepted as valid by TPS. This reconciliation point is at the end of the
processing day. It reconciles the:-
e APS transactions at Branches;
e APS transactions delivered by TPS to POLSAP;
It maintains a record of which transactions have passed through the TPS side and which transactions
have passed through the APS side and on a daily basis it reports transactions which have been
processed by one side and not the other.
4.5.2 APSS2136 - Daily TPS / APS Transaction Reconciliation
Summary Report
Objectives: To compare Branch APS transaction totals with the actual POLSAP and Client delivered
APS transaction totals for the last N days. There may be some error conditions where some differences
will show for the most recent days; but all these differences will disappear in a very few days after the
processing date demonstrating that all APS transactions at Branches are delivered to POLSAP and
Clients.
Users: Post Office I td and Fuljitsi Services Post Office Account
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 51 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Frequency: At the end of each APS processing day.
Outline contents:
Daily TPS / APS Transaction Reconciliation Summary Report
Processing Date: dd/mm/yyyy Report Date: dd/mmv/yyyy
Report Time: hh:mm:ss
Office Transactions Pathway Delivered Difference (1
Transaction Number Value (£) Number Value (£) Number Value (£)
Date
Date 1 9,999,999 999,999,999.99 TIP 9,999,999 — 999,999,999.99 9,999,999 —999,999,999.99
Clients 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Difference (2) 9,999,999 — 999,999,999.99
Date 2 9,999,999 999,999,999.99 TIP 9,999,999 — 999,999,999.99 9,999,999 999,999,999.99
Clients 9,999,999 999,999,999.99 9,999,999 — 999,999,999.99
Difference (2) 9,999,999 999,999,999.99
Date N 9,999,999 999,999,999.99 TIP 9,999,999 —999,999,999.99 9,999,999 999,999,999.99
Clients 9,999,999 — 999,999,999.99 9,999,999 999,999,999.99
Difference (2) 9,999,999 — 999,999,999.99
Sort order: Reverse chronological order on Transaction Date.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The last N dates for which transactions were delivered and for which differences in
the total number and/or total value of:
e APS transactions at Branches;
e APS transactions delivered by TPS to TIP (POLSAP);
e APS transactions processed by APS (not necessarily delivered to Clients since delivery
agreements do not always deliver daily),
have been identified and still exist.
Office Transactions: The total number and total value of APS transactions at Branches for the
corresponding transaction dates. This is derived from a summary provided by the Branch Database.
Pathway Delivered Transactions:
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 52 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
TIP: The volume and value of APS transactions that were processed by the TPS
system
Clients: The volume and value of APS transactions that were processed by the APS
system
Difference (2): TIP minus Clients
Difference (1): The Branch Transactions number and value minus the TIP number and value, and the
Branch Transactions number and value minus the Client number and value for the corresponding
transaction dates.
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.5.3 APSS2136b - Daily TPS / APS Transaction Reconciliation
Client Account Exception Report
Objectives: To identify Client account exceptions when comparing the actual number and value of
transactions that were processed by TPS (TIP) and APS (Client) for the last 30 days.
Users: Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day.
Outline contents:
Daily TPS / APS Transaction Reconciliation Client Account Exception Report
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Clearing Agent Client Account Pathway Delivered
No & Name
Transaction Number Value (£)
Date
Date 1 PODGGeneric Client 1 TIP 9,999,999 999,999,999.99
Client 9,999,999 999,999,999.99
Difference 9,999,999 999,999,999.99
Client 2 TIP 9,999,999 999,999,999.99
Client 9,999,999 999,999,999.99
Difference 9,999,999 999,999,999.99
Client 3 Client 3 TIP 9,999,999 999,999,999.99
Client 9,999,999 999,.999,999.99
Difference 9,999,999 999,999,999,99
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref. SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date 18 March 2013
PageNo: 53 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Total Difference 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Date N PODGGiro Client 1 TIP 9,999,999 999,999,999.99
Client 9,999,999 999,999,999.99
Difference 9,999,999 999,999,999.99
Total Difference 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Sort order: Reverse chronological order on Transaction Date. Within this, the sort order will be
ascending on Clearing Agent.
Within this, the sort order will be ascending on Client Account.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The last N dates for which transactions have delivered for which differences in the
total number and/or total value of TPS and APS delivered APS transactions have been identified and
still exist at Client account level.
Difference: For each date and Client, the TIP number and value minus the Client number and value for
delivered.
Clearing Agent: This has little or no meaning now that all Client Files routed by the Post Office Data
Gateway (PODG)
Client Account No and Name: The Client account number and name for which differences in the total
number and/or total value of TPS and APS delivered APS transactions have been identified and still
exist at Client account level.
Pathway Delivered: The total number and total value of POLSAP and Client delivered APS transactions
for the corresponding transaction dates.
Total Difference: The total Number and total Value of the Difference for all Clients for the specified
date.
Reconciliation Error: Total Difference minus Difference (2) from the Daily TPS / APS Transaction
Reconciliation Summary Report for the specified date (see section 5.2.2).
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 54 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
4.5.4 APSS2136c - Daily TPS / APS Transaction Reconciliation
Detail Exception Report
Objectives: To report all transactions for the last 30 days which are different in POLSAP to Client
delivery. Differences may occur either as a result of some error condition, or in the case of unmatched
TPS/POLSAP transactions, as a result of business processing rules being different from those of
APS/Client transactions.
Users: Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day.
Outline contents:
Daily TPS / APS Transaction Reconciliation Detail Exception Report
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Transaction Source Transaction Details Error Message
Date
Date I TPS/TIP TPS/TIP Transaction Details 1 Discrepancy 1
APS/Client APS/Client Transaction Details 1 Difference 1
TPS/TIP TPS/TIP Transaction Details 2 Discrepancy 2
APS/Client APS/Client Transaction Details 2 Difference 2
TPS/TIP Only Count 9,999,999 “Unmatched”
APS/Client Only Count 9,999,999 Difference 3
Number Value (£
Total Difference 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Date 2 TPS/TIP TPS/TIP Transaction Details 3 Discrepancy 3
APS/Client APS/Client Transaction Details 3 Difference 1
TPS/TIP Only Count 9,999,999 “Unmatched”
APS/Client Only Count 9,999,999 Difference 3
Number Value (£)
Total Difference 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Date 3 TPS/TIP TPS/TIP Transaction Details 3 Discrepancy 3
APS/Client APS/Client Transaction Details 3 Difference 1
Number Value (£)
Total Difference 9,999,999 999,999,999.99
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref. SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date 18 March 2013
PageNo: 55 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Reconciliation Error 9,999,999 999,999,999.99
Date N TPS/TIP TPS/TIP Transaction Details n Discrepancy n
APS/Client APS/Client Transaction Details n Difference n
Number Value (£
Total Difference 9,999,999 999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Sort order: Reverse chronological order on Transaction Date. Within this, the sort order will be
ascending on Transaction Details as defined below.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The last N dates for which transactions have been delivered and for which
differences in the total number and/or total value of TPS and APS delivered APS transactions have been
identified and still exist at a detailed level.
Source: Identifies whether the exceptions are due to APS harvesting discrepancies or due to
POLSAP/Client delivery discrepancies.
Transaction Details: Details of the APS transactions for which only an APS/Client record was found (ie:
a quarantined TPS transaction) or only a TPS/TIP was present (ie: the APS record was quarantined) for
the corresponding transaction dates. The Transaction Details will be:
FAD Code. K
Time. K
Receipt Reference. K
Receipt Serial Number. K
Transaction Type. Cc
Client Code. c
Customer Reference. c
Method of Capture. Cc
Value. Cc
Clearing Agent. s
Client Account and Name. Ss
Reversing/Reversed Receipt Reference. Ss
Ss
Reversing/Reversed Receipt Serial Number.
Key to above:
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 56 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
K=> Transactions from APS are matched with APS transactions from TPS on these fields. All
transactions for which no match can be made appear in this report with the error message “Unmatched”.
In addition to the marked fields, above, “Transaction Date” is a “K” field.
C=> Matching APS transactions from APS and TPS are compared on these fields. If any of these
fields are different, both transactions appear on this report with the appropriate error message.
S => Fields shown from the APS transaction only
TPS/TIP Only: Unmatched TPS transactions are transactions that appear in TPS and are delivered to
POLSAP but for which there are no matching APS transactions. Such transactions may occur, for
example, due to business processing rules for TPS and APS being different. For Dates 1 and 2 only,
unmatched TPS transactions will not be detailed individually, but a total count and value will be entered.
For Dates 3 to N, unmatched TPS transactions will be detailed individually.
APS/Client Only: Unmatched APS transactions are transactions that appear in APS and are delivered
to Clients but for which there are no matching TPS transactions. Such transactions are not expected
other than in error conditions. For Dates 1 and 2 only, unmatched APS transactions will not be detailed
individually, but a total count and value will be entered. For Dates 3 to N, unmatched APS transactions
will be detailed individually.
Error Message: The error message identifying the APS transaction discrepancy. This includes problems
concerning synchronisation between HNG-X and POLSAP on Client accounts, HNG-X security checks,
and transaction validation checks. The message “Unmatched” will be used for unmatched TPS or APS
transactions.
Difference: The Value of the TPS/POLSAP Transaction minus the Value of the APS/Client Transaction.
Note: Difference 3 is the Unmatched TPS Value minus the Unmatched APS Value.
Total Difference: The Count of the total Number of TPS Transactions minus the total Number of APS
Transactions, and the total Value of the Difference for all Transactions for the specified date.
Reconciliation Error: Total Difference minus Difference (2) from the Daily TPS / APS Transaction
Reconciliation Summary Report for the specified date (see section 5.2.2).
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.6 APS Reconciliation / Reporting Point 3
4.6.1 Description
The APS Harvester Reconciliation was used to ensure all Horizon Branches had been harvested. As
HNG-X does not rely on harvesting of transaction this report is no longer relevant.
4.6.2 I APSS2139 - Daily APS Office Harvesting Report
The APS Harvester Reconciliation was used to ensure all Horizon Branches had been harvested. As
HNG-X does not rely on harvesting of transaction this report is no longer relevant.
4.7 APS Reconciliation Point 4
4.7.1 Description
The APS measures the difference between what the BRDB passed to APS and what BRDB thought that
it passed to APS — the two may differ.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 57 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
BRDB creates a summary of all transactions by branch and passes this to APS. APS adds up all the
transaction detail that was given to it and compares to the summary. Where there is a difference it is
reported.
4.7.2, APSS2140 - APS Harvester Transaction Totals Summary
Objectives: To provide Branch totals and harvested totals by transaction date for each of the last 30
transaction days for the APS Harvester.
Users: Fujitsu Services Post Office Account
Frequency: Following completion of the APS harvester each day
Outline contents:
APS Harvester Transaction Totals Summary
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Transaction Office Totals APS Harvested Totals Difference
Date
Number Value (£) Number Value (£) Number Value (£)
Date 1 9,999,999 999,999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Date 2 9,999,999 999,999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Date N 9,999,999 999,999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Sort order: Reverse chronological order on Transaction Date.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The last N dates for which transactions have been harvested and for which
differences in the total number and/or total value of:
e APS transactions at Branches;
e Transactions harvested by APS.
have been identified and still exist.
Office Totals: The total number and total value of Branch APS transactions for the given date from
Branches that have been harvested
APS Harvested Totals: The total number and total value of APS harvested APS transactions for the
given date.
Difference: The Branch Totals (number and value) minus the APS Harvested Totals (number and value)
for each Transaction Date.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 58 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.7.3 APSS2140b - APS Harvester Transaction by Office
Objectives: To provide details by Branch code of any discrepancies that exists in the overall totals
shown in the APS Harvester Transaction Totals Summary (see section 5.4.2).
Users: Fujitsu Services Post Office Account.
Frequency: Following completion of the APS harvester each day.
Outline contents:
APS Harvester Transaction Totals by Office
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Transaction, FAD Office Totals APS Harvested Totals Difference
Date Code_&
Name
Number Value (£) Number Value (£) Number Value (£)
Date 1 123456 9,999,999 — 999,999,999.99 9,999,999 999,999,999.99 9,999,999 999,999.999.99
345678 9,999,999 999.999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
456654 9,999,999 999,999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
Total 9,999,999 999,999,999.99 9,999,999: 999,999,999,.99 9,999,999 _999,999,999.99
Reconciliation Error 9,999,999 —999,999,999,99
Date N 123456 9,999,999 —999.999,999.99 9,999,999 999,999,999.99 9,999,999 999,999,999.99
345678 9,999,999 _999,999,999.99 9,999,999 999,999,999.99 9,999,999 —999,999,999.99
456654 9,999,999 999.999,999.99 9,999,999 999,999,999.99 9,999,999 999,999.999.99
Total 9,999,999 999,999,999.99 9,999,999 999,999,999.99 9,999,999 —999,999,999.99
Reconciliation Error 9,999,999 999,999,999.99
Sort order: Reverse chronological order on Transaction Date. Within that ascending on Branch Code.
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Transaction Date: The last N dates for which transactions have been harvested and for which
differences in the total number and/or total value of:
e APS transactions at Branches;
e APS transactions harvested by APS
have been identified and still exist.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 59 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FAD Code and Name: The Post Office Ltd Branch code and Branch name identifying the Branch for
which TPS/APS harvesting discrepancies still exist.
Office Totals: The total number and total value of Branch APS transactions for the given date and
harvested Branch.
APS Harvested Totals: The total number and total value of APS harvested transactions for the given
date and Branch.
Total: The total number and total value of the transactions for all Branches for the specified date.
Reconciliation Error: The Total number and value minus the corresponding entries from the APS
Harvester Transaction Totals Summary for the specified date (see section 5.4.2).
Difference: The Branch Totals (number and value) minus the APS Harvested Totals (number and value)
for each Transaction Date.
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.8 APS2134 - APS Validation Status Report
Objectives: To identify the success or failure of the APS Validation process. This compares the volume
of normal transactions and the value of all transactions between each Client Transmission file and the
corresponding fields in the CTS sub-file.
Users: Fujitsu Services Post Office Account
Frequency: At the end of each APS processing day
Outline contents:
APS Validation Status Report
Processing Date: dd/mm/yyyy Report Date: dd/mm/yyyy
Report Time: hh:mm:ss
Report message
Field derivations:
Report Date: The date the report was generated.
Report Time: The time the report was generated.
Processing Date: The logical system date set by the APS Host Batch Schedule. This date is constant
for one processing cycle of the daily schedule.
Report Message: If all APS validation was successful, the message will be
[All APS Client transmission files and CTS validated successfully
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 60 of 66
FUJ00080386
FUJ00080386
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
If any validation of a file fails, the message will be:
Validation Error on [filename] for Client: [Client account and name] Count Value
Transaction Tables 9,999,999 999,999,999.99
File 9,999,999 999,999,999.99
Or
Validation Error on Client Transmission Summary Count Value
Transaction Tables 9,999,999 999,999,999.99
File 9,999,999 999,999,999.99
The appropriate message will appear for all files that fail the validation.
Value fields: If any value to be reported is negative, then it shall be enclosed in parenthesis. For
example, the value -£4.23 shall be shown as (4.23).
4.9 APS Report Delivery
Reports for Post Office Ltd are delivered in accordance with security and audit requirements.
Reports for Fujitsu Services Post Office Account are delivered to the MIS Client PC in BRAO1 via FTP.
The 5 APS reports shown below are then sent via email to Post Office Ltd:
1. APSS2133
2. APSS2133b
3. APSS2133c
4. APSS2136
5. APSS2139
4.10 External Transactions
Transactions that are performed on non-Horizon terminals are delivered to AP Clients via the Branch
Database and the APS Service. These transactions are loaded into the Branch Database and are
validated at this point to ensure that subsidiary Horizon systems can complete all necessary
processing. Transactions that fail validation are prevented from being loaded and are automatically
returned to the transaction supplier.
Due to this validation, there should be no further transaction processing failures within the Horizon
service.
However, there is a possibility that an external transaction is queried by an AP Client. This may occur
if the customer who performed an AP transaction queries or disputes the amount of the transaction. In
these instances, Fujitsu would receive the initial query but can only trace the transaction back to the
file in which the transaction was supplied. It is almost inevitable that this type of query will need to be
routed back to the transaction supplier for resolution.
This re-routing will be performed by raising a call with the Post Office Limited Service Desk.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 61 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
A new report has been generated for Post Office Limited called the Rejected Sub-Files Report. Report
Description:-
Ordering of the report is Load Date followed by Trading Date.
The Times Rejected column will indicate how many times that the sub-file has been rejected and will
indicate whether there is an ongoing problem with poor quality data in corrected files.
If the quality of the data in the external transaction file is good then we would not expect any output
from the report.
Branch]
BRDBI Data I Accounting] Trading Times _IReason For
Load Date} Source: CodeI DateIStatus _I Rejected IHold Last ProgressedI
Reconciliation for external transactions is the responsibility of P&BA not the Post Office Account
Reconciliation Service. However, in the event that entries persist on the report the Post Office
Account Reconciliation Service will contact P&BA to ask for these files to be cleared.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 62 of 66
FUJ00080386
FUJ00080386
Fe)
FU ITSU End to End Reconciliation Reporting
} FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
5 TPS Reconciliation Reports Specified
The Transaction Processing System (TPS) Report Set has been designed to enable reconciliation of the
transactions carried out in Post Office branches using the Electronic Point of Sale Service (EPOSS)
which are sent to POLSAP and Credence.
The TPS exceptions report set identified herewith reports errors that have occurred within counter
transactions or during the harvesting process.
NB: For the avoidance of doubt, there is no formal reconciliation produced between the POLSAP and
Credence transaction stream. The Credence stream should therefore not be used to verify financial
integrity and Post Office Ltd should ensure the TPS Report Set and POLSAP transaction stream are
used for this purpose.
IT IS NOT INTENDED THAT FUJITSU SERVICES WILL DELIVER ANY OF THE TPS
RECONCILIATION REPORT SET IDENTIFIED HEREWITH TO POST OFFICE LTD.
The reports specified below are Horizon based Reconciliation Report set.
5.1 TPSC250 - Host Detected Transaction Control Errors
This report is produced daily and shows detail for any Post Office branch where the control totals for the
transactions output by the Host to POLSAP and Credence do not match the Daily Transaction Totals
calculated by the Counters.
TPS RECONCILIATION REPORTS RUN DATE/TIME: 26/10/2006°20:52:53 Page No: 1
PROGRAM: TPSC250
Host Detected Transaction Control Errors
Org Unit Id Group Id Trading Date Number Abs Quantity Absolute Value
69303 128006 ——- 26/10/2006. TPS Total 3097 7
Counter Total 3098
2951
The following data is reported for each exception.
e Organisation Unit Id: Unique identifier for each POCL Branch.
e Group Id: Normally 6 digit Branch Code
e Trading Date: Trading Date is the period of time between consecutive public end of day markers
in message store.
e TPS Total: Control Totals for Number, Absolute Quantity and Absolute Value calculated by the
Host
* Counter Total: Control Totals for Number, Absolute Quantity and Absolute Value calculated by
the Counter.
An “END OF REPORT” message will appear at the end of the report even if there are no errors reported.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18 March 2013
PageNo: 63 of 66
FUJ00080386
FUJ00080386
oO
FU ITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
5.2 TPSC254 — Harvester Exceptions
This report is produced daily and shows a list of exceptions detected by the BRDB copy process when
failing to process one or more messages
19% RECONCILIATION REPORTS UN DATE/TIME: 26/10/2006 20:52:54 PAGE Wor
PROGRAM: TPSC254
gey:-100><Pgty:0><
Deh 313007><L4:3008><L53
ERTRY_MEHOD
(uaa
we
1
vasio02
Be
mano.
129006
26 Mane
[EFFECTIVE_EXCHANGE_ RATE ‘lun 32 Value:
1 EXCHANGE, RATE Colin 32 ¥alue
‘column 34 Yale
‘column 37 ¥alue: 0
Column 39 ¥alue: NULL
STOCK gu
Along with the exception details briefing the reason for the rejection by the BRDB copy process, the
report also shows the contents of the corrupted or incomplete record split up into columns.
An “END OF REPORT” message will appear at the end of the report even if there are no errors reported.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN Ref. SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18 March 2013
PageNo: 64 of 66
FUJ00080386
FUJ00080386
oO
FUJITSU End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
5.3. TPSC257 — POLSAP Incomplete Summaries Report
This report identifies all Post Office branches on a daily basis in which the net total of transactions (debits/credits) does NOT net to a value of zero.
This report also contains any branch that has had a harvester exception as on the TPSC254 report.
FUJITSU SERVICES TRANSACTION PROCESSING SYSTEM Page Not 1
POL FS INCOMPLETE SUMMARIES REPORT FOR 26-OCT-2006
(LIST OF HELD UP POL FS SUMMARIES WHERE THE TOTAL VALUE FROM BRANCH AND TRADING DATE DID NOT BALANCE TO ZERO)
Report No.: TPSC257
Produced on: 26/10/2006 20:
Trading Date Group Id_ Article Id Article Type Trans Mode Acronym Settlement Type Ledger Account: Movement Type Account Value Account Quantity Account
Reference Id Client Reference
26-0CT-2006 120006 so Ro -1 +0
128006 30 RD +0 +0
128006 99 é 552001 =1099
128006 pyo0000253 00 =n)
120006 sa00000141 40 se P 120699 1249, 110
26-ocT-2006 128006 8800000136 40 se E 120012 251 +0 +5
26-ocT-2006 120006 sA00000115 40 se P 120740 499, “4
26-ocT-2006 128006 sA00000056 40 se E 120007 49070 42
26-cT-2006 120006 sAo0000085 40 se E c 120007 +66. 4
26-oct-2006 128006 A00000053 40 si c c 120184 +830 +5
26-0cT-2006 120006 sA00000052 40 se E c 120003 40 “4
26-0cT-2006 128006 sA00000050 40 se E 120003 +3694 “4
26-ocT-2006 120006 sao000004a © 40 se E 120003 428719. 437
26-0cT-2006 128006 sA00000003 40 se c 120088, 4922. “16
26-ocT-2006 120006 sA00000036 40 sc c 120088 ~456 +8
26-cT-2006 128006 $A00000035 40 se c c 120184 “1916. 4
26-ocT-2006 120006 $A00000031 40 sc P c 120008, =3750 433
26-0cT-2006 128006 sA00000013 40 se P c 120748, 4246. 415
26-ocT-2006 128006 sA00000010 40 se P c 121573, 446 487
26-ocT-2006 128006 gvBo000001 33 bop E c 120012 951 -35.0 -3501
26-ocT-2006 128006 gvBo000001 33 sc E c 120012 251 4 +1452
26-0cT-2006 126006 gowo001229 13 se P c 120005, 251 +0, 422
26-0cT-2006 128006 QoBo001226 13 sc z c 120012 251 12 “4
26-ocT-2006 126006 goBo001200 13 se E 120012 251 45) 0
Total Nunber of Held Back Sub-file(s) = 1
‘this is delta position for the date, not the cumulative position of POL FS Incomplete Summaries
+4 End of Report **#
‘©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE) Ref. ‘SVMISDM/SD/0020
Version: V3.4
Date: 18-Mar-2013
Page No: 65 of 66
Fe)
FUJITSU
FU.
End to End Reconciliation Reporting
FUJITSU RESTRICTED (COMMERCIAL IN CONFIDENCE)
FUJ00080386
IJ00080386
The following data is reported for each branch.
Data Attribute
Description
Trading Date
‘The Calendar Date that the EOD Marker was written. EOD Marker defines the
end of a Trading Day. N.B. The time the EOD Marker is written varies from
Branch to Branch.
Group Id Group Id (Branch Code without the check sum) for the branch.
Article Id POLSAP Article
All HNG-X Products will map to a POLSAP Article. This may be a dummy article
to facilitate the consistent mapping of all Products.
Dummy articles will be for items such as Cash in hand, cheques etc that will not
map to an article in POLSAP but actually map to a GL or Agent Account instead.
Transaction HNG-X Mode the product was transacted in, e.g. Sell, Rem In, Revaluation, etc.
Mode Id
Settlement Defines which data is used to settle with the Client
P = Post Office data
C = Client Data
E = Estimated data
This is required as there will be a different indicator used within POLSAP to
differentiate these data types. (Special GL indicator).
This is optional as it is only relevant to Client products and transactions that need
to feed the Client ledger.
Ledger Defines which Ledger the POLSAP account belongs in
G = General Ledger
Client Ledger (AP)
A= Agents Ledger (AR)
POLSAP. uses three different ledgers and needs to know which ledger each
account number is part of.
This field is optional in the file because records that relate only to stock
movements with no financial impact will not map to an account in any ledger.
Account POLSAP account number
This is the account number within the Ledger defined above. This field is optional
in the file because records that relate only to stock movements with no financial
impact will not map to an account in any ledger.
Movement Type
POLSAP Movement type
This is only relevant for stocked products and allows different movement types
such as REM in, REM out, and adjustments to be shown differently in SAP.
There will be a consistent mapping between certain modes to movement types
but these will only be valid for particular Articles.
Account
Reference Id
Transaction Identifier (this field is needed if the information is being sent
unsummarised)
Controlled by reference data.
[DN: This is either the LFS Pouch Identifier or Transaction Correction ID. These
are mutually exclusive and can therefore be harvested into a single NEW
attribute in the TPS interface table called AccountReference .]
Client
Reference
Client Reference number (supplied by Client)
This will only be used for the actioned Transactions Correction being passed back
to POLSAP against the Client products.
An “END OF REPORT” message will appear at the end of the report even if there are no errors reported.
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIAL IN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.4
Date: 18-Mar-2013
Page No: 66 of 66
FUJ00080386
FUJ00080386
FUJITSU FUJITSU RESTRICTED {COMMERCIAL IN COM
(COMMERCIAL IN CONFIDENCE)
A Transaction Types
The following banking and payment card transaction types are supported:
Txn Accounting Accounting
Type I Description Description Sign I Application
3. Withdrawal (with PIN) WITHDRAWALS 1 NBS
4 Withdrawal with balance (with PIN) WITHDRAWALS -1 NBS
5 Withdraw all(with PIN) WITHDRAWALS -1 NBS
8 Withdrawal Correction DEPOSITS 1 NBS
13 Withdrawal (with Signature) WITHDRAWALS -1 NBS
Withdrawal with balance (with
14 Signature) WITHDRAWALS 1 NBS
15 Withdraw all (with Signature) WITHDRAWALS -1 NBS
22 Deposit (No verification) DEPOSITS 1 NBS
27 NS! Cheque Deposit DEPOSITS 1 NBS
41 Purchase (With signature) DEPOSITS 1 DCS
42 Refund (With signature) WITHDRAWALS -1 Dcs
43 Cash Purchase(with Signature) DEPOSITS 1 Dcs
51 ETU Purchase DEPOSITS 1 ETS
52 ETU Refund WITHDRAWALS -1 ETS
62 Deposit DEPOSITS 1 NBS
63 Withdrawal WITHDRAWALS -1 NBS
64 Withdrawal with balance WITHDRAWALS -1 NBS
65 Withdraw Limit WITHDRAWALS -1 NBS
67 Cheque Deposit DEPOSITS 1 NBS
68 Withdrawal Correction ICC DEPOSITS 1 NBS
71 Purchase DEPOSITS 1 DCS
72 Refund WITHDRAWALS -1 Dcs
73 Cash Purchase(with EMV) DEPOSITS 1 Dcs
©Copyright Fujitsu Services Ltd 2013 FUJITSU RESTRICTED (COMMERCIALIN Ref: SVM/SDM/SD/0020
CONFIDENCE) Version: V3.1
Date: 18-Mar-2013,
Page No: 67 of 66