Rushabh Shah

Financial Abstract Reporting Period 1st April 2016 to 31st December 2016 Particulars Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 FINANCIAL INFORMATION Bank Balances Debtors (money owed to you) Creditors (money owed by you) Total Income Total Expenses Net Income £ £ £ £ 2,39,-,-,542.64 £ £ £ £ 2,13,-,-,915.35 £ -£ £ £ £ £ 31,-,108.64 £ £ 30,-,233.01 2,33,-,597.70 £ £ £ £ 2,31,-,-,785.29 £ £ £ £ 2,38,136.20 9,-,929.23 £ £ £ £ 2,57,-,-,506.74 £ £ £ £ 2,63,329.75 8,-,275.17 £ £ £ £ 2,58,801.38 7,-,859.17 £ £ £ £ 2,62,461.82 8,-,465.14 £ £ 28,439.81 £ 6,157.89 -£ 45,- £ £ 27,401.10 3,528.13 £ £ 28,280.90 9,225.84 £ £ 29,842.53 7,432.64 £ £ 31,-,562.77 £ £ 25,460.13 9,005.01 £ 333.22 -£ £ 1,843.75 -£ £ 979.93 £ 1,432.49 STATUTORY LIABILITIES/DUES VAT owed to date PAYE/NIC owed to date Corporation tax to date £ -£ Schedules £ 252.74 £ Links to the sheet Balance Sheet Profit & Loss Profit and Loss by Class -Dec16 Aged Receivable Aged Payable Paye & NIC Wages Schedule Rental agent collection schedule - December 16 ABC - Loan Account Repair and maintenance schedule Management Fees Comparision Rental Income Management Fees Interest On Mortgage General Ledger £ 1,257.99 -£ £ 672.23 -£ £ 86.47 £ £ 527.37 £ Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Updated Notes: VAT: Rental Income: Interest on Mortgage: Accuracy of Figures: Not Registered For VAT Detailed comments listed in Class Profit and Loss Sheet Detailed comments listed in Class Profit and Loss Sheet Figures has been manupulated in the report. Analytical review: List of properties where Rent not received in December Property Name Reasons: 1 Rent not received in December month. 2 Spoken to tenant as benefit payment had stopped and the tenant assured me it was just a review so will chases as soons as the housing office is open again 3 XYZ Agent says that Rent is not collected yet- Tenant given a warning letter as he is aware the property will come back to us despite his loss last year if rent isn't on time says he is going back to work in January 2017 but if payment is not received he will be evicted BL- Paying rent on 4th of January 2017 as in Bermuda Tenant is paying 2 months rent on the 16th of January if he has not paid eviction will proceed straight away Rent not received in December month. Rent not received in Since March,2016 Empty Awaiting tenant Tenant is clearing arrears at an agreed rate of £50 per month as his circumstances have changed -250 Received Tenant given a warning letter as he is aware the property will come back to us despite his loss last year if rent isn't on time says he is going back to work in January 2017 but if payment is not 11 received he will be evicted BL- received Interest on Mortgage is not there in: 3 5 6 ABC Rental Account Balance Sheet As of December 31, 2016 Apr 2016 May 2016 Jun 2016 Jul 2016 Aug 2016 Sep 2016 Oct 2016 Nov 2016 Dec 2016 Fixed Asset Total Fixed Asset Cash at bank and in hand Bank #1519 1,036.15 11,096.18 ABC 6821 23,170.60 28,021.05 HSBC - 45761 39,167.73 18,892.72 1,75,811.78 1,55,811.78 0.00 0.00 HSBC 60057 Rents Held in Trust Total Cash at bank and in hand £ 2,39,186.26 £ 12,143.70 2,13,821.73 £ 14,827.07 15,682.85 30,985.88 29,799.11 32,130.24 31,439.47 34,968.97 34,944.00 31,062.38 27,131.92 24,052.66 19,607.80 18,811.37 30,993.96 25,898.08 35,532.05 43,861.44 53,539.12 51,124.48 56,272.12 1,55,811.78 1,55,858.92 1,55,858.92 1,55,938.86 1,55,938.86 1,55,938.86 1,55,938.86 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,33,918.41 £ 2,31,528.07 £ 2,38,136.20 £ 2,57,918.10 £ 2,63,329.75 £ 2,58,801.38 £ 2,62,461.82 Debtors Debtors Total Debtors 10,120.85 £ Current Assets Loan Account - ABC LTD PayPal 10,120.85 14,786.09 £ 5,706.59 Prepaid Expenses Prepaid rent 14,786.09 -0.02 -£ 6,555.87 0.02 £ 9,661.19 12,420.81 9,600.49 12,420.81 £ 9,600.49 13,729.84 £ 15,756.22 10,629.10 8,505.07 7,283.84 8,334.40 10,629.10 £ 8,505.07 £ 7,283.84 £ 8,334.40 18,886.80 20,308.35 20,561.38 21,619.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,220.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 Uncategorised Asset 0.00 Total Current Assets £ 5,956.59 £ Net current assets Creditors: amounts falling due within one year £ 2,55,263.70 £ 0.00 £ 6,805.87 0.00 0.00 0.00 0.00 0.00 15,000.00 15,000.00 £ 9,911.19 £ 13,979.84 £ 16,006.22 £ 19,136.80 £ 20,558.35 £ 35,811.38 £ 38,089.95 2,35,413.69 £ 2,43,829.58 £ 2,57,928.72 £ 2,63,742.91 £ 2,87,684.00 £ 2,92,393.17 £ 3,01,896.60 £ 3,08,886.17 0.00 340.00 0.00 £ 340.00 Trade Creditors Accrued management fees Total Trade Creditors 0.00 0.00 £ 0.00 0.00 £ 0.00 £ £ 0.00 581.11 772.15 772.15 0.00 £ 581.11 £ 772.15 £ 772.15 Current Liabilities National Insurance P & J Properties PAYE/NIC Payable Prepayment ; Rental Agent 161.28 161.28 161.28 161.28 161.28 161.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -252.74 333.22 -1,843.75 -1,257.99 -672.23 -86.47 527.37 979.93 1,432.49 0.00 0.00 0.00 0.00 15,312.00 13,780.80 12,249.60 10,718.40 4 Rounding off Salary Payable 12,811.35 0.00 0.00 -0.10 -0.10 -0.10 -0.10 -0.26 -0.26 -4,941.28 -5,693.71 -3,446.14 -1,198.57 1,049.00 2,763.11 4,477.22 6,191.33 Total Current Liabilities Total Creditors: amounts falling due within one year £ 12,719.89 -£ 4,446.78 -£ 7,376.18 -£ 4,542.95 -£ 1,709.62 £ 16,435.71 £ 17,071.18 £ 17,706.49 £ 18,341.96 £ 12,719.89 -£ 4,446.78 -£ 7,376.18 -£ 4,542.95 -£ 1,369.62 £ 16,435.71 £ 17,652.29 £ 18,478.64 £ 19,114.11 Net current assets (liabilities) Total assets less current liabilities £ 2,42,543.81 £ 2,39,860.47 £ 2,51,205.76 £ 2,62,471.67 £ 2,65,112.53 £ 2,71,248.29 £ 2,74,740.88 £ 2,83,417.96 £ 2,89,772.06 £ 2,42,543.81 £ 2,39,860.47 £ 2,51,205.76 £ 2,62,471.67 £ 2,65,112.53 £ 2,71,248.29 £ 2,74,740.88 £ 2,83,417.96 £ 2,89,772.06 Total net assets (liabilities) £ 2,42,543.81 £ 2,39,860.47 £ 2,51,205.76 £ 2,62,471.67 £ 2,65,112.53 £ 2,71,248.29 £ 2,74,740.88 £ 2,83,417.96 £ 2,89,772.06 Capital and Reserves Accumulated adjustment 682.00 682.00 682.00 682.00 682.00 682.00 682.00 682.00 682.00 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 2,96,051.81 73,200.00 73,200.00 80,200.00 92,400.00 92,400.00 92,400.00 92,400.00 92,400.00 92,400.00 Owner's Drawings -84,465.90 -96,601.73 -96,655.21 -97,053.80 -97,858.31 -98,335.60 -1,00,167.76 -1,00,464.37 -1,00,542.70 Retained Earnings -74,310.18 -74,310.18 -74,310.18 -74,310.18 -73,385.18 -73,385.18 -73,385.18 -73,385.18 -73,385.18 Profit for the year 31,386.08 40,838.57 45,237.34 44,701.84 47,222.21 53,835.26 59,160.01 68,133.70 74,566.13 Opening Balance Equity Owner's capital Total Capital and Reserves £ 2,42,543.81 £ 2,39,860.47 £ 2,51,205.76 £ 2,62,471.67 £ 2,65,112.53 £ 2,71,248.29 £ 2,74,740.88 £ 2,83,417.96 £ 2,89,772.06 ABC - Rental Account Profit and Loss April - December, 2016 Apr 2016 May 2016 Jun 2016 Jul 2016 Aug 2016 Sep 2016 Oct 2016 Nov 2016 Dec 2016 Total Income Billable Expense Income Other Miscellaneous Income Rental Income - Furnished Uncategorised Income Total Income £ 0.00 0.00 0.00 0.00 0.00 0.00 0.00 791.11 0.00 791.11 303.45 303.45 303.45 303.45 303.45 303.45 303.45 303.45 303.45 2,731.05 53,229.20 43,610.70 34,293.27 44,433.72 30,492.67 37,122.37 36,970.74 42,763.63 34,160.71 3,57,077.01 0.00 0.00 0.00 0.00 132.13 0.00 0.00 0.00 0.00 132.13 53,532.65 £ 43,914.15 £ 34,596.72 £ 44,737.17 £ 30,928.25 £ 37,425.82 £ 37,274.19 £ 43,858.19 £ 34,464.16 £ 3,60,731.31 Cost of Sales -54.00 Cost of sales -54.00 Total Cost of Sales £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 -£ 54.00 £ 0.00 £ 0.00 -£ 54.00 Gross Profit £ 53,532.65 £ 43,914.15 £ 34,596.72 £ 44,737.17 £ 30,928.25 £ 37,425.82 £ 37,328.19 £ 43,858.19 £ 34,464.16 £ 3,60,785.31 Expenses Bank charges 17.50 30.10 Charitable Contributions 49.00 Dues and Subscriptions 0.00 Furniture & Fixtures 17.50 17.50 9.80 16.72 17.50 17.50 17.50 161.62 21.00 21.00 21.00 21.00 21.00 21.00 21.00 21.00 217.00 0.00 547.26 0.00 0.00 0.00 0.00 0.00 0.00 547.26 0.00 0.00 0.00 63.00 0.00 0.00 4,973.15 5,538.01 0.00 10,574.16 Income Protection Fee 34.24 34.24 34.24 34.24 34.24 34.24 34.24 34.24 34.24 308.20 Insurance 42.20 36.19 36.19 6,616.13 6.01 523.03 36.33 36.33 36.33 7,368.73 10,313.18 14,194.04 12,253.61 10,313.18 14,194.04 12,033.78 11,851.17 11,398.34 11,398.34 1,07,949.69 56.14 208.82 34.16 121.49 208.82 34.16 208.82 34.16 127.05 1,033.63 1,490.61 1,733.45 347.20 1,398.67 656.68 990.88 388.04 710.86 383.54 8,099.94 52.67 0.00 0.00 52.70 0.00 0.00 52.67 0.00 0.00 158.03 5,412.93 4,659.35 3,574.77 4,833.23 3,032.88 4,489.67 3,674.97 5,209.97 3,430.49 38,318.28 0.00 0.00 40.95 66.01 77.24 18.98 0.00 17.49 121.65 342.31 294.56 1,083.32 1,138.62 176.39 209.66 187.31 173.31 46.94 436.16 3,746.26 0.00 15.40 0.00 0.00 0.00 65.80 0.00 0.00 0.00 81.20 121.13 121.13 121.13 121.13 132.13 0.00 0.00 0.00 0.00 616.64 Interest On Mortgage (Mortgage Expense) Landlords Insurance Legal and professional fees Licence Fees Management fees Meal & Entertainment Other Expense Printing & Stationery Property Insurance Rates 0.00 0.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.70 Repair and maintenance 6,903.82 1,703.38 3,392.48 2,293.84 2,631.16 2,522.18 1,827.08 2,204.73 3,740.23 27,218.91 Salaries and wages 3,966.66 3,966.66 3,966.66 3,966.66 3,966.66 3,966.66 3,033.34 3,033.34 3,033.34 32,899.99 282.83 282.24 282.18 282.18 216.19 216.19 1,029.69 216.13 216.13 3,023.76 Set up Fees 0.00 0.00 0.00 0.00 0.00 350.90 0.00 0.00 0.00 350.90 Taxes Paid 0.00 0.00 0.00 12,329.25 0.00 0.00 0.00 0.00 0.00 12,329.25 Service charge Telecommunications Travel Uncategorised Expense Utilities 0.00 615.99 0.00 0.00 0.00 0.00 0.00 0.00 0.00 615.99 1,196.48 1,012.47 900.44 862.54 842.39 870.39 856.59 1,266.20 898.16 8,705.66 0.00 0.00 0.00 0.00 39.00 280.00 0.00 0.00 0.00 319.00 1,200.05 963.86 1,731.41 1,985.07 1,123.18 1,659.17 1,718.67 1,511.15 1,565.98 13,458.54 Total Expenses £ 31,434.00 £ 30,682.34 £ 28,439.81 £ 45,554.24 £ 27,401.09 £ 28,281.06 £ 29,896.57 £ 31,296.40 £ 25,460.13 £ 2,78,445.65 Net Operating Income £ 22,098.65 £ 13,231.81 £ 6,156.91 -£ 817.07 £ 3,527.16 £ 9,144.76 £ 7,431.62 £ 12,561.79 £ 9,004.03 £ 82,339.66 Other Income Council Tax Refund 9.01 Interest income 0.98 Total Other Income £ 9.99 9.01 1.20 £ 1.20 0.98 £ 0.98 48.12 £ 48.12 0.98 £ 0.98 80.92 £ 80.92 0.98 £ 0.98 0.98 £ 0.98 0.98 £ 0.98 136.12 £ 145.13 Other Expenses 0.01 Reconciliation Discrepancies -0.16 -0.04 -0.19 Total Other Expenses £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.01 -£ 0.16 -£ 0.04 £ 0.00 £ 0.00 -£ 0.19 Net Other Income £ 9.99 £ 1.20 £ 0.98 £ 48.12 £ 0.97 £ 81.08 £ 1.02 £ 0.98 £ 0.98 £ 145.32 Net Income £ 22,108.64 £ 13,233.01 £ 6,157.89 -£ 768.95 £ 3,528.13 £ 9,225.84 £ 7,432.64 £ 12,562.77 £ 9,005.01 £ 82,484.98 ABC - Rental Account Profit and Loss by Class Dec-16 Name of the Properties 1 2 3 4 5 6 7 8 13 12 11 10 9 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Group Property TOTAL Others Income Other Miscellaneous Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 632.24 700.00 860.44 0.00 0.00 630.00 308.00 0.00 53,814.90 475.00 £ 2,340.00 £ 664.92 £ 2,426.66 £ 0.00 £ 2,786.00 £ 2,310.00 £ 0.00 £ 1,295.00 £ 1,365.00 £ 0.00 £ 910.00 £ 0.00 £ 553.28 £ 0.00 £ 290.78 £ 595.00 £ 84.00 £ 0.00 £ 579.94 £ 0.00 £ 350.00 £ 595.00 £ 0.00 £ 770.00 £ 700.00 £ 483.28 £ 810.07 £ 630.00 £ 0.00 £ 651.00 £ 636.33 £ 627.20 £ 560.00 £ 630.00 £ 483.28 £ 315.00 £ 502.49 £ 860.44 £ 700.00 £ 632.24 £ 630.00 £ 308.00 £ 630.00 £ 644.00 £ 599.84 £ 15,851.16 £ 0.00 £ 0.00 £ 0.00 £ 303.45 £ 32,402.20 Gross Profit £ 1,100.00 £ 575.00 £ 475.00 £ 2,340.00 £ 664.92 £ 2,426.66 £ 0.00 £ 2,786.00 £ 2,310.00 £ 0.00 £ 1,295.00 £ 1,365.00 £ 0.00 £ 910.00 £ 0.00 £ 553.28 £ 0.00 £ 290.78 £ 595.00 £ 84.00 £ 0.00 £ 579.94 £ 0.00 £ 350.00 £ 595.00 £ 0.00 £ 770.00 £ 700.00 £ 483.28 £ 810.07 £ 630.00 £ 0.00 £ 651.00 £ 636.33 £ 627.20 £ 560.00 £ 630.00 £ 483.28 £ 315.00 £ 502.49 £ 860.44 £ 700.00 £ 632.24 £ 630.00 £ 308.00 £ 630.00 £ 644.00 £ 599.84 £ 15,851.16 £ 0.00 £ 0.00 £ 0.00 £ 303.45 £ 32,402.20 0.00 17.50 2,426.66 0.00 2,786.00 2,310.00 0.00 1,295.00 1,365.00 0.00 910.00 0.00 553.28 0.00 290.78 595.00 84.00 0.00 579.94 0.00 350.00 595.00 0.00 770.00 700.00 483.28 810.07 630.00 0.00 651.00 636.33 627.20 560.00 630.00 483.28 315.00 0.00 0.00 424.83 £ 664.92 0.00 303.45 575.00 2,340.00 22,191.63 0.00 £ 475.00 599.84 0.00 1,100.00 575.00 644.00 0.00 £ 1,100.00 630.00 0.00 0.00 0.00 0.00 Total Income Rental Income - Furnished 502.49 0.00 Expenses Bank charges 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 17.50 Charitable Contributions 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 21.00 0.00 0.00 21.00 Income Protection Fee 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34.24 34.24 Insurance Interest On Mortgage (Mortgage 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30.32 6.01 36.33 0.00 255.43 472.01 429.41 1,940.43 358.18 271.70 253.64 313.31 0.00 216.87 148.15 119.48 135.60 193.76 147.38 119.39 241.37 129.57 120.13 299.70 101.15 156.03 184.97 129.85 139.68 263.59 150.29 119.34 379.54 249.35 129.68 184.97 124.87 88.20 236.32 350.07 184.66 207.76 119.49 207.79 207.45 0.00 8,101.03 187.42 0.00 0.00 0.00 13,389.95 Landlords Insurance 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 127.05 0.00 127.05 Legal and professional fees 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36.34 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 347.20 383.54 232.96 0.00 267.46 166.32 0.00 155.40 131.04 0.00 120.12 0.00 55.33 0.00 29.08 59.50 8.40 0.00 57.99 0.00 35.00 59.50 0.00 77.00 70.00 48.33 81.00 63.00 0.00 65.10 63.63 62.72 56.00 63.00 48.33 31.50 50.25 86.04 70.00 63.22 63.00 30.80 63.00 64.40 59.99 2,219.15 0.00 0.00 0.00 0.00 3,843.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 30.72 0.00 90.93 121.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.40 41.92 395.64 436.16 Expense) 169.94 Management fees 245.38 105.60 392.09 75.90 65.56 224.64 79.79 Meal & Entertainment 0.00 0.00 0.00 0.00 Other Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 84.00 0.00 0.00 0.00 0.00 70.00 0.00 70.00 105.00 0.00 0.00 0.00 0.00 141.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 350.00 0.00 0.00 0.00 0.00 0.00 2,213.39 369.46 98.00 4,783.77 0.00 0.00 0.00 145.87 5,080.34 Salaries and wages 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3,033.34 0.00 0.00 3,033.34 Serv ice charge 0.00 0.00 0.00 0.00 0.00 0.00 0.00 216.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 216.13 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 17.49 0.00 880.67 898.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,565.98 0.00 1,565.98 Repair and maintenance 66.70 Trav el 0.00 0.00 0.00 0.00 Utilities 0.00 0.00 0.00 0.00 0.00 Total Expenses £ 275.54 £ 387.98 £ 65.56 £ 616.73 £ 79.79 £ 232.96 £ 255.43 £ 739.47 £ 595.73 £ 1,940.43 £ 513.58 £ 402.74 £ 469.77 £ 553.77 £ 0.00 £ 272.20 £ 148.15 £ 148.55 £ 265.10 £ 202.16 £ 217.38 £ 282.38 £ 241.37 £ 164.57 £ 179.63 £ 299.70 £ 319.28 £ 226.03 £ 233.30 £ 210.85 £ 202.68 £ 263.59 £ 215.39 £ 182.97 £ 442.26 £ 305.35 £ 192.68 £ 233.30 £ 156.37 £ 488.45 £ 322.36 £ 420.07 £ 247.88 £ 270.76 £ 150.29 £ 2,484.17 £ 641.31 £ 157.99 £ 10,788.54 £ 187.42 £ 3,101.14 £ 1,782.77 £ 1,900.56 £ 24,889.89 Net Operating Income £ 824.46 £ 187.02 £ 409.44 £ 1,723.27 £ 585.13 £ 2,193.70 -£ 255.43 £ 2,046.53 £ 1,714.27 -£ 1,940.43 £ 781.42 £ 962.26 -£ 469.77 £ 356.23 £ 0.00 £ 281.08 -£ 148.15 £ 142.23 £ 329.90 -£ 118.16 -£ 217.38 £ 297.56 -£ 241.37 £ 185.43 £ 415.37 -£ 299.70 £ 450.72 £ 473.97 £ 249.98 £ 599.21 £ 427.32 -£ 263.59 £ 435.61 £ 453.36 £ 184.94 £ 254.65 £ 437.32 £ 249.98 £ 158.63 £ 14.04 £ 538.08 £ 279.93 £ 384.36 £ 359.24 £ 157.71 -£ 1,854.17 £ 2.69 £ 441.85 £ 5,062.62 -£ 187.42 -£ 3,101.14 -£ 1,782.77 -£ 1,597.11 £ 7,512.30 Other Income Interest income 0.00 Total Other Income £ Net Other Income Net Income 0.00 1,723.27 409.44 187.02 824.46 £ 0.00 £ 0.00 £ 0.00 £ £ £ £ £ £ £ £ £ 0.00 0.00 0.00 0.00 0.00 £ £ 0.00 £ 585.13 0.00 £ £ 0.00 £ 2,193.70 0.00 £ £ 0.00 -£ 255.43 0.00 £ 0.00 £ 0.00 £ £ 0.00 £ 2,046.53 0.00 £ £ 0.00 £ 0.00 £ 1,714.27 -£ 1,940.43 0.00 £ £ 0.00 £ 781.42 0.00 £ £ 0.00 £ 962.26 £ 0.00 -£ 469.77 Analytical review: List of properties where Rent not received in December Property Name Reasons: 1 Rent not received in December month. 2 Spoken to tenant as benefit payment had stopped and the tenant assured me it was just a review so will chases as soons as the housing office is open again 3 XYZ Agent says that Rent is not collected yet. 4 Tenant given a warning letter as he is aware the property will come back to us despite his loss last year if rent isn't on time says he is going back to work in January 2017 but if payment is not received he will be evicted BL- Paying rent on 4th of January 2017 as in Bermuda 6 Tenant is paying 2 months rent on the 16th of January if he has not paid eviction will proceed straight away 7 Rent not received in December month. 8 Rent not received in Since March,2016 9 Empty Awaiting tenant 10 Tenant is clearing arrears at an agreed rate of £50 per month as his circumstances have changed -250 Received 11 Tenant given a warning letter as he is aware the property will come back to us despite his loss last year if rent isn't on time says he is going back to work in January 2017 but if payment is not received he will be evicted BL- received Interest on Mortgage is not there in: 3 5 6 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 356.23 £ 0.00 £ 281.08 -£ 148.15 £ 0.00 £ 0.00 £ £ 0.00 £ 142.23 0.00 £ £ 0.00 £ 329.90 0.00 £ £ 0.00 -£ 118.16 0.00 £ £ 0.00 -£ 217.38 0.00 £ £ 0.00 £ 297.56 0.00 £ £ 0.00 -£ 241.37 0.00 £ £ 0.00 £ 185.43 0.00 £ £ 0.00 £ 415.37 0.00 £ £ 0.00 -£ 299.70 0.00 £ £ 0.00 £ 450.72 0.00 £ £ 0.00 £ 473.97 0.00 £ £ 0.00 £ 249.98 0.00 £ £ 0.00 £ 599.21 0.00 £ £ 0.00 £ 427.32 0.00 £ £ 0.00 -£ 263.59 0.00 £ £ 0.00 £ 435.61 0.00 £ £ 0.00 £ 453.36 0.00 £ £ 0.00 £ 184.94 0.00 £ £ 0.00 £ 254.65 £ 0.00 £ 437.32 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 0.98 0.98 £ 0.00 0.00 £ £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 0.00 £ 249.98 £ 158.63 £ 14.04 £ 538.08 £ 279.93 £ 384.36 £ 359.24 £ 157.71 -£ 1,854.17 £ 2.69 £ 441.85 £ 5,062.62 -£ 187.42 £ 0.00 £ 0.98 £ 0.00 £ 0.98 -£ 3,101.14 -£ 1,781.79 £ 0.00 £ 0.98 £ 0.00 £ 0.98 -£ 1,597.11 £ 7,513.28 ABC - Rental Account A/R Ageing Summary As of December 31, 2016 Name of the customer Current 1 - 30 31 - 60 61 - 90 91 and over Total 1 0.00 0.00 2 0.00 0.00 3 0.00 0.00 4 0.00 0.00 5 0.00 0.00 6 0.00 0.00 7 0.00 0.00 8 0.00 0.00 9 0.00 0.00 10 0.00 0.00 11 0.00 0.00 12 0.00 0.00 13 0.00 0.00 14 0.00 0.00 15 0.00 0.00 16 0.00 0.00 17 0.00 0.00 18 0.00 0.00 19 -1.00 -1.00 0.01 7,749.37 7,749.34 20 0.01 0.01 -0.08 21 -0.08 22 0.00 0.00 23 0.00 0.00 585.13 24 585.13 25 TOTAL £ 8,334.47 TOTAL - £ 0.00 0 -£ 0.07 -0.14 £ 0.01 0.02 -£ 0.98 0.98 0.01 £ 8,334.40 -0.02 16668.8 ABC - Rental Account A/P Ageing Summary As of December 31, 2016 Current 1 - 30 31 - 60 61 - 90 91 and over Total 0.00 1 0.00 0.00 2 191.04 3 0.00 581.11 - 0.00 5 0.00 0.00 6 0.00 0.00 4 TOTAL £ 0.00 £ 0.00 £ 191.04 £ 581.11 £ 0.00 £ 772.15 ABC Rental PAYE & NIC Creditor Month Opening May June July Aug Sept Oct Nov Dec Jan Feb Mar April May June July August Sept Oct Nov Dec Total PAYE payable-,911.80 NI payable- Total Payable-,208.60 PAYE/NI Paid 3,-,-,762.73 - 13,681.23 Net Payable at the end of the month 853.44 1,706.88 2,560.32 3,413.76 4,267.20 5,120.64 2,556.99 3,410.43 3,929.91 1,530.66 1,-,843.75 1,-,432.49 Payment month May June July Aug Sep Oct- Sr. No. 1 2 3 4 5 Sr. No. 1 2 3 4 5 Sr. No. 1 2 3 4 5 Name Employee 1 Employee Employee Employee Employee 2 3 4 5 Name Employee 1 Employee Employee Employee Employee 2 3 4 5 Name Employee 1 Employee Employee Employee Employee 2 3 4 5 Jun-16 Gross Salary Student Loan - Em'ee NI Em'er NI 0 0 0 0 0 0 May-16 Gross Salary Student Loan - - Em'ee NI Em'er NI 0 0 0 0 0 0 Apr-16 Gross Salary Student Loan - - - - Em'ee NI Em'er NI 0 0 0 0 0 0 - - PAYE - PAYE - PAYE - NET SALARY - NET SALARY - NET SALARY - December 2016 Monthly Statement Property Rental Balance Rent Collected 1 £425.00 £0.00 £425.00 2 £450.00 -£450.00 £0.00 3 4 £450.00 £400.00 £0.00 -£133.90 £450.00 £395.20 - £450.00 £400.00 £300.00 £60.00 £425.00 -£1,492.13 -£112.31 -£1,566.90 £202.02 -£72.10 £0.00 £425.00 £450.00 £450.00 £500.00 £550.00 -£26.90 £1,130.27 £0.00 £0.00 £0.00 - £450.00 £450.00 £475.00 £500.00 £450.00 £375.00 £250.00 £358.92 £345.20 £425.00 £1,580.99 Tenants housing has been stopped due to start by the 15th January 2016 Tenant is clearing arrears at an agreed rate f £50 th hi i t h £70.00 £250.00 £75.00 £100.81 Empty Awaiting tenant -£883.94 £451.60 -£320.00 -£1,197.38 £448.00 £614.60 -£600.99 £0.00 £0.00 £450.00 - £450.00 £450.00 £450.00 £375.00 -£250.00 £40.00 -£469.98 £220.00 £460.00 £465.00 £400.00 £0.00 28 £395.00 -£439.77 £0.00 29 30 £425.00 -£225.00 £165.78 £225.00 £450.00 £450.00 £500.00 £450.00 £395.00 -£842.09 £11.40 £0.71 -£725.61 -£262.00 £0.00 £207.70 £500.00 £454.52 £345.20 £14,515.00 -£8,520.82 £11,322.26 £450.00 BL- BL- BL- £578.62 £414.24 £450.00 £500.00 £550.00 £450.00 £450.00 - £50.00 £428.46 22 23 £450.00 Works Exc. VAT Man. Fees @ 10% BL- Paying rent on 4th of January 2017 as in Bermuda Tenant is paying 2 months rent on the 16th of January if he has not paid eviction will proceed straight away Tenant making up her arrears at £50 per month BL- Tenant given a warning letter as he is aware the property will come back to us despite his loss last year if rent isn't on time says he is going back to work in January 2017 but if payment is not received he will be evicted BL- Tenant due to pay next instalment 3rd Jan 2017 Spoken to tenant as benefit payment had stopped and the tenant assured me it was just a review so will chases as soons as the housing office is open again £263.90 £50.00 Sub Total VAT @ 0% Total Charges Balance due to Landlord £42.50 £92.50 £0.00 £92.50 £332.50 £0.00 £0.00 £0.00 £0.00 £0.00 £45.00 £39.52 £1,625.99 £39.52 £0.00 £0.00 £1,625.99 £39.52 -£1,175.99 £355.68 £6.00 £42.85 £25.00 £35.89 £34.52 £42.50 £0.00 £0.00 £57.86 £41.42 £45.00 £50.00 £55.00 £6.00 £112.85 £25.00 £285.89 £34.52 £42.50 £0.00 £0.00 £57.86 £116.42 £45.00 £50.00 £155.81 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £6.00 £112.85 £25.00 £285.89 £34.52 £42.50 £0.00 £0.00 £57.86 £116.42 £45.00 £50.00 £155.81 £54.00 £315.61 £225.00 £73.03 £310.68 £382.50 £0.00 £0.00 £520.76 £297.82 £405.00 £450.00 £394.19 £0.00 £45.16 £44.80 £61.46 £0.00 £45.16 £44.80 £61.46 £0.00 £0.00 £0.00 £0.00 £0.00 £45.16 £44.80 £61.46 £0.00 £406.44 £403.20 £553.14 £0.00 £45.00 £0.00 £45.00 £0.00 £0.00 £0.00 £45.00 £0.00 £405.00 £22.00 £46.00 £46.50 £40.00 £22.00 £309.90 £46.50 £40.00 £0.00 £0.00 £0.00 £0.00 £22.00 £309.90 £46.50 £40.00 £198.00 £150.10 £418.50 £360.00 £0.00 £50.00 £0.00 £50.00 -£50.00 £22.50 £45.00 £22.50 £45.00 £0.00 £0.00 £22.50 £45.00 £202.50 £405.00 £0.00 £20.77 £50.00 £45.45 £34.52 £0.00 £20.77 £50.00 £45.45 £34.52 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £20.77 £50.00 £45.45 £34.52 £0.00 £186.93 £450.00 £409.07 £310.68 Overall figures: Grand Total Due to Landlord Notes: Works unpaid for: Please note: £7,749.33 ABC - Rental Account Transaction Report Dec-16 Date Transactio n Type No. Adj Name Memo/Des cription Account Amount Balance Loan Account - ABC LTD - PayPal Beginning Balance 07/12/2016 Expense 20,561.38 No Paypal PAYPAL PAY Loan Account 12.00 20,573.38 12/12/2016 Expense No BCARD PLAT Loan Account 729.09 21,302.47 20/12/2016 Expense No Paypal PAYPAL PAY Loan Account 24.00 21,326.47 21/12/2016 Expense No Paypal PAYPAL PAY Loan Account 199.00 21,525.47 21/12/2016 Expense No Paypal PAYPAL PAY Loan Account 44.99 21,570.46 21/12/2016 Expense No Paypal PAYPAL PAY Loan Account 19.99 21,590.45 30/12/2016 Expense No Paypal PAYPAL PAY Loan Account 6.06 21,596.51 30/12/2016 Expense No Paypal PAYPAL PAY Loan Account 6.71 21,603.22 30/12/2016 Expense No Paypal PAYPAL PAY Loan Account 7.04 21,610.26 30/12/2016 Expense No Paypal PAYPAL PAY Loan Account 9.69 21,619.95 Total for Loan Account - ABC LTD - PayPal £ 1,058.57 TOTAL £ 1,058.57 ABC - Rental Account Transaction Report Dec-16 Date Transactio n Type No. Adj Name Memo/Des cription Account Split Amount Balance Repair and maintenance 01/12/2016 Expense No XX xx Repair and maHSBC - 45761 100.00 100.00 01/12/2016 Expense No XX xx Repair and maHSBC - 45761 66.70 166.70 19/12/2016 Expense No XX xx Repair and maABC 6821 4.19 170.89 21/12/2016 Invoice 1950 No XX xx Repair and maDebtors 60.00 230.89 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 100.81 331.70 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 263.90 595.60 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 50.00 645.60 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 250.00 895.60 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 70.00 965.60 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 1,580.99 2,546.59 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 50.00 2,596.59 31/12/2016 Invoice 1943 No XX xx Repair and maDebtors 75.00 2,671.59 Total for Repair and maintenance £ 2,671.59 TOTAL £ 2,671.59 Sum of Amount Name Rental Agent 3 Rental Agent 2 Rental Agent 4 Rental Agent 1 Rental Agent 5 Rental Agent 6 Rental Agent 7 (blank) Grand Total Rental Income Total Rental Agent Management Fees - Average fees Paid: - Percentage fees 12% 10% 7% 10% 14% 12% 13% 11% ABC - Rental Account ABC - Rental Account Transaction Report Dec-16 Date Transactio n Type No. Adj Name Memo/Description Account Split Amount Balance Rental Income - Furnished 01/12/2016 Invoice 1934 No Rental Agent 1 Rental IncomeDebtors 1,733.33 1,733.33 02/12/2016 Invoice 1937 No Rental Agent 1 Rental IncomeDebtors 2,340.00 4,073.33 08/12/2016 Invoice 1952 No Rental Agent 3 Rental IncomeDebtors 925.00 4,998.33 12/12/2016 Invoice 1951 No Rental Agent 5 Rental IncomeDebtors 475.00 5,473.33 12/12/2016 Invoice 1904 No Rental Agent 4Rent-16/10/2016 to 15/11/2Rental IncomeDebtors 1,650.00 7,123.33 15/12/2016 Invoice 1931 No Rental Agent 7 Rental IncomeDebtors 575.00 7,698.33 21/12/2016 Invoice 1948 No Rental Agent 1 Rental IncomeDebtors 975.00 8,673.33 21/12/2016 Invoice 1950 No Rental Agent 7 Rental IncomeDebtors 650.00 9,323.33 28/12/2016 Invoice 1947 No Rental Agent 1 Rental IncomeDebtors 1,100.00 10,423.33 30/12/2016 Invoice 1945 No Rental Agent 1 Rental IncomeDebtors 1,990.00 12,413.33 31/12/2016 Invoice 1943 No Rental Agent 2BL- Rental IncomeDebtors 414.24 12,827.57 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 450.00 13,277.57 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 500.00 13,777.57 31/12/2016 Invoice 1943 No Rental Agent 2BL- Rental IncomeDebtors 550.00 14,327.57 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 451.60 14,779.17 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 448.00 15,227.17 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 614.60 15,841.77 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 450.00 16,291.77 31/12/2016 Invoice 1943 No Rental Agent 2Tenant making up her arreaRental IncomeDebtors 220.00 16,511.77 31/12/2016 Invoice 1943 No Rental Agent 2BL- Rental IncomeDebtors 460.00 16,971.77 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 465.00 17,436.77 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 400.00 17,836.77 31/12/2016 Invoice 1943 No Rental Agent 2Tenant due to pay next inst Rental IncomeDebtors 225.00 18,061.77 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 450.00 18,511.77 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 207.70 18,719.47 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 500.00 19,219.47 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 454.52 19,673.99 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 345.20 20,019.19 31/12/2016 Invoice 1949 No Rental Agent 6 Rental IncomeDebtors 664.92 20,684.11 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 425.00 21,109.11 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 345.20 21,454.31 31/12/2016 Invoice 1943 No Rental Agent 2BL- Rental IncomeDebtors 358.92 21,813.23 31/12/2016 Invoice 1943 No Rental Agent 2Tenant is clearing arrears aRental IncomeDebtors 250.00 22,063.23 31/12/2016 Invoice 1943 No Rental Agent 2BL- 428.46 22,491.69 31/12/2016 Invoice 1943 No Rental Agent 2Tenants housing has been Rental IncomeDebtors 60.00 22,551.69 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 395.20 22,946.89 31/12/2016 Invoice 1943 No Rental Agent 2BL- BL-Rental IncomeDebtors 450.00 23,396.89 31/12/2016 Invoice 1943 No Rental Agent 2BL- Rental IncomeDebtors 425.00 23,821.89 31/12/2016 Invoice 1943 No Rental Agent 2 Rental IncomeDebtors 578.62 24,400.51 Rental IncomeDebtors Total for Rental Income - Furnished £ 24,400.51 TOTAL £ 24,400.51 ABC - Rental Account Transaction Report Dec-16 Date Transaction Type No. Adj Name Memo/Description Account Split Amount Balance 166.40 Management fees 01/12/2016 Invoice 1934 No Rental Agent 1 Management fDebtors 166.40 02/12/2016 Invoice 1937 No Rental Agent 1 Management fDebtors 224.64 391.04 08/12/2016 Invoice 1952 No Rental Agent 3 Management fDebtors 111.00 502.04 12/12/2016 Invoice 1951 No Rental Agent 5 Management fDebtors 65.56 567.60 12/12/2016 Invoice 1904 No Rental Agent 4 Management fDebtors 118.80 686.40 15/12/2016 Invoice 1931 No Rental Agent 7 Management fDebtors 75.90 762.30 21/12/2016 Invoice 1948 No Rental Agent 1 Management fDebtors 93.60 855.90 21/12/2016 Invoice 1950 No Rental Agent 7 Management fDebtors 85.80 941.70 Rent-16/10/2016 to 15/11/2016 28/12/2016 Invoice 1947 No Rental Agent 1 Management fDebtors 105.60 1,047.30 30/12/2016 Invoice 1945 No Rental Agent 1 Management fDebtors 191.04 1,238.34 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 41.42 1,279.76 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.00 1,324.76 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 50.00 1,374.76 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 55.00 1,429.76 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.16 1,474.92 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 44.80 1,519.72 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 61.46 1,581.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.00 1,626.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 22.00 1,648.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 46.00 1,694.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 46.50 1,740.68 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 40.00 1,780.68 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 22.50 1,803.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.00 1,848.18 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 20.77 1,868.95 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 50.00 1,918.95 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.45 1,964.40 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 34.52 1,998.92 31/12/2016 Invoice 1949 No Rental Agent 6 Management fDebtors 79.79 2,078.71 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 42.50 2,121.21 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 34.52 2,155.73 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 35.89 2,191.62 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 25.00 2,216.62 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 42.85 2,259.47 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 6.00 2,265.47 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 39.52 2,304.99 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 45.00 2,349.99 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 42.50 2,392.49 31/12/2016 Invoice 1943 No Rental Agent 2 Management fDebtors 57.86 2,450.35 Total for Management fees £ 2,450.35 TOTAL £ 2,450.35 ABC - Rental Account Transaction Report Dec-16 Date Transaction Type No. Adj Name Memo/Descript ion Account Split Amount Balance Interest On Mortgage (Mortgage Expense) 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 188.28 188.28 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 214.07 402.35 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 1617 223.79 626.14 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 1617 337.15 963.29 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 1617 245.38 1,208.67 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 306.72 1,515.39 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 169.94 1,685.33 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 178.11 1,863.44 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 138.40 2,001.84 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 131.90 2,133.74 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 148.42 2,282.16 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 154.91 2,437.07 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 148.18 2,585.25 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 132.12 2,717.37 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 132.12 2,849.49 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 148.40 2,997.89 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 107.35 3,105.24 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 133.87 3,239.11 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 271.10 3,510.21 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 168.80 3,679.01 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 172.41 3,851.42 01/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 250.05 4,101.47 05/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.47 4,164.94 05/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.47 4,228.41 05/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 72.25 4,300.66 08/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 94.31 4,394.97 08/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 255.84 4,650.81 08/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 86.36 4,737.17 12/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 392.09 5,129.26 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 13.72 5,142.98 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 25.71 5,168.69 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 21.96 5,190.65 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 11.51 5,202.16 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 194.07 5,396.23 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 13.11 5,409.34 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 21.96 5,431.30 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 29.28 5,460.58 14/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 29.28 5,489.86 15/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 181.17 5,671.03 15/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.41 5,734.44 15/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 17.94 5,752.38 15/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 21.95 5,774.33 15/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 182.45 5,956.78 16/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 71.25 6,028.03 20/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 18.91 6,046.94 20/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 21.94 6,068.88 20/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 22.34 6,091.22 22/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 71.15 6,162.37 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.29 6,225.66 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.38 6,289.04 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.27 6,352.31 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.00 6,415.31 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 78.91 6,494.22 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 86.66 6,580.88 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 63.32 6,644.20 28/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 111.45 6,755.65 30/12/2016 Expense No xyz XYZ Interest On Mortgage (Mortgage Expense) ABC 6821 1,386.02 8,141.67 Total for Interest On Mortgage (Mortgage Expense) £ 8,141.67 TOTAL £ 8,141.67 ABC - Rental Account General Ledger Dec-16 Date Transaction Type No. Adj Name Memo/Description Split Amount Balance