Spreadsheet: 675996d1588601651-weekday-formula-linked-from-tab-1-cell-h2-may-2020
Sheet: 5.1.20

 |  |  |  |  | DAY # - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 5
 |  |  |  |  | DAY - |  | Friday | .. | Sales Tax Rate
 |  |  |  |  | REPORT DATE- |  | 2020-05-01 00:00:00 |  | Telcom/Sales Tx Rate
_ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ |  | _ | _ | _ | _ | _ | _ | _
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
 |  |  | A/C # |  | TODAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCOUNTS RECEIVABLE |  |  |  |  |  | TODAY'S DEPOSIT
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  |  | - | - | - |  | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guest Ledger |  |  |  |  |  | A/C # |  |  | TODAY |  | MTD
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | City Ledger |  | 0 |  | - |  | - | - |  | - |  | -
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Less Paid Outs
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cash Tips
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C/L prior day ccd's |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Over/Short
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Today's Deposit
 |  |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Less Advance Deposits |  | 0 |  | - | - | - | - | - | - | - | -
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BANK BALANCE |  |  |  |  | SHORT & OVER
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY'S BALANCE |  |  |  | - |  | - | - |  | Name |  | $
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yesterday's Balance |  |  |  |  | - |  | -
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | Today's Deposit
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | - |  | - |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  |  |  |  |  |  |  | Total Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | - | - |  | - |  | -
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Total
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | -
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yesterday's Balance
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Today's Balances
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Net Income
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Payments
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Ledger Balances
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  |  |  | Difference
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | =
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Balances :
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  |  |  | City Ledger :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per PMS |  | 0 |  | * data input - on these cells only !!!
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  |  |  | Per this IJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff
 |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Guest Ledger :
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Per PMS |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Per this IJ
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff
 |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | =
 |  |  | see backup |  |  |  |  |  | 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 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | = |  | =
 |  |  |  |  | 0
 |  |  | - |  | - |  | -
 |  |  | - |  | - |  | -
 | = | = | = | = | = | = | = | =
::
 |  |  |  |  | DAY #-
 |  |  |  |  | DAY  -
 |  |  |  |  | REPORT DATE-
 | -
 |  |  | AC# |  | TODAY
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | ROOM # |  | REASON
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - | - | - |  | -
 |  |  |  |  | TODAY
 |  |  | AMOUNT |  | # COVERS
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 |  |  | 0 |  | 0
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  |  |  |  |  | MONTH |  | PRIOR YR |  | PRIOR YR |  | BUDGET |  | BUDGET
 |  |  | A/C # |  | TODAY |  | TO DATE |  | TODAY |  | MTD |  | TODAY |  | MTD
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
 | - |  | - |  | - |  | - |  | - |  | - |  | - |  | -
::
 |  |  |  |  | DAY #-
 |  |  |  |  | DAY  -
 |  |  |  |  | REPORT DATE-
 |  |  | MISC INCOME
_ |  | _ | _ | _ | _ | _ | _ | _ | _ | _ | - | _
 | - |  | - |  | - |  | - |  | -
 |  |  | A/C # |  | TODAY
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  |  |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  |  |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  |  |  | MTD MISC INCOME
 | = | = | = | = | = | = | = | = | = | = | = | =
_ |  | _ | _ | _ | _ | _ | _ | _ | _ | _ | - | _
 | - |  | - |  | - |  | - |  | - |  | MONTH
 | NAME |  | A/C # |  | TODAY |  | [NAME] |  |  |  | TO DATE
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | = | = | = | = | = | = | = | = | = | = | = | =
::
 |  |  |  |  | DAY #-
 |  |  |  |  | DAY  -
 |  |  |  |  | REPORT DATE-
 |  |  | NON REVENUE CREDITS & ADJUSTMENTS
_ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
 |  |  | A/C # |  | TODAY
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | TOTAL NON REVENUE CREDITS |  |  |  |  |  | MTD NON REVENUE CREDITS
 | = | = | = | = | = | = | = | = | = | = | = | =
_ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _ | _
 |  |  |  |  |  |  |  |  |  |  | MONTH
 | NAME |  | A/C # |  | TODAY |  | [NAME] |  |  |  | TO DATE
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 |  |  |  |  | 0
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | - |  | - |  | - |  | - | - | - |  | -
 | TOTAL NON REVENUE ADJS |  |  |  |  |  | MTD NON REVENUE ADJS
 | = | = | = | = | = | = | = | = | = | = | = | =
 | = | = | = | = | = | = | = | = | = | = | = | =
 | TOTAL NET NON REV & ADJS |  |  |  |  |  | MTD NET NON REV & ADJS
 | = | = | = | = | = | = | = | = | = | = | = | =