GL consolidated balance sheet r

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
Intangible Assets
95001
9358
BAL - Intangible Assets
00000
Default
60,000.00
314,129.08
254,129.08
95001
9359
BAL - Intangible Assets - Am 00000
Default
(12,000.00)
(60,000.00)
(48,000.00)
Intangible Assets
48,000.00
254,129.08
206,129.08
Intangible Assets
48,000.00
254,129.08
206,129.08
01A Intangible Assets
48,000.00
254,129.08
206,129.08
Community Assets
95001
9340
BAL - Community Assets
00000
Default
835,449.95
860,449.95
25,000.00
95001
9341
BAL - Community Assets -
00000
Default
(71,120.00)
(121,950.00)
(50,830.00)
Community Assets
764,329.95
738,499.95
(25,830.00)
Council Dwellings
95101
9301
BAL - Operational Assets -
00000
Default
577,681,652.69
594,625,175.16
16,943,522.47
95101
9311
BAL - Dwellings - Depreciat
00000
Default
0.00
(4,724,137.00)
(4,724,137.00)
Council Dwellings
577,681,652.69
589,901,038.16
12,219,385.47
Infrastructure Assets
95001
9330
BAL - Infrastructure Assets
00000
Default
534,773.31
534,773.31
0.00
95001
9331
BAL - Infrastructure Assets
00000
Default
(115,603.30)
(128,983.30)
(13,380.00)
95101
9330
BAL - Infrastructure Assets
00000
Default
0.00
161,700.86
161,700.86
Infrastructure Assets
419,170.01
567,490.87
148,320.86
Other Land and Buildings
95001
9310
BAL - Operational Assets -
00000
Default
78,320,278.60
78,084,660.87
(235,617.73)
95001
9311
BAL - Dwellings - Depreciat
00000
Default
(2,033,855.01)
(3,187,855.01)
(1,154,000.00)
95101
9310
BAL - Operational Assets -
00000
Default
7,069,312.00
7,143,974.91
74,662.91
95101
9312
BAL - Other Land & Building 00000
Default
(9,762.21)
(124,104.21)
(114,342.00)
95201
9310
BAL - Operational Assets -
00000
Default
4,960,210.22
6,408,969.22
1,448,759.00
95201
9311
BAL - Dwellings - Depreciat
00000
Default
(2.00)
(63,972.00)
(63,970.00)
Other Land and Buildings
88,306,181.60
88,261,673.78
(44,507.82)
Vehicle, plant , furniture & equipme 95001
9320
BAL - Vehicles Plant & Equ
00000
Default
2,560,696.43
3,067,028.09
506,331.66
95001
9321
BAL - Vehicles - Depreciatio 00000
Default
(891,194.33)
(1,464,911.33)
(573,717.00)
95201
9320
BAL - Vehicles Plant & Equ
00000
Default
6,116,610.14
6,464,620.23
348,010.09
95201
9321
BAL - Vehicles - Depreciatio 00000
Default
(2,611,451.60)
(3,203,400.60)
(591,949.00)
95201
9322
BAL - Plant & Equipment - D 00000
Default
(186,908.00)
(212,075.00)
(25,167.00)
Vehicle, plant , furniture & eq
4,987,752.64
4,651,261.39
(336,491.25)
01 OP Assets
672,159,086.89
684,119,964.15
11,960,877.26
Assets under construction
95001
9350
BAL - Non Operational Asse 99041
W.I.P
553,122.47
2,780,928.96
2,227,806.49
Page 1 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
Assets under construction
553,122.47
2,780,928.96
2,227,806.49
Investment Properties
95001
9350
BAL - Non Operational Asse 00000
Default
82,109,928.08
85,835,348.88
3,725,420.80
95001
9351
BAL - Non Operational Asse 00000
Default
(48,000.00)
(48,000.00)
0.00
95101
9350
BAL - Non Operational Asse 00000
Default
4,294,000.00
4,387,000.00
93,000.00
Investment Properties
86,355,928.08
90,174,348.88
3,818,420.80
Surplus assets, held for disposal
95001
9350
BAL - Non Operational Asse 99087
Surplus Assets
4,634,268.00
8,221,655.08
3,587,387.08
95101
9350
BAL - Non Operational Asse 99087
Surplus Assets
0.00
3,568,686.40
3,568,686.40
95101
9351
BAL - Non Operational Asse 99087
Surplus Assets
0.00
(18,686.40)
(18,686.40)
Surplus assets, held for disp
4,634,268.00
11,771,655.08
7,137,387.08
02 Non Op Assets
91,543,318.55
104,726,932.92
13,183,614.37
01B Tangible Assets
763,702,405.44
788,846,897.07
25,144,491.63
Long Term Debtors
95001
9360
BAL - Receivables More Th
00000
Default
892.72
892.72
0.00
95001
9501
BAL - Debtors - Deferred
00000
Default
100,643.00
88,211.00
(12,432.00)
95001
9501
BAL - Debtors - Deferred
99100
Grand Arcade L
0.00
244,445.00
244,445.00
95001
9501
BAL - Debtors - Deferred
99101
Private Sector H
453,617.00
527,609.11
73,992.11
95101
9360
BAL - Receivables More Th
00000
Default
132,718.07
91,236.82
(41,481.25)
Long Term Debtors
687,870.79
952,394.65
264,523.86
05 Long term Debtors
687,870.79
952,394.65
264,523.86
02A Long Term Debtors
687,870.79
952,394.65
264,523.86
Deferred Premium on early repaym 95001
9501
BAL - Debtors - Deferred
99587
Debt redemption
2,828,816.95
0.00
(2,828,816.95)
Deferred Premium on early re
2,828,816.95
0.00
(2,828,816.95)
Deferred Premium on early
2,828,816.95
0.00
(2,828,816.95)
02B Deferred Premium o
2,828,816.95
0.00
(2,828,816.95)
Cash and Bank
95001
9710
BAL - Petty Cash
00000
Default
3,220.00
3,245.00
25.00
95001
9711
BAL - Cash Floats
00000
Default
8,941.88
6,519.18
(2,422.70)
95001
9712
BAL - Cash
00000
Default
(33,397,765.74)
(29,000,748.25)
4,397,017.49
95101
9712
BAL - Cash
00000
Default
34,745,743.43
31,209,590.47
(3,536,152.96)
95201
9712
BAL - Cash
00000
Default
(1,928,124.03)
(1,882,333.53)
45,790.50
Cash and Bank
(567,984.46)
336,272.87
904,257.33
Debtors
95001
9520
BAL - Debtors - Payments i
00000
Default
451,742.28
407,275.08
(44,467.20)
Page 2 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
95001
9521
BAL - Debtors - Customs &
00000
Default
266,351.78
650,119.29
383,767.51
95001
9522
BAL - Debtors - Governmen 00000
Default
679,802.55
1,995,852.20
1,316,049.65
95001
9522
BAL - Debtors - Governmen 99580
NNDR
0.00
2,588,365.05
2,588,365.05
95001
9524
BAL - Debtors - Council Tax 99574
Council Tax
8,543,639.30
8,545,387.16
1,747.86
95001
9524
BAL - Debtors - Council Tax 99575
Council Tax Cos
455,846.20
561,087.20
105,241.00
95001
9525
BAL - Debtors - NNDR Pay
99580
NNDR
707,550.99
421,053.03
(286,497.96)
95001
9525
BAL - Debtors - NNDR Pay
99581
NNDR Costs
1,795.00
3,005.50
1,210.50
95001
9526
BAL - Debtors - Community
99576
Poll Tax
2,020.96
1,005.46
(1,015.50)
95001
9527
BAL - Debtors - Receivable
99024
External Debtors
2,165,715.00
2,288,330.06
122,615.06
95001
9532
BAL - Debtors - External Int
00000
Default
1,588,958.66
0.00
(1,588,958.66)
95001
9560
BAL - Debtors - Other Exter 00000
Default
1,079,493.06
1,147,858.49
68,365.43
95001
9560
BAL - Debtors - Other Exter 76952
189 Coolidge Ga
459.48
0.00
(459.48)
95001
9560
BAL - Debtors - Other Exter 99008
Unidentified Inco
(3,166.95)
2,251.49
5,418.44
95001
9560
BAL - Debtors - Other Exter 99056
8 Marmora Roa
334.28
334.28
0.00
95001
9560
BAL - Debtors - Other Exter 99060
49 Madingley Ro
426.40
426.40
0.00
95001
9560
BAL - Debtors - Other Exter 99061
1 The Westering
105.75
105.75
0.00
95001
9560
BAL - Debtors - Other Exter 99085
Bailey Mews / 2
106.93
106.93
0.00
95001
9560
BAL - Debtors - Other Exter 99086
41A - 49 Mading
426.40
426.40
0.00
95001
9560
BAL - Debtors - Other Exter 99091
1b High Street,
4,694.40
0.00
(4,694.40)
95001
9560
BAL - Debtors - Other Exter 99097
Collection Fund
0.00
259,427.56
259,427.56
95001
9580
BAL - Bad Debts Provision
99574
Council Tax
(3,592,089.35)
(3,716,289.58)
(124,200.23)
95001
9581
BAL - Bad Debts Provision
99576
Poll Tax
(2,020.96)
(1,005.46)
1,015.50
95001
9582
BAL - Bad Debts Provision
00000
Default
(844,511.19)
(978,658.27)
(134,147.08)
95001
9939
BAL - Parliamentary Electio
00000
Default
(219.34)
(219.34)
0.00
95101
9520
BAL - Debtors - Payments i
00000
Default
84,651.07
80,761.84
(3,889.23)
95101
9522
BAL - Debtors - Governmen 00000
Default
26,183.00
11,521.00
(14,662.00)
95101
9523
BAL - Debtors - Tenants
00000
Default
1,198,751.84
1,309,799.10
111,047.26
95101
9560
BAL - Debtors - Other Exter 00000
Default
90,245.00
1,205.00
(89,040.00)
95101
9582
BAL - Bad Debts Provision
00000
Default
(847,919.33)
(917,661.28)
(69,741.95)
95201
9560
BAL - Debtors - Other Exter 00000
Default
59,022.55
147,197.31
88,174.76
Debtors
12,118,395.76
14,809,067.65
2,690,671.89
Investments
95001
9600
BAL - Investments - Surplus 00000
Default
73,740,000.00
68,500,000.00
(5,240,000.00)
95001
9600
BAL - Investments - Surplus 99099
Investment Inter
0.00
1,521,988.16
1,521,988.16
95001
9601
BAL - Investments - Other
00000
Default
100.00
100.00
0.00
Page 3 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
Investments
73,740,100.00
70,022,088.16
(3,718,011.84)
Stocks and works in progress
95001
9370
BAL - Stock - General
00000
Default
51,518.16
54,627.36
3,109.20
95201
9370
BAL - Stock - General
01223
Stock-Printing
2,151.20
0.00
(2,151.20)
95201
9371
BAL - Stock - CPlus System 00000
Default
230,400.48
267,958.82
37,558.34
95201
9390
BAL - Work in Progress
00000
Default
21,767.01
35,648.36
13,881.35
Stocks and works in progres
305,836.85
358,234.54
52,397.69
03 Current Assets
85,596,348.15
85,525,663.22
(70,684.93)
03 Current assets
85,596,348.15
85,525,663.22
(70,684.93)
Creditors
95001
9649
BAL - Creditors - Sub Contr
00000
Default
(10,764.69)
(1,717.51)
9,047.18
95001
9651
BAL - Creditors - Inland Rev 00000
Default
(188.59)
0.00
188.59
95001
9651
BAL - Creditors - Inland Rev 99010
Mortgage & Bon
(6.09)
0.00
6.09
95001
9652
BAL - Creditors - Governme 00000
Default
(268,896.00)
(439,493.00)
(170,597.00)
95001
9652
BAL - Creditors - Governme 99580
NNDR
(228,943.94)
0.00
228,943.94
95001
9653
BAL - Creditors - Payables
00000
Default
(4,195,882.27)
(6,685,149.89)
(2,489,267.62)
95001
9656
BAL - Creditors - Quasi Age 00000
Default
0.00
4,959.90
4,959.90
95001
9657
BAL - Creditors - Taxi Plate
00000
Default
1,938.00
(13,982.00)
(15,920.00)
95001
9658
BAL - Creditors - Other Dep 99027
Property Rent
(260,526.17)
(326,013.89)
(65,487.72)
95001
9660
BAL - Creditors - Capital Ex 00000
Default
(1,028,242.37)
(315,547.26)
712,695.11
95001
9680
BAL - Creditors - Others
00000
Default
(2,952,627.69)
(1,980,334.25)
972,293.44
95001
9680
BAL - Creditors - Others
99011
PROVISION - A
(1,242.06)
0.00
1,242.06
95001
9680
BAL - Creditors - Others
99051
Key Deposit
(180.00)
(280.00)
(100.00)
95001
9680
BAL - Creditors - Others
99080
Private Hire Tra
(3,660.00)
(6,830.00)
(3,170.00)
95001
9680
BAL - Creditors - Others
99081
Taxi Transpond
(7,568.00)
(9,598.00)
(2,030.00)
95001
9680
BAL - Creditors - Others
99089
Capital Contribu
(1,062,516.18)
(3,519,405.23)
(2,456,889.05)
95001
9680
BAL - Creditors - Others
99095
Capital Cost of E
(56,950.54)
0.00
56,950.54
95001
9680
BAL - Creditors - Others
99096
Capital Cost of E
(50,599.00)
0.00
50,599.00
95001
9680
BAL - Creditors - Others
99097
Collection Fund
(591,236.05)
0.00
591,236.05
95101
9652
BAL - Creditors - Governme 00000
Default
(1,207,768.56)
(26,070.87)
1,181,697.69
95101
9660
BAL - Creditors - Capital Ex 00000
Default
(593,459.61)
(422,569.95)
170,889.66
95101
9680
BAL - Creditors - Others
00000
Default
(115,343.35)
(136,602.38)
(21,259.03)
95101
9680
BAL - Creditors - Others
69228
Tenants - Rent P
(497,850.33)
(565,220.53)
(67,370.20)
95101
9680
BAL - Creditors - Others
99084
Creditor for NW
(20,243.20)
(20,243.20)
0.00
95201
9680
BAL - Creditors - Others
00000
Default
(183,703.39)
(178,889.35)
4,814.04
Page 4 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £  Total Balance to Date £
Code
Code
Name
Spend   £
Code
Creditors
(13,336,460.08)
(14,642,987.41)
(1,306,527.33)
Receipts in advance
95001
9700
BAL - Council Tax - Receip
00000
Default
(2,312,413.02)
(2,446,267.00)
(133,853.98)
95001
9701
BAL - NNDR - Receipts in A 00000
Default
(1,325,826.81)
(1,167,230.65)
158,596.16
95001
9702
BAL - Other - Receipts in A
00000
Default
(646,555.29)
(886,675.09)
(240,119.80)
95001
9702
BAL - Other - Receipts in A
99024
External Debtors
(105,350.35)
(156,536.68)
(51,186.33)
95001
9702
BAL - Other - Receipts in A
99088
S106 Maintenan
(304,903.36)
(695,355.83)
(390,452.47)
95101
9702
BAL - Other - Receipts in A
00000
Default
(47.40)
0.00
47.40
Receipts in advance
(4,695,096.23)
(5,352,065.25)
(656,969.02)
Temporary Loans*
95001
9610
BAL - Borrowing - Tempora
00000
Default
(1,430,021.94)
0.00
1,430,021.94
Temporary Loans*
(1,430,021.94)
0.00
1,430,021.94
04 Current Liabilities
(19,461,578.25)
(19,995,052.66)
(533,474.41)
04 Current Liabilities
(19,461,578.25)
(19,995,052.66)
(533,474.41)
Creditors repayable in more than 1
95001
9680
BAL - Creditors - Others
99090
Capital Contribu
(4,771,171.92)
(2,645,493.99)
2,125,677.93
Creditors repayable in more
(4,771,171.92)
(2,645,493.99)
2,125,677.93
04B Creditors repayable in
(4,771,171.92)
(2,645,493.99)
2,125,677.93
Capital Contributions Unapplied
95001
9735
BAL - Capital Contributions  99041
W.I.P
(295,344.05)
(365,034.14)
(69,690.09)
95001
9736
BAL - Developers Contribut
00000
Default
(3,088,814.45)
(3,673,209.33)
(584,394.88)
95001
9961
BAL - PDG earmarked for c
00000
Default
0.00
(187,454.67)
(187,454.67)
95101
9736
BAL - Developers Contribut
00000
Default
(34,955.38)
(34,955.38)
0.00
Capital Contributions Unapp
(3,419,113.88)
(4,260,653.52)
(841,539.64)
06A Capital Contributions
(3,419,113.88)
(4,260,653.52)
(841,539.64)
Government Grants - deferred
95001
9735
BAL - Capital Contributions  00000
Default
(2,438,134.91)
(2,606,608.67)
(168,473.76)
95001
9735
BAL - Capital Contributions  99043
Parkside Swimm
(6,278,745.77)
(6,109,049.94)
169,695.83
95001
9735
BAL - Capital Contributions  99069
Nuns Way
(11,327.08)
(10,297.35)
1,029.73
95001
9735
BAL - Capital Contributions  99070
125 Newmarket
(467,300.00)
(467,300.00)
0.00
95001
9735
BAL - Capital Contributions  99071
Trumpington Re
(12,112.51)
(10,766.68)
1,345.83
95001
9735
BAL - Capital Contributions  99072
Trumpington Re
(58,736.96)
(52,210.63)
6,526.33
95001
9735
BAL - Capital Contributions  99073
Donkey Commo
(19,719.70)
(16,902.60)
2,817.10
95001
9735
BAL - Capital Contributions  99074
Cherry Hinton F
(18,458.36)
(17,959.48)
498.88
95001
9735
BAL - Capital Contributions  99075
St Matthews Pla
(24,331.22)
(21,627.75)
2,703.47
95001
9735
BAL - Capital Contributions  99076
Public Convenie
(6,818.19)
(6,590.92)
227.27
Page 5 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £  Total Balance to Date £
Code
Code
Name
Spend   £
Code
95001
9735
BAL - Capital Contributions  99077
Green Waste Co
(77,202.87)
(57,902.16)
19,300.71
95001
9735
BAL - Capital Contributions  99078
Youth Minibus
(22,400.00)
(19,200.00)
3,200.00
95101
9735
BAL - Capital Contributions  00000
Default
(43,785.00)
(142,393.47)
(98,608.47)
Government Grants - deferre
(9,479,072.57)
(9,538,809.65)
(59,737.08)
06 Gov Grants Deferred
(9,479,072.57)
(9,538,809.65)
(59,737.08)
Provisions*
95001
9750
BAL - Provisions
00000
Default
(366,278.40)
(336,075.17)
30,203.23
95201
9750
BAL - Provisions
00000
Default
(141,483.82)
(141,002.61)
481.21
Provisions*
(507,762.22)
(477,077.78)
30,684.44
08 Provisions
(507,762.22)
(477,077.78)
30,684.44
Asset/Liability related to defined be 95001
9725
BAL - Pension Asset / (Liab
00000
Default
(35,672,000.00)
(26,287,000.00)
9,385,000.00
Asset/Liability related to defi
(35,672,000.00)
(26,287,000.00)
9,385,000.00
09 Asset/Liability related t
(35,672,000.00)
(26,287,000.00)
9,385,000.00
05 Liabilities
(53,849,120.59)
(43,209,034.94)
10,640,085.65
Capital Receipts Deferred
95001
9740
BAL - Deferred Capital Rec
00000
Default
(100,643.00)
(88,211.00)
12,432.00
95101
9740
BAL - Deferred Capital Rec
00000
Default
(133,006.49)
(91,525.24)
41,481.25
Capital Receipts Deferred
(233,649.49)
(179,736.24)
53,913.25
07 Cap Receipts Deferred
(233,649.49)
(179,736.24)
53,913.25
Usable Capital Receipts reserve
95001
9790
BAL - Usable Capital Recei
99016
Sale of Land
(995,048.26)
(2,144,848.26)
(1,149,800.00)
95001
9790
BAL - Usable Capital Recei
99019
Loan Repaymen
0.00
(12,432.00)
(12,432.00)
95001
9790
BAL - Usable Capital Recei
99505
Earmarked land
0.00
(303,349.45)
(303,349.45)
95101
9790
BAL - Usable Capital Recei
99016
Sale of Land
(2,476,144.08)
(2,418,255.08)
57,889.00
95101
9790
BAL - Usable Capital Recei
99020
Sale of RTB Dw
(18,268,958.51)
(14,918,802.75)
3,350,155.76
95101
9790
BAL - Usable Capital Recei
99021
Shared Owners
(410,791.82)
(696,588.82)
(285,797.00)
95101
9790
BAL - Usable Capital Recei
99022
RTB Discount R
(226,665.94)
(383,802.31)
(157,136.37)
95101
9790
BAL - Usable Capital Recei
99544
Land & Non RTB
(814,111.00)
(872,000.00)
(57,889.00)
Usable Capital Receipts rese
(23,191,719.61)
(21,750,078.67)
1,441,640.94
12 Usable Capital Receipts
(23,191,719.61)
(21,750,078.67)
1,441,640.94
Pensions reserve
95001
9765
BAL - Pension Reserve
00000
Default
35,672,000.00
26,287,000.00
(9,385,000.00)
Pensions reserve
35,672,000.00
26,287,000.00
(9,385,000.00)
Page 6 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
13 Pensions Reserve
35,672,000.00
26,287,000.00
(9,385,000.00)
Collection Fund
95001
9991
BAL - Collection Fund Defic 00000
Default
(77,897.14)
34,035.28
111,932.42
Collection Fund
(77,897.14)
34,035.28
111,932.42
14 Collection Fund
(77,897.14)
34,035.28
111,932.42
Earmarked reserves
95001
9874
BAL - Property Improvemen 00000
Default
(157,172.11)
(162,225.59)
(5,053.48)
95001
9879
BAL - Partnership Projects
00000
Default
(38,003.32)
(29,327.40)
8,675.92
95001
9880
BAL - David Urwin Award
00000
Default
(4,838.90)
(4,862.70)
(23.80)
95001
9881
BAL - Disabled Access Gra
00000
Default
(47,700.58)
(68,943.58)
(21,243.00)
95001
9884
BAL - Consultation Program 00000
Default
(79,476.60)
(53,808.66)
25,667.94
95001
9887
BAL - Counsels Fees
00000
Default
0.00
7,346.70
7,346.70
95001
9891
BAL - Community Developm 00000
Default
(24,686.95)
(35,003.86)
(10,316.91)
95001
9893
BAL - EASTERN REGION W 00000
Default
(2,659.68)
0.00
2,659.68
95001
9894
BAL - LAPE A/C earmarked 00000
Default
(469,198.05)
(561,669.36)
(92,471.31)
95001
9897
BAL - Cambridge LSP Joint
00000
Default
(4,456.00)
(3,818.50)
637.50
95001
9898
BAL - Mapping Poverty Res 00000
Default
(172.75)
(3,172.75)
(3,000.00)
95001
9908
BAL - PDPs (Priority Develo 00000
Default
7,600.33
7,600.33
0.00
95001
9922
BAL - Insurance Fund
00000
Default
(397,782.72)
(459,701.02)
(61,918.30)
95001
9924
BAL - Prince Chula Beques
00000
Default
(100.00)
(100.00)
0.00
95001
9925
BAL - Historic Buildings Act
00000
Default
(5,538.74)
(5,062.94)
475.80
95001
9926
BAL - Efficiency Fund
00000
Default
(172,096.00)
0.00
172,096.00
95001
9929
BAL - Private Hire - Surplus 00000
Default
32,606.54
28,225.10
(4,381.44)
95001
9930
BAL - Street Trading - Surp
00000
Default
471.21
(3,815.40)
(4,286.61)
95001
9931
BAL - Kick About Site - St A 00000
Default
(41,710.80)
(43,959.79)
(2,248.99)
95001
9932
BAL - Taxis Surplus/Deficit
00000
Default
14,609.72
6,780.45
(7,829.27)
95001
9933
BAL - Asset Renewal Rese
00000
Default
(6,758,018.56)
(7,096,320.01)
(338,301.45)
95001
9941
BAL - Development Plan Fu 00000
Default
(29,768.66)
(46,226.08)
(16,457.42)
95001
9942
BAL - Rating Revaluation A
00000
Default
(21,890.38)
(21,890.38)
0.00
95001
9944
BAL - Technology Investme 00000
Default
(894,302.47)
(558,482.33)
335,820.14
95001
9946
BAL - Building Control
00000
Default
(13,787.58)
(15,079.57)
(1,291.99)
95001
9947
BAL - Finance General rech 00000
Default
(193.84)
(193.84)
0.00
95001
9948
BAL - Commutation Adjustm 00000
Default
(887,130.00)
(887,130.00)
0.00
95001
9950
BAL - Housing Fitness & En 00000
Default
(41,590.00)
(56,620.00)
(15,030.00)
Page 7 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £  Total Balance to Date £
Code
Code
Name
Spend   £
Code
95001
9951
BAL - Housing Needs Study 00000
Default
(15,360.00)
(3,500.00)
11,860.00
95001
9953
BAL - Access Scheme
00000
Default
(82,087.45)
(119,773.86)
(37,686.41)
95001
9954
BAL - 70 Rock Road (CPO)
00000
Default
(335,003.69)
(351,753.87)
(16,750.18)
95001
9955
BAL - Revenue Contribution 00000
Default
(545,380.00)
(336,900.00)
208,480.00
95001
9956
BAL - Major Planning Appe
00000
Default
(233,297.78)
(38,227.36)
195,070.42
95001
9957
BAL - 68 Keynes Road (CP
00000
Default
0.00
(216,770.49)
(216,770.49)
95001
9958
BAL - Fixed Penalty Notices 00000
Default
(502.55)
(4,267.55)
(3,765.00)
95001
9962
BAL - Grand Arcade Lease  00000
Default
0.00
(244,445.00)
(244,445.00)
95101
9933
BAL - Asset Renewal Rese
00000
Default
(1,147,237.12)
(1,316,610.41)
(169,373.29)
95101
9945
BAL - Shared Ownership
00000
Default
(300,000.00)
(300,000.00)
0.00
95101
9952
BAL - Tenants Triennial Su
00000
Default
(16,861.50)
(22,381.50)
(5,520.00)
95101
9999
BAL - Balances
99048
CareCall Legacy
(10,073.70)
(10,073.70)
0.00
Earmarked reserves
(12,722,790.68)
(13,032,164.92)
(309,374.24)
15 Earmarked Reserves
(12,722,790.68)
(13,032,164.92)
(309,374.24)
General Fund
95001
9999
BAL - Balances
00000
Default
(12,318,452.35)
(13,616,486.71)
(1,298,034.36)
General Fund
(12,318,452.35)
(13,616,486.71)
(1,298,034.36)
16 General Fund
(12,318,452.35)
(13,616,486.71)
(1,298,034.36)
Housing Revenue Account
95101
9999
BAL - Balances
00000
Default
(6,702,125.30)
(6,590,553.19)
111,572.11
Housing Revenue Account
(6,702,125.30)
(6,590,553.19)
111,572.11
17 HRA
(6,702,125.30)
(6,590,553.19)
111,572.11
DSO
95201
9934
BAL - Asset Renewal Rese
00000
Default
(1,190,479.33)
(1,253,407.24)
(62,927.91)
95201
9935
BAL - Asset Renewal Rese
00000
Default
(3,078,953.99)
(3,551,645.82)
(472,691.83)
DSO
(4,269,433.32)
(4,805,053.06)
(535,619.74)
18 DSO
(4,269,433.32)
(4,805,053.06)
(535,619.74)
Capital Adjustment Account
95001
9780
BAL - Capital Adjustment A
91021
Commutation Ad
887,130.00
887,130.00
0.00
95001
9780
BAL - Capital Adjustment A
99000
TCA-Interest
(192,105.00)
(192,105.00)
0.00
95001
9780
BAL - Capital Adjustment A
99002
Write Down of D
41,864,917.32
43,201,870.50
1,336,953.18
95001
9780
BAL - Capital Adjustment A
99003
Capital Receipts
(14,770,938.62)
(15,033,825.89)
(262,887.27)
95001
9780
BAL - Capital Adjustment A
99004
Direct Revenue
(54,712,290.93)
(59,331,207.99)
(4,618,917.06)
95001
9780
BAL - Capital Adjustment A
99005
Reserved Capita
(26,769,742.98)
(26,769,742.98)
0.00
Page 8 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
95001
9780
BAL - Capital Adjustment A
99006
MRP Net of Dep
12,421,786.65
15,883,990.65
3,462,204.00
95001
9780
BAL - Capital Adjustment A
99007
Write Down of D
1,630,881.33
1,646,118.05
15,236.72
95001
9780
BAL - Capital Adjustment A
99012
De Minimus Cap
9,858,451.91
10,270,399.97
411,948.06
95001
9780
BAL - Capital Adjustment A
99052
Capital Contribu
(1,435,622.19)
(1,866,775.30)
(431,153.11)
95001
9780
BAL - Capital Adjustment A
99098
Transfer of Fixe
(130,467,427.04)
(129,060,807.04)
1,406,620.00
95001
9780
BAL - Capital Adjustment A
99101
Private Sector H
(453,617.00)
(453,617.00)
0.00
95101
9780
BAL - Capital Adjustment A
99000
TCA-Interest
(75,635.53)
(75,635.53)
0.00
95101
9780
BAL - Capital Adjustment A
99001
Credit Arrangem
(304,475.00)
(304,475.00)
0.00
95101
9780
BAL - Capital Adjustment A
99002
Write Down of D
1,796,614.55
1,796,614.55
0.00
95101
9780
BAL - Capital Adjustment A
99003
Capital Receipts
(35,798,838.29)
(41,749,583.46)
(5,950,745.17)
95101
9780
BAL - Capital Adjustment A
99004
Direct Revenue
(9,690,010.12)
(12,858,172.42)
(3,168,162.30)
95101
9780
BAL - Capital Adjustment A
99005
Reserved Capita
(47,682,289.68)
(47,682,289.68)
0.00
95101
9780
BAL - Capital Adjustment A
99006
MRP Net of Dep
(4,805,755.22)
(62,931.82)
4,742,823.40
95101
9780
BAL - Capital Adjustment A
99007
Write Down of D
99,871.49
99,871.49
0.00
95101
9780
BAL - Capital Adjustment A
99012
De Minimus Cap
2,269,264.65
2,319,148.59
49,883.94
95101
9780
BAL - Capital Adjustment A
99052
Capital Contribu
0.00
(568.64)
(568.64)
95101
9780
BAL - Capital Adjustment A
99053
Major Repairs R
(28,292,512.09)
(33,276,136.09)
(4,983,624.00)
95101
9780
BAL - Capital Adjustment A
99054
Transfer to Majo
41,140,271.00
48,731,061.00
7,590,790.00
95101
9780
BAL - Capital Adjustment A
99098
Transfer of Fixe
(509,612,619.20)
(505,368,782.20)
4,243,837.00
95201
9780
BAL - Capital Adjustment A
99000
TCA-Interest
(56,655.00)
(56,655.00)
0.00
95201
9780
BAL - Capital Adjustment A
99098
Transfer of Fixe
(2,557,329.61)
(2,517,923.61)
39,406.00
Capital Adjustment Account
(755,708,674.60)
(751,825,029.85)
3,883,644.75
Capital Adjustment Accou
(755,708,674.60)
(751,825,029.85)
3,883,644.75
Financial Instruments Adjustment A 95001
9781
BAL - Financial Instruments 99101
Private Sector H
0.00
121,749.00
121,749.00
95001
9781
BAL - Financial Instruments 99587
Debt redemption
0.00
2,284,040.95
2,284,040.95
Financial Instruments Adjust
0.00
2,405,789.95
2,405,789.95
Financial Instruments Adju
0.00
2,405,789.95
2,405,789.95
Revaluation Reserve
95001
9760
BAL - Revaluation Reserve
00000
Default
0.00
(9,121,061.00)
(9,121,061.00)
95101
9760
BAL - Revaluation Reserve
00000
Default
0.00
(19,004,158.01)
(19,004,158.01)
95201
9760
BAL - Revaluation Reserve
00000
Default
0.00
(1,177,500.00)
(1,177,500.00)
Revaluation Reserve
0.00
(29,302,719.01)
(29,302,719.01)
Revaluation Reserve
0.00
(29,302,719.01)
(29,302,719.01)
Page 9 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department

Consolidated Balance Sheet
Cost
Account
Analysis
Analysis
Current Year
CBS Description
Centre
Account Name
Balances b/f £ Total Balance to Date £
Code
Code
Name
Spend £
Code
06 Financed By
(779,552,742.49)
(812,374,996.42)
(32,822,253.93)
TOTAL
(0.00)
(0.00)
(0.00)
Page 10 of 10
GL consolidated balance sheet reporting 2007-08.rep using GL run by MAIN01C on 06/06/08 at 11:48:20
Designed by : Cambridge City Council, Finance Department