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

Need Help Recording Depreciation (Sage IA)

Sage 50 general help forum - Free help and support for all general issues
Post Reply
Genex
User
User
Posts: 2
Joined: 01 Nov 2019, 15:39
Sage Version: v2014 20 UK/Europe/Africa

Need Help Recording Depreciation (Sage IA)

Post by Genex » 01 Nov 2019, 16:21

Hi, while I read and Google and watch videos about it, I thought I'd ask in here. My company is at the point where I could no longer afford my accountant and need to do the EOY myself. I'm confused, but will try to be as clear as possible.

Summary:
1. I have sold a fixed asset from the Plant Machinery NC and am unsure how to record the £300 money in on the bank statement in Sage
2. I am unclear how to log the NCs for Depreciation, This Year, Brought Forward.

Detail:
I have the following NC's and not sure how to proceed with the sale of the asset or the yearly depreciation recording.

0020 Plant Machinery (Debit £14,000) <-- £300 asset was/is in here
0025 Plant Machinery Depreciation Brought Forward (Credit £12,000)
0026 Plant Machinery Depreciation This Year (zero)
8001 Plant Machinery Depreciation (zero)

and also,

0030 Office Equipment (Debit £3,200)
0035 Office Equipment Depreciation Brought Forward (Credit £3,200)
0036 Office Equipment Depreciation This Year (zero)
8004 Office Equipment Depreciation (zero)


So if I can ask;

Would it potentially be better to log the £300 sale as miscellaneous income (sold in Feb) and fully depreciate the Plant and Machinery to balance? If so, how do I do that journal to fully depreciate the Plant Machinery and then, I assume, the opening balance for the next year will be zero and won't need to be touched? If not then...

How do I log the £300 sale?
Do I ignore the annual depreciation on the Office Equipment that has now fully depreciated and don't Bring it Forward so the next year shows 0?
At what point can I fully depreciate an asset in terms of percentage etc? Can I fully depreciate that Plant and Machinery now?

Do I do this depreciation before running EOY and then where do I journal the Depreciation Brought Forward to and from and is this done after EOY?


Apologies for all of the questions, but things are pretty bad right now. If I could afford an accountant I would but I can't even pay the mortgage.

FWIW, I believe the company has made a loss for this year.

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Need Help Recording Depreciation (Sage IA)

Post by brucedenney » 04 Nov 2019, 10:16

You need advice from an accountant.
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.

Genex
User
User
Posts: 2
Joined: 01 Nov 2019, 15:39
Sage Version: v2014 20 UK/Europe/Africa

Re: Need Help Recording Depreciation (Sage IA)

Post by Genex » 04 Nov 2019, 12:12

Thank you for the reply, but I don't have the money to speak to an accountant so was hoping to get some guidance here. I imagine it's very simply, I just want to make sure I put the figures in the right NCs

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: Need Help Recording Depreciation (Sage IA)

Post by brucedenney » 05 Nov 2019, 16:42

Well I can say what I would do, but you must understand this is just an opinion, I am not a qualified accountant and my advice and liability is what you paid for it.

The sale of the £300 asset should be put against the Plant and machinery in the balance sheet. You could do this as a Bank Receipt against 0020. You have converted n asset in the form of plant into an asset in the form of cash in the bank balance it has no impact on the P&L.

You need to calculate the depreciation amount, e.g. if depreciate by 25% reducing balance you take 25% of the £1700 = £425 and you journal it as a Credit to 0026 and a Debit to 8001 on the last day of your financial year, (this puts the cost of depreciation into the P&L). After year end you journal is again from 0026 to 0025 to show the new b/f balance. (Personally I would just have a depreciation account and not have one for B/F and one for the current year. It saves a journal but hey ho that is how it has been set up in the past and you might as well run with it.) If you have some other depreciation policy then you follow that. HMRC have rules about what you can do for tax purposes with depreciation, you need to check you are compliant with them.

When an asset is fully depreciated you can journal all the depreciation against the asset and all be zero.
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.

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 11 guests