The Book-keepers Forum (BKF)

Post Info TOPIC: Serious question ? I'm confused ,accounting software


Member

Status: Offline
Posts: 15
Date:
Serious question ? I'm confused ,accounting software
Permalink Closed


I've completed level 1 & 2 manual bookkeeping with the iab I'm working my 

way through level 3 bookkeeping and accounting. I was completely new to bookkeeping I haven't got any experience all my learning is manual . Ive been playing around on solar accounts (free trial) and its left me confused , surely it can't be that simple can it ?

ive been panicking over using computer software as I haven't used it before and I'm not great on computers,i know this is going to sound stupid but am I wrong in thinking as long as I know what accounts to put the transactions into I'm sorted because solar accounts does the trial balance ,trading profit and loss account and the balance sheet.

either Ive learned well and its making the entries seem simple or I'm completely missing something . The softwares doing everything for me , is it really this simple.

apologies in advance for coming accross as silly but im shocked like I said Ive learned everything manually,I'm currently learning how to manually do the trading , profit and loss account and balance sheet for sole traders , partnerships and not for profit organisations.

any advise would be appreciated . 



__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Sarah
Can you bob your first name under the line on your profile (via edit profile, signature) as it saves us looking up your name each time.

Most questions on here are serious, it's usually the answers that descend into sillyness.

You need to have the basics, ie the manual bookkeeping, to understand the rest of it.

Never used solar accounts, but most software at some point needs you to rely on understanding whether to debit or credit something when eg you need to sort out journals, prepayments, accruals and the often weird ways of doing things that clients trouble you with.

Plus, remember that even though the system will provide a P and L and balance sheet, that without that background and you knowing where to shove things in the first place then the output can be completely incorrect. The old adage rubbish in, rubbish out. Plus also remember that the reports you get from software are more often than not the finished article you will use for your final accounts and the ultimate tax returns. So careful not to be complacent, but yes the software makes the job a lot easier and a hell of a lot quicker.

 

edited for typos!!!!



-- Edited by Cheshire on Sunday 2nd of April 2017 08:57:29 PM

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thank you for your reply
Yes I understand there's more to it .
What software would you recommend me use as someone new to bookkeeping ,I can just keep practising while I'm still studying .
I was going to do the computerised accounting with the Aat next , but now I don't know wether to just get the free trial and try and work my way around it .
Thanks for your help

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Are you looking to do the full AAT?

Also what do you propose when you have passed your exams? Is it being a self employed bookkeeper and if so to what level-just to Trial Balance? Or is the plan to work for a firm of accountants as bookkeeper, progressing your career that way. Or within a company's Accounts department?

Software choice would be geared to your plans, in part.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 7
Date:
Permalink Closed

Hi Sarah,

If you are looking for a robust accounting package to practice on, I can highly recommend Admin Soft Accounts. It's absolutely free and has all the bells and whistles, my favourite part is that you download the programme and its not 'floating about in the cloud' like most accounting software today.... I'm old school :)

They do have an online support forum as well which is great. It has Sales & Purchases Ledgers, Nominal Ledger, Stock as well as HR/Payroll.

It is free for life not just a free trial.

 



__________________

"If I must start somewhere, right here and now is the best place imaginable." Richelle E. Goodrich



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

If you've not decided as to whether you hope to work in practice or in industry, I'd recommend learning Sage, which is found in both.

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thanks for all the replies, I'll have a look at that admin soft accounts.
I'm hoping I can be a self employed bookkeeper , preparing the p& l and the balance sheet, from home or on clients premises. I spoke to a training provider regarding the AAT qualification , they said I could start at level 3 as long as I complete the computerised accounts first . After reading on different forums I don't think I need to go the AAT route for what I want to do , I think learning payroll will be more beneficial as from what I've gathered clients want a bookkeeper who can do this . I'm 32 and my youngest child is now in full time school my partner has always been the breadwinner that's why I'm a late learner,I'm past the point of trying to carve out a carreer in accounting plus I'm happy to stick to bookkeeping I've really enjoyed learning ,working for my self with hours to suit my family would be great . My problem is how do I gain experience I'm happy to work for free for a while. I know a mechanic who owns a garage, he wants me to do the books for him ,I'm absolutely petrified to say yes I really don't want to make any mistakes . He knows I'm new to this and he's ok with that I just don't feel confident ,part of me just thinks do it . I've picked everything up quite quickly , I've spent so much time finding information from different sources ,watching tutorial videos online so I could have a solid understanding of everything . If I was to do the mechanics books , what would be the best software to use ? I can't wait for the day I actually feel confident in what I'm doing , I'm an honest person and I like things done right I want to be good at what I do .
Any advice / guidance would be greatly appreciated.
Do many small sole traders use sage?
Should I take a sage course through a training provider or direct from sage ?

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Are you typing this on a phone Sarah? Its just that its one big paragraph and makes for harder reading.

So you are looking to only go up to TB, with an Accountant then taking over to finish the Accounts and do the tax returns - have I got that right?

If so - no you dont NEED to do AAT, but certainly finishing it up to the end of level three will help you quite a lot. There is a new qualification out at the end of level three for bookkeepers - the AATQB. Plus being a member and having a licence will get you considerably more work from Accountants than if you dont have the licence.

Which training provider did you speak to? Try First Intuition if you havent already. Also before you do try them, try the skills check on the AAT website.

A lot of clients are not fussed about the bookkeeper doing the payroll, IF they have an Accountant, But if the bookkeeper is also acting as Accountant then yes they would want a one stop shop. Payroll is quite an invovled subject these days and what with Auto Enrolment can be quite tying so a lot of bookkeepers actually subbie it out to other folk ( a few on here subcontract it out to John (Leger and myself) as we both provide a white label offering (so your clients dont know!). If you are looking at payroll - look at the CIPP course.

Gaining work without experience is chicken and egg-like. Offering to work for free for other Accountants generally doesnt work Im afraid - they think they will spend an age training you up and knowing you will leave. But a lot of people do bookkeeping for charities for free so that might well be a place to start.

If you are looking at doing the AAT computerised accounts then check with the training company you do it with and most importantly where you will be taking the exam to find out what sage they use for the exams - some only use sage 50 and some only sage one. Some of the better training centres offer both. That obviously determines the one you will need to get - you can donwload both for free trails for a month (and there are ways to extend that month if you need to, although the course can easily be done in a couple of weeks!)

The mechanic who owns a garage - bit more detail required. Eg just a one man band, limited or sole trader, sells cars or just repairs them, an MOT station or not, VAT registered or not and if so what VAT scheme, how long in business, how and on what software does he do the books now, does he realise he will still need his Accountant to finish off the books?

What is your knowledge of VAT out of interest.

Sorry - I know you asked us questions and you have a few back, but its often the only way we can provide best practice advice.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Hi Joanne thanks for replying
I'm writing from my phone , I'll use computer next time . I spoke with training link about studying AAT qualifications. To be honest Joanne I've completely burnt myself out stressing over everything. I think I'm trying to think to far ahead without a fully realistic understanding of everything . I just need to focus on finishing level 3 and starting a computerised accounting course , I should have a better understanding and a bit more direction.(I always try to step ahead of myself haha ).

Your right in the future if needed I could just sub the payroll out. I have a good understanding of accounting for vat , at the moment level 3 is teaching me how to prepare end of year financial statements for sole traders,partnerships and not for profit orgs.

The mechanic has 1 employee,been operating for 1 1/2 years ,vat registered,Ltd ,just repairs , no mot station at the minute but does have plans for this . Not sure of anything else at the min .

I have looked at bookkeeping with the AAT but apparently it's equivalent to the IAB bookkeeping qualifications , I'm sure I read that you can register for AATQB membership status if you have completed level 3 IAB bookkeeping, I could be wrong but I'm sure I've read that .

I don't know what to do at the moment to be honest, my best bet is just concentrate on what's in front of me, and keep snooping around the forums picking up tips



__________________

sarah 



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

P.s forgot to answer ? Yes he knows he needs an accountant , he's only really asking me to do the bookkeeping as a favour to our mutual friend , and to be honest I won't do it unless I feel I'm actually competent to do it,at the moment I don't.

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Will reply properly when I've got my glasses!!!

Just a quick one - whereabouts are you based? (sorry if you've said!)

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

I'm in the West Midlands Joanne .

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Ahh, I had an idea that if you had been a bit closer and he was game that I could've maybe offered to do his books and take you on as a sort of apprentice to give you some experience, but you are just a wee bit too far and it's not necessarily the kind of business that can be done remotely without putting a few solid days in at their place and I don't have the time for the travel on top (unless I was paid for that time too and I can't see a business doing that).

Don't stress about it. Use your study time wisely. Do what Johnny did and try a variety of software downloads as you can often get the trial versions for free. But remember a lot of clients have their own, although some choose software because they like the shines bells and whistles it has rather than if it's suitable! Suggest you look at VT trans+ for running your business. Looks clunky and so not trendy but it's a great bit of kit and is cheap as chips (plus many Accountants use it for account production, even when they use all the other software, including sage (due to the cost of other account production software such as sap and iris)

No idea if you can get exemptions to the AATQB, was nothing on when they launched it but I wouldn't be surprised in some ways. Their website will say, if I get chance I will have a look.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thanks Joanne for all the advice , I'll have a look at that software , I'm really starting to get the hang of solar accounts , I know exactly where to put everything , I keep checking the reports and everything's looking accurate . I'm going to get the free trial of vt trans+ later . Thanks again Joanne

__________________

sarah 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Hi,

Yes I agree with Joanne, download and play with as many software providers as you can.

I've not tried them all, but I have played with the main players - each have their own negatives.

If you use any of the stock modules you need to be aware that they account for it differently, QBO for example uses AVCO, Sage One IIRC uses FIFO valuation. (Both obviously inline with the IAS - just something to research on whichever you use)

I've got to be honest, I'd say a garage is outside the scope of cloud software - I'm visually seeing a growing business, plans to expand into performing MOTs, possibly further employees - I'd suggest a desktop offering.

The idea behind the cloud software is that the client will perform the majority of the basics themselves, leaving month and year end adjustments to you, together with awkward entries like (for the untrained) a disposal.

With a garage being, at a guess, mainly cash sales - it would take forever to input what you need, day in, day out unless you've a decent till and strong desktop software.

To do the bookkeeping for the client who uses cloud software, using tangible invoices would be crazy, you'd need to collect or have the paperwork delivered (in person, email, Dropbox etc)- whilst paying circa 20-30 per month for the privilege of just using the cloud.

Another negative (as mentioned by Joanne in another thread) the issues surrounding backing up is a pain in the rear. With Sage desktop you can backup before trying anything new / colourful / something you're testing - to then revert if needs be.


My vote therefore still goes to Sage, VT does receive masses of compliments and I've never really heard of people having a serious moan about VT.

If you do learn the desktop version first you will see how things fit into place more so than using the cloud with its 'I'm too non-complicated to fail' attitude.

Also the reports generated from the cloud are shockingly lacking in detail - especially VAT.

Anyway, just opinion :)







__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thanks Johnny , I now think taking a sage course is a must , I will have a much better understanding .

This may sound like a silly question Johnny but let's say the client uses quickbooks , they enter day to day transactions ,they want me to do the month end adjustments . Can the information in their quickbooks be sent to my sage software ,does the sage software then put all those figures into the correct accounts or do I have to manually re-enter all the transactions made by the client.

I hope this question makes sense I'm aware I could be looking really thick right now , I've never used or had any need to use any software before and I'm not great with technology, I bought myself a laptop 6 weeks ago just to get used to it again I've been using tablets and phones for that long.

I'm going onto sage later , they do sage 50 accounts training there are 1-4 stages it's £415 including vat , would this teach me most of what I need to know Johnny .

Thanks again Johnny.

__________________

sarah 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Hi,

For the best experience ideally having the same brand of software is preferential as it enables you to drill down (click into and view individual transactions) into individual accounts.

If you were to use QB and the client uses Sage, you'd need to manually import a trial balance.

It's not rare to do such, in fact it is probably the standard as to buy all brands of software would literally cost a fortune.

A TB will detailed reports would help you to see what transactions have taken place.

If you're determined on completing a Sage course, I won't try to change your mind. But I'd buy, instead, a Sage for dummies type of book - a recent publication.

You will soon pick up the basics to how it works. It will be the odd transaction which will have you stumped - then you ask here.

If you sign up on the Sage site for the Sage 50c software, download - install etc etc you'll have a 30 day trial of the Desktop version.

(Much to do with software now is subscription based)

Don't confuse Sage 50c with Sage One or Sage Start mind.

Sage 50c is the newer version of Sage 50 - an industry great. There are a couple of differences but for the purpose of this it doesn't matter at this stage.


Try to get your manual workings, after opening balances, transactions, adjustments etc to match the computer generated TB B/S P/L.

Talking of opening balances - have a search around for information on here for how to use the opening balance wizard, then think of whether any outstanding purchase and sales invoices have already been accounted for, for VAT purposes.

For eg -

You take over today. 4/4/17

Say last VAT Quarter has been calculated as up to 31/3/17 but not yet paid.
Between 1/4/17 - 3/4/17 you have outstanding Sales invoices - you'll need to ensure these hit the VAT return.
Any outstanding Sales invoices dated 31/3/17 or before, will not need to hit the VAT return because their value is included in the VAT return, quarter ended 31/3/17.


I hope that makes sense.

Some will say avoid Sage, or desktop is dead, laa laa lar - it's not. Don't get me wrong, Sage isn't spot on - it's expensive.

Crack Sage before moving on to VT.





-- Edited by abacus12345 on Tuesday 4th of April 2017 02:14:34 PM

__________________

Johnny  - Owner of an overly-active keyboard. 

A man who can read, yet doesn't, is in no way wiser than a man who can't.

 



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thank you Johnny you have been extremely helpful.its worth looking over the book first and downloading the trial version before putting out for the course I might just be able to pick it up that way .

Thanks Johnny

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Sarah
I would say, download the 50c trail version, gvie it a try with the dummies book (you can get it from the library) before you think of doing a course. You can practice on the freebie for a month, set up an other email address and download for another month. if you give it as much time as you can you will get a feel for whether you want to use it or not and then you can always go for a sage course. Ive never done one and find my way round it ok, although Im sure they can teach me other ways that might be quicker or slightly easier but not to the extent where I feel I can get my moneysworth at that price!!

Sage is the industry standard for a lot of companies still, despite the onslaught by others, but a lot of bookkeepers do actualy manage without it - as Johnny says find the one you are most comfortable with. Despite being a huge sage user and a big fan, if I was starting out now I really would give VT+ a serious trial as it works out so much cheaper. A lot depends on what clients you get - but is something you wont know about until you get going. Downside of VT - no stock processing, but as you may have seen from another post today zero (as I call it) has a bloody useless stock processing facility anyway. People manage with what they have in other ways sometimes.

Remember also that most of these are not Accounts production software, for that you you may need other software and maybe even more software for tax returns themselves.

Dont be too prescriptive with clients - forcing them to change software is not always the best way to retain or indeed gain clients. If you use Quickbooks and they use Sage, they may well wish to continue to use sage, but you will just need to get the appropriate reports to enable you to check the bookkeeping and then do the final accounts. Depends, as I suggested earlier, on what services you are going to offer.

BTW - garages often have their garage friendly/sector specific accounting software packages, rather than ones that we tend to use, although I use Sage Professional for one, but they do car sales as well so it would get very messy using some of the others!


Talking of cloudy sh**e Johnny - one wouldnt let me post a refund to an expenses account!!!!!!!!!!!!!!!!!!!!!!!!!! Bloody rubbish!!!!!!!!!!!!!!!!!!!!!!!!!



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thanks Joanne , I'm going to download it in a minute ( just get my Jim jams on and a cuppa tea ready).

Do you know where I could find some kind of made up case material , that I could enter into sage .

Thanks Joanne

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Sarah
How about using some of the Trial balances from your studies. Start by making up a pile of outstanding invoices for the debtor and creditor balances consisting of both invoices and credit notes and covering a few different suppliers and customer names. Then set up those suppliers and customers (use some fake names and addressess from local businesses or such). The set up your opening balances. Do backups before you start something new so you can get used to that side of it and always have a good rummage round the product to see where entries pop up and what reports you can get.

Do you do the books for any local charities - football club, scouts or such? If so - do them on the system alongside the paper records.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thanks Joanne good idea .
I don't do any books yet I'm waiting until I have a good understanding of computerised accounting first .
I'm going to go to library this week to find that book .

__________________

sarah 



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

I'm on sage now should I download the desktop version standard or professional .

__________________

sarah 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

I'm tempted to say go for the standard, as then you know pro is better (rather than getting used to pro and being stuck with standard at a clients and wondering why you can't do something, if that makes sense!!)

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

It's to late I got the pro haha
Just downloaded .

__________________

sarah 

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About