Spreadsheet: 874413d1720993459-power-query-steps-not-working-why-power-query-from-qbo-file
Sheet: SCA

Date | Transaction Type | Name | Account | Debit | Credit
2020-11-30 00:00:00 | [NAME]) | Call-A-Head | Cash Clearing |  | 402.9
2023-09-21 00:00:00 | Expense | Call-A-Head | Chase  Ink 8659 |  | 157.87
2024-03-22 00:00:00 | Expense | Call-A-Head | Chase  Ink 8659 |  | 2541.65
2024-04-22 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 149.54
2024-04-22 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 149.54
2024-04-22 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 69.43
2024-04-22 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 149.54
2024-04-22 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 149.54
2024-04-29 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 554.93
2024-04-29 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 554.93
2024-04-30 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 554.93
2024-04-30 00:00:00 | [NAME]) | Call-A-Head | 1005 BOA #7075 |  | 554.93
2024-06-04 00:00:00 | Expense | Call-A-Head | Chase  Ink 8659 |  | 299.08
2024-06-04 00:00:00 | Expense | Call-A-Head | Chase  Ink 8659 |  | 554.93
2024-06-04 00:00:00 | Expense | Call-A-Head | Chase  Ink 8659 |  | 389.06
2023-11-15 00:00:00 | [NAME]) | Cassone Leasing | 1005 BOA #7075 |  | 7355
2024-02-07 00:00:00 | Check | Cassone Leasing | TD Bank Funds Control 7461 |  | 7750
2023-10-13 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 1932.88
2023-10-24 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 7595.11
2023-10-30 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 3490.59
2024-01-03 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 6011.47
2024-01-05 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 690
2024-01-15 00:00:00 | Expense | Clean Earth Environmental | Chase  Ink 8659 |  | 432.26
2024-05-30 00:00:00 | [NAME]) | Diaz Electric | 1005 BOA #7075 |  | 13000
2023-08-16 00:00:00 | [NAME]) | [NAME] | 1005 BOA #7075 |  | 887.81
2023-12-31 00:00:00 | [NAME]) | [NAME] | Cash Clearing |  | 939.44
2024-07-02 00:00:00 | [NAME]) | [NAME] | 1005 BOA #7075 |  | 602.3
2023-05-11 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 2700
2023-05-11 00:00:00 | Expense | Livstid Studios Llc | Cash Clearing | 2700
2023-06-10 00:00:00 | Expense | Livstid Studios Llc | Cash Clearing | 2700
2023-06-10 00:00:00 | [NAME]) | Livstid Studios Llc | Cash Clearing |  | 2700
2023-06-10 00:00:00 | Expense | Livstid Studios Llc | Chase  Ink 8659 |  | 2700
2023-06-26 00:00:00 | [NAME]) | Livstid Studios Llc | Cash Clearing |  | 2700
2023-08-14 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 3960
2023-08-14 00:00:00 | Expense | Livstid Studios Llc | Cash Clearing | 3960
2023-08-27 00:00:00 | [NAME]) | Livstid Studios Llc | Cash Clearing |  | 3960
2023-09-14 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 2700
2023-10-11 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 4400
2023-10-11 00:00:00 | [NAME]) | Livstid Studios Llc | Cash Clearing |  | 4400
2023-10-11 00:00:00 | Expense | Livstid Studios Llc | Cash Clearing | 4400
2023-11-13 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 4450
2023-12-13 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 4230
2024-01-16 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 3925
2024-04-11 00:00:00 | Expense | Livstid Studios Llc | 1005 BOA #7075 |  | 4310
2024-06-13 00:00:00 | [NAME]) | Livstid Studios Llc | 1005 BOA #7075 |  | 3150
2024-05-30 00:00:00 | [NAME]) | Pjp Installers , Inc | 1005 BOA #7075 |  | 10000
2024-02-02 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1068.43
2024-02-02 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1039.09
2024-02-02 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1058.18
2024-02-02 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1028.84
2024-02-05 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1193.25
2024-02-05 00:00:00 | Expense | [NAME] | 1005 BOA #7075 |  | 1243.09
2024-05-15 00:00:00 | Check | Raiden Electric | TD Bank Funds Control 8401 |  | 14200
2023-11-02 00:00:00 | Payment | School Construction Auth.:Ps 6 | TD Bank Funds Control 8401 | 115664.12
2024-03-28 00:00:00 | Deposit | School Construction Auth.:Ps 6 | 1005 BOA #7075 | 37214.08
2024-03-28 00:00:00 | Deposit | School Construction Auth.:Ps 6 | Cash Clearing |  | 37214.08
2024-03-28 00:00:00 | Payment | School Construction Auth.:Ps 6 | Cash Clearing | 37214.08
2024-04-25 00:00:00 | Payment | School Construction Auth.:Ps 6 | TD Bank Funds Control 8401 | 189697.29
2024-05-29 00:00:00 | Payment | School Construction Auth.:Ps 6 | TD Bank Funds Control 8401 | 103895.8
2023-11-13 00:00:00 | Expense | Tristate Paving Llc | 1005 BOA #7075 |  | 5700
2023-12-11 00:00:00 | Check | Tristate Paving Llc | TD Bank Funds Control 7461 |  | 95661.2
2024-02-26 00:00:00 | Check | Tristate Paving Llc | TD Bank Funds Control 7461 |  | 16773.68
2024-03-06 00:00:00 | Expense | Tristate Paving Llc | 1005 BOA #7075 |  | 13767
2024-03-08 00:00:00 | Expense | Tristate Paving Llc | 1005 BOA #7075 |  | 14491.11
2024-04-12 00:00:00 | Expense | Tristate Paving Llc | 1005 BOA #7075 |  | 14961
2024-06-06 00:00:00 | Check | Tri-State Paving, [NAME] | 1005 BOA #7075 |  | 20000
2023-08-18 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 2220.31
2023-08-18 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 108.88
2023-08-24 00:00:00 | Credit Card Credit | United Rentals | Chase  Ink 8659 | 2329.19
2023-09-18 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 1159.52
2023-11-11 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 375.62
2023-12-09 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 375.62
2024-01-16 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 8248.38
2024-02-02 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 375.62
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 7159.62
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 2816.76
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 2171.96
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 1517.17
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 1321.65
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 693.7
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 620.59
2024-04-22 00:00:00 | Expense | United Rentals | 1005 BOA #7075 |  | 184.33
2024-04-27 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 375.62
2024-05-25 00:00:00 | Expense | United Rentals | Chase  Ink 8659 |  | 375.62
2023-04-18 00:00:00 | [NAME]) | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 5683.97
2023-07-18 00:00:00 | [NAME]) | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 27287.64
2023-10-20 00:00:00 | Expense | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 16953.11
2023-10-20 00:00:00 | Expense | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 34366.35
2024-01-31 00:00:00 | [NAME]) | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 798
2024-03-07 00:00:00 | Check | Varsity Plumbing & Heating Inc. | TD Bank Funds Control 7461 |  | 44456.2
2024-05-30 00:00:00 | [NAME]) | Varsity Plumbing & Heating Inc. | 1005 BOA #7075 |  | 33557.8
2023-11-15 00:00:00 | [NAME]) | Venus Fire Protection | Cash Clearing |  | 660
2023-11-15 00:00:00 | Expense | Venus Fire Protection | Cash Clearing | 660
2023-11-15 00:00:00 | Expense | Venus Fire Protection | Chase  Ink 8659 |  | 660
 |  |  |  | 37214.08 | 287488.44
 |  |  |  | 51634.08 | 52976.42
 |  |  |  |  | 164641.08
 |  |  |  | 409257.21 | 14200
 |  |  |  | 2329.19 | 32821.71
 |  |  |  | 500434.56 | 552127.65