Excel Fixed Asset Register

[howard]

I am looking for a Excel Fixed asset template that I can use for Fixed asset additions, depreciation and controlling disposals (sale of assets)

It would be appreciated if anyone can advise where I can download a termplate

 

[xenou]

I've never seen a good one.
You can get some canned software pretty cheap (probably) - I'd go that route if possible. Otherwise building it out yourself isn't very hard but is time consuming and usually requires a few iterations as you add or fix it. A good asset ledger gets very large as you need to be sure you capture a lot of key information - date acquired, date in service, salvage, method, convention, purchase information (PO, Vendor, Invoice). Then you have asset classes (maybe) or departments, serial numbers ... and possibly tax methods as well, and bonus depreciation taken, plus all your reports for depreciation and retirement. etc. etc. etc.

 

[howard]

Hi Xenou

Thanks for the reply. One can build ones own Fixed asset Register, but it is time consuming , but the end product would be great if designed correctly. One could also purchase an off the shelf product, but it it is not as flexible as creating one's own asset register. It is something I need to think about before making a decision

 

[dmt32]

I am looking for a Excel Fixed asset template that I can use for Fixed asset additions, depreciation and controlling disposals (sale of assets)

It would be appreciated if anyone can advise where I can download a termplate

couple of suggestions maybe?

Fixed asset record with depreciation - Templates - Office.com

Fixed asset record - Templates - Office.com

Free Asset Tracking Template for Excel by Vertex42

 

[howard]

Thanks for the reply & the links.

I found the link below to be very useful & I can be adapt this to suit my needs

Fixed asset record with depreciation - Templates - Office.com

 

[xenou]

How many assets do you need to keep track of (about)? Do you need to keep separate schedules of book and tax depreciation or are they both the same for you? I've built a couple of these over the years but usually for keeping track of additions and tying out to the assets to the general ledger. Though I have included depreciation too, usually to get an estimate. I take a dim view of templates because generally I never see any that would actually work the way I needed it to. But you do have to start somewhere.

 

[howard]

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

 

[xenou]

It looks alright for a start. I'd want to keep the raw data in a cleaner data table without the summaries in between. You can pull the summaries on a separate tab using SumIf or similar formulas to foot the items by class. calculating the depreciation is the sticky part. Either you create a procedure to update the prior year accumulated totals, or you fill out the yearly depreciation using a column for each year which you can use to sum up the depreciation up to the current year. Or if you are brave and trust your data you can re-calculate the depreciation on demand based on cost, method, and time. Either way, be sure to tie out to the ledger and keep backups at the end of each year. I would also include: Date Retired and Asset ID, and if applicable a model number and serial number for the asset (which could also be in the description rather than a separate field). It might be very helpful to have the Vendor, Invoice Number, Invoice Date, and PO Number. If you have dates then you can combine the report for additions with the other assets (since you just filter your data on the current year and that's your additions). Ditto for retirements.

 

[howard]

Hi Xenou

Thanks for the valuable input. I will take this into account when I set up my Asset Register

Regards


Howard

 

[jumpalongjim]

For anyone new to the search for a fixed asset register in Excel, I've posted my own best effort online for public use. Try it and use it if it meets your requirements. I've been using it without a hitch for many years: it's one of my all time favourite workbooks.
https://reconcilable.com/blog/worlds-best-excel-workbook-for-fixed-assets/