We've been manually calculating depreciation (excel spreadsheet) for our hire equipment ,cumulatively using the period balances, which has sufficed so far enabling us to calculate the end of year depreciation etc. But it is becoming more clumsy and problematic as the oldest items are now fully depreciated and also we are selling off redundant equipment (some with nil NBV, others still within life months).
Our basic spreadsheet is now not suitable for this and also the number of assets have increased significantly since the business started.
I would like to now set up all these in our Sage 2009 prof. (v.15.01.20.0191) - say at the beginning of this year, 2012. How do i go about entering all the assets including the historic details, and items fully depreciated or disposed of? We have a list of all individual assets with their relevant details i.e, cost, date purchased, depreciation to date & current nbv - so although a tedious task they can be re-entered on sage without too much trouble.........
i had read somewhere that when assets (those added historically onto sage at a later date) were disposed of later that the cumulative depreciation wasn't being calculated/posted correctly - is this correct, or it it that there is a proper way of entering the historical data ?
many thanks
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
FIXED ASSETS - Setting up existing assets on new Sage 50
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: FIXED ASSETS - Setting up existing assets on new Sage 50
It is a bit old, but this might help guide you through the process.
http://support.makingithappen.co.uk/man ... record.htm
It is worth spending a little time in the demo company and doing some month ends and getting to grips with exactly what Sage does.
http://support.makingithappen.co.uk/man ... record.htm
It is worth spending a little time in the demo company and doing some month ends and getting to grips with exactly what Sage does.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 3 guests