Spreadsheet: 858058d1706833009-stop-excel-from-auto-resize-row-height-rows-with-different-heights-down-the-worksheet-test
Sheet: Test

Company Name:
Report Name: | General Ledger Report
Reporting Book: | CASH
Other books: | TAX
Include reporting book: | Yes
Start Date:
End Date:
Location:
Posted Dt. | [NAME]. | Doc | Memo / Description | JNL | Debit | Credit | Balance | PD Rcls | VT Rcls
41040 - Appliances (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67345 | AP Pymt - HD Supply Facilities Maintenan: U-17-102 Ge&reg; Black Plastic Interior Smart Dishwasher | APC | 482.1 |  | 482.1 | this is a Revenue account - NOT exp | 14415
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67560 | AP Pymt - HD Supply Facilities Maintenan: U-30-311 Ge&reg; Black Plastic Interior Smart Dishwasher | APC | 482.1 |  | 964.2
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67762 | AP Pymt - HD Supply Facilities Maintenan: U-20-103 GE Stainless Int Smrt Dishwashr | APC | 542.29 |  | 1506.49
Totals for 41040 - Appliances
53100 - Carpet (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-04 00:00:00 | 2024-01-04 00:00:00 | 81205450017444 | AP Pymt - National Apartment Flooring: U-13-201 3/8" REBOND 6LB | APC | 104.5 |  | 104.5
2024-01-04 00:00:00 | 2024-01-04 00:00:00 | 81205450017444 | AP Pymt - National Apartment Flooring: U-13-201 ECO SELECTION II | APC | 702 |  | 806.5
2024-01-04 00:00:00 | 2024-01-04 00:00:00 | 81205450017444 | AP Pymt - National Apartment Flooring: U-13-201 CA Crpt Stewardship Assessment | APC | 29 |  | 835.5
Totals for 53100 - Carpet |  |  |  |  | 835.5 | 0 | 835.5
53300 - Cleaning (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-27-111 EXTRA CLEAN | APC | 85 |  | 85
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-27-111 vacant unit 27-111 2x2 complete cleaning | APC | 225 |  | 310
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-27-312 vacant unit 27-312 1x1 complete clean | APC | 195 |  | 505
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-28-106 2X2 COMPLETE CLEAN (Including Floors & Refrigerator) | APC | 225 |  | 730
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-30-112 vacant unit 30-112 1x1 complete cleaning | APC | 195 |  | 925
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67186 | AP Pymt - Custom & Professional Services: U-13-201 vacant unit 13-201 2x2 complete cleaning | APC | 225 |  | 1150
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67324 | AP Pymt - Custom & Professional Services: U-30-208 vacant unit 30-208 1x1 complete cleaning | APC | 195 |  | 1345
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67324 | AP Pymt - Custom & Professional Services: U-26-310 vacant unit 26-310 1x1 complete cleaning | APC | 195 |  | 1540
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67392 | AP Pymt - Western General Painting, Inc.: U-29-102 APT#29-102 1X1 COMPLETE CLEAN & BLINDS | APC | 90 |  | 1630
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67392 | AP Pymt - Western General Painting, Inc.: U-29-102 CLEAN FLOORS IN LIVING+DINING ROOM | APC | 50 |  | 1680
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67392 | AP Pymt - Western General Painting, Inc.: U-29-102 CLEAN WASHER AND DRYER | APC | 20 |  | 1700
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67392 | AP Pymt - Western General Painting, Inc.: U-29-102 CLEAN REFRIGERATOR | APC | 25 |  | 1725
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67457 | AP Pymt - Custom & Professional Services: U-08-203 2X2 COMPLETE CLEAN (Including Floors & Refrigerator) | APC | 225 |  | 1950
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67457 | AP Pymt - Custom & Professional Services: U-08-203 EXTRA CLEAN | APC | 75 |  | 2025
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67457 | AP Pymt - Custom & Professional Services: U-17-102 EXTRA CLEAN | APC | 75 |  | 2100
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67457 | AP Pymt - Custom & Professional Services: U-17-102 PREP. CAULK & PAINT (2) COATS NEW BASEBOARDS | APC | 175 |  | 2275 | 53600
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67457 | AP Pymt - Custom & Professional Services: U-28-210 vacant unit 28-210 1x1 complete cleaning | APC | 195 |  | 2470
2024-01-24 00:00:00 | 2024-01-24 00:00:00 | 67605 | AP Pymt - Custom & Professional Services: vacant casita guest suite 1x1 #32462 , complete cleaning | APC | 181.35 |  | 2651.35 | guest unit? | if yes, 41050?
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67746 | AP Pymt - Custom & Professional Services: U-12-203 1X1 COMPLETE CLEAN | APC | 195 |  | 2846.35
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67746 | AP Pymt - Custom & Professional Services: U-07-104 vacant unit 7-104 1x1 complete cleaning | APC | 195 |  | 3041.35
Totals for 53300 - Cleaning |  |  |  |  | 3041.35 | 0 | 3041.35
53400 - Carpet Cleaning (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-15-103 APT. # 15-103 STEAM CLEAN TWO ROOMS ONLY | APC | 85 |  | 85
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-15-103 DEODORIZE CARPET | APC | 35 |  | 120
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-26-201 CARPET SCRUBBER | APC | 45 |  | 165
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-26-201 STEAM CLEAN ONE ROOM | APC | 65 |  | 230
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-29-111 vacant unit 29-111 2x2 , re clean carpet , due to bad odor on carpet | APC | 85 |  | 315
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-31-110 vacant unit 31-110 1x1 regular carpet cleaningAPT. # 31-110 STEAM CLEAN ONE ROOM | APC | 65 |  | 380
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67264 | AP Pymt - Western General Painting, Inc.: U-20-203 vacant unit 20-203 1x1 carpet cleaning | APC | 65 |  | 445
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67392 | AP Pymt - Western General Painting, Inc.: U-22-101 vacant unit 22-101 1x1 carpet cleaning | APC | 65 |  | 510
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-13-201 APT#13-201 1BED ONLY STEAM CLEAN CARPET | APC | 65 |  | 575
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-26-310 APT#26-310 1BEDROOM STEAM CLEAN CARPET | APC | 65 |  | 640
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-27-111 vacant unit 27-111 2x2 carpet cleaning | APC | 85 |  | 725
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-27-312 CARPET SCRUBBER | APC | 35 |  | 760
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-29-102 APT#29-102 1BEDROOM STEAM CLEAN CARPET | APC | 65 |  | 825
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-29-102 CARPET SCRUBBER | APC | 35 |  | 860
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-30-112 APT#30-112 1BED ONLY STEAM CLEAN CARPET | APC | 65 |  | 925
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-30-208 APT#30-208 1BEDROOM STEAM CLEAN CARPET | APC | 65 |  | 990
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-30-208 CARPET SCRUBBER | APC | 35 |  | 1025
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67557 | AP Pymt - Western General Painting, Inc.: U-27-312 vacant unit 27-312 1x1 carpet cleaning | APC | 65 |  | 1090
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67824 | AP Pymt - Western General Painting, Inc.: U-07-104 APT. # 7-104 STEAM CLEAN ONE ROOM | APC | 65 |  | 1155
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67824 | AP Pymt - Western General Painting, Inc.: U-08-203 CARPET SCRUBBER | APC | 45 |  | 1200
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67824 | AP Pymt - Western General Painting, Inc.: U-08-203 vacant unit 8-203 2x2 carpet cleaning | APC | 85 |  | 1285
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67824 | AP Pymt - Western General Painting, Inc.: U-28-210 vacant unit 28-210 1x1 carpet cleaning | APC | 65 |  | 1350
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67824 | AP Pymt - Western General Painting, Inc.: U-15-103 APT. # 15-103 STEAM CLEAN ONE ROOM | APC | 65 |  | 1415
Totals for 53400 - Carpet Cleaning |  |  |  |  | 1415 | 0 | 1415
54250 - Windows & Screens (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-18 00:00:00 | 2024-01-18 00:00:00 | 81205450017593 | AP Pymt - Robles Glass & Supplies, Inc.: Material Box of blinds Size: 82.5 | APC | 145.05 |  | 1021.41
2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 81205450017513 | AP Pymt - Robles Glass & Supplies, Inc.: Material U-Channel | APC | 12.93 |  | 12.93
2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 81205450017513 | AP Pymt - Robles Glass & Supplies, Inc.: Mirror New vanity mirror [NAME]: 36 X 36 | APC | 168.63 |  | 181.56
2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 81205450017513 | AP Pymt - Robles Glass & Supplies, Inc.: U-08-102 Material Horizontal Blinds | APC | 74.99 |  | 876.36 | occupied | 51500?
2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 81205450017513 | AP Pymt - Robles Glass & Supplies, Inc.: U-08-102 occupied unit 8-102 (2) horizontal blinds , purchase and replaced | APC | 61.59 |  | 243.15
2024-01-11 00:00:00 | 2024-01-11 00:00:00 | 81205450017513 | AP Pymt - Robles Glass & Supplies, Inc.: U-17-102 Material | APC | 558.22 |  | 801.37
Totals for 54250 - Windows & Screens |  |  |  |  | 1021.41 | 0 | 1021.41
54300 - Appliance Parts & Repairs (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67341 | AP Pymt - GE Appliances - Haier US Appli: U-28-106 DRYER CORD 4' 30 AMP 3 WIRE | APC | 12.93 |  | 12.93 | code w/appliance | 14415
2024-01-17 00:00:00 | 2024-01-17 00:00:00 | 67560 | AP Pymt - HD Supply Facilities Maintenan: U-15-204 Ge&reg; Hotpoint 1.6 Cu. Ft. Over-The-Range Microwave (Black) | APC | 273.69 |  | 286.62 |  | 14415
2024-01-24 00:00:00 | 2024-01-24 00:00:00 | 67690 | AP Pymt - HD Supply Facilities Maintenan: U-31-205 Ge&reg; 3.8 Cu.ft. Top Load Washing Machine, 120 Volt, White | APC | 566.61 |  | 853.23 |  | 14415
2024-01-24 00:00:00 | 2024-01-19 00:00:00 | 69300503 | AP Invoice - HD Supply Facilities Maintenan: U-31-205 Ge&reg; 3.8 Cu.ft. Top Load Washing Machine, 120 Volt, White | APC | 12.55 |  | 865.78 |  | 14415
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67738 | AP Pymt - Coast Appliance Parts Co.: UPPER RACK | APC | 177.94 |  | 1043.72
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67738 | AP Pymt - Coast Appliance Parts Co.: COMPLETE SERVICE RACK | APC | 222.85 |  | 1266.57
Totals for 54300 - Appliance Parts & Repairs |  |  |  |  | 1266.57 | 0 | 1266.57
54360 - Fences & Gates (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67207 | AP Pymt - JEM UNLIMITED IRON, INC: 30 FEET CHAIN | APC | 186 |  | 186
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67207 | AP Pymt - JEM UNLIMITED IRON, INC: WE REPLACED THE BROKEN AND RUSTED CHAIN , AROUND 30 FEET OF CHAIN. THE EXISTING TRACK IS ROTTING/RUSTED AND HAS MANY HOLES/CRACKS IN IT. WE HIGHLY RECOMMEND TO REPLACE THE TRACK. PLEASE LET US KNOW IF YOU GUYS WANT US TO SEND A QUOTE FOR A NEW TRACK. | APC | 460.35 |  | 646.35
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67207 | AP Pymt - JEM UNLIMITED IRON, INC: THE TECHNICIAN CHECKED THE POWER CONNECTION, PHOTO BEAM AND THE LOOP DETECTORS TO VERIFIED IF THE SENSOR WAS BROKEN, HE CHECKED THE RECEIVER AND FOUND ONE PART WAS BROKEN, HE SOLDER THE ANTENNA WIRE AND MAKE IT LONGER. HE TESTED EVERYTHING TO VERIFIED THAT | APC | 355 |  | 1001.35
2024-01-25 00:00:00 | 2024-01-25 00:00:00 | 81205450017642 | AP Pymt - Floyd Community Controls: Community Controls Slim Controlled Access Key Fob - Blue - HID or [NAME] CARFOBSLIM-BLU-BLANK | APC | 85.98 |  | 1087.33 | x | 53700
2024-01-25 00:00:00 | 2024-01-25 00:00:00 | 81205450017642 | AP Pymt - Floyd Community Controls: Programming and laser etching PROSURLAS | APC | 26.88 |  | 1114.21 |  | 53700
2024-01-25 00:00:00 | 2024-01-25 00:00:00 | 81205450017642 | AP Pymt - Floyd Community Controls: Shipping | APC | 18.14 |  | 1132.35 |  | 53700
Totals for 54360 - Fences & Gates |  |  |  |  | 1132.35 | 0 | 1132.35
54375 - Sidewalks / Curbs / Pavement (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67183 | AP Pymt - Cornerstone Landscape Care: U-COMMON Sandbags Per 121-602, sandbags will be installed in the catch basins and drains at buildings 18 & 31 | APC | 280 |  | 280
Totals for 54375 - Sidewalks / Curbs / Pavement |  |  |  |  | 280 | 0 | 280
54425 - Pools / Spas / Water Features (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67180 | AP Pymt - Clear Expectations, Inc.: Monthly Service per Contract for 2 Pools and 2 Spas 3X Summer (May-Sep) 2X Winter (Oct-Apr) | APC | 976.5 |  | 976.5
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67317 | AP Pymt - Clear Expectations, Inc.: MuriaticAcid per gallon | APC | 13.76 |  | 990.26
2024-01-10 00:00:00 | 2024-01-10 00:00:00 | 67317 | AP Pymt - Clear Expectations, Inc.: Liquid Chlorine per gallon | APC | 92.43 |  | 1082.69
Totals for 54425 - Pools / Spas / Water Features |  |  |  |  | 1082.69 | 0 | 1082.69
54450 - Irrigation Repairs (Balance Forward As of 01/01/24) |  |  |  |  |  |  | 0
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67183 | AP Pymt - Cornerstone Landscape Care: building #30 near parking lot , replaced 2 1/2" mainline from sprinkler water line | APC | 525 |  | 525
2024-01-03 00:00:00 | 2024-01-03 00:00:00 | 67183 | AP Pymt - Cornerstone Landscape Care: front building 18 and building 30 repaired 1" lateral sprinkler water lines , parts and labor | APC | 225 |  | 750
2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 67742 | AP Pymt - Cornerstone Landscape Care: Tree removal + stump grind | APC | 1200 |  | 1950 | x | 54400?
Totals for 54450 - Irrigation Repairs |  |  |  |  | 1950 | 0 | 1950