Spreadsheet: 151759d1335109415-need-excel-automation-and-accounting-help-please-copy-of-workbook1
Sheet: TASK 1

Accrual | Year to Date Balances for period 12/11
 |  |  |  |  | [1] Calculate the net cash at this property if you sold it today.
 |  |  |  |  | 2) I need to create a formula that you can use for the next month.  Not all months will have the same accounts or rows for each account.  New accounts may be used or not used depending on their month end balances.
Account Description | Item | Debit | Credit | Total
1000-0000 | Cash - Operating | 5739047.51 | 0 |  |  |  | Sum of Total
1012-0000 | Cash - Tax and Insurance Reserve | 777014.33 | 0 |  |  |  | Item | Total
1071-0000 | Cash - Low DSCR Escrow | 0 | 0 |  |  |  | A/P - Accrued Expenses | -109729.78
1099-0000 | Petty Cash | 750 | 0 |  |  |  | A/P - Capital Expenditure | -302995.24
1101-0000 | A/R - Base Rents | 16512.32 | 0 |  |  |  | A/P - Miller Global Prop 08 | -1698.02
1104-0000 | A/R - Storage Rent | 912.28 | 0 |  |  |  | A/P - Mortgage Interest | -163127.89
1105-0000 | A/R - Other Rent | 0 | 0.24 |  |  |  | A/P - Operating Expenses | -165660
1110-0000 | A/R - Operating Exp Recov | 0 | 2505.18 |  |  |  | A/P - Real Estate Taxes | -500471.8
1112-0000 | A/R - REtax Recovery | 0 | 61352.82 |  |  |  | A/R - Base Rents | 16512.32
1116-0000 | A/R - Utility Recov | 31364.89 | 0 |  |  |  | A/R - MG Leasing III | 205471
1124-0000 | A/R - Misc Tenant Charges | 1 | 0 |  |  |  | A/R - Misc Tenant Charges | 1
1199-0000 | A/R - Property Misc | 10913.23 | 0 |  |  |  | A/R - Operating Exp Recov | -2505.18
1200-0274 | A/R - MG Leasing III | 205471 | 0 |  |  |  | A/R - Other Rent | -0.24
1310-0000 | Prepaid Taxes | 58102.67 | 0 |  |  |  | A/R - Property Misc | 10913.23
1320-0000 | Prepaid Insurance | 31436.7 | 0 |  |  |  | A/R - REtax Recovery | -61352.82
1399-0000 | Other Prepaids | 3770.26 | 0 |  |  |  | A/R - Storage Rent | 912.28
1400-0000 | Utility Deposit | 49791.2 | 0 |  |  |  | A/R - Utility Recov | 31364.89
1550-0000 | Office Equipment | 10548.6 | 0 |  |  |  | [NAME] Costs | -903104.5
1551-0000 | [NAME] Equip | 0 | 10116.97 |  |  |  | [NAME] | -456740.89
1650-0000 | Bldg Furn & Fixtures | 27730 | 0 |  |  |  | [NAME] | -101084.93
1650-9999 | Bldg Furn & Fixtures - CY Additions | 11816.65 | 0 |  |  |  | [NAME] Improv | -1038593.03
1651-0000 | [NAME] | 0 | 13361.38 |  |  |  | [NAME] Leases | -1187220
1700-0000 | Land | 19612500 | 0 |  |  |  | [NAME] | -13361.38
1750-0000 | Office Building | 114621025.33 | 0 |  |  |  | [NAME] Bldg | -11432149.27
1750-1000 | Office Building Projects in Progress | 180897.79 | 0 |  |  |  | [NAME] Equip | -10116.97
1750-9999 | Office Building - CY Additions | 78495.79 | 0 |  |  |  | Accrued Audit and Tax Fees | -10800
1751-0000 | [NAME] Bldg | 0 | 11432149.27 |  |  |  | Bldg Furn & Fixtures | 27730
1800-0000 | Lease Commissions | 2189500.09 | 0 |  |  |  | Bldg Furn & Fixtures - CY Additions | 11816.65
1800-9999 | Lease Commissions - CY Additions | 35872.24 | 0 |  |  |  | Cash - Low DSCR Escrow | 0
1801-0000 | [NAME] | 0 | 456740.89 |  |  |  | Cash - Operating | 5739047.51
1825-0000 | Other Lsg Considerations | 177163.07 | 0 |  |  |  | Cash - Tax and Insurance Reserve | 777014.33
1825-9999 | Other Lsg Consid - CY Additions | 608675.19 | 0 |  |  |  | Deferred Main Expenses | 361059.07
1826-0000 | [NAME] | 0 | 101084.93 |  |  |  | FAS141 Acquired Leases | 1453202
1830-0000 | FAS141 Acquired Leases | 1453202 | 0 |  |  |  | FASB13 Accrd Rents | 2125046.42
1831-0000 | [NAME] Leases | 0 | 1187220 |  |  |  | Financing Costs | 923739.71
1850-0000 | Tenant Improvements | 1949520.73 | 0 |  |  |  | Financing Costs - CY Additions | 6000
1850-1000 | Tenant Finish in Progress | 1324415.73 | 0 |  |  |  | Land | 19612500
1850-9999 | [NAME] Additions | 0 | 17916.39 |  |  |  | Lease Commissions | 2189500.09
1851-0000 | [NAME] Improv | 0 | 1038593.03 |  |  |  | Lease Commissions - CY Additions | 35872.24
1895-0000 | Financing Costs | 923739.71 | 0 |  |  |  | Office Building | 114621025.33
1895-9999 | Financing Costs - CY Additions | 6000 | 0 |  |  |  | Office Building - CY Additions | 78495.79
1896-0000 | [NAME] Costs | 0 | 903104.5 |  |  |  | Office Building Projects in Progress | 180897.79
1950-0000 | FASB13 Accrd Rents | 2125046.42 | 0 |  |  |  | Office Equipment | 10548.6
1970-0000 | Deferred Main Expenses | 361059.07 | 0 |  |  |  | Other Lsg Consid - CY Additions | 608675.19
2000-0000 | A/P - Operating Expenses | 0 | 165660 |  |  |  | Other Lsg Considerations | 177163.07
2050-0000 | A/P - Real Estate Taxes | 0 | 500471.8 |  |  |  | Other Prepaids | 3770.26
2060-0000 | A/P - Mortgage Interest | 0 | 163127.89 |  |  |  | Petty Cash | 750
2075-0000 | A/P - Capital Expenditure | 0 | 302995.24 |  |  |  | Prepaid Base Rent | -584693.88
2085-0000 | Accrued Audit and Tax Fees | 0 | 10800 |  |  |  | Prepaid Insurance | 31436.7
2099-0000 | A/P - Accrued Expenses | 0 | 109729.78 |  |  |  | Prepaid Oper Exp Recov | -26979.5
2100-0061 | A/P - Miller Global Prop 08 | 0 | 1698.02 |  |  |  | Prepaid Other Rent | -140715.93
2300-0000 | Tenant Security Deposits | 0 | 378636.95 |  |  |  | Prepaid Storage Rent | -600
2401-0000 | Prepaid Base Rent | 0 | 584693.88 |  |  |  | Prepaid Taxes | 58102.67
2404-0000 | Prepaid Storage Rent | 0 | 600 |  |  |  | Tenant Finish in Progress | 1324415.73
2405-0000 | Prepaid Other Rent | 0 | 140715.93 |  |  |  | Tenant Improvements | 1949520.73
2410-0000 | Prepaid Oper Exp Recov | 0 | 26979.5 |  |  |  | [NAME] Additions | -17916.39
 |  |  |  |  |  |  | Tenant Security Deposits | -378636.95
Database: ACCTGDAT | Trial Balance |  | Page:      2 |  |  |  | Utility Deposit | 49791.2
 | MGP Main DB |  | Date: 3/26/2012 |  |  |  | (blank)
 |  |  | Time: 05:11 PM |  |  |  | Grand Total | 135012041.21
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit | Credit
2700-0000 | Mortgage Payable | 0 | 93262125.02
2999-0270 | Inter-entity Miller Global Fund VI | 500000 | 0
3273-0270 | [NAME] VI (1333 H St.) | 0 | 48000000
3673-0270 | [NAME] (1333 H St.) | 5500000 | 0
3700-0270 | PY R/E - Miller Global Fund VI LLC | 0 | 847798.53
4001-0000 | Base Rent | 0 | 10380901.99
4002-0000 | FASB13 Rent | 0 | 736034.52
4002-0100 | FAS141 Acquired Leases | 209881 | 0
4004-0000 | Storage Rent | 0 | 27068.41
4005-0000 | Other Rent | 0 | 191629.4
4050-0000 | Percentage Rent | 0 | 205471
4110-0000 | Oper Exp Recov | 0 | 416153.15
4112-0000 | Retax Recov | 0 | 186878.9
4116-0000 | Utility Recov | 0 | 397116.32
4124-0000 | [NAME] Recov | 0 | 4641.42
4190-0000 | Late Fee Income | 0 | 3612.24
4490-0000 | Vending Income | 0 | 727.84
5000-0000 | Janitorial Contract | 299432.47 | 0
5005-0000 | Day Porter | 32475.91 | 0
5010-0000 | Special Cleaning | 1300.66 | 0
5030-0000 | Window Cleaning | 12789.36 | 0
5050-0000 | [NAME] | 7668.58 | 0
5125-0000 | Electrical Repairs | 8939.7 | 0
5150-0000 | Electrical Supplies | 3994.79 | 0
5170-0000 | Light Bulbs/Fixtures | 18566.18 | 0
5200-0000 | HVAC Contract | 9396.51 | 0
5210-0000 | HVAC Repair | 252737.34 | 0
5250-0000 | HVAC Supplies | 8988.84 | 0
5260-0000 | Water Treatment | 4737.48 | 0
5300-0000 | Elevator Contract | 62723.96 | 0
5310-0000 | Elevator Repair | 2953.84 | 0
5320-0000 | Musak/Network Video | 3547.2 | 0
5400-0000 | Plumbing Repairs | 6066.35 | 0
5450-0000 | Plumbing Supplies | 7894.78 | 0
5500-0000 | Painting - Common Areas | 1720.66 | 0
5600-0000 | General Building Repairs | 2596.52 | 0
5605-0000 | General Building Supplies | 179.48 | 0
5610-0000 | BLDG Repairs - Ins Reimb | 2733.21 | 0
5615-0000 | Building Services - Tenant Reimbursement | 0 | 99680
5620-0000 | Doors & Store Fronts | 2605.27 | 0
5640-0000 | Metal Maintenance | 11031.36 | 0
5650-0000 | Misc Hardware & SM Tools | 3936.25 | 0
5660-0000 | Locks & Keys | 3932.9 | 0
5680-0000 | Seasonal Decorations | 3140.11 | 0
5695-0000 | Roof & Structural Repairs | 1501.34 | 0
5700-0000 | Maintenance/Secur P/R | 228463.9 | 0
5725-0000 | WO Service Contract | 5345.04 | 0
5799-0000 | Uniforms | 1277.72 | 0
5800-0000 | Security Contract | 205737.43 | 0
5810-0000 | Fire Safety Contract | 1900 | 0
5820-0000 | Sec & Fire Safety Supp | 1697.3 | 0
5830-0000 | Sec & Fire Safety Repairs | 0 | 0
5850-0000 | Sec & Fire Safety Monitor | 21589.86 | 0
5890-0000 | Sec & Fire Safety Inspect | 20862.31 | 0
5900-0000 | Trash Removal | 15811.5 | 0
5930-0000 | Interior Plant Contract | 4961.28 | 0
Database: ACCTGDAT | Trial Balance |  | Page:      3
 | MGP Main DB |  | Date: 3/26/2012
 |  |  | Time: 05:11 PM
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit | Credit
5960-0000 | Pest Control | 3558.1 | 0
6000-0000 | Electricity | 576527.22 | 0
6020-0000 | Gas | 85540.3 | 0
6060-0000 | Water & Sewer | 40770.17 | 0
6100-0000 | Grounds Contract | 5691.65 | 0
6130-0000 | Landscaping Exterior | 634.5 | 0
6190-0000 | Snow Removal | 2059.1 | 0
6400-0000 | License and Permits | 1286.91 | 0
6500-0000 | Office Supplies | 5460.98 | 0
6510-0000 | Office [NAME] | 9121.58 | 0
6520-0000 | Office Equip Maintenance | 3074.87 | 0
6530-0000 | Dues & Subscriptions | 2701.99 | 0
6535-0000 | Professional Development | 1788 | 0
6540-0000 | Meeting Expense | 1224.41 | 0
6550-0000 | Telephone & Fax | 15684.41 | 0
6558-0000 | Internet Service | 1371.85 | 0
6560-0000 | Postage & Messenger | 5411.72 | 0
6570-0000 | Office Rent | 34550.04 | 0
6575-0000 | Parking/Bus Passes | 12240 | 0
6576-0000 | Travel Reimbursement | 10.83 | 0
6585-0000 | Other Office Expense | 472.31 | 0
6700-0000 | Management Contract | 294280.78 | 0
6705-0000 | Personal Property Taxes | 149 | 0
6707-0000 | Other Business Taxes | 139788.43 | 0
6730-0000 | Mgmt Salaries Taxes & Ben | 201821.39 | 0
6800-0000 | Real Estate Taxes | 1862527.51 | 0
6870-0000 | General Liability Insurance | 82196.04 | 0
7100-0000 | Marketing Expenses | 1299.68 | 0
7130-0000 | Charitable Contributions | 95.42 | 0
7150-0000 | Tenant Relations | 10518.03 | 0
7250-0000 | Legal Fees - Leasing | 2897.2 | 0
7255-0000 | Legal Fees - Other | 7888.11 | 0
7300-0000 | Outside Consultant | 15950 | 0
7599-0000 | Other Admin Expenses | 22.77 | 0
7800-0000 | Vacant Unit Fix-Up | 4581 | 0
7805-0000 | Non-Passthrough Repairs and Maintenance | 2109.7 | 0
7806-0000 | Non-Passthrough Utilities | 397116.32 | 0
7820-0000 | Space Plans/Drawings | 1363.79 | 0
7900-0000 | Reimbursable Expenses | 0 | 4744.89
8150-0000 | Telephone | 11.06 | 0
8180-0000 | Postage & Messenger | 241.79 | 0
8215-0000 | [NAME] Expenses | 41.42 | 0
8300-0000 | Airfare | 6766 | 0
8310-0000 | Ground Transportation | 1827.94 | 0
8330-0000 | Meals | 1032.74 | 0
8340-0000 | Hotels | 2579.59 | 0
8350-0000 | Parking - Meetings & Trav | 236 | 0
8390-0000 | Client Development | 63.9 | 0
8410-0000 | Legal Fees - General | 13131.19 | 0
8440-0000 | Audit and Tax Fees | 18000 | 0
8459-0000 | Loan Fees | 35000 | 0
8460-0000 | Organization/Filing Fees | 250.4 | 0
8465-0000 | Business Licenses and Permits | 175 | 0
8600-0000 | Interest Exp - Mort | 1888429.62 | 0
8696-0000 | Interest Exp - Fee Amortization | 244964.15 | 0
9000-0000 | Asset [NAME] | 720000 | 0
Database: ACCTGDAT | Trial Balance |  | Page:      4
 | MGP Main DB |  | Date: 3/26/2012
 |  |  | Time: 05:11 PM
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit | Credit
9551-0000 | Depr - Office Equipment | 1741.6 | 0
9651-0000 | Depr - Bldg Furn & Fix | 6390.05 | 0
9751-0000 | Depr - Office | 2934602.68 | 0
9801-0000 | Amrt - Lease Commissions | 236410.23 | 0
9826-0000 | Amrt - Other Lease Cons | 86210.57 | 0
9831-0000 | Amrt - FAS141 Acquired Leases | 1867368 | 0
9851-0000 | Amrt - Tenant Improvement | 358163.99 | 0
 | Total: | 172374838.22 | 172374838.22