Spreadsheet: 806948d1669690261-distribution-of-data-base-on-dates-with-mutiple-duplicates-collection-vs-deposites-excelforum-file
Sheet: OUPUT

this is also needed for the semi report |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS WILL BE THE FINAL OUTPUT
SEMI FINAL OUTPUT |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FINAL OUTPUT
COLLECTIONS SEMI OUTPUT - SORTED |  |  |  |  |  | DEPOSITS SEMI OUTPUT SORTED |  |  |  |  |  |  |  |  | COLLECTIONS |  |  |  |  |  | DEPOSITS
(1) | (2) |  | (3) | (4) |  | (5) | (6) | (6) | (7) | (8) |  |  |  |  | (1) | (2) |  | (3) | (4) |  | (5) | (6) | (6) | (7) | (8)
Date | OR No. |  | Qty | Amount |  | Date | OR No. | Amount | Short/(Over) | Balance |  |  |  |  | Date | OR No. |  | Qty | Amount |  | Date | OR No. | Amount | Short/(Over) | Balance
 | From | To |  |  |  |  |  |  |  |  |  |  |  |  |  | From | To
Beg. Bal. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beg. Bal.
2017-03-01 00:00:00 |  | 2017-03-01 00:00:00 |  | 10211.5 |  | 2017-11-01 00:00:00 |  | 270576.19 |  |  |  |  |  |  | 2017-01-03 00:00:00 |  |  |  | 10211.5 |  |  |  |  | 10211.5 | 10211.5
2017-04-01 00:00:00 |  | 2017-04-01 00:00:00 |  | 23747 |  | 1/16/2017 |  | 70606.3 |  |  |  |  |  |  | 2017-01-04 00:00:00 |  |  |  | 23747 |  |  |  |  | 23747
2017-04-01 00:00:00 |  | 2017-04-01 00:00:00 |  | 10331.16 |  | 1/18/2017 |  | 76819.97 |  |  |  |  |  |  | 2017-01-04 00:00:00 |  |  |  | 10331.16 |  |  |  |  | 10331.16
2017-05-01 00:00:00 |  | 2017-05-01 00:00:00 |  | 19255 |  | 1/19/2017 |  | 16844.07 |  |  |  |  |  |  | 2017-01-05 00:00:00 |  |  |  | 19255 |  |  |  |  | 19255
2017-05-01 00:00:00 |  | 2017-05-01 00:00:00 |  | 5268.81 |  | 1/23/2017 |  | 39325.1 |  |  |  |  |  |  | 2017-01-05 00:00:00 |  |  |  | 5268.81 |  |  |  |  | 5268.81
2017-06-01 00:00:00 |  | 2017-06-01 00:00:00 |  | 30453 |  | 1/23/2017 |  | 190677.21 |  |  |  |  |  |  | 2017-01-06 00:00:00 |  |  |  | 30453 |  |  |  |  | 30453
2017-06-01 00:00:00 |  | 2017-06-01 00:00:00 |  | 9366.52 |  | 1/31/2017 |  | 87939.64 |  |  |  |  |  |  | 2017-01-06 00:00:00 |  |  |  | 9366.52 |  |  |  |  | 9366.52
2017-09-01 00:00:00 |  | 2017-09-01 00:00:00 |  | 32036.2 |  |  |  |  |  |  |  |  |  |  | 2017-01-09 00:00:00 |  |  |  | 32036.2 |  |  |  |  | 32036.2
2017-09-01 00:00:00 |  | 2017-09-01 00:00:00 |  | 4650 |  |  |  |  |  |  |  |  |  |  | 2017-01-09 00:00:00 |  |  |  | 4650 |  |  |  |  | 4650
2017-09-01 00:00:00 |  | 2017-09-01 00:00:00 |  | 14979 |  |  |  |  |  |  |  |  |  |  | 2017-01-09 00:00:00 |  |  |  | 14979 |  |  |  |  | 14979
2017-09-01 00:00:00 |  | 2017-09-01 00:00:00 |  | 5782.05 |  |  |  |  |  |  |  |  |  |  | 2017-01-09 00:00:00 |  |  |  | 5782.05 |  |  |  |  | 5782.05
2017-10-01 00:00:00 |  | 2017-10-01 00:00:00 |  | 13576 |  |  |  |  |  |  |  |  |  |  | 2017-01-10 00:00:00 |  |  |  | 13576 |  |  |  |  | 13576
2017-11-01 00:00:00 |  | 2017-11-01 00:00:00 |  | 5787 |  |  |  |  |  |  |  |  |  |  | 2017-01-11 00:00:00 |  |  |  | 5787 |  | 2017-01-11 00:00:00 |  | 270576.19
2017-11-01 00:00:00 |  | 2017-11-01 00:00:00 |  | 9118 |  |  |  |  |  |  |  |  |  |  | 2017-01-11 00:00:00 |  |  |  | 9118 |  |  |  |  | 5787
2017-11-01 00:00:00 |  | 2017-11-01 00:00:00 |  | 5598.97 |  |  |  |  |  |  |  |  |  |  | 2017-01-11 00:00:00 |  |  |  | 5598.97 |  |  |  |  | 5598.97
2017-12-01 00:00:00 |  | 2017-12-01 00:00:00 |  | 18881 |  |  |  |  |  |  |  |  |  |  | 2017-01-12 00:00:00 |  |  |  | 18881 |  |  |  |  | 18881
2017-12-01 00:00:00 |  | 2017-12-01 00:00:00 |  | 12020 |  |  |  |  |  |  |  |  |  |  | 2017-01-12 00:00:00 |  |  |  | 12020 |  |  |  |  | 12020
2017-12-01 00:00:00 |  | 2017-12-01 00:00:00 |  | 5045.29 |  |  |  |  |  |  |  |  |  |  | 2017-01-12 00:00:00 |  |  |  | 5045.29 |  |  |  |  | 5045.29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-16 00:00:00 |  | 70606.3 | 70606.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-18 00:00:00 |  | 76819.97 | 76819.97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-19 00:00:00 |  | 16844.07 | 16844.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-23 00:00:00 |  | 39325.1 | 39325.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-23 00:00:00 |  | 190677.21 | 190677.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-01-31 00:00:00 |  | 87939.64 | 87939.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUBTOTAL
COLLECTION AMOUT MINUS DEPOSIT AMOUNT
PAG WALA SIR YUN DEPOSIT AMOUNT COPY LANG YUN AMOUNT NG DEPOSIT SA SHORT OVER
SA BALANCE SIR
[NAME] THEN YUN BABA NG SHORT OVER
LIKE [NAME] 26,064.69 + J13 2,347.00