Spreadsheet: 888581d1739124306-outstanding-cash-received-sunboy-cash-received-tms
Sheet: Sheet1

I kindly request an Excel formula to generate a report that details the total cash received, total cash
banked, the difference between the two, and a list of cash not banked, as shown in the desired solution.
Please note that there is a dropdown list below "Month" to select the desired month. Thank you.
 |  |  |  |  |  |  |  |  |  |  | DESIRED SOLUTION
Cash Received |  |  |  |  |  | Cash Banked |  |  |  |  | Month
Date | Ref | [NAME] | Amount |  |  | Date | Ref | [NAME] | Amount |  | January
2025-01-06 00:00:00 | 17431 | Fees | 300 |  |  | 2025-01-06 00:00:00 | 17431 | Banked | 300 |  | Cash Received | 13911
2025-01-06 00:00:00 | 17432 | Fees | 100 |  |  | 2025-01-06 00:00:00 | 17432 | Banked | 100 |  | Cash Banked | 13644
2025-01-07 00:00:00 | 17433 | Fees | 300 |  |  | 2025-01-07 00:00:00 | 17433 | Banked | 300 |  | Difference | 267
2025-01-07 00:00:00 | 17434 | Fees | 100 |  |  | 2025-01-07 00:00:00 | 17434 | Banked | 100 |  | Transactions not Banked:
2025-01-08 00:00:00 | 17435 | Fees | 200 |  |  | 2025-01-08 00:00:00 | 17435 | Banked | 200 |  | 17519 | 100
2025-01-08 00:00:00 | 17436 | Fees | 200 |  |  | 2025-01-08 00:00:00 | 17436 | Banked | 200 |  | 17520 | 100
2025-01-08 00:00:00 | 17437 | Fees | 300 |  |  | 2025-01-08 00:00:00 | 17437 | Banked | 300 |  | 17521 | 67
2025-01-08 00:00:00 | 17438 | Fees | 300 |  |  | 2025-01-08 00:00:00 | 17438 | Banked | 300 |  | Total | 267
2025-01-09 00:00:00 | 17439 | Fees | 200 |  |  | 2025-01-09 00:00:00 | 17439 | Banked | 200
2025-01-09 00:00:00 | 17440 | Fees | 200 |  |  | 2025-01-09 00:00:00 | 17440 | Banked | 200 |  |  | 13911
2025-01-09 00:00:00 | 17441 | Fees | 200 |  |  | 2025-01-09 00:00:00 | 17441 | Banked | 200 |  | Cash Banked | 13644
2025-01-09 00:00:00 | 17442 | Bus Fares | 10 |  |  | 2025-01-09 00:00:00 | 17442 | Banked | 10 |  | Difference | 267
2025-01-10 00:00:00 | 17443 | Bus Fares | 92 |  |  | 2025-01-10 00:00:00 | 17443 | Banked | 92 |  | Transactions not Banked:
2025-01-13 00:00:00 | 17444 | Fees | 300 |  |  | 2025-01-13 00:00:00 | 17444 | Banked | 300 |  | 17519 | 100
2025-01-13 00:00:00 | 17445 | Fees | 400 |  |  | 2025-01-13 00:00:00 | 17445 | Banked | 400 |  | 17520 | 100
2025-01-13 00:00:00 | 17446 | Fees | 300 |  |  | 2025-01-13 00:00:00 | 17446 | Banked | 300 |  | 17521 | 67
2025-01-13 00:00:00 | 17447 | Fees | 50 |  |  | 2025-01-13 00:00:00 | 17447 | Banked | 50 |  | Total | 267
2025-01-13 00:00:00 | 17448 | Fees | 200 |  |  | 2025-01-13 00:00:00 | 17448 | Banked | 200
2025-01-13 00:00:00 | 17449 | Fees | 100 |  |  | 2025-01-13 00:00:00 | 17449 | Banked | 100
2025-01-13 00:00:00 | 17450 | Fees | 200 |  |  | 2025-01-13 00:00:00 | 17450 | Banked | 200
2025-01-13 00:00:00 | 17451 | Fees | 100 |  |  | 2025-01-13 00:00:00 | 17451 | Banked | 100
2025-01-13 00:00:00 | 17452 | Fees | 200 |  |  | 2025-01-13 00:00:00 | 17452 | Banked | 200
2025-01-13 00:00:00 | 17453 | Fees | 200 |  |  | 2025-01-13 00:00:00 | 17453 | Banked | 200
2025-01-14 00:00:00 | 17454 | Fees | 400 |  |  | 2025-01-14 00:00:00 | 17454 | Banked | 400
2025-01-14 00:00:00 | 17455 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17455 | Banked | 100
2025-01-14 00:00:00 | 17456 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17456 | Banked | 100
2025-01-14 00:00:00 | 17457 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17457 | Banked | 100
2025-01-14 00:00:00 | 17458 | Fees | 400 |  |  | 2025-01-14 00:00:00 | 17458 | Banked | 400
2025-01-14 00:00:00 | 17459 | Fees | 400 |  |  | 2025-01-14 00:00:00 | 17459 | Banked | 400
2025-01-14 00:00:00 | 17460 | Bus Fares | 72 |  |  | 2025-01-14 00:00:00 | 17460 | Banked | 72
2025-01-14 00:00:00 | 17461 | Fees | 200 |  |  | 2025-01-14 00:00:00 | 17461 | Banked | 200
2025-01-14 00:00:00 | 17462 | Bus Fares | 100 |  |  | 2025-01-14 00:00:00 | 17462 | Banked | 100
2025-01-14 00:00:00 | 17463 | Fees | 280 |  |  | 2025-01-14 00:00:00 | 17463 | Banked | 280
2025-01-14 00:00:00 | 17464 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17464 | Banked | 100
2025-01-14 00:00:00 | 17465 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17465 | Banked | 100
2025-01-14 00:00:00 | 17466 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17466 | Banked | 100
2025-01-14 00:00:00 | 17467 | Fees | 100 |  |  | 2025-01-14 00:00:00 | 17467 | Banked | 100
2025-01-14 00:00:00 | 17468 | Fees | 250 |  |  | 2025-01-14 00:00:00 | 17468 | Banked | 250
2025-01-14 00:00:00 | 17469 | Fees | 250 |  |  | 2025-01-14 00:00:00 | 17469 | Banked | 250
2025-01-14 00:00:00 | 17470 | Fees | 220 |  |  | 2025-01-14 00:00:00 | 17470 | Banked | 220
2025-01-14 00:00:00 | 17471 | Fees | 300 |  |  | 2025-01-14 00:00:00 | 17471 | Banked | 300
2025-01-14 00:00:00 | 17472 | Fees | 40 |  |  | 2025-01-14 00:00:00 | 17472 | Banked | 40
2025-01-15 00:00:00 | 17473 | Fees | 150 |  |  | 2025-01-15 00:00:00 | 17473 | Banked | 150
2025-01-15 00:00:00 | 17474 | Fees | 200 |  |  | 2025-01-15 00:00:00 | 17474 | Banked | 200
2025-01-15 00:00:00 | 17475 | Fees | 150 |  |  | 2025-01-15 00:00:00 | 17475 | Banked | 150
2025-01-15 00:00:00 | 17476 | Fees | 150 |  |  | 2025-01-15 00:00:00 | 17476 | Banked | 150
2025-01-15 00:00:00 | 17477 | Bus Fares | 161 |  |  | 2025-01-15 00:00:00 | 17477 | Banked | 161
2025-01-15 00:00:00 | 17478 | Fees | 300 |  |  | 2025-01-15 00:00:00 | 17478 | Banked | 300
2025-01-15 00:00:00 | 17479 | Fees | 300 |  |  | 2025-01-15 00:00:00 | 17479 | Banked | 300
2025-01-16 00:00:00 | 17480 | Fees | 200 |  |  | 2025-01-16 00:00:00 | 17480 | Banked | 200
2025-01-16 00:00:00 | 17481 | Bus Fares | 41 |  |  | 2025-01-16 00:00:00 | 17481 | Banked | 41
2025-01-17 00:00:00 | 17482 | Fees | 100 |  |  | 2025-01-17 00:00:00 | 17482 | Banked | 100
2025-01-17 00:00:00 | 17483 | Fees | 100 |  |  | 2025-01-17 00:00:00 | 17483 | Banked | 100
2025-01-17 00:00:00 | 17484 | Fees | 100 |  |  | 2025-01-17 00:00:00 | 17484 | Banked | 100
2025-01-20 00:00:00 | 17485 | Fees | 100 |  |  | 2025-01-20 00:00:00 | 17485 | Banked | 100
2025-01-20 00:00:00 | 17486 | Fees | 400 |  |  | 2025-01-20 00:00:00 | 17486 | Banked | 400
2025-01-20 00:00:00 | 17487 | Fees | 40 |  |  | 2025-01-20 00:00:00 | 17487 | Banked | 40
2025-01-20 00:00:00 | 17488 | Fees | 200 |  |  | 2025-01-20 00:00:00 | 17488 | Banked | 200
2025-01-20 00:00:00 | 17489 | Bus Fares | 91 |  |  | 2025-01-20 00:00:00 | 17489 | Banked | 91
2025-01-20 00:00:00 | 17490 | Fees | 200 |  |  | 2025-01-20 00:00:00 | 17490 | Banked | 200
2025-01-20 00:00:00 | 17491 | Fees | 100 |  |  | 2025-01-20 00:00:00 | 17491 | Banked | 100
2025-01-20 00:00:00 | 17492 | Fees | 150 |  |  | 2025-01-20 00:00:00 | 17492 | Banked | 150
2025-01-21 00:00:00 | 17493 | Fees | 100 |  |  | 2025-01-21 00:00:00 | 17493 | Banked | 100
2025-01-21 00:00:00 | 17494 | Bus Fares | 62 |  |  | 2025-01-21 00:00:00 | 17494 | Banked | 62
2025-01-21 00:00:00 | 17495 | Fees | 200 |  |  | 2025-01-21 00:00:00 | 17495 | Banked | 200
2025-01-22 00:00:00 | 17496 | Bus Fares | 59 |  |  | 2025-01-22 00:00:00 | 17496 | Banked | 59
2025-01-23 00:00:00 | 17497 | Fees | 100 |  |  | 2025-01-23 00:00:00 | 17497 | Banked | 100
2025-01-23 00:00:00 | 17498 | Bus Fares | 43 |  |  | 2025-01-23 00:00:00 | 17498 | Banked | 43
2025-01-24 00:00:00 | 17499 | Collegiate projects | 40 |  |  | 2025-01-24 00:00:00 | 17499 | Banked | 40
2025-01-24 00:00:00 | 17500 | Bus Fares | 6 |  |  | 2025-01-24 00:00:00 | 17500 | Banked | 6
2025-01-27 00:00:00 | 17501 | Fees | 100 |  |  | 2025-01-27 00:00:00 | 17501 | Banked | 100
2025-01-27 00:00:00 | 17502 | Fees | 50 |  |  | 2025-01-27 00:00:00 | 17502 | Banked | 50
2025-01-27 00:00:00 | 17503 | Fees | 100 |  |  | 2025-01-27 00:00:00 | 17503 | Banked | 100
2025-01-27 00:00:00 | 17504 | Fees | 30 |  |  | 2025-01-27 00:00:00 | 17504 | Banked | 30
2025-01-27 00:00:00 | 17505 | Bus Fares | 53 |  |  | 2025-01-27 00:00:00 | 17505 | Banked | 53
2025-01-28 00:00:00 | 17506 | Bus Fares | 45 |  |  | 2025-01-28 00:00:00 | 17506 | Banked | 45
2025-01-28 00:00:00 | 17507 | Fees | 100 |  |  | 2025-01-28 00:00:00 | 17507 | Banked | 100
2025-01-28 00:00:00 | 17508 | Fees | 100 |  |  | 2025-01-28 00:00:00 | 17508 | Banked | 100
2025-01-28 00:00:00 | 17509 | Fees | 100 |  |  | 2025-01-28 00:00:00 | 17509 | Banked | 100
2025-01-28 00:00:00 | 17510 | Deposit | 78 |  |  | 2025-01-28 00:00:00 | 17510 | Banked | 78
2025-01-28 00:00:00 | 17511 | Deposit | 248 |  |  | 2025-01-28 00:00:00 | 17511 | Banked | 248
2025-01-29 00:00:00 | 17512 | Bus Fares | 116 |  |  | 2025-01-29 00:00:00 | 17512 | Banked | 116
2025-01-30 00:00:00 | 17513 | Fees | 50 |  |  | 2025-01-30 00:00:00 | 17513 | Banked | 50
2025-01-30 00:00:00 | 17514 | Fees | 100 |  |  | 2025-01-30 00:00:00 | 17514 | Banked | 100
2025-01-30 00:00:00 | 17515 | Fees | 100 |  |  | 2025-01-30 00:00:00 | 17515 | Banked | 100
2025-01-30 00:00:00 | 17516 | Fees | 60 |  |  | 2025-01-30 00:00:00 | 17516 | Banked | 60
2025-01-30 00:00:00 | 17517 | Fees | 200 |  |  | 2025-01-30 00:00:00 | 17517 | Banked | 200
2025-01-30 00:00:00 | 17518 | Deposit | 7 |  |  | 2025-01-30 00:00:00 | 17518 | Banked | 7
2025-01-31 00:00:00 | 17519 | Fees | 100 |  |  | 2025-02-02 00:00:00 | 17519 | Banked | 100
2025-01-31 00:00:00 | 17520 | Fees | 100 |  |  | 2025-02-02 00:00:00 | 17520 | Banked | 100
2025-01-31 00:00:00 | 17521 | Bus Fares | 67 |  |  | 2025-02-02 00:00:00 | 17521 | Banked | 67
2025-02-02 00:00:00 | 17522 | Fees | 200 |  |  | 2025-02-02 00:00:00 | 17523 | Fees | 78
2025-02-02 00:00:00 | 17523 | Fees | 78 |  |  | 2025-02-02 00:00:00 | 17524 | Bus Fares | 100
2025-02-02 00:00:00 | 17524 | Bus Fares | 100 |  |  | 2025-02-02 00:00:00 | 17525 | Fees | 74
2025-02-02 00:00:00 | 17525 | Fees | 74