Spreadsheet: 874426d1721025414-power-query-steps-not-working-why-sca-project-ps-6-bottom-line-ii-total-paid-to-date
Sheet: Transaction Report

BOTTOM LINE CONSTRUCTION & DEVELOPMENT,LLC
Transaction Report
All Dates
 | Date | Transaction Type | Num | Adj | Name | Memo/Description | Account | Split | Debit | Credit | Balance
BOA #7075
 | 04/18/2023 | [NAME]) | 36 | No | Varsity Plumbing & Heating Inc. | Inv #01 Req#1 [NAME] | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 5683.97 | -5683.97
 | 05/11/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Cash Clearing |  | 2700 | -8383.97
 | 07/18/2023 | [NAME]) | 57 | No | Varsity Plumbing & Heating Inc. | Payment for Req#2 - Brooklyn Tech Project | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 27287.64 | -35671.61
 | 08/14/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Cash Clearing |  | 3960 | -39631.61
 | 08/16/2023 | [NAME]) |  | No | [NAME] | Acct #[PHONE] | Inv #001 and 002 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 887.81 | -40519.42
 | 09/14/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Other Job Costs:Project Consulting |  | 2700 | -43219.42
 | 10/11/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Cash Clearing |  | 4400 | -47619.42
 | 10/20/2023 | Expense |  | No | Varsity Plumbing & Heating Inc. |  | 1005 BOA #7075 | Subcontractors |  | 16953.11 | -64572.53
 | 10/20/2023 | Expense |  | No | Varsity Plumbing & Heating Inc. |  | 1005 BOA #7075 | Subcontractors |  | 34366.35 | -98938.88
 | 11/13/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Other Job Costs:Project Consulting |  | 4450 | -103388.88
 | 11/13/2023 | Expense |  | No | TRISTATE PAVING LLC |  | 1005 BOA #7075 | Subcontractors |  | 5700 | -109088.88
 | 11/15/2023 | [NAME]) | To print | No | CASSONE LEASING | Inv #PS 88 #297868 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 7355 | -116443.88
 | 12/13/2023 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Other Job Costs:Project Consulting |  | 4230 | -120673.88
 | 01/16/2024 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Professional Fees:Consulting |  | 3925 | -124598.88
 | 01/16/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 8248.38 | -132847.26
 | 01/31/2024 | [NAME]) | To print | No | Varsity Plumbing & Heating Inc. | #PS 88 VARSITY REQ 1 FOR 10_31_23 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 798 | -133645.26
 | 02/02/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1068.43 | -134713.69
 | 02/02/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1039.09 | -135752.78
 | 02/02/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1058.18 | -136810.96
 | 02/02/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1028.84 | -137839.8
 | 02/05/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1193.25 | -139033.05
 | 02/05/2024 | Expense |  | No | POSILLICO |  | 1005 BOA #7075 | Cost of Goods Sold:Materials |  | 1243.09 | -140276.14
 | 03/06/2024 | Expense |  | No | TRISTATE PAVING LLC |  | 1005 BOA #7075 | Subcontractors |  | 13767 | -154043.14
 | 03/08/2024 | Expense |  | No | TRISTATE PAVING LLC |  | 1005 BOA #7075 | Subcontractors |  | 14491.11 | -168534.25
 | 03/28/2024 | Deposit |  | No | School Construction Auth.:PS 6 |  | 1005 BOA #7075 | Cash Clearing | 37214.08 |  | -131320.17
 | 04/11/2024 | Expense |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | Professional Fees:Consulting |  | 4310 | -135630.17
 | 04/12/2024 | Expense |  | No | TRISTATE PAVING LLC |  | 1005 BOA #7075 | Subcontractors |  | 14961 | -150591.17
 | 04/22/2024 | [NAME]) | To print | No | CALL-A-HEAD | 1907488 2_9_24 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 149.54 | -150740.71
 | 04/22/2024 | [NAME]) | To print | No | CALL-A-HEAD | 1895560 1_11_24 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 149.54 | -150890.25
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 7159.62 | -158049.87
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 2816.76 | -160866.63
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 2171.96 | -163038.59
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 1517.17 | -164555.76
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 1321.65 | -165877.41
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 693.7 | -166571.11
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 620.59 | -167191.7
 | 04/22/2024 | Expense |  | No | United Rentals |  | 1005 BOA #7075 | Other Job Costs:Equipment Rental |  | 184.33 | -167376.03
 | 04/22/2024 | [NAME]) | To print | No | CALL-A-HEAD | 1893020 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 69.43 | -167445.46
 | 04/22/2024 | [NAME]) | To print | No | CALL-A-HEAD | 4_5_2024 1928325 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 149.54 | -167595
 | 04/22/2024 | [NAME]) | To print | No | CALL-A-HEAD | 3_7_24 1916990 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 149.54 | -167744.54
 | 04/29/2024 | [NAME]) | To print | No | CALL-A-HEAD | PS 6R-1895547-1/11/24 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 554.93 | -168299.47
 | 04/29/2024 | [NAME]) | To print | No | CALL-A-HEAD | 1887777/12/19/23 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 554.93 | -168854.4
 | 04/30/2024 | [NAME]) | To print | No | CALL-A-HEAD | PS 6R-1907476-2/9/24 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 554.93 | -169409.33
 | 04/30/2024 | [NAME]) | To print | No | CALL-A-HEAD | PS 6R-1916980-3/7/24 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 554.93 | -169964.26
 | 05/30/2024 | [NAME]) | To print | No | Varsity Plumbing & Heating Inc. |  | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 33557.8 | -203522.06
 | 05/30/2024 | [NAME]) | To print | No | PJP INSTALLERS , INC | #PS 6R-6729 | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 10000 | -213522.06
 | 05/30/2024 | [NAME]) | To print | No | DIAZ ELECTRIC |  | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 13000 | -226522.06
 | 06/06/2024 | Check | 1410003150 | No | Tri-State Paving, LLC |  | 1005 BOA #7075 | Subcontractors |  | 20000 | -246522.06
 | 06/13/2024 | [NAME]) |  | No | Livstid Studios LLC |  | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 3150 | -249672.06
 | 07/02/2024 | [NAME]) |  | No | [NAME] | [PHONE] | 1005 BOA #7075 | 2010 Trade Accounts Payable |  | 602.3 | -250274.36
Total for BOA #7075 |  |  |  |  |  |  |  |  | 37214.08 | 287488.44
Cash Clearing
 | 11/30/2020 | [NAME]) | 3 | No | CALL-A-HEAD |  | Cash Clearing | 2010 Trade Accounts Payable |  | 402.9 | -402.9
 | 05/11/2023 | Expense |  | No | Livstid Studios LLC |  | Cash Clearing | 1005 BOA #7075 | 2700 |  | 2297.1
 | 06/10/2023 | Expense |  | No | Livstid Studios LLC |  | Cash Clearing | Chase  Ink 8659 | 2700 |  | 4997.1
 | 06/10/2023 | [NAME]) | 56 | No | Livstid Studios LLC |  | Cash Clearing | 2010 Trade Accounts Payable |  | 2700 | 2297.1
 | 06/26/2023 | [NAME]) | 55 | No | Livstid Studios LLC |  | Cash Clearing | 2010 Trade Accounts Payable |  | 2700 | -402.9
 | 08/14/2023 | Expense |  | No | Livstid Studios LLC |  | Cash Clearing | 1005 BOA #7075 | 3960 |  | 3557.1
 | 08/27/2023 | [NAME]) | 38 | No | Livstid Studios LLC |  | Cash Clearing | 2010 Trade Accounts Payable |  | 3960 | -402.9
 | 10/11/2023 | [NAME]) | 48 | No | Livstid Studios LLC |  | Cash Clearing | 2010 Trade Accounts Payable |  | 4400 | -4802.9
 | 10/11/2023 | Expense |  | No | Livstid Studios LLC |  | Cash Clearing | 1005 BOA #7075 | 4400 |  | -402.9
 | 11/15/2023 | [NAME]) | 51 | No | Venus Fire Protection |  | Cash Clearing | 2010 Trade Accounts Payable |  | 660 | -1062.9
 | 11/15/2023 | Expense |  | No | Venus Fire Protection |  | Cash Clearing | Chase  Ink 8659 | 660 |  | -402.9
 | 12/31/2023 | [NAME]) | 57 | No | [NAME] | [PHONE] | Cash Clearing | 2010 Trade Accounts Payable |  | 939.44 | -1342.34
 | 03/28/2024 | Deposit |  | No | School Construction Auth.:PS 6 |  | Cash Clearing | 1005 BOA #7075 |  | 37214.08 | -38556.42
 | 03/28/2024 | Payment |  | No | School Construction Auth.:PS 6 |  | Cash Clearing | Accounts Receivable (A/R) | 37214.08 |  | -1342.34
Total for Cash Clearing |  |  |  |  |  |  |  |  | 51634.08 | 52976.42
TD Bank Funds Control 7461
 | 12/11/2023 | Check | 104 | No | TRISTATE PAVING LLC |  | TD Bank Funds Control 7461 | Subcontractors |  | 95661.2 | -95661.2
 | 02/07/2024 | Check | 105 | No | CASSONE LEASING |  | TD Bank Funds Control 7461 | Other Job Costs:Equipment Rental |  | 7750 | -103411.2
 | 02/26/2024 | Check | 106 | No | TRISTATE PAVING LLC |  | TD Bank Funds Control 7461 | Subcontractors |  | 16773.68 | -120184.88
 | 03/07/2024 | Check | 107 | No | Varsity Plumbing & Heating Inc. |  | TD Bank Funds Control 7461 | Subcontractors |  | 44456.2 | -164641.08
Total for TD Bank Funds Control 7461 |  |  |  |  |  |  |  |  |  | 164641.08
TD Bank Funds Control 8401
 | 11/02/2023 | Payment |  | No | School Construction Auth.:PS 6 |  | TD Bank Funds Control 8401 | Accounts Receivable (A/R) | 115664.12 |  | 115664.12
 | 04/25/2024 | Payment |  | No | School Construction Auth.:PS 6 |  | TD Bank Funds Control 8401 | Accounts Receivable (A/R) | 189697.29 |  | 305361.41
 | 05/15/2024 | Check | 109 | No | Raiden Electric |  | TD Bank Funds Control 8401 | Subcontractors |  | 14200 | 291161.41
 | 05/29/2024 | Payment |  | No | School Construction Auth.:PS 6 |  | TD Bank Funds Control 8401 | Accounts Receivable (A/R) | 103895.8 |  | 395057.21
Total for TD Bank Funds Control 8401 |  |  |  |  |  |  |  |  | 409257.21 | 14200
Chase  Ink 8659
 | 06/10/2023 | Expense |  | No | Livstid Studios LLC |  | Chase  Ink 8659 | Cash Clearing |  | 2700 | 2700
 | 08/18/2023 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 2220.31 | 4920.31
 | 08/18/2023 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 108.88 | 5029.19
 | 08/24/2023 | Credit Card Credit |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental | 2329.19 |  | 2700
 | 09/18/2023 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 1159.52 | 3859.52
 | 09/21/2023 | Expense |  | No | CALL-A-HEAD |  | Chase  Ink 8659 | Other Job Costs:Carting + Dump |  | 157.87 | 4017.39
 | 10/13/2023 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Other Job Costs:Carting + Dump |  | 1932.88 | 5950.27
 | 10/24/2023 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Other Job Costs:Carting + Dump |  | 7595.11 | 13545.38
 | 10/30/2023 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Other Job Costs:Carting + Dump |  | 3490.59 | 17035.97
 | 11/11/2023 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 375.62 | 17411.59
 | 11/15/2023 | Expense |  | No | Venus Fire Protection |  | Chase  Ink 8659 | Cash Clearing |  | 660 | 18071.59
 | 12/09/2023 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 375.62 | 18447.21
 | 01/03/2024 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Subcontractors |  | 6011.47 | 24458.68
 | 01/05/2024 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Subcontractors |  | 690 | 25148.68
 | 01/15/2024 | Expense |  | No | CLEAN EARTH ENVIRONMENTAL |  | Chase  Ink 8659 | Subcontractors |  | 432.26 | 25580.94
 | 02/02/2024 | Expense |  | No | United Rentals |  | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 375.62 | 25956.56
 | 03/22/2024 | Expense |  | No | CALL-A-HEAD | CALL A HEAD CORP BROAD CHANNEL CALL A HEAD CORP BROAD CHANNEL NY | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 2541.65 | 28498.21
 | 04/27/2024 | Expense |  | No | United Rentals | UNITED RENTALS UNITED RENTALS #15306 [PHONE] NY | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 375.62 | 28873.83
 | 05/25/2024 | Expense |  | No | United Rentals | & UNITED RENTALS | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 375.62 | 29249.45
 | 06/04/2024 | Expense |  | No | CALL-A-HEAD | CALL A HEAD CORP BROAD CHANNEL | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 299.08 | 29548.53
 | 06/04/2024 | Expense |  | No | CALL-A-HEAD | CALL A HEAD CORP BROAD CHANNEL | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 554.93 | 30103.46
 | 06/04/2024 | Expense |  | No | CALL-A-HEAD | CALL A HEAD CORP BROAD CHANNEL | Chase  Ink 8659 | Other Job Costs:Equipment Rental |  | 389.06 | 30492.52
Total for Chase  Ink 8659 |  |  |  |  |  |  |  |  | 2329.19 | 32821.71
TOTAL |  |  |  |  |  |  |  |  | 500434.56 | 552127.65
Sunday, [NAME] 2024 12:58:09 PM GMT-7 - Accrual Basis