How to enter data in Sage Line 50 Accounts?

dal

Free Member
Jul 26, 2007
479
26
Ok so I'm trying to get to grips with sage 50 Accounts, I'm using 2010 version. Compiling first VAT return which is well overdue :redface: but we currently have bigger priorites than VAT returns at this moment in time.

Should I enter the details via 'bank' tab under 'payment' and 'receipt'. Or should I enter via 'company' tab as journal. I do not even comprehend what journal is.

Or is my method completely way off target.

I do not wish to use the vat wizard on this first return as the return is complied over two years; items like plant, tools, machinery etc that can be claimed for up to 4 years since registering for VAT according to HMRC, but must be accounted for on the first VAT return.

Any advice is greatly appreciated; sage is pretty awkward, and the help files are not detailed enough in my opinion.:(
 

Arch Stanton

Free Member
Jan 16, 2011
107
25
Portsmouth, UK
How you record transactions on Sage will depend on what sort of transactions they are.

Use the Customers module to set up your customers and enter sales invoices. Invoices from suppliers can be entered in the Suppliers module. In the Bank module you can enter receipts from Customers, payments to Suppliers and other (non-supplier) bank payments.

Don't use journals if you do not know what they are.

There are video tutorials to be found under Sage's Help menu. These will guide you through a lot of common data entry tasks. There are also detailed PDF guides.

You will need to use the VAT return on Sage and reconcile the VAT transactions otherwise you risk them appearing again on the next return. Note the VAT Transfer Wizard does not do the VAT return.

If you are new to Sage and do not understand accounts then I suggest you get help from a bookkeeper or accountant.
 
  • Like
Reactions: dal
Upvote 0

Scalloway

Free Member
Jun 6, 2010
18,414
12
4,191
Shetland Islands
Should I enter the details via 'bank' tab under 'payment' and 'receipt'. Or should I enter via 'company' tab as journal. I do not even comprehend what journal is.

If you are just entering cash sales and cash payments that will work. Journals are for corrections so for the moment I would leave them alone.

You should do a bank reconciliation before you try the VAT return to ensure you have entered all tranactions for the period.

Using a bookkeeper may seem like an uneccessary expense at the moment but having properly prepared books will save time, effort and expense when you need to submit your tax return.
 
  • Like
Reactions: dal
Upvote 0

Pandybearse

Free Member
Dec 9, 2009
85
8
It took us a good couple of months to fully get our heads around Sage from scratch, and it sounds to us like you really should get someone professional to do it, while you watch, as it will cost 10 times more (at least) to re-do it if you get it wrong. You only need a bookeeper to enter data, you'll need an accountant if it goes wrong.
 
  • Like
Reactions: dal
Upvote 0

dal

Free Member
Jul 26, 2007
479
26
Thanks a lot for the advice, it's greatly appreciated. I do have an accountant, they are quite expensive but they do yield better results than my friends accountants.

I suppose I will have to give them a call and get them to help. What I am worried is that you constantly come across new problems.
Thanks people.:)
 
Upvote 0

AverageWhiteBloke

Free Member
Oct 31, 2010
103
27
Sage can be pretty daunting at first, a lot of the terminology can be confusing. I find a lot of the transactions repeat so after a while it gets easier. Generally most stuff is done in the bank module. While in there you can pay bills or use the supplier/customer part in bank to record payments.

I was that overwhelmed the first year I had the software I never used it :D once you get into it though your life becomes a lot easier. I could have just passed my stuff over to the accountant but that would obviously come at a price, also if you keep needing to contact them for info the time will be logged and billed. It's very handy to have the information in front of you all the time. I was lucky my accountant had someone who dealt with Sage issues who I could email to confirm I was doing the right thing.

I'm guessing that you have done your accounting manually up until this point? So the crossover should be easy-ish.

Firstly use the practice data option to test what your trying to do it will not affect your accounts. Once you have tried in practice and your confident repeat in your company data.

Another tip would be BACK UP, BACK UP, You can never back up enough. At first do it before entering any new information its a helluva lot easier restoring to a previous point than correcting errors IME. As you get more familiar with the software you will have to do this less.

Journals are simply a way of adjusting payments that are not straight forward. I.E wages which are made up of NI, TAX, gross and net payment. One payment would come out of the bank but would need put into different categories for book keeping. Wrong entries where you have categorised something wrong can be corrected by your accountant with the use of a journal. Most things can be dealt with without using a Journal.

As for bringing stuff from previous financial years into the equation it would be a lot easier if you just deal with your current financial year, deal with the other stuff separately and bring them into the accounts later rather than having to change the tax rates depending on the transaction date. The vat will allow you to make changes before submitting so it will auto do the return for the current period and you manually make the adjustments for stuff you want to bring forward.

While getting your head round the software I found it a lot easier to deal with current rather than trawling through old, in fact by the time I got through the old even the new stuff was old if that makes sense :)

Another good tip is accounting is not a standardised thing when it comes to Sage, I have seen different people do the same transaction in different ways there's no hard and fast rules. The most important thing is that you and your accountant know why you put it there and hopefully your accountant will tell you which part you are doing wrong, journal to correct it at year end and advise you on how to do it in future.

Always remember that you are not the accountant your job is just to keep your records as accurately as you can and let them fine tune it before submitting.
 
Upvote 0

Pandybearse

Free Member
Dec 9, 2009
85
8
Please remember for 99% of Sage stuff you don't need an accountant, just get a mobile bookeeper to come in and put the data in for you while you watch, ours charges £10/hour. Sage is the accountant in this case (VAT return), does all the double entries and everything. And if you find problems, especially VAT related ones as you are worried about, surely they need fixing or you will end up in jail :eek:
 
Upvote 0

AverageWhiteBloke

Free Member
Oct 31, 2010
103
27
surely they need fixing or you will end up in jail

Bit extreme :D You do have time to correct VAT returns. My accountant has put through some motoring expenses I was wrongly claiming under mileage on a return from a previous year with no problems. TBH the revenue are just happy to get their money these days. Good suggestion though letting a book keeper do the first couple of month while you watch.
 
Upvote 0
"Compiling first VAT return which is well overdue but we currently have bigger priorites than VAT returns at this moment in time"

There isn't much more to worry about than this, as they can close you down and wipe you out quicker than anyone else (and you may personally be help liable for debts, regardless of being a ltd company). You are also running up charges!
 
Upvote 0

Pandybearse

Free Member
Dec 9, 2009
85
8
"Compiling first VAT return which is well overdue but we currently have bigger priorites than VAT returns at this moment in time"

There isn't much more to worry about than this, as they can close you down and wipe you out quicker than anyone else (and you may personally be help liable for debts, regardless of being a ltd company). You are also running up charges!

Here here......these things only get worse, never better. I sleep well at night by working tirelessly until we get these sorts of things running smooth. VAT on Sage now takes around 5 minutes including online submission. Paying it is another matter though :(
 
Upvote 0

AverageWhiteBloke

Free Member
Oct 31, 2010
103
27
Paying it is another matter though
Very true, one of the plus points of sage is vat owed can often be forgot about and mixed in with your cash until you finally get round to working it out and realising you have spent some of it. :eek: With Sage you can see your liability in real time if Sage is up to date and make sure that money is ring fenced off. The million dollar question is if cash flow is an issue whether or not to spend that money to keep a float based on whether you know you can get that money back in time for it to be paid. More often than not a customer which owes you will not pay you in time for the return which is often happening in the current climate.
The vat will tell you it's not your money to spend but the harsh reality is at times you had to as long as you know the money is coming in.

What I had to do with Sage when first getting into it was create a start point to take over the accounting, present day is best while all transactions are fresh in your mind. Let an accountant sort out the previous stuff who will be quicker and better then bring the adjustments into your already rolling accounts so you know where you are from the off. As long as you give them some figures for the late return and pay the money owed across that will then buy you time to get it all in order and corrected on the next one without accumulating fines and interest.

IME learning how to use Sage while trawling back through old stuff makes the process much harder and you may never catch up.
 
  • Like
Reactions: Pandybearse
Upvote 0

dal

Free Member
Jul 26, 2007
479
26
Thanks for all the advice people. The VAT return was due in September (1st VAT return; just gone registered) so I'm not massively overdue. We are having to go over four years to calculate this VAT as we have bought plant, tools etc that can be claimed for. I want to get the return correct as four years of plant and tools have been considerable as these were bought at the start and we're talking on a few quid of VAT.

I have arranged a meeting with our accountants to sit down for a few hours and set me us up properly.

I find one of my biggest problems is that we receive a lot of email invoices, then receive receipts for invoices. Which I find very confusing, as often struggle to account properly for these. How does everyone else file these along with their paper receipts etc. Does everyone else print out all receipts and file them in monthly folders?
 
Upvote 0

Latest Articles

Join UK Business Forums for free business advice