Fixed Asset Register

PNGBill

Win10 Office Pro 2016
Local time
Tomorrow, 08:54
Joined
Jul 15, 2008
Messages
2,271
We are doing our annual accounts and have inherited a complicated and confusing excel spreadsheet Fixed Asset Register.

I believe access will handle this issue much better then excel.

Question is.. should I include the tables for this in our current database or make a new database. Current db is just under 400mb.
New one will be small but no activities are related.

Does anyone have such an animal kicking around that I can start with??
Not trying to be lazy here but need to resolve the depreciation schedule soon.

Regards, Bill
 
personally, i would make a new dbs - its probably only vaguely unrelated to your existing accounts databases, and would be more easily used standalone
 
Thanks for feedback - will do a new one.

Can quickly make one up and add features as time allows.
 
Access 2000 has an Asset Register that creates automatically - just saved myself a bit of work.:D
 
The important bit is many tax authorities outside the US use Diminshing Value depreciation, something that is not always appreciated in the US.

Simon
 
Have just about got the access Asset Register to work.
Default forms and reports run straight from tables but it did save some time.
Have sorted it to produce a single Proposed Annual Depreciation Report that takes into account assets that are both Diminishing Value & Straight Line (1 item only).
It gives a subtotal of Current Value, PropDepreciation & NewWDV and respective Grand Totals. Also shows dep rate used for each Category.
Subtotals cover all categories setup (8) and the single Straight Line item.
A button then appends these to the Depreciation Table so next year can start all over again.
It takes into account items purchased and sold within the year that have a reduced num of days for depreciation.

Will produce reports for generating journals ie Gain/Loss on disposal of asset etc.

Some fields were on the Tables eg CurrentValue but are now calculated as required.

Much better then the cumbersome excel spreadsheet our old accountant used which was full of errors and related headaches.
:)
 

Users who are viewing this thread

Back
Top Bottom