Spreadsheet: 112625d1308688704-some-banks-not-adding-template
Sheet: Sheet1

PERIOD TOTALS | PAYMENT DETAILS |  |  |  |  |  |  |  |  |  |  |  | DELIVERED SALES DETAILS |  |  |  |  |  |  |  |  |  |  |  |  | UNDELIVERED DETAILS |  |  |  | BANK PAYMENTS
 |  |  |  |  |  | 3600 | 180 |  |  |  | 2221387535 |  |  |  |  |  |  |  |  |  | 1600 | 80 | 2430000 |  |  |  | 0 |  |  | ZENITH | 4830000
S/N | PAYMENT DATE | CUSTOMER'S NAME | ATP NO. | TELLER  NO | DEPOT RECEIPT NO. | QTY PAID FOR  - BAGS | QTY PAID FOR -TONS | PRICE/ TRUCK | ATP AMOUNT PAID | BANK | ACTUAL AMOUNT PAID | PAYMENT STATUS | DATE | ATC No. | WAY BILL No. | TRUCK NO | DEPOT ATC No. | VALIDATION CODE | REF. No. | DEPOT INVOICE No. | DELIVERY QTY/BAGS | DELIVERY QTY/TONS | DELIVERY AMOUNT. | CUSTOMER'S NAME | COMMENT/REMARK | UNDELIVERED QTY | UNDELIVERED SALES QTY/TONS | UNDELIVERED AMOUNT |  | INTERCONTINENTAL | 4830000
 |  | CUSTOMER 1 | 6 | 23 | 34 | 600 | 30 | 810000 | 810000 | ZENITH | 4830000 |  |  |  |  |  |  |  |  |  | 400 | 20 | 810000 | CUSTOMER 1 |  |  |  |  |  | FIRST BANK | 0
 |  | CUSTOMER 102 |  |  |  | 1200 | 60 | 810000 | 1620000 | INTERCONTINENTAL | 4830000 |  |  |  |  |  |  |  |  |  | 600 | 30 | 810000 | CUSTOMER 102 |  |  |  |  |  | AFRIBANK | 34869707
 |  | CUSTOMER 24 |  |  |  | 1800 | 90 | 810000 | 2430000 | FIRST BANK | 2430000 |  |  |  |  |  |  |  |  |  | 600 | 30 | 810000 | CUSTOMER 24 |  |  |  |  |  | ACCESS BANK | 23768
 |  |  |  |  |  |  | 0 |  |  | AFRIBANK | 34869707 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | FINBANK | 2869678
 |  |  |  |  |  |  | 0 |  |  | ACCESS BANK | 23768 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | FIDELITY BANK | 28697089
 |  |  |  |  |  |  | 0 |  |  | FINBANK | 2869678 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | GUARANTEE TRUST BANK | 285769
 |  |  |  |  |  |  | 0 |  |  | FIDELITY BANK | 28697089 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | OCEANIC BANK | 6079787
 |  |  |  |  |  |  | 0 |  |  | GUARANTEE TRUST BANK | 285769 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | SPRING BANK | 89079786
 |  |  |  |  |  |  | 0 |  |  | OCEANIC BANK | 6079787 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | SKYE BANK | 986755869
 |  |  |  |  |  |  | 0 |  |  | SPRING BANK | 89079786 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | UBA | 1295868
 |  |  |  |  |  |  | 0 |  |  | SKYE BANK | 986755869 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | STANBIC BANK | 9586868
 |  |  |  |  |  |  | 0 |  |  | UBA | 1295868 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | DIAMOND BANK | 98765
 |  |  |  |  |  |  | 0 |  |  | STANBIC BANK | 9586868 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | ECOBANK | 0
 |  |  |  |  |  |  | 0 |  |  | DIAMOND BANK | 98765 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | UNION | 768797970
 |  |  |  |  |  |  | 0 |  |  | ECOBANK | 76879708 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | EQUITORIAL TRUST BANK | 8697855
 |  |  |  |  |  |  | 0 |  |  | UNION | 768797970 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | FCMB | 5678
 |  |  |  |  |  |  | 0 |  |  | EQUITORIAL TRUST BANK | 8697855 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | NIGERIA INTERNATIONAL BANK | 85768797
 |  |  |  |  |  |  | 0 |  |  | FCMB | 5678 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | BANK PHB | 5869707
 |  |  |  |  |  |  | 0 |  |  | NIGERIA INTERNATIONAL BANK | 85768797 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | UNITY BANK | 97866069
 |  |  |  |  |  |  | 0 |  |  | BANK PHB | 5869707 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | WEMA BANK | 5768797
 |  |  |  |  |  |  | 0 |  |  | UNITY BANK | 97866069 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | TOTAL | 2142077827
 |  |  |  |  |  |  | 0 |  |  | WEMA BANK | 5768797 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0