Spreadsheet: 862126d1709894928-filter-function-and-conditions-fico_mapping_excelforum_2
Sheet: fagll03

Posting Date | G/L Account | G/L Account Name | Document Number | Document type | Segment | Profit Center | Cost Center | Assignment | Amount in local currency | Reference | Text | Posting Key | Clearing Document | Withholding tax amnt | Invoice reference | WBS element | Vendor Code | Customer Code | Network | Activity
2024-02-01 00:00:00 | 21200101 | Accounts Payable | 1900057723 | KR | HOFC | HOFC-000 |  | 1000002184 | -39672.8 | SG_969/970/971/9 | Mental Health & Psychiatrist Sessions | 31 | 1500008909 | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 63300000 | Dues and Subscription | 1900057723 | KR | HOFC | HOFC-000 | D054-000 | SG_0000969 | 10577.46 | SG_969/970/971/9 | Mental Health Sessions + Convo_10.13.23-11.12.23 | 40 |  | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 63300000 | Dues and Subscription | 1900057723 | KR | HOFC | HOFC-000 | D054-000 | SG_0000970 | 10577.46 | SG_969/970/971/9 | Mental Health Sessions + Convo_11.13.23-12.12.23 | 40 |  | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 63300000 | Dues and Subscription | 1900057723 | KR | HOFC | HOFC-000 | D054-000 | SG_0000971 | 10577.46 | SG_969/970/971/9 | Mental Health Sessions + Convo_12.12.23-01.12.24 | 40 |  | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 63300000 | Dues and Subscription | 1900057723 | KR | HOFC | HOFC-000 | D054-000 | SG_0000985 | 7192.85 | SG_969/970/971/9 | Psychiatrist session Dec 2023 | 40 |  | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 63300000 | Dues and Subscription | 1900057723 | KR | HOFC | HOFC-000 | D054-000 |  | 747.57 | SG_969/970/971/9 | Late fees - SG 969/970/971 | 40 |  | 0 | 1900057723 |  | 1000002184
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900057734 | KR | HOFC | HOFC-000 |  | EM09022674 | -1881 | REIMB. | [NAME] meeting,transpo,notarial fee | 31 | 2000085453 | 0 | 1900057734 |  | EM09022674
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900057734 | KR | HOFC | HOFC-000 | D091-000 |  | 1381 | REIMB. | [NAME] meeting,transpo,notarial fee | 40 |  | 0 | 1900057734 |  | EM09022674
2024-02-01 00:00:00 | 66000000 | Taxes, Permits and [NAME] | 1900057734 | KR | HOFC | HOFC-000 | D091-000 |  | 500 | REIMB. | [NAME] meeting,transpo,notarial fee | 40 |  | 0 | 1900057734 |  | EM09022674
2024-02-01 00:00:00 | 21960312 | Expanded Withholding Tax - 2% Subcon/Services | 1900058436 | KR | HOFC | HOFC-000 |  |  | -86.61 | 3748 |  | 50 |  | 0 | 1900058436 |  | 1000001454
2024-02-01 00:00:00 | 11960503 | Deferred [NAME] | 1900058436 | KR | HOFC | HOFC-000 |  | 0 | 519.64 | 3748 |  | 40 |  | 0 | 1900058436 |  | 1000001454
2024-02-01 00:00:00 | 63800000 | Repairs and Maintenance | 1900058436 | KR | HOFC | HOFC-000 | D060-000 |  | 4330.36 | 3748 | PMS Isuzu Pass van NAI 8268 | 40 |  | 0 | 1900058436 |  | 1000001454
2024-02-01 00:00:00 | 21200101 | Accounts Payable | 1900058436 | KR | HOFC | HOFC-000 |  | 1000001454 | -4763.39 | 3748 | PMS Isuzu Pass van NAI 8268 | 31 |  | -86.61 | 1900058436 |  | 1000001454
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058437 | KR | HOFC | HOFC-000 |  | EM00001065 | -3000 | REIMB.SDCARD | Reimb. SD card memory for admin service old laptop | 31 | 2000085390 | 0 | 1900058437 |  | EM00001065
2024-02-01 00:00:00 | 63100000 | Printing; Office Supplies | 1900058437 | KR | HOFC | HOFC-000 | D060-000 | MR-1243 | 3000 | REIMB.SDCARD | Reimb. SD card memory for admin service old laptop | 40 |  | 0 | 1900058437 |  | EM00001065
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058475 | KR | HOFC | HOFC-000 |  | EM09015172 | -15000 | TRANSPO ALLOWANC | [NAME] for February 2024 | 31 | 2000085276 | 0 | 1900058475 |  | EM09015172
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058475 | KR | HOFC | HOFC-000 | D040-000 |  | 15000 | TRANSPO ALLOWANC | [NAME] for February 2024 | 40 |  | 0 | 1900058475 |  | EM09015172
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058476 | KR | HOFC | HOFC-000 |  | EM09003978 | -6430 | REIM_02012024 | [NAME] | 31 | 2000084619 | 0 | 1900058476 |  | EM09003978
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058476 | KR | BLDG | BLDG-000 | BLDG-000 | Building | 6430 | REIM_02012024 | [NAME] | 40 |  | 0 | 1900058476 |  | EM09003978
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058477 | KR | IPD | ENER-000 | ENER-000 | ENERGY | 13910 | REIM_02012024 | Various Travel Expenses_LGBU Site Visit | 40 |  | 0 | 1900058477 |  | EM09003978
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058477 | KR | HOFC | HOFC-000 |  | EM09003978 | -13910 | REIM_02012024 | Various Travel Expenses_LGBU Site Visit | 31 | 2000084619 | 0 | 1900058477 |  | EM09003978
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058478 | KR | HOFC | HOFC-000 |  | EM09003978 | -15405.27 | REIM_02012024 | Reim_Various Expenses | 31 | 2000084619 | 0 | 1900058478 |  | EM09003978
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058478 | KR | IPD | ENER-000 | ENER-000 | ENERGY | 14403.27 | REIM_02012024 | BOD Pantry Supplies, Travel Exp_LGBU Site Visit | 40 |  | 0 | 1900058478 |  | EM09003978
2024-02-01 00:00:00 | 21460210 | Accrued Expenses | 1900058478 | KR | IPD | INPD-000 |  | [NAME] | 1002 | REIM_02012024 | Various Expenses | 40 |  | 0 | 1900058478 |  | EM09003978
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058479 | KR | HOFC | HOFC-000 |  | EM09024108 | -2260 | 2ND BASED OFF | Based off Cash Conversion-PANGASINAN (January 2024 | 31 | 2000084630 | 0 | 1900058479 |  | EM09024108
2024-02-01 00:00:00 | 50061060 | COS - Business Travel | 1900058479 | KR | MPD | 2187-000 |  | 2187-000 | 2260 | 2ND BASED OFF | Based off Cash Conversion - PANGASINAN (January 20 | 40 |  | 0 | 1900058479 | C-2187-GRQ | EM09024108
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058480 | KR | HOFC | HOFC-000 |  | EM09014037 | -43400 | REIM_02012024 | Reim_Starlink Internet (Amacan) | 31 | 2000084622 | 0 | 1900058480 |  | EM09014037
2024-02-01 00:00:00 | 50061090 | COS - Telephone, Fax and Other communication | 1900058480 | KR | IPD | 2238-000 |  | 2238-000 | 43400 | REIM_02012024 | Reim_Starlink Internet (Amacan) | 40 |  | 0 | 1900058480 | C-2238-GEX | EM09014037
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058481 | KR | HOFC | HOFC-000 |  | EM09008395 | -1753 | REIMB.MEALS | Reimb. meals - Meeting for SBP & HR_Transition & | 31 | 2000085267 | 0 | 1900058481 |  | EM09008395
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058481 | KR | HOFC | HOFC-000 | D021-000 |  | 1753 | REIMB.MEALS | hand-over w/ VDelima, FPorillo & HAcobo | 40 |  | 0 | 1900058481 |  | EM09008395
2024-02-01 00:00:00 | 11960503 | Deferred [NAME] | 1900058482 | KR | HOFC | HOFC-000 |  | 0 | 125682.89 | PH91MKP0033359 |  | 40 |  | 0 | 1900058482 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058482 | KR | HOFC | HOFC-000 | D040-000 | expense | 95107.4 | PH91MKP0033359 | Financial Audit 1st Progress Bill CY 2023 | 40 |  | 0 | 1900058482 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058482 | KR | HOFC | HOFC-000 | D040-000 | audit fee | 952250 | PH91MKP0033359 | Financial Audit 1st Progress Bill CY 2023 | 40 |  | 0 | 1900058482 |  | 1000001076
2024-02-01 00:00:00 | 21200101 | Accounts Payable | 1900058482 | KR | HOFC | HOFC-000 |  | 1000001076 | -1173040.29 | PH91MKP0033359 | Financial Audit 1st Progress Bill CY 2023 | 31 | 2000085375 | 0 | 1900058482 |  | 1000001076
2024-02-01 00:00:00 | 21200101 | Accounts Payable | 1900058483 | KR | HOFC | HOFC-000 |  | 1000001076 | -1082806.41 | PH91MKP0033358 | Financial Audit Acceptance Fee CY 2023 | 31 | 2000085376 | 0 | 1900058483 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058483 | KR | HOFC | HOFC-000 | D040-000 | audit fee | 879000 | PH91MKP0033358 | Financial Audit Acceptance Fee CY 2023 | 40 |  | 0 | 1900058483 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058483 | KR | HOFC | HOFC-000 | D040-000 | expense | 87791.44 | PH91MKP0033358 | Financial Audit Acceptance Fee CY 2023 | 40 |  | 0 | 1900058483 |  | 1000001076
2024-02-01 00:00:00 | 11960503 | Deferred [NAME] | 1900058483 | KR | HOFC | HOFC-000 |  | 0 | 116014.97 | PH91MKP0033358 |  | 40 |  | 0 | 1900058483 |  | 1000001076
2024-02-01 00:00:00 | 21200101 | Accounts Payable | 1900058484 | KR | HOFC | HOFC-000 |  | 1000001076 | -190400 | PH91MKP0033356 | TP Study: Acceptance bill | 31 | 2000085374 | 0 | 1900058484 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058484 | KR | HOFC | HOFC-000 | D040-000 | audit fee | 150000 | PH91MKP0033356 | TP Study: Acceptance bill | 40 |  | 0 | 1900058484 |  | 1000001076
2024-02-01 00:00:00 | 65300000 | Legal and Audit Fee | 1900058484 | KR | HOFC | HOFC-000 | D040-000 | expense | 20000 | PH91MKP0033356 | TP Study: Acceptance bill | 40 |  | 0 | 1900058484 |  | 1000001076
2024-02-01 00:00:00 | 11960503 | Deferred [NAME] | 1900058484 | KR | HOFC | HOFC-000 |  | 0 | 20400 | PH91MKP0033356 |  | 40 |  | 0 | 1900058484 |  | 1000001076
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058486 | KR | HOFC | HOFC-000 |  | EM09015172 | -8732.92 | REIMB.MEALS | Reimb. meals - meeting w/ IBSI & Atty. [NAME] | 31 | 2000085276 | 0 | 1900058486 |  | EM09015172
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058486 | KR | HOFC | HOFC-000 | D040-000 | 77034 | 7004.92 | REIMB.MEALS | Reimb. meals - meeting w/ [NAME]. [NAME] | 40 |  | 0 | 1900058486 |  | EM09015172
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058486 | KR | HOFC | HOFC-000 | D040-000 | 100114382 | 1728 | REIMB.MEALS | Reimb. meals - meeting w/ IBSI | 40 |  | 0 | 1900058486 |  | EM09015172
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058488 | KR | HOFC | HOFC-000 |  | EM09008395 | -935 | REIMB.MEALS | Reimb. OT meals w/ VDelima, HSamson & other Financ | 31 | 2000085267 | 0 | 1900058488 |  | EM09008395
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058488 | KR | HOFC | HOFC-000 | D021-000 |  | 935 | REIMB.MEALS | Reimb. OT meals w/ VDelima, HSamson & other Financ | 40 |  | 0 | 1900058488 |  | EM09008395
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058490 | KR | HOFC | HOFC-000 |  | EM09008395 | -5000 | GAS ALLOWANCE | Gasoline allowance January 2024 | 31 | 2000085395 | 0 | 1900058490 |  | EM09008395
2024-02-01 00:00:00 | 64200000 | Petroleum; Oil; and Lubricant | 1900058490 | KR | HOFC | HOFC-000 | D021-000 |  | 5000 | GAS ALLOWANCE | Gasoline allowance January 2024 | 40 |  | 0 | 1900058490 |  | EM09008395
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058494 | KR | HOFC | HOFC-000 | D020-000 |  | 300 | REIMB.MEALS&PARK | Reimb. parking fee | 40 |  | 0 | 1900058494 |  | EM00000002
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058494 | KR | HOFC | HOFC-000 | D020-000 |  | 3754.19 | REIMB.MEALS&PARK | Reimb. meals - Meeting w/ Aidea & JAP | 40 |  | 0 | 1900058494 |  | EM00000002
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058494 | KR | HOFC | HOFC-000 | D020-000 | 62169/62170 | 8161.07 | REIMB.MEALS&PARK | Reimb. meals - Meeting w/ MDC &RGV | 40 |  | 0 | 1900058494 |  | EM00000002
2024-02-01 00:00:00 | 64100000 | Transportation and Meals | 1900058494 | KR | HOFC | HOFC-000 | D020-000 | 339601 | 1850 | REIMB.MEALS&PARK | Reimb. meals - Meeting w/ Jimmy Villaroma & JAP | 40 |  | 0 | 1900058494 |  | EM00000002
2024-02-01 00:00:00 | 21300502 | Employee Accounts Payable | 1900058494 | KR | HOFC | HOFC-000 |  | EM00000002 | -14065.26 | REIMB.MEALS&PARK | Reimb. meals - Meeting w/ B&V, Aidea and MDC | 31 | 2000085249 | 0 | 1900058494 |  | EM00000002