Hi Xenou
Thanks for the reply
I have looked at a number of templates on Google and none of them are suitable
I would need a Fixed Asset register that would give me the following reports
1) Book value report showing asset #, Cost Price, Prior Year Depr, Current Month Dep, YTD Dep, Accumulated Dep., Net Book Value-this report must be by department
The depreciation is on a straight line basis and the % depends on the asset category for eg P & M = 20%, F & F = 16.67%-see sample
2) Purchases Report -showing assets purchased-see attached sample
3) Disposals report-see attached sample
<b>Page 1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:202px;" /><col style="width:151px;" /><col style="width:69px;" /><col style="width:65px;" /><col style="width:121px;" /><col style="width:65px;" /><col style="width:125px;" /><col style="width:76px;" /><col style="width:103px;" /><col style="width:111px;" /><col style="width:84px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="color:#0000ff; font-family:Trebuchet MS; font-size:14pt; text-align:left; ">BR1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Page :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td></tr><tr style="height:27px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:; font-size:15pt; text-align:left; ">Book Value Report as at End of September 2012</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Date :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">1/09/2011</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Time :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">10:43</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:; font-size:8pt; text-align:left; ">Asset No.</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Description</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Purchased</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Type</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Quantity</td><td style="font-family:; font-size:8pt; text-align:left; ">Cost Price</td><td style="font-family:; font-size:8pt; text-align:left; ">Prior Years Depr Month-To-Date Depr</td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Year-To-Date Depr</td><td style="font-family:; font-size:8pt; text-align:left; ">Accumulated Depr</td><td style="font-family:; font-size:8pt; text-align:left; ">Net Book Value</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:; font-size:8pt; text-align:left; ">* Group:</td><td style="font-family:; font-size:8pt; text-align:left; ">CORPORATE SIGNAGE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:; font-size:8pt; text-align:left; ">** Cost Centre: Br1</td><td style="color:#800000; font-weight:bold; font-family:Tahoma; font-size:8pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:NEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">NEW VEHICLES</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2928.47 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">536.89 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">48.81 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">585.69 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1122.58 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1805.89 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Br1</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2928.47 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">536.89 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">48.81 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">585.69 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1122.58 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1805.89 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:; font-size:8pt; text-align:left; ">** Cost Centre:</td><td style="color:#800000; font-weight:bold; font-family:Tahoma; font-size:8pt; text-align:left; ">Br1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:NEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">NEW VEHICLES</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2119.67 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1379.21 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">13.99 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">189.18 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1568.39 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">551.27 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:SERVICE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SERVICE</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">161.87 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">159.17 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2.70 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">161.87 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:USED VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">USED VEHICLES</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1080.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1062.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">18.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1080.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; "> </td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">10 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3361.53 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2600.38 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">13.99 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">209.88 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2810.26 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">551.27 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-family:; font-size:8pt; text-align:left; ">* TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">CORPORATE SIGNAGE</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">11 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">6290.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3137.27 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">62.81 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">795.57 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3932.84 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2357.16 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-family:; font-size:8pt; text-align:left; ">* Group:</td><td style="font-family:; font-size:8pt; text-align:left; ">FURNITURE & FITTINGS</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="font-family:; font-size:8pt; text-align:left; ">** Cost Centre:</td><td style="color:#800000; font-weight:bold; font-family:Tahoma; font-size:8pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:NEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">NEW VEHICLES</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">6 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1426.49 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">204.21 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">19.83 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">237.80 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">442.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">984.49 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Department:SERVICE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SERVICE</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">6 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1288.40 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">193.14 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">17.91 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">214.78 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">407.92 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">880.48 </td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4
<b>Page 2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:92px;" /><col style="width:167px;" /><col style="width:101px;" /><col style="width:123px;" /><col style="width:81px;" /><col style="width:73px;" /><col style="width:80px;" /><col style="width:120px;" /><col style="width:115px;" /><col style="width:84px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="color:#0000ff; font-family:Trebuchet MS; font-size:14pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Page :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:right; ">2 </td></tr><tr style="height:28px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:; font-size:16pt; text-align:left; ">Purchases Report (Book Values) For 1/10/2011 To 30/09/2012</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Date :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">30/09/2010</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Time :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">13:58</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:; font-size:8pt; text-align:left; ">Asset No.</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Description</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Location</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Purchased</td><td style="font-family:; font-size:8pt; text-align:left; ">Start Depr.</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Type</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Quantity</td><td style="font-family:; font-size:8pt; text-align:left; ">Cost Price</td><td style="font-family:; font-size:8pt; text-align:left; ">YTD Depr</td><td style="font-family:; font-size:8pt; text-align:left; ">Net Book Value</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:; font-size:8pt; text-align:left; ">* TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">FURNITURE & FITTINGS</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 16.67</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">13 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">42,068.32 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:; font-size:8pt; text-align:left; ">* Group:</td><td style="font-family:; font-size:8pt; text-align:left; ">OFFICE EQUIPMENT</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:; font-size:8pt; text-align:left; ">** Department:</td><td style="font-family:; font-size:8pt; text-align:left; ">NEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Cost Centre: BR1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">LAND ROVER</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">NEW VEHICLES</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:; font-size:8pt; text-align:left; ">* TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">OFFICE EQUIPMENT</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:; font-size:8pt; text-align:left; ">* Group:</td><td style="font-family:; font-size:8pt; text-align:left; ">PLANT & MACHINERY</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:; font-size:8pt; text-align:left; ">** Department:</td><td style="color:#800000; font-weight:bold; font-family:Tahoma; font-size:8pt; text-align:left; ">SERVICE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Cost Centre: Br1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">BR1</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">8 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">139,315.46 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FOR</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SERVICE</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">8 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">139,315.46 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-family:; font-size:8pt; text-align:left; ">* TOTALS FOR</td><td style="font-family:; font-size:8pt; text-align:left; ">PLANT & MACHINERY</td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">SL 20%</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">8 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">139,315.46 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-family:; font-size:8pt; text-align:left; ">COMPANY TOTALS</td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">24 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">236,349.78 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="color:#c0c0c0; font-family:Tahoma; font-size:8pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4
<b>Page 1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:32px;" /><col style="width:32px;" /><col style="width:157px;" /><col style="width:65px;" /><col style="width:65px;" /><col style="width:65px;" /><col style="width:32px;" /><col style="width:75px;" /><col style="width:65px;" /><col style="width:91px;" /><col style="width:116px;" /><col style="width:120px;" /><col style="width:101px;" /><col style="width:72px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td></tr><tr style="height:25px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="color:#0000ff; font-family:Trebuchet MS; font-size:14pt; "> </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Page :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td></tr><tr style="height:28px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-family:; font-size:16pt; text-align:left; ">Disposals Report (Book Values) For October 2011 To May 2012</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Date :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">1/05/2012</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Time :</td><td style="color:#808080; font-family:Tahoma; font-size:8pt; text-align:left; ">10:40</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:; font-size:8pt; text-align:left; ">Asset No.</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Description</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Type</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">PeriodPurchased</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Sold</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Quantity</td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">Cost Price</td><td style="font-family:; font-size:8pt; text-align:left; ">Accumulated Depr.</td><td style="font-family:; font-size:8pt; text-align:left; ">Net Book Value</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Proceeds</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">Profit</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-family:; font-size:8pt; text-align:left; ">* Group:</td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">CORPORATE SIGNAGE</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:; font-size:8pt; text-align:left; ">** Department: NEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Cost Centre: BR1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1013 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">01</td><td style="font-family:; font-size:8pt; text-align:left; ">CORPORATE SIGNAGE</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SCRAPPED</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/02/2007</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/01/2012</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">63,027.50 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">63,027.47 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.03 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-0.03 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1073 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">01</td><td style="font-family:; font-size:8pt; text-align:left; ">CORPORATE SIGNAGE</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SCRAPPED</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2007</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/01/2012</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">80,500.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">75,133.31 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5,366.69 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-5,366.69 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">FIAT EASTERN CAPE</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2007</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">143,527.50 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">138,160.78 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5,366.72 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-5,366.72 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FORNEW VEHICLES</td><td > </td><td > </td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2007</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">143,527.50 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">138,160.78 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5,366.72 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-5,366.72 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:; font-size:8pt; text-align:left; ">** Department: USED</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:; font-size:8pt; text-align:left; ">*** Cost Centre: BR1</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1089 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">01</td><td style="font-family:; font-size:8pt; text-align:left; ">SIGNAGE - CHROMADEK</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SCRAPPED</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/05/2008</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/01/2012</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">7,459.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5,594.22 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1,864.78 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-1,864.78 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1097 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">01</td><td style="font-family:; font-size:8pt; text-align:left; ">NOTICE BOARDS</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SCRAPPED</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/07/2008</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/01/2012</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2,955.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">2,117.75 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">837.25 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-837.25 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1102 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">01</td><td style="font-family:; font-size:8pt; text-align:left; ">SIGNAGE BOARDS</td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">SCRAPPED</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4 </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2009</td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/01/2012</td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3,688.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1,966.91 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">1,721.09 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-1,721.09 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-family:; font-size:8pt; text-align:left; ">*** TOTALS FOR</td><td > </td><td style="font-family:; font-size:8pt; text-align:left; ">FIAT EASTERN CAPE</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2009</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">14,102.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">9,678.88 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4,423.12 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-4,423.12 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-family:; font-size:8pt; text-align:left; ">** TOTALS FORUSED</td><td > </td><td > </td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2009</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">3 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">14,102.00 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">9,678.88 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">4,423.12 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-4,423.12 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-family:; font-size:8pt; text-align:left; ">* TOTALS FOR CORPORATE SIGNAGE</td><td > </td><td > </td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:left; ">1/06/2009</td><td > </td><td > </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">5 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">157,629.50 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">147,839.66 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">9,789.84 </td><td style="font-family:Tahoma; font-size:8pt; text-align:right; ">0.00 </td><td style="color:#ff0000; font-family:Tahoma; font-size:8pt; text-align:right; ">-9,789.84 </td></tr></table> <br />
Excel tables to the web - Excel Jeanie Html 4