Spreadsheet: 300522d1393503529-conditional-formatting-globe_janphp1
Sheet: Globe

Date_Received | Service_Provider | Account Number | SubAccount Number | I.INVOICE_DATE | I.INVOICE_NUMBER | I.INVOICE_DUE_DATE | Circuit ID | Description | Amount | ISC.PREV_BALANCE_AMOUNT | ISC.PREV_PAYMENT_AMOUNT | ISC.PREV_ADJUSTMENTS_AMOUNT | ISC.ADJUSTMENTS_AMOUNT | ISC.LATE_PAYMENT_CHARGE | ISC.LONG_DISTANCE_CHARGES | ISC.SERVICE_CHARGES | ISC.OTHER_CHARGES_CREDITS | ISC.TAXES_AMOUNT | ISC.MISC_AMOUNT | Total | File Name | I.Mail_Tracking | Cost Allocation
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | Monthly Charges, [PHONE] (01/01/2014 - 01/31/2014) | 355.35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3934.39 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | Mobile Phone Outright Payment Recontracting, [PHONE] | 3928.57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | Short payment of Mobile Phone Outright Payment Recontracting, [PHONE] | -350.44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | VAT Charges, [PHONE] | 471.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | Short Payment of VAT Charges, [PHONE] | -471.43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 59351642 |  | 2013-12-31 00:00:00 | 59351642 39 | 2014-01-21 00:00:00 | [PHONE] | Overseas Communication Tax, [PHONE] | 0.91 | 2656.47 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Monthly Charges, [PHONE] (12/21/2013 - 01/31/2014) | 624.11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 917.28 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | One-time Charges, [PHONE] | 145.46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Short Payment of One-time Charges, [PHONE] | -145.46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Mobile Phone Outright Payment Recontracting, [PHONE] | 4107.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Short payment of Mobile Phone Outright Payment Recontracting, [PHONE] | -4107.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | VAT charges, [PHONE] | 492.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Short Payment of VAT charges, [PHONE] | -492.86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls
2014-01-10 00:00:00 | GLOBE | 51101434 |  | 2013-12-31 00:00:00 | 51101434 59 | 2014-01-21 00:00:00 | [PHONE] | Usage Charges, [PHONE] | 293.17 | 2824.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Globetif.xls