Only just literally just reformat the following all the literal "entire" content (including every single word and charecter) by logically segmenting distinct parts, fixing scentences spacings, organizing in tables, adding headlings, subheadings, bullets, and numbering lists where logical:


Global Store /… / GS Finance Reporting
Confluence Page created by Jason Folk (Jason Folk was the Senior Manager II, Product Manager who led backend infrastructure development for Walmart's B2C & B2B Cross-border Trade channels , last modified on Dec 11, 2014
Global Store Financial Reporting Flows:

Financial Reporting requires GSL/GSOMS/GIS to produce multiple reporting fields in order to properly close the books each month.
Below are each of the 13 reports (currently) required by finance which are seeded by GSL/GIS data.
Accounting Sales Summary for GS by Distributor: AcSS (Accounting Sales Summary) - New Global Store 08.04.2014 rev
1.xlsx
Includes several reports (Exisiting, GS-specific, By Tender, etc) showing revenue
Section Data
Source
Cells Description Qualification Criteria Happy Path Sad Path
Sales & Quantity GIS A-G GS Revenue
& # of orders
sold
Order Shipped Once order is
shipped the #
of
orders/revenue
is captured
Unshipped
order/revenue
amounts
excluded from
dataset
Returns GSL H-N Physical &
Virtual Sales
Returned
Physical (Int'l): Once correct
item returned info is passed
from Geodis>PB>GSL
Physical (Dom): Once WMT
RC takes possession of item
and GSL is alerted
Int'l returns
exception
codes passed
to GSL.
Domestic
return
exception
codes passed
to GSL.
If exception
codes for
returns aren't
refreshed and
sent to GSL,
the disposal
costs/customer
refunded
amounts/etc
will not tie
back to
internal
metrics.
CSA/Appeasements GSL O-Q Goodwill
optional
payments to
customers
CS agent can/cannot issue a
customer a partial refund.
GSOMS has to send data to
GSL
CS logs
goodwill,
passes to
GSOMS,
picked up by
GSL
Delta in
balanaces

Section Data
Source
Cells Description Qualification Criteria Happy Path Sad Path
Revenue/TLC GSL T&Y Shipping
Revenue &
Shipping
Refunded
Revenue
Domestic Shipping Revenue
provided by WMT, Int'l
Shipping Revenue provided by
3PL. Dom Refunded Shipping
Rev provided by 3PL and then
passed t WMT RC. Intl
Refunded Shipping Rev (not at
launch) provided my 3PL after
confirmation of successful
receiving of physical returned
item
TLC passes
Dom& Intl
Revenue costs
down to GSL.
The Ship
Revenue will
equal the
returned
revenue from
3PL.
Int'l ship
revenue
doesn't get
passed
from 3PL
during API
call
TLC
doesn't
generate
any/correct
dom
shipping
revenue
3PL
doesn't
pass
correct (or
different)
returned
shipping
revenue
TLC/Smart Pricing GSL Z-AI Breakdown
of TLC costs
which
produce the
total cost
customer
sees
International Shipping:
Variable, PB at Runtime
DC Handling Fee: Fixed,
PB at Runtime
Duties: Variable, PB at
Runtime
Taxes: Variable, PB at
Runtime
Brokerage Fees: Variable,
PB at Runtime
Tech Fees: Fixed, PB at
Runtime
Classification Fees: Fixed,
PB at Runtime
Import
Charges are
provided by
3PL at runtime
to generate
TLC
If 3PL call
cannot be
made, the total
cost cannot be
generated and
the item
cannot be
purchased

Section Data
Source
Cells Description Qualification Criteria Happy Path Sad Path
TLC/PB GSL AJ-
AM
Clarify with
Vicki the
source
All the realtime inputs
comprising of Total Landed
Cost, from both 3PL and
GSOMS, to display the cost
per item the customer will see
& be charged
Import
Charges are
provided by
3PL at runtime
to generate
TLC
If 3PL call
cannot be
made, the total
cost cannot be
generated and
the item
cannot be
purchased
Accounting Sales by Tender: Accounting Sales Tender Report - New Global Store.xlsx
Section Data
Source
Cells Description Qualification
Criteria
Happy Path Sad Path
Tender
Type/Payment
Method
GSL A Sales broken
out by
payment type
over a specific
period of time
Payment type gets
captured by the
PSPs and is
pushed to GSOMS
Customer card
info gets properly
captured by the
PSP, which gets
passed to
GSOMS/GSL and
persisted
PSP doesn't
capture/transfer payment
info. Discrepancy b/t
GSOMS transaction
revenue and PSP.
Shipped
Revenue/TLC
GSL B Multiple
components to
create value
(item price,
other TLC
values)
Total Landed Cost
provided by both
3PL and WMT at
runtime
Runtime calls
successfully made
from 3PL and GS
to create a
complete TLC.
3PL calls not complete or
WMT runtime TLC calls fail
which will not generate a
price for the customer

Section Data
Source
Cells Description Qualification
Criteria
Happy Path Sad Path
Appeasement GSL C Goodwill credit
applied by CS,
approved by
FinOps, for
customer
retention
Customer-initiated
call to CS for
disappointing
customer
experience results
in a partial refund
CS agent files
refund claim in
Atlantico
which gets
picked up by
GSOMS and
refunded by
PSP
Refund
amount gets
pushed to
GSOMS and
ultimately GSL
GSOMS
generates
emails (via
Gossip)
alerting
customer to
partial refund
approval
Return info doesn't get
passed from CS to PSP
Customer gets refunded
>100% of the value of
the returned item
No notification (email or
data) gets passed to
GSOMS/GSL
Order rev/cost
discrepancy
Refund from
Returns
GSL D Any refunded
revenue due to
returns
For Domestic
returns, customer
will be refunded
via PSP and
GSOMS will be
alerted to partial
refund
Int'l returns
exception codes
passed to GSL.
Domestic return
exception codes
passed to GSL.
If exception codes for
returns aren't refreshed and
sent to GSL, the disposal
costs/customer refunded
amounts/etc will not tie
back to internal metrics.

S
e
c
t
i
o
n
D
a
t
a
S
o
u
r
c
e
C
e
l
l
s
D
e
s
c
r
i
p
t
i
o
n
Q
u
a
l
i
f
i
c
a
t
i
o
n
C
r
i
t
e
r
i
a
H
a
p
p
y
P
a
t
h
S
a
d
P
a
t
h
A
p
p
e
a
s
e
m
e
n
t
G
S
L
E
A
n
o
t
h
e
r
G
o
o
d
will c
r
e
dit
C
u
s
t
o
m
e
r
-initia
t
e
d
c
all t
o
C
S
fo
r
dis
a
p
p
oin
tin
g
c
u
s
t
o
m
e
r
e
x
p
e
rie
n
c
e
r
e
s
ult
s in a partial refund
C
S
a
g
e
n
t
file
s
r
e
f
u
n
d
claim in
A
tla
n
tic
o
w
hic
h
g
e
t
s
pic
k
e
d
u
p
b
y
G
S
O
M
S
a
n
d
r
e
f
u
n
d
e
d
b
y
P
S
P
R
e
f
u
n
d
a
m
o
u
n
t
g
e
t
s
p
u
s
h
e
d
t
o
G
S
O
M
S
a
n
d
ultim
a
t
ely
G
S
L
G
S
O
M
S
g
e
n
e
r
a
t
e
s
e
m
ails
(
via
G
o
s
sip
)
ale
r
tin
g
c
u
s
t
o
m
e
r
t
o
p
a
r
tial r
e
f
u
n
d
a
p
p
r
o
v
al R
e
t
u
r
n in
fo
d
o
e
s
n't
g
e
t
p
a
s
s
e
d
f
r
o
m
C
S
t
o
P
S
P
C
u
s
t
o
m
e
r
g
e
t
s
r
e
f
u
n
d
e
d
>
1
0
0
%
o
f
t
h
e
v
alu
e
o
f
t
h
e
r
e
t
u
r
n
e
d it
e
m
N
o
n
o
tific
a
tio
n
(
e
m
ail o
r
d
a
t
a
)
g
e
t
s
p
a
s
s
e
d
t
o
G
S
O
M
S
/
G
S
L
O
r
d
e
r
r
e
v
/
c
o
s
t
dis
c
r
e
p
a
n
c
y
R
e
v
e
n
u
e
(
fo
r
m
ula
B
-
E
)
G
S
L
F
Diff
e
r
e
n
c
e
b
e
t
w
e
e
n
S
hip
pin
g
C
o
s
t
s
a
n
d
A
p
p
e
a
s
e
m
e
n
t
s
=
R
e
v
e
n
u
e
R
e
f
u
n
d
e
d
G
S
L
G
A
s
k
Vic
ki Returned Charged - FX Cost GSL H FX charg
e
s
f
r
o
m inter
n
a
tio
n
al transactions
T
h
e
F
X
c
o
s
t is
t
h
e
c
o
n
v
e
r
sio
n
f
r
o
m local currency back into USD from the order date to the settlement date
T
h
e
s
p
o
t
r
a
t
e
s
fo
r
t
h
e
F
X
r
a
t
e
s
will be provided by Adyen on a daily basis. The difference b/
t
t
h
e
c
h
a
r
g
e
d
d
a
t
e
&
t
h
e
s
e
t
tle
m
e
n
t
d
a
t
e
will b
e
t
h
e
F
X
c
o
s
t
r
e
p
o
r
t
e
d
A
d
y
e
n
d
o
e
s
n't
p
r
o
vid
e
t
h
e
r
a
t
e
s
t
o
W
M
T
T
h
e
F
X
r
a
t
e in
fo
d
o
e
s
n't
g
e
t
p
a
s
s
e
d
d
o
w
n
t
o
G
S
O
M
S
/
G
S
L
F
X
G
ain
/
L
o
s
s
G
S
L I A
d
y
e
n
s
e
n
d
s

ICAROS:ICAROS - Existing rev 1.xlsx
Section Data
Source
Cells Description Qualification Criteria Happy Path Sad
Path
Distributor
Sales
USOMS/GIS A-G Retail sales data
by DC
Once the order has been
passed thru USOMS, the DC
will be determined and the order
will be updated with the
appropriate DC#
USOMS will
append the DC info
to the order which
will be used from
then onward.
Returns by DC PB/GSL H-K Returns
Appeasements GSL L
Virtual>Physical GSL M-N Tracking status
from PB. People
get refunds
before receiving
product
Backshipment:Backshipment Report - Existing.xlsx
Domestic Return to WMT RC Report
Section Data Source Cells Description Qualification
Criteria
Happy
Path
Sad
Path
Department Name USOMS/GIS A-P Most originating
from
Ext Cost Assumed GIS has
data
O Ask Sid?Igor?
Ext Retail Assumed GIS has
data
Q
FIFO Unit Cost Assumed GIS has
data
Z
Extended FIFO
Cost
Assumed GIS has
data
AA
Y What does this
mean?
Daily Cash Settlement Reconciliation Report: Cash Flow Settlement Reconciliation Report 07 30 14 v12.xlsx
Section Data Source Cells Description Qualification Criteria Happy Path Sad Path
Department Name USOMS/GIS A-P Most originating from
Pitney Bowes Payment Exceptions Report: Pitney Bowes Payment Exceptions Report v 1.xlsx
Section Data
Source
Cells Description Qualification Criteria Happy
Path
Sad
Path
Exceptions PB/GIS A-W Sources are Item Acutal(s) and Exception
Report from PB, ingested into GSL,
produced by GIS
?Does GIS have
everything they need to
produce report?
Cash Settlement FX Gain Loss Summary: FX Gain-Loss Report 08 04 14.xlsx
Section Data Source Cells Description Qualification
Criteria
Happy
Path
Sad
Path
FX
Rates
PSP/GSOMS/GIS B-M Sources are Item Acutal(s) and Exception Report
from PB, ingested into GSL, produced by GIS
GS Returns: Global Store Returns - New Global Store v3.xlsx
Section Data Source Cells Description Qualification
Criteria
Happy
Path
Sad
Path
FX
Rates
PSP/GSOMS/GIS B-M Sources are Item Acutal(s) and Exception Report
from PB, ingested into GSL, produced by GIS