Spreadsheet: 856594d1705785586-need-help-with-providing-a-total-for-current-month-now-and-specific-yr-excluding-items-deposits-m-and-yr-issue-1-20-24
Sheet: Sheet1

INTERNAL (BNK) TRANSFERS : |  | OTHER DEPOSITS OR INCOME                  YEAR- |  |  | 2024-01-01 00:00:00 |  |  |  |  | The figures below are used in the "Yearly Budget" & "Monthly Budget" tabs for accuracy regarding actual deposits to the checking account . Not including account transfers - because money in all accounts are filled from any deposits to the main checking account!  Including them would amount to duplicating deposits! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCOUNT's
SALE OF PERSONAL ITEMS : |  | Choose Month Below |  | (Transfers Not Included)                             YEAR TO DATE DEPOSITS  ----> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WITHDRAWS :
LOAN DEPOSITS : |  |  |  | MONTHLY AVERAGE  ----> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMAINING BAL :
REFUNDS INCLUDEING TAXES : |  |  |  | (Transfers Not Included)                     CURRENT MONTH  DEPOSITS ----> |  |  |  |  | M |  | <<--- Adds all deposits except for any TRANSFERS for the Current Month. |  |  |  |  |  |  |  |  |  |  |  |  | REC # | DEP-DT | 00-00 | 02-02 | 03-03 | 17-500 | 18-501 | 19-502 | 20-503 | 2400
SOCIAL SECURITY DEPOSITS : |  | 2023-12-01 00:00:00 | <---------------Total Deposited to Checking  Acct During Selected Month----------------> |  |  |  |  |  | Y |  | <<--- Adds all deposits except for any TRANSFERS for the Current Year. |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
RETIREMENT FUND DEPOSITS : |  | DATE | DEPOSIT TYPE | Decription | AMOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-01-02 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 200 |  | DEPOSIT TYPES |  |  |  |  |  |  |  |  |  |  | DATE |  | AMOUNT |  | YEARS |  | 3 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-01-05 00:00:00 | TRANSFER IN | FROM 500 Acct-17   Car Insurance Acct | 130 |  | SELECT |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  |  | 2022-01-01 00:00:00 |  | 4 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-01-05 00:00:00 | TRANSFER IN | FROM Acct-00           Main Savings Act | 53.6 |  | TRANSFER OUT |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  |  | 2023-01-01 00:00:00 |  | 5 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-01-05 00:00:00 | TRANSFER IN | FROM 503 Acct-20   State & Local Tax Acct | 55 |  | TRANSFER IN |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 |  |  |  | 2024-01-01 00:00:00 |  | 6 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-01-10 00:00:00 | TRANSFER IN | FROM 500 Acct-17   Car Insurance Acct | 300 |  | INS.  CHECK |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00 |  |  |  | 2025-01-01 00:00:00 |  | 7 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-02-02 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 100 |  | EXTRA INCOME |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00 |  |  |  | 2026-01-01 00:00:00 |  | 8 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-02-04 00:00:00 | TRANSFER IN | FROM 500 Acct-17   Car Insurance Acct | 100 |  | FUND W/D |  |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 |  |  |  | 2027-01-01 00:00:00 |  | 9 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-02-04 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 100 |  | REFUND |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00 |  |  |  | 2028-01-01 00:00:00 |  | 10 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-02-06 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 50 |  | PERSONAL SALES |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00 |  |  |  | 2029-01-01 00:00:00 |  | 11 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-02-28 00:00:00 | TAX REFUND | Tax Refund 2022 (Fed) | 10437 |  | LOAN |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00 |  |  |  | 2030-01-01 00:00:00 |  | 12 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-06 00:00:00 | REFUND | APG  Refund for check order shiping charge | 15.89 |  | TAX REFUND |  |  |  |  |  |  |  |  |  |  | 2023-10-01 00:00:00 |  |  |  | 2031-01-01 00:00:00 |  | 13 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-07 00:00:00 | REFUND | Barrington Diesel SUbscription | 55 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | 2032-01-01 00:00:00 |  | 14 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-07 00:00:00 | REFUND | Technical Information Subscription | 65 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00 |  |  |  | 2033-01-01 00:00:00 |  | 15 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-07 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 1000 |  |  |  |  |  |  |  |  |  |  |  |  | SELECT |  |  |  | 2034-01-01 00:00:00 |  | 16 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-07 00:00:00 | REFUND | From UMBC Office Visit Over Charges | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2035-01-01 00:00:00 |  | 17 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-11 00:00:00 | TAX REFUND | Tax Refund 2022 (PA State) | 103 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2036-01-01 00:00:00 |  | 18 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-11 00:00:00 | REFUND | Staples (For ink return) | 132.46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2037-01-01 00:00:00 |  | 19 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-15 00:00:00 | REFUND | Returned a 12" Sawblade for Tablesaw (purchased the wrong size) | 79.47 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2038-01-01 00:00:00 |  | 20 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-19 00:00:00 | REFUND | Tractor Supply  (Shipping Cost) | 3.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2039-01-01 00:00:00 |  | 21 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-24 00:00:00 | REFUND | APG  Checking Account Refund for fraudulent charges | 756.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2040-01-01 00:00:00 |  | 22 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-27 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2041-01-01 00:00:00 |  | 23 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-27 00:00:00 | TRANSFER IN | FROM 500 Acct-17   Car Insurance Acct | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2042-01-01 00:00:00 |  | 24 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-03-27 00:00:00 | TRANSFER IN | FROM 503 Acct-20   State & Local Tax Acct | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2043-01-01 00:00:00 |  | 25 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-04-04 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2044-01-01 00:00:00 |  | 26 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-04-10 00:00:00 | TRANSFER IN | FROM Acct-00           Main Savings Act | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2045-01-01 00:00:00 |  | 27 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-04-25 00:00:00 | REFUND | Boscov's  ([NAME])  was part of total bill $57.19 | 24.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2046-01-01 00:00:00 |  | 28 |  | 53.6 |  |  | 130 | 40 | 77.13 | 55 | 120.78
 |  | 2023-05-01 00:00:00 | REFUND | Handyman Magazine Cancellation Balance | 3.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2047-01-01 00:00:00 |  | 29
 |  | 2023-05-03 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2048-01-01 00:00:00 |  | 30
 |  | 2023-05-04 00:00:00 | REFUND | NOOM Trial | 4.59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2049-01-01 00:00:00 |  | 31
 |  | 2023-05-05 00:00:00 | REFUND | Walgreens | 15.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2050-01-01 00:00:00 |  | 32
 |  | 2023-06-06 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  | 2023-06-08 00:00:00 | TFR FROM Acct-17 | FROM 500 Acct-17   Car Insurance Acct | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  | 2023-06-02 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  | 2023-06-16 00:00:00 | REFUND | Returned 2 Bra's to Boscov's | 46.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  | 2023-06-23 00:00:00 | EXTRA INCOME | 1st Check for Atlantic Tractor | 522.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  | 2023-07-09 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  | 2023-07-21 00:00:00 | REFUND | Home Depot  (for night light cover plate) | 23.26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  | 2023-06-30 00:00:00 | EXTRA INCOME | Atlantic Tractor Pay Check | 1086.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  | 2023-06-16 00:00:00 | EXTRA INCOME | Atlantic Tractor Pay Check | 522.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  | 2023-08-08 00:00:00 | REFUND | Refund from Ink Inc. For returned ink cartridges | 46.87 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  | 2023-08-02 00:00:00 | INS.  CHECK | Claim # 054019406-01 | 7470.63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  | 2023-08-16 00:00:00 | TRANSFER IN | FROM 501 Acct-18   (to cover insurance item replacements)   Tax Saving Acct | 371.38 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  | 2023-08-17 00:00:00 | TRANSFER IN | FROM 501 Acct-18(to cover insurance item replacements)   Tax Saving Acct | 182.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  | 2023-08-10 00:00:00 | TRANSFER IN | FROM 501 Acct-18(to cover insurance item replacements)   Tax Saving Acct | 173.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  | 2023-08-11 00:00:00 | TRANSFER IN | FROM 501 Acct-18(to cover insurance item replacements)   Tax Saving Acct | 85.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  | 2023-08-24 00:00:00 | REFUND | Home Depot  (for one box of [NAME]) | 79.11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
 |  | 2023-08-30 00:00:00 | TRANSFER IN | FROM 501 Acct-18   Tax Saving Acct | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  | 2023-08-30 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  | 2023-08-30 00:00:00 | INS.  CHECK | Claim # 054019406-01 | 261.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  | 2023-08-24 00:00:00 | INS.  CHECK | Claim # 054019406-01 | 743.86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  | 2023-08-24 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
 |  | 2023-08-24 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  | 2023-09-06 00:00:00 | INS.  CHECK | Claim # 054019406-01 | 456.96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  | 2023-09-07 00:00:00 | REFUND | Amazon Speaker Cable #1  (2) that were supposed to be 50' but were 25' | 36.02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
 |  | 2023-09-11 00:00:00 | REFUND | Returned Wrong Tool  Should have been a 11/16" | 14.79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  | 2023-09-19 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
 |  | 2023-10-06 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  | 2023-10-08 00:00:00 | REFUND | Amazon  Missing Wheels Shippment | 13.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  | 2023-10-29 00:00:00 | TRANSFER IN | FROM Acct-00           Main Savings Act | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  | 2023-10-29 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
 |  | 2023-11-06 00:00:00 | TRANSFER IN | State & Local Tax Acct | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  | 2023-12-03 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
 |  | 2023-12-03 00:00:00 | TRANSFER IN | Car Insurance Acct | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  | 2023-12-04 00:00:00 | REFUND | From [NAME] (Account Closed) | 241.68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  | 2023-12-07 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  | 2023-12-12 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  | 2023-12-15 00:00:00 | REFUND | Was for returned dog bed | 19.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  | 2023-12-19 00:00:00 | TRANSFER IN | FROM 502 Acct-19   New Car Acct | 169 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  | 2023-12-08 00:00:00 | TRANSFER IN | FROM 500 Acct-17   Car Insurance Acct | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  | 2023-12-20 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
 |  | 2023-12-26 00:00:00 | TRANSFER IN | FROM Acct-00           Main Savings Act | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
 |  | 2024-01-01 00:00:00 | EXTRA INCOME | ***  All available funds all accounts beginning 2024  *** | 9205.23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  | 2024-01-05 00:00:00 | TRANSFER IN | FROM Acct-2400      #2 Savings  Acct (00) | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  | 2024-01-02 00:00:00 | REFUND | Pay back for items [NAME] took to Aging | 12.85 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  | 2023-12-30 00:00:00 | TRANSFER IN | FROM 503 Acct-20      State & Local Tax Acct | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  | 2023-12-30 00:00:00 | TRANSFER IN | FROM 503 Acct-20      State & Local Tax Acct | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  | 2024-01-07 00:00:00 | TRANSFER IN | FROM 503 Acct-20      State & Local Tax Acct | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  | 2024-01-09 00:00:00 | REFUND | Simply Good Stuff (Can Openner) | 26.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80