Company Code Mandatory Single Entry
Account Number Optional Multiple Entry is possible
Year Mandatory Single Entry
Rep. Per From Mandatory Single Entry
Rep. Per To Mandatory Single Entry
Currency Type Mandatory Single Entry
Don't show p&L a/c with zero
Flag balances
Don't show p&L a/c with zero
Flag balances with no postings
Sophie Comments
Only 1 Company Code at the same time Yes
y is possible
Will only be used for
Only 1 Currency Type at the same time currency 40 so yes
Company Code Currency Currency Account Number Account Description Cost centre
Type
1000 40 USD 415000 External proc. costs
1000 40 USD 415000 External proc. costs
1000 40 USD INT /415001 External proc. costs
1000 40 USD INT /415001 External proc. costs
1000 40 USD INT /415002 External proc. costs
1000 40 USD INT /415002 External proc. costs
1000 40 USD INT /415003 External proc. costs
1000 40 USD INT /415003 External proc. costs
1000 40 USD INT /415004 External proc. costs
1000 40 USD INT /415005 External proc. costs
1000 40 USD INT /415005 External proc. costs
1000 40 USD INT /415006 External proc. costs
1000 40 USD INT /415006 External proc. costs
1000 40 USD INT /415007 External proc. costs
1000 40 USD INT /415007 External proc. costs
1000 40 USD INT /415008 External proc. costs
1000 40 USD INT /415009 External proc. costs
1000 40 USD INT /415010 External proc. costs
1000 40 USD INT /415011 External proc. costs
1000 40 USD INT /415012 External proc. costs
1000 40 USD INT /415012 External proc. costs
1000 40 USD INT /415013 External proc. costs
1000 40 USD INT /415013 External proc. costs
1000 40 USD INT /415014 External proc. costs
1000 40 USD INT /415014 External proc. costs
1000 40 USD INT /415100 Transport and for.ma
1000 40 USD INT /415101 External proc. costs
1000 40 USD INT /415101 External proc. costs
1000 40 USD INT /415102 External proc. costs
1000 40 USD INT /415102 External proc. costs
1000 40 USD INT /416000 CO Transfer postings
1000 40 USD INT /416000 CO Transfer postings
1000 40 USD INT /416000 CO Transfer postings
1000 40 USD INT /416000 CO Transfer postings
1000 40 USD INT /416000 CO Transfer postings
1000 40 USD INT /416001 CO Transfer postings
1000 40 USD INT /416001 CO Transfer postings
1000 40 USD INT /416001 CO Transfer postings
1000 40 USD INT /416001 CO Transfer postings
1000 40 USD INT /416100 Electricity (fixed)
1000 40 USD INT /416200 Electricity (vbl)
1000 40 USD INT /416400 Gas
1000 40 USD INT /416500 Heating oil
1000 40 USD INT /416600 External proc. costs
1000 40 USD INT /416700 External proc. costs
1000 40 USD INT /416800 External proc. costs
1000 40 USD INT /416900 External proc. costs
1000 40 USD INT /417000 Purchased services
1000 40 USD INT /417000 Purchased services
1000 40 USD INT /417001 Purchased services
1000 40 USD INT /417001 Purchased services
1000 40 USD INT /417002 External proc. costs
1000 40 USD INT /417003 External proc. costs
1000 40 USD INT /417003 External proc. costs
1000 40 USD INT /417004 External proc. costs
1000 40 USD INT /417004 External proc. costs
1000 40 USD INT /420000 Direct labor costs
1000 40 USD INT /420000 Direct labor costs
1000 40 USD INT /421000 Indirect labor costs
1000 40 USD INT /421000 Indirect labor costs
1000 40 USD INT /422000 Downtime pay
1000 40 USD INT /422000 Downtime pay
1000 40 USD INT /422200 Vacation bonus
1000 40 USD INT /422200 Vacation bonus
1000 40 USD INT /422300 External proc. costs
1000 40 USD INT /422300 External proc. costs
1000 40 USD INT /423000 External proc. costs
1000 40 USD INT /423000 External proc. costs
1000 40 USD INT /430000 Salaries
1000 40 USD INT /430100 External proc. costs
1000 40 USD INT /430100 External proc. costs
1000 40 USD INT /430200 Downtime salaries
1000 40 USD INT /430200 Downtime salaries
1000 40 USD INT /430300 External proc. costs
1000 40 USD INT /430300 External proc. costs
1000 40 USD INT /430400 External proc. costs
1000 40 USD INT /430400 External proc. costs
1000 40 USD INT /430500 External proc. costs
1000 40 USD INT /430500 External proc. costs
1000 40 USD INT /430600 External proc. costs
1000 40 USD INT /430600 External proc. costs
1000 40 USD INT /430700 External proc. costs
1000 40 USD INT /430700 External proc. costs
1000 40 USD INT /430800 External proc. costs
1000 40 USD INT /430800 External proc. costs
1000 40 USD INT /430900 Other sal. expenses
1000 40 USD INT /431000 Overtime premiums
1000 40 USD INT /431000 Overtime premiums
1000 40 USD INT /431100 Variant shift
1000 40 USD INT /431200 Workplace bonus
1000 40 USD INT /431200 Workplace bonus
1000 40 USD INT /431300 External proc. costs
1000 40 USD INT /431300 External proc. costs
1000 40 USD INT /431500 INSURANCE
1000 40 USD INT /431500 INSURANCE
1000 40 USD INT /431600 External proc. costs
1000 40 USD INT /432000 Continued pay
1000 40 USD INT /432000 Continued pay
1000 40 USD INT /433000 External proc. costs
1000 40 USD INT /434000 Std vacation bonus
1000 40 USD INT /434000 Std vacation bonus
1000 40 USD INT /434001 Ajuste ML
1000 40 USD INT /435000 Annual bonus
1000 40 USD INT /436000 Medical Costs
1000 40 USD INT /436000 Medical Costs
1000 40 USD INT /437000 Sales commission
1000 40 USD INT /437000 Sales commission
1000 40 USD INT /440000 Social security
1000 40 USD INT /440100 Soc. secur., salary
1000 40 USD INT /440200 External proc. costs
1000 40 USD INT /440300 External proc. costs
1000 40 USD INT /440300 External proc. costs
1000 40 USD INT /444000 External proc. costs
1000 40 USD INT /444000 External proc. costs
1000 40 USD INT /445000 Pension payments
1000 40 USD INT /446000 Workers' comp.assoc.
1000 40 USD INT /446000 Workers' comp.assoc.
1000 40 USD INT /447000 Employee health ins.
1000 40 USD INT /448000 External proc. costs
1000 40 USD INT /449000 Other personnel exp.
1000 40 USD INT /449200 Other personnel exp.
1000 40 USD INT /449200 Other personnel exp.
1000 40 USD INT /449300 Other personnel exp.
1000 40 USD INT /451000 Building maintenance
1000 40 USD INT /452000 Mach & equip maint
1000 40 USD INT /452000 Mach & equip maint
1000 40 USD INT /453000 Maintenance costs
1000 40 USD INT /453000 Maintenance costs
1000 40 USD INT /454000 External proc. costs
1000 40 USD INT /454000 External proc. costs
1000 40 USD INT /455000 External proc. costs
1000 40 USD INT /455000 External proc. costs
1000 40 USD INT /456000 External proc. costs
1000 40 USD INT /456000 External proc. costs
1000 40 USD INT /462000 Bill of exchange tax
1000 40 USD INT /462000 Bill of exchange tax
1000 40 USD INT /463000 Trading capital tax
1000 40 USD INT /463000 Trading capital tax
1000 40 USD INT /463000 Trading capital tax
1000 40 USD INT /464000 Motor vehicle tax
1000 40 USD INT /464000 Motor vehicle tax
1000 40 USD INT /465000 Other taxes
1000 40 USD INT /465000 Other taxes
1000 40 USD INT /465001 Miscellaneous taxes
1000 40 USD INT /465006 Miscellaneous taxes
1000 40 USD INT /465007 Miscellaneous taxes
1000 40 USD INT /465011 Miscellaneous taxes
1000 40 USD INT /465200 Export taxes
1000 40 USD INT /465200 Export taxes
1000 40 USD INT /465300 External proc. costs
1000 40 USD INT /465300 External proc. costs
1000 40 USD INT /465400 External proc. costs
1000 40 USD INT /465400 External proc. costs
1000 40 USD INT /465500 Consumption taxes
1000 40 USD INT /465501 MAINTENANCE OF WELLS
1000 40 USD INT /466000 Insurance
1000 40 USD INT /466000 Insurance
1000 40 USD INT /466200 External proc. costs
1000 40 USD INT /466200 External proc. costs
1000 40 USD INT /466300 External proc. costs
1000 40 USD INT /466400 External proc. costs
1000 40 USD INT /466400 External proc. costs
1000 40 USD INT /466500 External proc. costs
1000 40 USD INT /466500 External proc. costs
1000 40 USD INT /470100 Cafeteria equipment
1000 40 USD INT /470101 Meals
1000 40 USD INT /472000 Shipping costs
1000 40 USD INT /472000 Shipping costs
1000 40 USD INT /472020 External proc. costs
1000 40 USD INT /472020 External proc. costs
1000 40 USD INT /472030 External proc. costs
1000 40 USD INT /472030 External proc. costs
1000 40 USD INT /473000 Postage w/o phone
1000 40 USD INT /473120 Telephone (calls)
1000 40 USD INT /473130 Other communication
1000 40 USD INT /473140 External proc. costs
1000 40 USD INT /473150 External proc. costs
1000 40 USD INT /473160 External proc. costs
1000 40 USD INT /473170 External proc. costs
1000 40 USD INT /474100 Tr.exp.-lump sum tax
1000 40 USD INT /474210 Trip costs, accomm.
1000 40 USD INT /474220 Trip costs, meals
1000 40 USD INT /474230 Trip costs, trans.
1000 40 USD INT /474230 Trip costs, trans.
1000 40 USD INT /474240 Trip costs, other
1000 40 USD INT /474250 Tr.cost.entertainmnt
1000 40 USD INT /474260 External proc. costs
1000 40 USD INT /474270 External proc. costs
1000 40 USD INT /474280 Tr.exp.lump sum tax
1000 40 USD INT /474290 External proc. costs
1000 40 USD INT /474300 External proc. costs
1000 40 USD INT /474300 External proc. costs
1000 40 USD INT /474310 Per diem dom. txfree
1000 40 USD INT /474310 Per diem dom. txfree
1000 40 USD INT /474320 Per diem dom. taxble
1000 40 USD INT /474340 Per diem for. taxble
1000 40 USD INT /474341 PALLETS
1000 40 USD INT /474350 External proc. costs
1000 40 USD INT /474360 External proc. costs
1000 40 USD INT /474360 External proc. costs
1000 40 USD INT /474380 External proc. costs
1000 40 USD INT /474380 External proc. costs
1000 40 USD INT /474390 External proc. costs
1000 40 USD INT /474390 External proc. costs
1000 40 USD INT /474400 External proc. costs
1000 40 USD INT /474400 External proc. costs
1000 40 USD INT /474410 External proc. costs
1000 40 USD INT /474410 External proc. costs
1000 40 USD INT /474430 External proc. costs
1000 40 USD INT /474440 External proc. costs
1000 40 USD INT /474504 External proc. costs
1000 40 USD INT /474504 External proc. costs
1000 40 USD INT /474505 External proc. costs
1000 40 USD INT /474506 External proc. costs
1000 40 USD INT /474506 External proc. costs
1000 40 USD INT /474508 External proc. costs
1000 40 USD INT /474512 External proc. costs
1000 40 USD INT /474513 External proc. costs
1000 40 USD INT /474521 External proc. costs
1000 40 USD INT /474530 External proc. costs
1000 40 USD INT /474536 External proc. costs
1000 40 USD INT /474538 External proc. costs
1000 40 USD INT /474540 External proc. costs
1000 40 USD INT /474590 External proc. costs
1000 40 USD INT /474600 External proc. costs
1000 40 USD INT /474700 External proc. costs
1000 40 USD INT /499999 Trip costs, accomm.
1000 40 USD INT /504000 Loss-assets scrapped
1000 40 USD INT /519500 Dep. Vehicles
1000 40 USD INT /522000 Deprn - Concession
1000 40 USD INT /523002 Dep Vehicles
1000 40 USD INT /524000 Unpl.depr.tangibles
1000 40 USD INT /525000 Amort.fin.assets
1000 40 USD INT /527000 Write-dwn securities
1000 40 USD INT /528000 Other wrt-dwn secur.
1000 40 USD INT /528500 Correct for Restatem
1000 40 USD INT /531000 Exceptional deprecn
1000 40 USD INT /534000 Int.exp.affiliates
1000 40 USD INT /534000 Int.exp.affiliates
1000 40 USD INT /535500 Int.exp.affiliates
1000 40 USD INT /535500 Int.exp.affiliates
1000 40 USD INT /536000 Other int./simil.exp
1000 40 USD INT /536000 Other int./simil.exp
1000 40 USD INT /537000 W-o swap pt.valuatn
1000 40 USD INT /537005 W-o swap pt.valuatn
1000 40 USD INT /537500 Oth. int.-affil. co.
1000 40 USD INT /537500 Oth. int.-affil. co.
1000 40 USD INT /538000 Oth. int.-affil. co.
1000 40 USD INT /538500 Oth. int.-affil. co.
1000 40 USD INT /538600 Oth. int.-affil. co.
1000 40 USD INT /538700 Oth. int.-affil. co.
1000 40 USD INT /539000 Other inc/rev. taxes
1000 40 USD INT /539001 Loss unreal.e/rte df
1000 40 USD INT /540000 Discount charges
1000 40 USD INT /540000 Discount charges
1000 40 USD INT /544000 Exchange rate diffs
1000 40 USD INT /544100 Exchange rate diffs
1000 40 USD INT /544200 Exchange rate diffs
1000 40 USD INT /545000 Loss from valuation
1000 40 USD INT /545010 Loss from valuation
1000 40 USD INT /545010 Loss from valuation
1000 40 USD INT /545100 Oth. int.-affil. co.
1000 40 USD INT /545100 Oth. int.-affil. co.
1000 40 USD INT /545500 Loss from valuation
1000 40 USD INT /545600 Loss from valuation
1000 40 USD INT /546000 FX STO. DOMINGO
1000 40 USD INT /549000 ER loss lower lev.
1000 40 USD INT /549100 Meals
1000 40 USD INT /549100 Meals
1000 40 USD INT /549111 Exchange rate diffs
1000 40 USD INT /549500 ER loss lower lev.
1000 40 USD INT /549600 ER loss lower lev.
1000 40 USD INT /549700 ER loss lower lev.
1000 40 USD INT /550000 Loss unreal.e/rte df
1000 40 USD INT /559000 Loss-IR small diffs
1000 40 USD INT /565000 Commission
1000 40 USD INT /570000 INCOME TAX
1000 40 USD INT /590000 Loss unreal.e/rte df
1000 40 USD INT /655000 Oth. int.-affil. co.
1000 40 USD INT /655000 Oth. int.-affil. co.
1000 40 USD INT /655100 Oth. int.-affil. co.
1000 40 USD INT /655100 Oth. int.-affil. co.
1000 40 USD INT /655200 Oth. int.-affil. co.
1000 40 USD INT /655300 Oth. int.-affil. co.
1000 40 USD INT /655300 Oth. int.-affil. co.
1000 40 USD INT /655500 AJ.COST CONSTR.PHASE
1000 40 USD INT /700000 Oth. int.-affil. co.
1000 40 USD INT /700000 Oth. int.-affil. co.
1000 40 USD INT /700001 Oth. int.-affil. co.
1000 40 USD INT /700002 Oth. int.-affil. co.
1000 40 USD INT /700003 AJUSTE INVENTARIO AL
1000 40 USD INT /700005 Oth. int.-affil. co.
1000 40 USD INT /700010 Oth. int.-affil. co.
1000 40 USD INT /700010 Oth. int.-affil. co.
1000 40 USD INT /700011 Oth. int.-affil. co.
1000 40 USD INT /700011 Oth. int.-affil. co.
1000 40 USD INT /700012 Oth. int.-affil. co.
1000 40 USD INT /700012 Oth. int.-affil. co.
1000 40 USD INT /700013 Deprec. Envir. Remed
1000 40 USD INT /700013 Deprec. Envir. Remed
1000 40 USD INT /700015 Oth. int.-affil. co.
1000 40 USD INT /700100 Oth. int.-affil. co.
1000 40 USD INT /700100 Oth. int.-affil. co.
1000 40 USD INT /700200 Oth. int.-affil. co.
1000 40 USD INT /700500 Oth. int.-affil. co.
1000 40 USD INT /700505 Oth. int.-affil. co.
1000 40 USD INT /700511 Oth. int.-affil. co.
1000 40 USD INT /700700 Oth. int.-affil. co.
1000 40 USD INT /700701 Oth. int.-affil. co.
1000 40 USD INT /800001 Service sale
1000 40 USD INT /800002 MARKETING COST
1000 40 USD INT /800003 EXPO DUTIES REFUNDS
1000 40 USD INT /800004 Service sale
1000 40 USD INT /801000 Sales revenue-forgn
1000 40 USD INT /801001 Sales revenue-forgn
1000 40 USD INT /801002 Sales revenue-forgn
1000 40 USD INT /801003 Sales revenue-forgn
1000 40 USD INT /801100 VENTAS EXT.
1000 40 USD INT /871000 Dev.operating profit
1000 40 USD INT /897900 Interest rev.-aff.
1000 40 USD INT /898600 Gain-exch.rate diffs
1000 40 USD INT /899802 Gain-IR small diffs
Webs Element Internal Order Other Assignments FY 2018 1- 8
214221.61
4595111.09
11445.25
119570.83
56290.57
1105244.50
52212.09
1018945.90
17174.94
15068.27
388213.02
1110.14
141805.92
30961.60
42923.87
0
3312.70
11567.63
15689.82
76956.52
402552.32
12186.94
160955.01
20742.18
493840.22
132003.75
302745.40
3734233.20
1261.24
46075.76
2875.88
104392.26
150563.82
-257831.96
58419.02
14671.59
7232.62
-21904.21
0
15585.37
2424.72
210792.92
43723.61
7370.21
30289.39
1122.62
13804.76
17492.79
406714.36
34196.93
140908.62
0
2227.01
17232.18
18288.09
144293.31
22818.14
218256.25
11536.26
323722.06
26657.59
317901.33
27538.00
1127261.19
895.86
2627.38
175572.00
44087.73
41080.16
2878.47
1407005.08
671.67
7378.71
582.50
54155.34
65.58
4619.07
34287.26
26741.87
6949.02
17567.76
16233.42
101856.92
1761.48
1836900.62
2447896.65
2960.62
194554.25
144425.65
30473.36
708157.39
16373.98
8864.54
27796.49
292038.37
4211.44
33397.81
150609.41
11424.77
6034.26
106294.98
0
15910.16
42567.56
28158.19
6229.78
15167.79
7395.48
29494.43
92167.15
6.38
80276.83
235005.13
1041848.61
10829.89
20273.33
65612.79
1008655.46
518052.76
1762943.29
0
1660005.69
859646.15
40931.59
12222.77
152323.16
60275.90
1343382.80
50081.29
350485.96
203386.08
599759.02
562311.41
89916.70
158690.53
497858.52
122736.14
0
1409966.72
13819001.17
583015.54
30509.90
26173.16
53915.79
0
868359.47
0
1817.83
54649.65
346310.00
880149.71
803875.58
2949396.82
8599.68
81016.35
31544.30
0
1315.03
0
1052.02
90056.00
0
484119.58
469713.16
62387.55
1219785.55
11.84
11249.67
7733.60
68587.26
502.84
83982.99
56934.06
0
-229.18
0
119114.02
313500.00
111225.80
0
6254123.53
3745812.88
10074.69
8312.23
2059063.00
0
234908.69
42926.15
15525.51
0
2539612.23
515344.51
145740.75
180548.25
0
268346.40
8894.09
8146.19
1382.94
20056.09
59895.67
166106.77
1437310.58
512855.32
55304.09
511383.88
192466.89
551647.22
94327.20
52947.31
1514.05
53760.91
8970.05
31672.74
0
78871.25
2380.01
56880.00
1652.42
30204.26
44667.53
0
1432.09
554447.10
0
0
0
0
0
0
0
0
0
0
0
0
0
41848.57
616187.13
467.49
0
0
961328.66
2561667.59
670478.04
-898665.25
-43692.70
0
3076050.50
940995.10
443824.36
-23681.19
9597.53
-9303002.21
0
3765646.44
-836448.51
0
0
79404953.09
0
1242233.99
79308.97
0
0
6264.51
3081743.79
-8197.28
8197.28
-27625.98
369316.10
329321.00
155148.49
997294.24
1.96
0
6462524.52
5095431.15
-162005172.04
0
-91861544.10
0
-16551684.24
-179225.73
834.49
-1033857.19
76035611.97
0
-85825.14
0
73990.12
2991810.40
191833.57
0
12948.39
0
-3206743.46
0
175196.85
0
0
478159.63
146345.58
0
51677294.37
5554445.72
4201349.57
1003668.54
116643.46
0
3947.58
-3685900.64
0
0
-28966149.76
-59413974.36
-1534928.00
471719.55
-11167.40
-20146.86
-1626432.02
-1.87
Scenarios included Sophie Comments
Req. No High Level Requirement Details
2
Balance sheet
In case of Balance Sheets Accounts only balance will be shown in 1 line, Cost accounts should not
Center, Internal order and WBS Elements columns with be empty. show anything.
3
Year & Month Comparison will be creating too many entries each year, can we Can be only current
skip this and not include in the scope? year and YTD
5
Not relevant as B/S
Only open items are to be included, not cleared items. not included
8
If line items has multiple assignments (i.e If a line item has CC And IO both , How is that possible?
the report will display the amount by IO because the cost center will be I want to know how
statistical. Same case if you combine Cost Center & WBS Element, the report my GL gets split.
will display the amount by Wbs element because the cost center will be There should not be
statistical. statistical in there.
9 Include the P&L with balance zero but with line items posted on the period
10 We will include P&L with zero
11 Postings against PC to be included also in the "Other Assignment Column"
12 Revenue accounts don’t have PC, so we have to display in others
Clarifications Needed
We will consider only
expense accounts for
reporting as per
account assignments
How YTD will be show if
we run for only one
period?
Cases of transfer to be
included ?
Show only by real
objects
Period 1
Period to 3
415000
1 2 3
CCA 100 200 100
CCB 500 100 500
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages CCA
CCB
Period 1
Period to 3
415000
1 2 3
CCA 100 200 100
CCB 500 100 500
CCC -1500
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages CCA
CCB
CCC
Period 1
Period to 3
415000
1 2 3
CCA 100 200 100
CCB 500 100 500
CCC -1500
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages CCA
CCB
CCC
CCA 400
CCA -400
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages CCA
There is not postings into the account
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages
Posting Against Profit Center
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
USD Wages
1000 40 415000
CCA 100
IO B(Stat) 100
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
USD Wages CCA
1000 40 415000
CCA 100
IO B(Real) 100
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages
WBS 100
CC 100
Company Code Currency Currency Account Number Account Description Cost centre Webs Element
Type
1000 40 USD 415000 Wages WBS
Internal Order FY 2018 1- 3
400
1100
Internal Order FY 2018 1- 3
400
1100
-1500
Internal Order FY 2018 1- 3
400
1100
-1500
Internal Order FY 2018 1- 3
0
Internal Order FY 2018 1- 3
0 if no postings
Internal OrderOthers FY 2018 1- 3
500 500 Postings only against Profit Centers
Internal Order FY 2018 1- 8
100
Internal Order FY 2018 1- 8
IO B(Real) 100
Internal Order FY 2018 1- 8
100
