Spreadsheet: 719655d1613750460-capture-data-from-multiple-tabs-and-paste-in-specific-format-excel-help-v4
Sheet: Input

Store | Date | Rental Income | Other Lease Income | Late Fees | Insurance Income | Merchandise Income | Other Income | Labor | Marketing | Utilities | G&A | Maintenance | Management Fees | Real Estate Taxes | Insurance Expense | Bank Charges | Other Expenses | [NAME] Reserves | Interest Expense | Principal Payments
301 | 2019-01-01 00:00:00 | 8503 | 6881 | 1937 | 8213 | 6331 | 5014 | 9020 | 9179 | 8994 | 8747 | 2600 | 394 | 9355 | 6559 | 7363 | 9296 | 2822 | 8610 | 1849
301 | 2019-02-01 00:00:00 | 4046 | 5661 | 651 | 982 | 1401 | 6123 | 6934 | 8668 | 2454 | 6095 | 9319 | 6996 | 8580 | 2053 | 8157 | 5524 | 9508 | 9730 | 1384
301 | 2019-03-01 00:00:00 | 994 | 8782 | 2456 | 2369 | 9620 | 8775 | 8101 | 2052 | 3130 | 3350 | 3852 | 7779 | 4807 | 3146 | 1566 | 5804 | 1177 | 354 | 1662
301 | 2019-04-01 00:00:00 | 1197 | 4440 | 8451 | 8314 | 2480 | 74 | 7618 | 6180 | 2493 | 903 | 998 | 6067 | 5666 | 3344 | 8473 | 17 | 4865 | 1929 | 6401
301 | 2019-05-01 00:00:00 | 7350 | 697 | 3934 | 5760 | 7708 | 7773 | 142 | 2812 | 7728 | 4280 | 8200 | 7737 | 873 | 2756 | 4371 | 3651 | 8308 | 9334 | 5672
301 | 2019-06-01 00:00:00 | 6494 | 6476 | 2634 | 3957 | 496 | 8422 | 3282 | 9792 | 84 | 4027 | 1143 | 8056 | 4887 | 6498 | 6955 | 734 | 4676 | 9674 | 2044
301 | 2019-07-01 00:00:00 | 5264 | 3610 | 5805 | 3510 | 2348 | 2927 | 5062 | 125 | 8231 | 592 | 8881 | 2345 | 1911 | 9194 | 8231 | 1359 | 4077 | 745 | 7081
301 | 2019-08-01 00:00:00 | 4550 | 1201 | 2009 | 1788 | 8679 | 2134 | 7107 | 4469 | 6791 | 7802 | 6111 | 3320 | 741 | 9937 | 459 | 1558 | 5924 | 2198 | 735
301 | 2019-09-01 00:00:00 | 9982 | 7259 | 7584 | 1540 | 8630 | 5078 | 9452 | 6783 | 2214 | 5632 | 1545 | 4063 | 3455 | 5167 | 1788 | 3366 | 4500 | 8707 | 6750
301 | 2019-10-01 00:00:00 | 7376 | 9323 | 924 | 5788 | 2405 | 8176 | 869 | 918 | 6953 | 1059 | 6434 | 2973 | 7000 | 8681 | 8011 | 4952 | 1174 | 5485 | 7549
301 | 2019-11-01 00:00:00 | 5613 | 4095 | 2433 | 2045 | 8186 | 4289 | 1279 | 8042 | 53 | 9951 | 1719 | 7602 | 6366 | 1435 | 3989 | 7412 | 9366 | 7272 | 6319
301 | 2019-12-01 00:00:00 | 3629 | 8460 | 4091 | 931 | 8485 | 1811 | 4034 | 6044 | 615 | 2406 | 1843 | 5900 | 2574 | 3019 | 2010 | 9029 | 3020 | 654 | 3537
302 | 2019-01-01 00:00:00
302 | 2019-02-01 00:00:00
302 | 2019-03-01 00:00:00
302 | 2019-04-01 00:00:00
302 | 2019-05-01 00:00:00
302 | 2019-06-01 00:00:00
302 | 2019-07-01 00:00:00
302 | 2019-08-01 00:00:00
302 | 2019-09-01 00:00:00
302 | 2019-10-01 00:00:00
302 | 2019-11-01 00:00:00
302 | 2019-12-01 00:00:00
303 | 2019-01-01 00:00:00
303 | 2019-02-01 00:00:00
303 | 2019-03-01 00:00:00
303 | 2019-04-01 00:00:00
303 | 2019-05-01 00:00:00
303 | 2019-06-01 00:00:00
303 | 2019-07-01 00:00:00
303 | 2019-08-01 00:00:00
303 | 2019-09-01 00:00:00
303 | 2019-10-01 00:00:00
303 | 2019-11-01 00:00:00
303 | 2019-12-01 00:00:00
304 | 2019-01-01 00:00:00
304 | 2019-02-01 00:00:00
304 | 2019-03-01 00:00:00
304 | 2019-04-01 00:00:00
304 | 2019-05-01 00:00:00
304 | 2019-06-01 00:00:00
304 | 2019-07-01 00:00:00
304 | 2019-08-01 00:00:00
304 | 2019-09-01 00:00:00
304 | 2019-10-01 00:00:00
304 | 2019-11-01 00:00:00
304 | 2019-12-01 00:00:00