Spreadsheet: 870138d1716706661-help-with-consolidated-sheet-pulling-data-from-daily-sheets-and-formula-date-incrementing-june-2024
Sheet: JUNE 2024

DTS |  |  |  |  | JUNE 2024
 |  |  | LIGHTHOUSE |  |  |  | THE DECK |  |  |  | ACCOMMODATION |  |  |  | NON VATABLE ITEMS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drop safe
DAY | DATE | ROOM % | BED % | COVERS | LH BAR |  | LH FOOD |  | LD BAR |  | LD FOOD |  | ROOMS |  | Tips Pilot | TRANSPORT | [NAME] | LAUNDRY | SUNDRY | Conference |  | NET TOTAL | VAT | GROSS TOTAL | LD CARDS | CARDS |  | CREDIT ROOM SALES |  | DEB REC |  |  | S/O |  | NET TOTAL | VOUCHER | DIFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH BOOK RECEIPTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE | AMOUNT | Reason/supplier | PD OUT TO PC | TIPS PAID F/O | TIPS PAID PILOT | TOTAL BANKED | SAFE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/Forward |  |  | [NAME] |  | GL CODE |  | DEBITS |  | CREDITS
Sat | 1 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 101 |  |  |  | 0
Sun | 2 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 147 |  |  |  | 0
Mon | 3 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 184 |  |  |  | 0
Tue | 4 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 101 |  |  |  | 0
Wed | 5 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 102 |  |  |  | 0
Thu | 6 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 106
Fri | 7 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 140 |  |  |  | 0
Sat | 8 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 210 |  |  |  | 0
Sun | 9 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 201 |  |  |  | 0
Mon | 10 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 202
Tue | 11 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 203
Wed | 12 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 951
Thu | 13 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 310 |  |  |  | 0
Fri | 14 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 301 |  |  |  | 0
Sat | 15 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 401
Sun | 16 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 402
Mon | 17 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 406
Tue | 18 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 430
Wed | 19 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 720
Thu | 20 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 937 |  |  |  | 0
Fri | 21 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 812 |  | 0
Sat | 22 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 820
Sun | 23 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 827 |  | 0
Mon | 24 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 812 |  |  |  | 0
Tue | 25 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 230
Wed | 26 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 920
Thu | 27 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 920
Fri | 28 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 107
Sat | 29 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 522 |  |  |  | 0
Sun | 30 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  |  |  | 0 | 0 | 0 |  |  | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 827 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 827 |  | 0
 |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 | 0 | 0 |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NON VATABLE ITEMS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTROL |  |  |  | 0 |  | 0