Accounting and tax question in Real Estate
aandc3
Excelbasedtrialbalancefor_40.xlsxtb1
| Trial Balance | ||||
| Retail LLC | ||||
| Account | Description | Debit | Credit | |
| 1010-000 | CASH IN BANK | 157,358.50 | ||
| 1012-000 | PRIMARY CASH ACCOUNT | 8,208.02 | ||
| 1029-000 | OTHER RESERVES/ESCROWS | 49,299.78 | ||
| 1105-000 | A/R - OTHER | 140,794.92 | ||
| 1110-000 | RENTAL INCOME RECEIVABLE | 249,046.99 | ||
| 1170-000 | INTERCOMPANY RECEIVABLE | 1,217,273.64 | ||
| 1405-000 | LAND | 5,379,727.00 | ||
| 1406-000 | UNIMPROVED LAND | 7,515,474.00 | ||
| 1500-000 | BUILDING COSTS | 10,276,612.00 | ||
| 1520-000 | TENANT IMPROVEMENTS | 926,857.00 | ||
| 1530-000 | FURNITURE & EQUIPMENT | 139,237.00 | ||
| 1570-002 | SOFT COSTS-LEGAL | 9,100.25 | ||
| 1570-006 | SOFT COST-COMMISSIONS | 36,614.75 | ||
| 1591-000 | BUILDING – ACCUM DEPREC | 2,280,649.76 | ||
| 1630-000 | PREPAID CAP LOAN COSTS | 65,635.00 | ||
| 1690-000 | ACCUM AMORT-PPD LOAN COST | 26,254.02 | ||
| 1810-000 | PREPAIDS | 5,468.74 | ||
| 1812-000 | INSURANCE-PPD | 4,994.66 | ||
| 2020-000 | ACCOUNTS PAYABLE ACCRUAL | 22,421.67 | ||
| 2050-001 | RETAIL SECURITY DEPOSITS | 85,152.85 | ||
| 2060-000 | RENT RECVD IN ADVANCE | 53,336.76 | ||
| 2200-000 | MORTGAGES PAYABLE | 15,760,000.00 | ||
| 2225-000 | PAYMENTS-PERM 1ST | 646,237.42 | ||
| 3100-000 | DISTRIBUTIONS | 3,137,794.90 | ||
| 3300-000 | PARTNER'S CAPITAL | 7,852,091.91 | ||
| 3920-000 | INCOME/LOSS-CURRENT YEAR | 1,862,299.75 | ||
| 4110-000 | TENANT RENTS | 2,150,656.19 | ||
| 4130-000 | PERCENTAGE RENTS | 10,086.07 | ||
| 4220-000 | PROP TAX RECOVERIES | 219,348.96 | ||
| 4225-000 | PRIOR YR. PROP TAX RECOV | 6,259.10 | ||
| 4230-000 | INSURANCE RECOVERIES | 10,777.92 | ||
| 4235-000 | PRIOR YR. INSUR. RECOV. | 1,172.23 | ||
| 4240-000 | CAM REVENUE CHARGES | 164,511.09 | ||
| 4245-000 | PRIOR YR. CAM ADJUSTMENT | 13,117.48 | ||
| 4250-000 | UTILITIES RECOVERIES | 27,609.17 | ||
| 4253-000 | GAIN ON SALE OF LAND | 19,516.98 | ||
| 4900-000 | OTHER REVENUES | 26.28 | ||
| 5110-000 | ELECTRIC | 14,324.39 | ||
| 5130-000 | WATER AND SEWER | 0.00 | ||
| 5135-000 | WATER IRRIGATION | 2,166.00 | ||
| 5136-000 | STORM WATER | 14,808.46 | ||
| 5495-000 | REIMB-HVAC | 538.00 | ||
| 5500-000 | REPAIRS AND MAINTENANCE | 22,481.19 | ||
| 5510-000 | ROOF REPAIRS | 397.59 | ||
| 5525-000 | ELECTRICAL SUPPLIES | 4,175.45 | ||
| 5530-000 | PLUMBING REPAIRS | 5,509.94 | ||
| 5570-000 | FIRE AND SAFETY | 6,983.30 | ||
| 5580-000 | PAINTING | 4,850.00 | ||
| 5590-000 | REPAIR AND MAINT-OTHER | 835.00 | ||
| 5620-000 | PEST CONTROL | 723.00 | ||
| 5640-000 | CONTRACT SERV-LANDSCAPE | 37,777.85 | ||
| 5670-000 | SNOW REMOVAL | 1,902.50 | ||
| 5680-000 | SIGNAGE | 889.28 | ||
| 5710-000 | CONTRACT SERV - SECURITY | 19,595.00 | ||
| 5830-000 | ONSITE WAGES & BENEFITS | 31,212.00 | ||
| 5900-000 | PROPERTY TAXES | 215,205.65 | ||
| 6010-000 | PROPERTY INSURANCE | 5,387.92 | ||
| 6090-000 | INSURANCE-OTHER | 7,037.49 | ||
| 6300-000 | PARKING EXPENSE | 15,996.00 | ||
| 7113-000 | WATER & SEWER- N/R | 40,881.98 | ||
| 7114-000 | WASTE REMOVAL-N/R | 1,443.00 | ||
| 7140-000 | BLDG REPAIRS & MAINT-N/R | 28,095.51 | ||
| 7210-000 | ACCOUNTING FEES | 4,240.46 | ||
| 7270-000 | PROFESSIONAL FEES-OTHER | 1,120.73 | ||
| 7280-000 | MARKETING & ADVERTISING | 7,184.04 | ||
| 7410-000 | OWNERSHIP EXPENSE | 27,115.20 | ||
| 7425-000 | MANAGEMENT FEE N/R | 66,028.42 | ||
| 7426-000 | BANK FEES - N/R | 680.20 | ||
| 8300-000 | INTEREST EXPENSE | 691,291.13 | ||
| 8400-000 | DEPRECIATION & AMORT. | 571,130.16 | ||
| Total: | 31,191,514.80 | 31,191,514.80 |
