Spreadsheet: 876674d1723395216-extracting-and-appending-data-in-power-query-deposit_report_08_05_2024_08_08_2024
Sheet: deposit_report_08_05_2024_08_08

Date Transfer Initiated | Date of Deposit | Total Deposit Amount | Notes | Service Sales Total | Product Sales Total
08/07/2024 | 08/07/2024 |  |  | 945 | 0
Date | Time | Appointment Time | [NAME] | Customer | Description | Service Cost | Product Cost | Tip | Discount | Cash | Cash Retained By Shop | Cash Retained By [NAME] | [NAME] | Credit Card | Gross Collected | Barber Service Commission | Barber Product Commission | Processing Rate | Processing Fee | Instant Payout Fee | Tax | Total Due To Shop | Total Due To Barber | Squire/POS | Split payment | Transaction Type
08/07/2024 | 11:21:00 | 08/07/2024 11:00 am | [NAME] | Lecoeur | Lecoeur - Le Contour appointment with [NAME]
08/07/2024 | 11:46:00 | 08/07/2024 11:00 am | Jeric | [NAME] | [NAME] appointment with [NAME]
08/07/2024 | 12:04:00 | 08/07/2024 11:00 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/07/2024 | 12:44:00 | 08/07/2024 12:00 pm | [NAME] | [NAME] | [NAME] Director [NAME] appointment with [NAME] La Section - Evo
08/07/2024 | 12:45:00 | 08/07/2024 11:30 am | [NAME] | FÃ©lix Gervais | FÃ©lix Gervais - Director [NAME] appointment with [NAME]
08/07/2024 | 13:01:00 | 08/07/2024 12:00 pm | [NAME] | Antoine Forcier | Antoine Forcier - Junior Haircut + Beard appointment with [NAME]
08/07/2024 | 13:11:00 | 08/07/2024 12:30 pm | Gio | Guru | Guru - Haircut + Beard appointment with Gio @ La Section - Evo
08/07/2024 | 14:13:00 | 08/07/2024 1:00 pm | [NAME] | Mathis Beauchamp | Mathis Beauchamp - Junior Haircut appointment with [NAME]
08/07/2024 | 14:15:00 | 08/07/2024 1:00 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/07/2024 | 14:16:00 | 08/07/2024 1:30 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/07/2024 | 15:00:00 | 08/07/2024 1:30 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/07/2024 | 15:16:00 | 08/07/2024 2:45 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/07/2024 | 15:17:00 | 08/07/2024 2:00 pm | [NAME] | [NAME] | [NAME] Haircut + Beard appointment with [NAME]
08/07/2024 | 15:27:00 | 08/07/2024 2:45 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/07/2024 | 16:00:00 | 08/07/2024 2:45 pm | Jeric | Marko Pazin | Marko Pazin - Haircut appointment with [NAME]
08/07/2024 | 16:03:00 | 08/07/2024 3:15 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/07/2024 | 16:35:00 | 08/07/2024 3:45 pm | Jeric | [NAME] | Jackson - Le Contour appointment with [NAME]
08/07/2024 | 16:41:00 | 08/07/2024 3:45 pm | [NAME] | Walking | Walking - Director [NAME] appointment with [NAME]
08/07/2024 | 16:47:00 | 08/07/2024 3:00 pm | [NAME] | [NAME] | [NAME] Haircut + Beard appointment with [NAME]
08/07/2024 | 17:12:00 | 08/07/2024 4:45 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/07/2024 | 17:15:00 | 08/07/2024 4:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/07/2024 | 17:29:00 | 08/07/2024 4:45 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/07/2024 | 17:30:00 | 08/07/2024 4:30 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/07/2024 | 17:40:00 | 08/07/2024 5:00 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/07/2024 | 18:08:00 | 08/07/2024 5:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/07/2024 | 18:45:00 | 08/07/2024 5:15 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
 |  |  |  |  |  | 945 | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0
Date Transfer Initiated | Date of Deposit | Total Deposit Amount | Notes | Service Sales Total | Product Sales Total
08/06/2024 | 08/06/2024 |  |  | 1415 | 0
Date | Time | Appointment Time | [NAME] | Customer | Description | Service Cost | Product Cost | Tip | Discount | Cash | Cash Retained By Shop | Cash Retained By [NAME] | [NAME] | Credit Card | Gross Collected | Barber Service Commission | Barber Product Commission | Processing Rate | Processing Fee | Instant Payout Fee | Tax | Total Due To Shop | Total Due To Barber | Squire/POS | Split payment | Transaction Type
08/06/2024 | 11:15:00 | 08/06/2024 10:00 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 11:21:00 | 08/06/2024 11:00 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 11:39:00 | 08/06/2024 11:00 am | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/06/2024 | 11:45:00 | 08/06/2024 10:45 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 12:07:00 | 08/06/2024 11:30 am | Gio | Walk | Walk - Haircut appointment with Gio @ La Section - Evo
08/06/2024 | 12:15:00 | 08/06/2024 11:00 am | Jeric | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 12:44:00 | 08/06/2024 12:00 pm | Vaughn | Pemo Victor | Pemo Victor - Le Contour appointment with Vaughn @ La Section - Evo
08/06/2024 | 12:44:00 | 08/06/2024 12:15 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/06/2024 | 12:45:00 | 08/06/2024 11:30 am | Jeric | Nuvnish Beejan | Nuvnish Beejan - Haircut appointment with [NAME]
08/06/2024 | 13:00:00 | 08/06/2024 11:30 am | [NAME] | Adrian Carrasco | Adrian Carrasco - Junior Haircut appointment with [NAME]
08/06/2024 | 13:30:00 | 08/06/2024 12:00 pm | [NAME] | [NAME] simp | [NAME] simp - [NAME] appointment with [NAME]
08/06/2024 | 13:34:00 | 08/06/2024 12:45 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 13:41:00 | 08/06/2024 12:45 pm | Gio | Walk | Walk - Haircut appointment with Gio @ La Section - Evo
08/06/2024 | 14:24:00 | 08/06/2024 1:30 pm | Jeric | Payman [NAME] | Payman Radjaie - Haircut + Beard appointment with [NAME]
08/06/2024 | 14:31:00 | 08/06/2024 2:00 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 14:33:00 | 08/06/2024 1:30 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/06/2024 | 14:59:00 | 08/06/2024 2:15 pm | Jeric | Darren Nâ€™cho | Darren Nâ€™cho - Haircut appointment with [NAME]
08/06/2024 | 15:10:00 | 08/06/2024 2:30 pm | [NAME] | C-O Lou | C-O Lou - Director [NAME] appointment with [NAME]
08/06/2024 | 15:15:00 | 08/06/2024 2:00 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/06/2024 | 15:15:00 | 08/06/2024 1:45 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 15:35:00 | 08/06/2024 2:30 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/06/2024 | 15:44:00 | 08/06/2024 3:00 pm | [NAME] | Emeric | Emeric - Scissor Haircut appointment with [NAME]
08/06/2024 | 16:00:00 | 08/06/2024 2:30 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 16:04:00 | 08/06/2024 3:45 pm | [NAME] | Walki | Walki - Director [NAME] appointment with [NAME]
08/06/2024 | 16:44:00 | 08/06/2024 3:30 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 17:00:00 | 08/06/2024 3:30 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 17:04:00 | 08/06/2024 4:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/06/2024 | 17:13:00 | 08/06/2024 4:15 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 17:30:00 | 08/06/2024 4:15 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/06/2024 | 17:38:00 | 08/06/2024 5:00 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 17:57:00 | 08/06/2024 5:00 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/06/2024 | 18:08:00 | 08/06/2024 5:30 pm | Vaughn | Thomas Briand | Thomas Briand - Haircut appointment with Vaughn @ La Section - Evo
08/06/2024 | 18:14:00 | 08/06/2024 5:30 pm | Jeric | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 18:15:00 | 08/06/2024 5:00 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 18:15:00 | 08/06/2024 4:45 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/06/2024 | 18:22:00 | 08/06/2024 5:30 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/06/2024 | 19:11:00 | 08/06/2024 11:00 am | [NAME] | Walk | Walk - Scissor Haircut appointment with [NAME]
08/06/2024 | 19:22:00 | 08/06/2024 5:30 pm | [NAME] | Mathias | Mathias - Junior Haircut appointment with [NAME]
 |  |  |  |  |  | 1415 | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0
Date Transfer Initiated | Date of Deposit | Total Deposit Amount | Notes | Service Sales Total | Product Sales Total
08/05/2024 | 08/05/2024 |  |  | 1490 | 25
Date | Time | Appointment Time | [NAME] | Customer | Description | Service Cost | Product Cost | Tip | Discount | Cash | Cash Retained By Shop | Cash Retained By [NAME] | [NAME] | Credit Card | Gross Collected | Barber Service Commission | Barber Product Commission | Processing Rate | Processing Fee | Instant Payout Fee | Tax | Total Due To Shop | Total Due To Barber | Squire/POS | Split payment | Transaction Type
08/03/2024 | 11:16:00 | 08/03/2024 10:30 am | [NAME] | Charles-Antoine Lalonde | Charles-Antoine Lalonde - Director [NAME] appointment with [NAME]
08/03/2024 | 11:47:00 | 08/03/2024 11:00 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/03/2024 | 11:52:00 | 08/03/2024 10:45 am | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/03/2024 | 12:39:00 | 08/03/2024 12:00 pm | Gio | Walk | Walk - Haircut appointment with Gio @ La Section - Evo
08/03/2024 | 13:18:00 | 08/03/2024 12:30 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/03/2024 | 14:02:00 | 08/03/2024 1:15 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/03/2024 | 14:52:00 | 08/03/2024 2:00 pm | Gio | [NAME] | SEA SALT SPRAY
08/03/2024 | 15:02:00 | 08/03/2024 6:15 pm | [NAME] | Wa | Wa - Director [NAME] appointment with [NAME]
08/03/2024 | 17:42:00 | 08/03/2024 5:00 pm | [NAME] | Christian | Christian - Director [NAME] appointment with [NAME]
08/03/2024 | 18:09:00 | 08/03/2024 5:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/05/2024 | 04:03:00 | 08/03/2024 3:30 pm | [NAME] | [NAME] | [NAME] - The 24k service appointment with [NAME]
08/05/2024 | 04:05:00 | 08/03/2024 11:30 am | [NAME] | Gloading Fh | [NAME] Director [NAME] appointment with [NAME]
08/05/2024 | 04:11:00 | 08/03/2024 12:00 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/05/2024 | 04:14:00 | 08/03/2024 3:30 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/05/2024 | 04:15:00 | 08/03/2024 10:00 am | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/05/2024 | 04:20:00 | 08/03/2024 1:45 pm | [NAME] | [NAME] | [NAME] 24k service appointment with [NAME]
08/05/2024 | 11:03:00 | 08/05/2024 10:30 am | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/05/2024 | 11:08:00 | 08/05/2024 10:00 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 11:44:00 | 08/05/2024 10:30 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 12:45:00 | 08/05/2024 11:30 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 12:52:00 | 08/05/2024 12:15 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 13:30:00 | 08/05/2024 11:00 am | Vaughn | [NAME] | [NAME] - The 24k service appointment with Vaughn @ La Section - Evo
08/05/2024 | 13:41:00 | 08/05/2024 1:00 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 14:13:00 | 08/05/2024 1:30 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/05/2024 | 14:42:00 | 08/05/2024 2:15 pm | Vaughn | Romain | Romain - Haircut + Beard appointment with Vaughn @ La Section - Evo
08/05/2024 | 15:08:00 | 08/05/2024 2:30 pm | [NAME] | [NAME] martignetti | [NAME] appointment with [NAME]
08/05/2024 | 15:42:00 | 08/05/2024 3:00 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 16:13:00 | 08/05/2024 3:45 pm | Vaughn | Wal | Wal - Haircut appointment with Vaughn @ La Section - Evo
08/05/2024 | 16:21:00 | 08/05/2024 3:45 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 16:30:00 | 08/05/2024 3:00 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/05/2024 | 16:43:00 | 08/05/2024 4:15 pm | Vaughn | FodÃ© Yansane | FodÃ© Yansane - Haircut appointment with Vaughn @ La Section - Evo
08/05/2024 | 16:58:00 | 08/05/2024 4:30 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/05/2024 | 17:25:00 | 08/05/2024 5:00 pm | Vaughn | Auguste Fozet | Auguste Fozet - Haircut appointment with Vaughn @ La Section - Evo
 |  |  |  |  |  | 1490 | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0
Date Transfer Initiated | Date of Deposit | Total Deposit Amount | Notes | Service Sales Total | Product Sales Total
08/05/2024 | 08/05/2024 |  |  | 1645 | 25
Date | Time | Appointment Time | [NAME] | Customer | Description | Service Cost | Product Cost | Tip | Discount | Cash | Cash Retained By Shop | Cash Retained By [NAME] | [NAME] | Credit Card | Gross Collected | Barber Service Commission | Barber Product Commission | Processing Rate | Processing Fee | Instant Payout Fee | Tax | Total Due To Shop | Total Due To Barber | Squire/POS | Split payment | Transaction Type
08/02/2024 | 10:33:00 | 08/02/2024 10:00 am | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/02/2024 | 10:50:00 | 08/02/2024 10:00 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/02/2024 | 10:56:00 | 08/02/2024 10:00 am | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/02/2024 | 11:00:00 | 08/02/2024 10:15 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 11:08:00 | 08/02/2024 10:30 am | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 11:15:00 | 08/02/2024 10:00 am | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 11:31:00 | 08/02/2024 11:00 am | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 12:34:00 | 08/02/2024 11:45 am | Vaughn | Sami | Sami - Haircut + Beard appointment with Vaughn @ La Section - Evo
08/02/2024 | 12:40:00 | 08/02/2024 12:00 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/02/2024 | 12:45:00 | 08/02/2024 11:30 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 12:59:00 | 08/02/2024 12:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 13:15:00 | 08/02/2024 10:30 am | [NAME] | LoÃ¯c Morellon | LoÃ¯c Morellon - 6 Braids Cornrows, [NAME] appointment with [NAME]
08/02/2024 | 13:19:00 | 08/02/2024 12:30 pm | [NAME] | [NAME] | [NAME] appointment with [NAME]
08/02/2024 | 13:34:00 | 08/02/2024 1:00 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 13:39:00 | 08/02/2024 1:00 pm | Vaughn | ClÃ©ment Kombo | ClÃ©ment [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 14:35:00 | 08/02/2024 10:45 am | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 15:00:00 | 08/02/2024 2:30 pm | Gio | [NAME] | SEA SALT SPRAY
08/02/2024 | 15:04:00 | 08/02/2024 2:30 pm | Vaughn | Amadou F | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 15:15:00 | 08/02/2024 1:45 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 15:23:00 | 08/02/2024 2:30 pm | [NAME] | [NAME] | Brandon - Scissor Haircut appointment with [NAME]
08/02/2024 | 15:39:00 | 08/02/2024 3:00 pm | [NAME] | Kamel SMITH | Kamel SMITH - Director [NAME] appointment with [NAME]
08/02/2024 | 15:41:00 | 08/02/2024 3:00 pm | Gio | [NAME] | [NAME] appointment with Gio @ La Section - Evo
08/02/2024 | 15:57:00 | 08/02/2024 3:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 15:59:00 | 08/02/2024 3:30 pm | Vaughn | [NAME] | [NAME] appointment with Vaughn @ La Section - Evo
08/02/2024 | 16:24:00 | 08/02/2024 3:30 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME]
08/02/2024 | 16:33:00 | 08/02/2024 4:00 pm | Gio | Leo | Leo - Haircut appointment with Gio @ La Section - Evo
08/02/2024 | 16:34:00 | 08/02/2024 4:00 pm | [NAME] | Kastus Sh | [NAME] appointment with [NAME]
08/02/2024 | 17:00:00 | 08/02/2024 4:15 pm | [NAME] | [NAME] | Jean - Director [NAME] appointment with [NAME]
08/02/2024 | 17:24:00 | 08/02/2024 4:45 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 17:45:00 | 08/02/2024 4:45 pm | Gio | Ismael Nunez | [NAME] appointment with Gio @ La Section - Evo
08/02/2024 | 17:58:00 | 08/02/2024 5:00 pm | Gio | Mason | Mason - Haircut appointment with Gio @ La Section - Evo
08/02/2024 | 17:58:00 | 08/02/2024 5:45 pm | [NAME] | [NAME] | [NAME] [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 18:30:00 | 08/02/2024 5:15 pm | [NAME] | Florian Sanchez | [NAME] appointment with [NAME]
08/02/2024 | 18:35:00 | 08/02/2024 5:30 pm | [NAME] | [NAME] | [NAME] Director [NAME] appointment with [NAME] La Section - Evo
08/02/2024 | 18:57:00 | 08/02/2024 6:30 pm | Vaughn | Guillaume JettÃ© | Guillaume JettÃ© - Haircut appointment with Vaughn @ La Section - Evo
08/02/2024 | 19:02:00 | 08/02/2024 6:30 pm | [NAME] | [NAME] | Amir - Scissor Haircut appointment with [NAME]
08/02/2024 | 19:15:00 | 08/02/2024 6:00 pm | [NAME] | AVE Gebanga | AVE [NAME] appointment with [NAME]
08/02/2024 | 19:35:00 | 08/02/2024 6:30 pm | [NAME] | Guillaume JettÃ© | Guillaume JettÃ© - Haircut + Beard appointment with [NAME]
08/02/2024 | 20:31:00 | 08/02/2024 7:30 pm | [NAME] | Walk | Walk - Haircut + Beard appointment with [NAME]
 |  |  |  |  |  | 1645 | 25 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  |  | 0