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

Addbacks / Depreciation

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
Sally
User
User
Posts: 2
Joined: 07 Nov 2009, 14:04
Sage Version: V09 UK/Europe/Africa

Addbacks / Depreciation

Post by Sally » 07 Nov 2009, 14:21

Hi I wonder if anybody can help me. I am trying to do my Year End for '08. I have taken out a P&L and BS before running the Year End. I have done the appropriate workings, in a spreadsheet, for submital to revenue and needed to addback some expenses and the Depreciation. The Problem is, how do i addback expenses in SAGE to make it reflect correctly next year.

I have tried to CR the Expense accounts and DR the P&L (3200) and this gives me the correct P&L (My original Profit + the addbacks) but when i do the year end and look at the next year, the P&L is clear, which i assume is correct but the BS brings forward last years profit in Reserves but it doesnt include the amount added back.

Site4
User
User
Posts: 63
Joined: 08 Oct 2009, 12:39
Sage Version: v2009 15 UK/Europe/Africa

Re: Addbacks / Depreciation

Post by Site4 » 07 Nov 2009, 18:01

The reason that you're getting the slightly bonkers result is that in crediting the P&L and Debiting the P&L in the balance sheet you're cancelling the transactions out in the carried forward figures. What you need to do is find out where the non-P&L half of the postings should be going.

That is to say, if you have over-charged depreciation in the year, the original entry will have been debit P&L (let's say 8000) and credit the Balance sheet (let's say 00x1). Your correcting entry is therefore debit the balance sheet (00x1) and credit the P&L. If you have the 2008 year open, post to CR 8000 DR 00x1, if you've closed the year and are now in 2009, post to CR 3200 DR 00x1 this will correct your assets and bring forward the correct P&L figure.

Similar situation for your expenses. If for instance, you have over-charged postage, your original entry will have been DR 7501, CR ????. Possibly creditors, petty cash, bank, etc. If you then follow the same principle as we did to correct the depreciation, you'll be sound.

HTH.
Dave

Sally
User
User
Posts: 2
Joined: 07 Nov 2009, 14:04
Sage Version: V09 UK/Europe/Africa

Re: Addbacks / Depreciation

Post by Sally » 07 Nov 2009, 21:48

Thank you for that Dave. That makes total sense about the expenses. I can also see where im doubling up in the P&L but the problem i have now is with the Depreciation.
My original transaction was to DR the Asset Dep account 00x1and Cr the Dep expense 8000 because i need to depreciate the asset. When the Adjusted Profit is done, the depreciation is disallowed against the profit so i have to add it back to profit somehow in sage. I dont want to take it out of the depreciation nominal as it shows the value of the asset so i dont have a Balance Sheet nominal to Cr it to.

Sue

Site4
User
User
Posts: 63
Joined: 08 Oct 2009, 12:39
Sage Version: v2009 15 UK/Europe/Africa

Re: Addbacks / Depreciation

Post by Site4 » 19 Nov 2009, 22:13

It's all in the balance sheet...

I've confused myself, now,. I'll try and elucidate tomorrow.
Dave

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest