Reporting and reconciliation

To check and confirm that cash register/shop has the same number of transactions as Glase service, merchants can integrate towards the reconciliation feature of Glase service.

Reconciliation is provided with the following calls:

markTransactionPeriod - Marks the end of one and the beginning of a new transaction period; used in reporting.
executeReport - Generates a report for the transaction period.

@startuml skinparam monochrome true Cashregister->Glase: markTransactionPeriod Glase-->Cashregister: ersReference Cashregister->Glase: executeReport (ersReference) Glase-->Cashregister: REPORT_NOT_READY Cashregister->Glase: executeReport (ersReference) Glase-->Cashregister: XML report contents @enduml

Procedure to reconcile transactions and create report

The following are steps to perform reconciliation against Glase from points of sale:

At the end of a working shift or shop hour, a cashier presses a button ‘Close & Reconcile’ on a point of sale. The cash register sends markTransactionPeriod request to Glase to mark end of transactions list for this period. Glase returns with a unique reference number, ersReference.
The point of sale waits for a couple of seconds (around 3 seconds) in order to make sure that all transactions are ready to process for reconciliation report.
The point of sale calls executeReport using ersReference from step 1 to fetch reconciliation report representing transaction summary since the previous reconciliation until the end of transaction list for this period. The report to be specified, using executeReport, depends on whether it is per shop or per terminal reconciliation, see below.
In case the reconciliation report is not ready, Glase will return with result code 2 (REPORT_NOT_READY). The cashier should wait for couple seconds (around 3 seconds) more and repeat step 3 again.

Reports per shop reconciliation

Only one master cash register perform reconciliation process. The reconciliation report will show transactions summary for every point of sale in the shop.

Report ID	Report Name	Description
Reconciliation/Shop.xml	Merchant Transactions	Transaction summary for a shop representing number of transactions and summary amount done for the period.
Reconciliation/STD_RECON_003.xml	Merchant Transactions Details	Transaction details for a shop showing ersReference, cashier, point of sale and amount for the period.

Reports per terminal reconciliation

Every point of sale in a shop performs reconciliation process. The reconciliation report will show transactions summary only for the specific point of sale. In this case, terminalId should be provided when calling markTransactionPeriod.

Report ID	Report Name	Description
Reconciliation/STD_RECON_006.xml	Terminal Transactions Summary	Contains the number of transactions and summary amount purchased/refunded for the period.
Reconciliation/STD_RECON_007.xml	Terminal Transactions Details	Transaction details for a terminal showing reference id and amounts for each transaction in the period.

Example shop reports

Shop report STD_RECON_001 - executeReport SOAP request example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ext="http://external.interfaces.ers.seamless.com/">
   <soapenv:Header/>
   <soapenv:Body>
     <ext:executeReport>
       <context>
          <channel>WS</channel>
          <clientComment>comment</clientComment>
          <clientId>testClient</clientId>
          <clientReference>12345</clientReference>
          <clientRequestTimeout>0</clientRequestTimeout>
          <initiatorPrincipalId>
            <id>hml</id>
            <type>RESELLERUSER</type>
            <userId>9900</userId>
          </initiatorPrincipalId>
          <password>2009</password>
       </context>
       <reportId>Reconciliation/Shop.xml</reportId>
       <language>en</language>
       <parameters>
          <parameter>
             <entry>
                <key>transactionPeriodId</key>
                <value>2012071711291546101000028</value>
             </entry>
          </parameter>
       </parameters>
     </ext:executeReport>
   </soapenv:Body>
</soapenv:Envelope>

Shop report STD_RECON_001 - executeReport SOAP response example

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:executeReportResponse xmlns:ns2="http://external.interfaces.ers.seamless.com/">
         <return>
            <resultCode>0</resultCode>
            <resultDescription>SUCCESS</resultDescription>
            <report>
               <title/>
               <mimeType>text/html</mimeType>
               <content>Cjw/...=</content>
               <contentString><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<TransactionDetails> 
<Meta>
<ResellerId>spectra</ResellerId>
<TerminalId>a2aaebce17bf4e81985a49c7717af14d</TerminalId>
<TransactionPeriodId>2015120408534212001005262</TransactionPeriodId>
<GeneratedAt>2015-12-04 09:09</GeneratedAt> 
</Meta>

<Row>
<TerminalId>a2aaebce17bf4e81985a49c7717af14d</TerminalId>
<CashierId>NULL</CashierId>
<SalesAmount>100.00000</SalesAmount>
<ErsReference>2015120408531541501005256</ErsReference>
</Row>

</TransactionDetails>]]></contentString>
            </report> 
         </return>
      </ns2:executeReportResponse>
   </soapenv:Body>
</soapenv:Envelope>

Shop report STD_RECON_003 - executeReport SOAP request example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ext="http://external.interfaces.ers.seamless.com/">
   <soapenv:Header/>
   <soapenv:Body>
     <ext:executeReport>
       <context>
          <channel>WS</channel>
          <clientComment>comment</clientComment>
          <clientId>testClient</clientId>
          <clientReference>12345</clientReference>
          <clientRequestTimeout>0</clientRequestTimeout>
          <initiatorPrincipalId>
            <id>hml</id>
            <type>RESELLERUSER</type>
            <userId>9900</userId>
          </initiatorPrincipalId>
          <password>2009</password>
       </context>
       <reportId>Reconciliation/STD_RECON_003.xml</reportId>
       <language>en</language>
       <parameters>
          <parameter>
             <entry>
                <key>transactionPeriodId</key>
                <value>2012071711291546101000028</value>
             </entry>
          </parameter>
       </parameters>
     </ext:executeReport>
   </soapenv:Body>
</soapenv:Envelope>

Shop report STD_RECON_003 - executeReport SOAP response example

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:executeReportResponse xmlns:ns2="http://external.interfaces.ers.seamless.com/">
         <return>
            <resultCode>0</resultCode>
            <resultDescription>SUCCESS</resultDescription>
            <report>
               <title>STD_RECON_003_2012071711291546101000028.xml</title>
               <mimeType>text/html</mimeType>
               <content>PD94bWwgdmVyc2...=</content>
              <contentString><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<TransactionDetails>
<Meta>
<ResellerId>hm1</ResellerId>
<TransactionPeriodId>2012071711291546101000028</TransactionPeriodId>
<GeneratedAt>2012-07-18 15:21</GeneratedAt>
</Meta>

<Row>
<TerminalId>d8e0ff10ea214e5282899aa9697117c1</TerminalId>
<CashierId>bob</CashierId>
<SalesAmount>93.31000</SalesAmount>
<ErsReference>2012060410485453001000101</ErsReference>
</Row>

<Row>
<TerminalId>d8e0ff10ea214e5282899aa9697117c1</TerminalId>
<CashierId>bob</CashierId>
<SalesAmount>30.00000</SalesAmount>
<ErsReference>2012060410502892201000104</ErsReference>
</Row>

<Row>
<TerminalId>d8e0ff10ea214e5282899aa9697117c1</TerminalId>
<CashierId>bob</CashierId>
<SalesAmount>340.00000</SalesAmount>
<ErsReference>2012060411033709001000145</ErsReference>
</Row>

</TransactionDetails>]]></contentString>
            </report> 
         </return>
      </ns2:executeReportResponse>
   </soapenv:Body>
</soapenv:Envelope>

Example terminal reports

Terminal report STD_RECON_006 - executeReport SOAP request example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ext="http://external.interfaces.ers.seamless.com/">
   <soapenv:Header/>
   <soapenv:Body>
     <ext:executeReport>
       <context>
          <channel>WS</channel>
          <clientComment>comment</clientComment>
          <clientId>testClient</clientId>
          <clientReference>12345</clientReference>
          <clientRequestTimeout>0</clientRequestTimeout>
          <initiatorPrincipalId>
            <id>hml</id>
            <type>RESELLERUSER</type>
            <userId>9900</userId>
          </initiatorPrincipalId>
          <password>2009</password>
       </context>
       <reportId>Reconciliation/STD_RECON_006.xml</reportId>
       <language>en</language>
       <parameters>
          <parameter>
             <entry>
                <key>transactionPeriodId</key>
                <value>2012102916093771801000146</value>
             </entry>
             <entry>
                <key>TERMINALID</key>
                <value>2469e0bf14214797880cafb0eda1b535</value>
             </entry>
          </parameter>
       </parameters>
     </ext:executeReport>
   </soapenv:Body>
</soapenv:Envelope>

Terminal report STD_RECON_006 - executeReport SOAP response example

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:executeReportResponse xmlns:ns2="http://external.interfaces.ers.seamless.com/">
         <return>
            <resultCode>0</resultCode>
            <resultDescription>SUCCESS</resultDescription>
            <report>
               <title>STD_RECON_006_2012102916093771801000146.xml</title>
               <mimeType>text/html</mimeType>
               <content>PD94...==</content>
               <contentString><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<CashierTransactionSummary>
<Meta>
<ResellerId>hm1</ResellerId>
<TerminalId>2469e0bf14214797880cafb0eda1b535</TerminalId>
<TransactionPeriodId>2012102916093771801000146</TransactionPeriodId>
<GeneratedAt>2012-10-30 12:18</GeneratedAt>
</Meta>

<Row>
<SalesCount>1</SalesCount>
<SalesTotal>10.00000</SalesTotal>
</Row>

</TerminalTransactionSummary>]]></contentString>
            </report> 
         </return>
      </ns2:executeReportResponse>
   </soapenv:Body>
</soapenv:Envelope>

Terminal report STD_RECON_007 - executeReport SOAP request example

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:ext="http://external.interfaces.ers.seamless.com/">
   <soapenv:Header/>
   <soapenv:Body>
     <ext:executeReport>
       <context>
          <channel>WS</channel>
          <clientComment>comment</clientComment>
          <clientId>testClient</clientId>
          <clientReference>12345</clientReference>
          <clientRequestTimeout>0</clientRequestTimeout>
          <initiatorPrincipalId>
            <id>hml</id>
            <type>RESELLERUSER</type>
            <userId>9900</userId>
          </initiatorPrincipalId>
          <password>2009</password>
       </context>
       <reportId>Reconciliation/STD_RECON_007.xml</reportId>
       <language>en</language>
       <parameters>
          <parameter>
             <entry>
                <key>transactionPeriodId</key>
                <value>2012102916093771801000146</value>
             </entry>
             <entry>
                <key>TERMINALID</key>
                <value>2469e0bf14214797880cafb0eda1b535</value>
             </entry>
          </parameter>
       </parameters>
     </ext:executeReport>
   </soapenv:Body>
</soapenv:Envelope>

Terminal report STD_RECON_007 - executeReport SOAP response example

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:executeReportResponse xmlns:ns2="http://external.interfaces.ers.seamless.com/">
         <return>
            <resultCode>0</resultCode>
            <resultDescription>SUCCESS</resultDescription>
            <report>
               <title>STD_RECON_007_2012102916091394901000143.xml</title>
               <mimeType>text/html</mimeType>
               <content>PD94...==</content>
               <contentString><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<CashierTransactionSummary>
<Meta>
<ResellerId>hm1</ResellerId>
<TerminalId>2469e0bf14214797880cafb0eda1b535</TerminalId>
<TransactionPeriodId>2012102916093771801000146</TransactionPeriodId>
<GeneratedAt>2012-10-30 12:20</GeneratedAt>
</Meta>

<Row>
<SalesCount>1</SalesCount>
<SalesTotal>10.00000</SalesTotal>
</Row>

</TerminalTransactionSummary>]]></contentString>
            </report> 
         </return>
      </ns2:executeReportResponse>
   </soapenv:Body>
</soapenv:Envelope>