Spreadsheet: 584341d1533128928-sumif-is-blank-excel-upload
Sheet: Drop downs

FOM Compliance Code (XREF2) |  | Reason Code (XREF1) |  |  |  | Company Code | Currency |  | Transaction Types
choose from drop-down list |  | choose from drop-down list |  |  |  | S100 | GBP |  | Y01 -Arising on acquisition |  | True | 1
11 – |  | 51 - Cost Accrual |  |  |  | S101 | GBP |  | Y16 - Increase / Decrease |  | False | 0
12 – |  | 52 - Pre-payment |  |  |  | S102 | GBP |  | Y20 -Advances (Loan,Finance Lease),Int Rec'ble(Trade Rec'ble),Int Pay'ble( Trade Pay'ble),Charged to INC(Provisions)
 |  | 53 - Provision |  |  |  | S103 | GBP |  | Y21 - Advances (IC), Interco Int rec ( Trade Rec'ble), Interco Int payable ( Trade Pay'ble)
 |  | 54 - Accrued Revenue |  |  |  | S104 | GBP |  | Y22 - Transfers (From)
 |  | 55 - Deferred Revenue |  |  |  | S105 | GBP |  | Y25 -Capitalised fin costs paid(Loans,Trade Rec'ble), Int Pay'ble ( Trade Pay'ble), Released to INC(Provisions) |  | Please select value
 |  | 56 - Group/CSS/Divisional/BU/Contract recharge |  |  |  | S106 | GBP |  | Y26 -Charged to inc stat - Exceptional,Int Rec'ble(Trade Rec'ble), Def INC/Otr Acc (Trade Pay'ble),Charged to INC(Provisions) |  | SI
 |  | 57 - Reallocation of cost |  |  |  | S107 | GBP |  | Y27 -Released to inc stat - Exceptional items, Int Pay'ble ( Trade Pay'ble), Released to INC(Provisions) |  | SJ
 |  | 58 - Payroll corrections (P&L or balance sheet) |  |  |  | S108 | GBP |  | Y30 -Repayments ( Loans, Finance Lease), Int recd (Trade Rec'ble), Int paid (Trade Pay'ble), [NAME] ( Provisions) |  | SP
 |  | 59 - Procurement corrections |  |  |  | S109 | GBP |  | [NAME]), Inter co Int recd ( Trade Rec'Ble), interco Int paid ( Trade Pay'ble) |  | SH
 |  | 60 - GL coding corrections (P&L or balance sheet) |  |  |  | S110 | GBP |  | Y32 -Transfer (To)
 |  | 61 - Cost Object corrections P&L |  |  |  | S111 | EUR |  | Y35 -Proceeds - sale and leaseback GROSS(Finance Lease),Int paid  ex(Trade Pay'ble)
 |  | 62 - Other P&L & BS corrections |  |  |  | S112 | GBP |  | [NAME] Capitalised
 |  | 63 - Corporate Tax Adjustments |  |  |  | S113 | GBP |  | Y45 - Unwind of discount(Loans),Other Mov (Trade Rec’ble,Trade Pay’ble),Disposal (Finance lease)
 |  | 64 - Fair Value Adjustments |  |  |  | S114 | GBP |  | Y46 - Transfer to trade payables( Trade Pay'ble, Provisions)
 |  | 65 - Intercompany corrections |  |  |  | S115 | GBP |  | Y50 -B/F reclassifications
 |  | 66 - Manual Fixed Asset Adjustments |  |  |  | S116 | GBP |  | [NAME] -Reclassification non-current to current ( Loans,[NAME],Trade Rec'ble,Trade Pay'ble,Finance Lease,Provisions)
 |  | 67 - VAT/ GSTonly |  |  |  | S117 | EUR |  | [NAME] off cap fin costs - Exceptional items( Loans), Unwind discount( Trade Rec'ble), unwinding Discoount(Provisions)
 |  |  |  |  |  | S118 | GBP |  | Y56 - Reclassification Previous Year
 |  |  |  |  |  | S119 | SGD |  | Y60 -Impairment ( Loans), Release deferred consideration ( Trade Pab'ble)
 |  |  |  |  |  | S120 | GBP |  | Y65 -Amort capitalised fin costs (Loans)
 |  |  |  |  |  | S121 | GBP |  | Y81 - FX-Unrel non current
 |  |  |  |  |  | S122 | GBP |  | Y82 - FX-Unrelised current
 |  |  |  |  |  | S123 | AUD |  | Y83 - FX-Real non current
 |  |  |  |  |  | S124 | AUD |  | Y84 - FX-Relised current
 |  |  |  |  |  | S125 | AUD |  | Y87 - FX-Unrelised
 |  |  |  |  |  | S126 | AUD |  | Y88 - FX-Realised
 |  |  |  |  |  | S127 | AUD |  | [NAME] -Eliminated on disposal
 |  |  |  |  |  | S128 | AUD |  | YAJ - Adjustment
 |  |  |  |  |  | S129 | GBP
 |  |  |  |  |  | S130 | AED
 |  |  |  |  |  | S131 | AED
 |  |  |  |  |  | S132 | AED
 |  |  |  |  |  | S133 | BHD
 |  |  |  |  |  | S134 | GBP
 |  |  |  |  |  | S135 | USD
 |  |  |  |  |  | S136 | AUD
 |  |  |  |  |  | S137 | AED
 |  |  |  |  |  | S138 | SAR
 |  |  |  |  |  | S139 | SAR
 |  |  |  |  |  | S140 | INR
 |  |  |  |  |  | S141 | INR
 |  |  |  |  |  | S142 | INR
 |  |  |  |  |  | S143 | INR
 |  |  |  |  |  | S150 | HKD
 |  |  |  |  |  | S151 | GBP
 |  |  |  |  |  | S152 | GBP
 |  |  |  |  |  | S153 | GBP
 |  |  |  |  |  | S154 | EUR
 |  |  |  |  |  | S155 | CNY
 |  |  |  |  |  | S156 | GBP
 |  |  |  |  |  | S157 | GBP
 |  |  |  |  |  | S158 | PLN
 |  |  |  |  |  | S159 | TRY
 |  |  |  |  |  | S160 | EUR
 |  |  |  |  |  | S161 | EUR
 |  |  |  |  |  | S162 | EUR
 |  |  |  |  |  | S163 | EUR
 |  |  |  |  |  | S164 | EUR
 |  |  |  |  |  | S165 | EUR
 |  |  |  |  |  | S166 | CHF
 |  |  |  |  |  | S167 | EUR
 |  |  |  |  |  | S168 | EUR
 |  |  |  |  |  | S169 | EUR
 |  |  |  |  |  | S170 | NZD
 |  |  |  |  |  | S171 | EUR
 |  |  |  |  |  | S172 | GBP
 |  |  |  |  |  | S173 | GBP
 |  |  |  |  |  | S174 | GBP
 |  |  |  |  |  | S175 | GBP
 |  |  |  |  |  | S176 | GBP
 |  |  |  |  |  | S177 | GBP
 |  |  |  |  |  | S178 | GBP
 |  |  |  |  |  | S179 | GBP
 |  |  |  |  |  | S180 | GBP
 |  |  |  |  |  | S181 | GBP
 |  |  |  |  |  | S183 | GBP
 |  |  |  |  |  | S184 | EUR
 |  |  |  |  |  | S185 | ZAR
 |  |  |  |  |  | S186 | EUR
 |  |  |  |  |  | S187 | EUR
 |  |  |  |  |  | S188 | EUR
 |  |  |  |  |  | S189 | EUR
 |  |  |  |  |  | S190 | EUR
 |  |  |  |  |  | S191 | EUR
 |  |  |  |  |  | S192 | GBP
 |  |  |  |  |  | S193 | GBP
 |  |  |  |  |  | S194 | GBP
 |  |  |  |  |  | S195 | GBP
 |  |  |  |  |  | S196 | AUD
 |  |  |  |  |  | S197 | AUD
 |  |  |  |  |  | S198 | ZAR
 |  |  |  |  |  | S199 | NZD
 |  |  |  |  |  | S200 | GBP
 |  |  |  |  |  | S201 | GBP
 |  |  |  |  |  | S202 | GBP
 |  |  |  |  |  | S203 | GBP
 |  |  |  |  |  | S204 | GBP
 |  |  |  |  |  | S205 | AED
 |  |  |  |  |  | S206 | AUD
 |  |  |  |  |  | S207 | AUD
 |  |  |  |  |  | S208 | HKD
 |  |  |  |  |  | S209 | BHD
 |  |  |  |  |  | S210 | BHD
 |  |  |  |  |  | S211 | GBP
 |  |  |  |  |  | S212 | HKD
 |  |  |  |  |  | S213 | GBP
 |  |  |  |  |  | S214 | USD
 |  |  |  |  |  | S215 | USD
 |  |  |  |  |  | S216 | AED
 |  |  |  |  |  | S217 | ZAR
 |  |  |  |  |  | S218 | GBP
 |  |  |  |  |  | S219 | GBP
 |  |  |  |  |  | S220 | GBP
 |  |  |  |  |  | S221 | AUD
 |  |  |  |  |  | S222 | GBP
 |  |  |  |  |  | S223 | AUD
 |  |  |  |  |  | S224 | GBP
 |  |  |  |  |  | S225 | GBP
 |  |  |  |  |  | S226 | GBP
 |  |  |  |  |  | S227 | BHD
 |  |  |  |  |  | S228 | GBP
 |  |  |  |  |  | S229 | GBP
 |  |  |  |  |  | S230 | GBP
 |  |  |  |  |  | S231 | GBP
 |  |  |  |  |  | S232 | GBP
 |  |  |  |  |  | S233 | GBP
 |  |  |  |  |  | S234 | GBP
 |  |  |  |  |  | S235 | AED
 |  |  |  |  |  | S236 | QAR
 |  |  |  |  |  | S237 | ZAR
 |  |  |  |  |  | S238 | EUR
 |  |  |  |  |  | S239 | GBP
 |  |  |  |  |  | S240 | BRL
 |  |  |  |  |  | S241 | AED
 |  |  |  |  |  | S242 | NZD
 |  |  |  |  |  | S243 | NZD
 |  |  |  |  |  | S300 | USD
 |  |  |  |  |  | S301 | GBP
 |  |  |  |  |  | S302 | GBP
 |  |  |  |  |  | S303 | GBP
 |  |  |  |  |  | S319 | USD
 |  |  |  |  |  | S320 | INR
 |  |  |  |  |  | S321 | INR
 |  |  |  |  |  | S322 | INR
 |  |  |  |  |  | S323 | USD
 |  |  |  |  |  | S324 | USD
 |  |  |  |  |  | S325 | PHP
 |  |  |  |  |  | S326 | GTQ
 |  |  |  |  |  | S327 | GBP
 |  |  |  |  |  | S328 | AED
 |  |  |  |  |  | S329 | USD
 |  |  |  |  |  | S330 | PLN
 |  |  |  |  |  | S331 | GBP
 |  |  |  |  |  | S332 | USD
 |  |  |  |  |  | S333 | USD
 |  |  |  |  |  | S334 | MUR
 |  |  |  |  |  | S335 | GBP
 |  |  |  |  |  | S400 | CAD
 |  |  |  |  |  | S401 | CAD
 |  |  |  |  |  | S900 | GBP
 |  |  |  |  |  | S901 | GBP
 |  |  |  |  |  | S902 | GBP
 |  |  |  |  |  | S903 | USD
 |  |  |  |  |  | S904 | CAD
 |  |  |  |  |  | S905 | EUR
 |  |  |  |  |  | S906 | GBP
 |  |  |  |  |  | S907 | INR
 |  |  |  |  |  | S908 | GBP
 |  |  |  |  |  | S909 | EUR
 |  |  |  |  |  | S910 | GBP
 |  |  |  |  |  | S911 | AED
 |  |  |  |  |  | S912 | BRL
 |  |  |  |  |  | S913 | AUD
 |  |  |  |  |  | S997 | GBP
 |  |  |  |  |  | S998 | AUD
 |  |  |  |  |  | S999 | GBP
 |  |  |  |  |  | T900 | GBP
 |  |  |  |  |  | T901 | AUD
 |  |  |  |  |  | ZZ01 | GBP
 |  |  |  |  |  | ZZ02 | GBP
 |  |  |  |  |  | ZZ03 | EUR