Spreadsheet: 271731d1382029868-accounts-payable-trying-to-get-daily-updates-payables1
Sheet: Payables

Accounts Receivable
Missed payments |  | HOW DO I SHOW IF A PAYMENT HAS BEEN MISSED?
Company | Item | Factura | Date | Amount | Method | Cuotas |  |  | 2013-08-15 00:00:00 | 2013-08-16 00:00:00 | 2013-08-17 00:00:00 | 2013-08-18 00:00:00 | 2013-08-19 00:00:00 | 2013-08-20 00:00:00 | 2013-08-21 00:00:00 | 2013-08-22 00:00:00 | 2013-08-23 00:00:00 | 2013-08-24 00:00:00 | 2013-08-25 00:00:00 | 2013-08-26 00:00:00 | 2013-08-27 00:00:00 | 2013-08-28 00:00:00 | 2013-08-29 00:00:00 | 2013-08-30 00:00:00 | 2013-08-31 00:00:00 | 2013-09-01 00:00:00 | 2013-09-02 00:00:00 | 2013-09-03 00:00:00 | 2013-09-04 00:00:00 | 2013-09-05 00:00:00 | 2013-09-06 00:00:00 | 2013-09-07 00:00:00 | 2013-09-08 00:00:00 | 2013-09-09 00:00:00 | 2013-09-10 00:00:00 | 2013-09-11 00:00:00 | 2013-09-12 00:00:00 | 2013-09-13 00:00:00 | 2013-09-14 00:00:00 | 2013-09-15 00:00:00 | 2013-09-16 00:00:00 | 2013-09-17 00:00:00 | 2013-09-18 00:00:00 | 2013-09-19 00:00:00 | 2013-09-20 00:00:00 | 2013-09-21 00:00:00 | 2013-09-22 00:00:00 | 2013-09-23 00:00:00 | 2013-09-24 00:00:00 | 2013-09-25 00:00:00 | 2013-09-26 00:00:00 | 2013-09-27 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-09-30 00:00:00 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-01 00:00:00 | 2013-11-02 00:00:00 | 2013-11-03 00:00:00 | 2013-11-04 00:00:00 | 2013-11-05 00:00:00 | 2013-11-06 00:00:00 | 2013-11-07 00:00:00 | 2013-11-08 00:00:00 | 2013-11-09 00:00:00 | 2013-11-10 00:00:00 | 2013-11-11 00:00:00 | 2013-11-12 00:00:00 | 2013-11-13 00:00:00 | 2013-11-14 00:00:00 | 2013-11-15 00:00:00 | 2013-11-16 00:00:00 | 2013-11-17 00:00:00 | 2013-11-18 00:00:00 | 2013-11-19 00:00:00 | 2013-11-20 00:00:00 | 2013-11-21 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-25 00:00:00 | 2013-11-26 00:00:00 | 2013-11-27 00:00:00 | 2013-11-28 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00 | 2013-12-01 00:00:00 | 2013-12-02 00:00:00 | 2013-12-03 00:00:00 | 2013-12-04 00:00:00 | 2013-12-05 00:00:00 | 2013-12-06 00:00:00 | 2013-12-07 00:00:00 | 2013-12-08 00:00:00 | 2013-12-09 00:00:00 | 2013-12-10 00:00:00 | 2013-12-11 00:00:00 | 2013-12-12 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00 | 2013-12-15 00:00:00 | 2013-12-16 00:00:00 | 2013-12-17 00:00:00 | 2013-12-18 00:00:00 | 2013-12-19 00:00:00 | 2013-12-20 00:00:00 | 2013-12-21 00:00:00 | 2013-12-22 00:00:00 | 2013-12-23 00:00:00 | 2013-12-24 00:00:00 | 2013-12-25 00:00:00 | 2013-12-26 00:00:00 | 2013-12-27 00:00:00 | 2013-12-28 00:00:00 | 2013-12-29 00:00:00 | 2013-12-30 00:00:00 | 2013-12-31 00:00:00
Hostel | Teaching Chile |  |  | 1062075 | Tx | 2 |  | Payments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 562075
 |  |  |  |  |  |  |  | Paid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 562075
Indus | Expo Capacitacion |  |  | 1395627 | Cq | 4 |  |  |  | 348907 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348907 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348907 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348907
 |  |  |  |  |  |  |  |  |  | 348907 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348907 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 348907
 | [NAME] |  |  | 1900000 | Cq | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 650000
Grapint | Toner | 117221 |  | 232640 | Tx | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 232640
Dimacofi |  | 16259 |  | 116910 | Tx | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 116910
Trabajando.com | HR Expo | 9114 |  | 1785000 | Cq | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 446250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 446250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 446250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 446250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 446250
ABSCH | Expo | 957 |  | 571200 | Tx | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 571200
 |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  | TOTAL
 | DIFFICULT TO ADD NEW COLUMNS AS ALWAYS HAVE TO CHANGE THE FORMULAS IN K26,K27 AND B1