The Book-keepers Forum (BKF)

Post Info TOPIC: tricks that save time in sage


Senior Member

Status: Offline
Posts: 396
Date:
tricks that save time in sage
Permalink Closed


Hi guys

I am practising entering scenarios into sage 50 at the moment and I realized that without detailed knowledge about ' mechanics' of data entry it is difficult to enter scenario in time. For instance, company uses two sales accounts to record sales to the north of the country and to the south of the country. In ' details' column you are supposed to put short description of your transcaction. After you inserted date, nominal account etc it takes hours to write : sales of raw materials to the north of the country' especially if you have few transactions that refer to sales to the north of the country. Do you know any books or articles that teach you how to save time when you insert data in sage ?



__________________


Senior Member

Status: Offline
Posts: 236
Date:
Permalink Closed

Once you write it out once, it should 'remember' descripsion when you start typing the same thing in rows below.

Alternatively, you can use deprtment numbers to cut down on the typing (e.g., 1 for 'North', 2 for 'South'.

OR - Just start each description with either North or South and this will help sorting/analysing.

As for general time saving, I can only think of the usual F6 for copying above, Shft F6 for adding one to the above cell (e.g., for adding 1 to invoice number/date above) etc etc.



__________________


Senior Member

Status: Offline
Posts: 396
Date:
Permalink Closed

thanks for reply. My problem is that I don't even know how to practise data entering skills so that there are chances to pass computerised accounting exam. I wonder if speed can be developed by entering dozens of scenarios into sage ? I am stuck because I simply don't know what to do to prepair myself for exam. You guys probably passed accounting software exams before. What one should do in order to prepair well for the exam ? 



-- Edited by rafapak on Sunday 26th of March 2017 07:52:48 PM

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Yes, just entering stuff is the best way to practice - no amount of reading how to do something matches the experience of actually doing it.

As Richard says above, useful shortcuts are F6 to copy the field immediately above, and 'Shift-F6' to copy it and increment the value (which only happens on certain fields or data types - numeric and date IIRC).

Another one is F4 to call up a list of accounts - this works in the nominal code, sales ledger account and purchase ledger account fields, and a few others where there is a menu of things to choose from.

With dates, don't forget that you only have to enter the month and year if they differ from the month and year today. (So if entering 12th March, 2017, just enter 12 and press tab to move on to the next field. If entering 12th February, 2017, just type 122 and press tab.)

F7 inserts a line in a batch data entry screen - which most people don't need to do because you can enter things in any order, but it can be handy once you have more experience and pre-plan data entry. Similarly, F8 will delete a line.

When you're inputting a value, and you put an amount in the net field, depending on the tax code in use, the VAT amount will usually be worked out automatically - but in some instances, you might need to work out the VAT from a gross amount. Just enter the gross amount in the net field, and press.. er, I can't remember now if it's F9 or CTRL-F9 (The latter, I think) - this will do the calculation for you.

As you will almost certainly already know, the 'tab' button will move from one field to the next - and if at the end of a line in a batch screen, will take you to the start of the next. (I say almost certainly, because this is standard behaviour in most programs that have 'field' based data entry - yet I often see people enter data in one field, then use the mouse to click into the next field, and so on!)

Another thing I often see people NOT doing is properly (by which I mean FULLY) setting up supplier (and to a lesser extent, customer) accounts - which means the defaults for that supplier aren't set; the normal tax code, and nominal account in particular. Although it's not always so, the goods from most regular suppliers will be going into the same (or similar) nominal accounts each time, and will usually have the same VAT treatment.

That's just a few off the top of my head. There may be more that I can't think of right now.

Edit the following day: Using Sage and used F9 to work out the VAT from the gross, and remembered that when I wrote the above I wasn't sure, so I've now clarified it. This, really, reiterates what I've said: It's down to practice and experience. A lot of these things are so second nature that if we try to remember them, they're easy to forget!



-- Edited by VinceH on Monday 27th of March 2017 12:02:31 PM

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 396
Date:
Permalink Closed

thanks Vince for reply. I am very frustrated cause I do scenarios in very slow tempos. I don't know if this is the matter of practice or I am the lousiest data inputter ever ! I think it is also necessary to know chart of accounts codes by heart. it takes time when you don't remember what code given account was given and you have to check before you start doing journal entries etc

__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

If you're reasonably okay with a keyboard in general, then it's probably just a matter of practice and experience.

If you're general keyboard skills are weak, that'll be a factor - but that's also an area you can improve with practice, so boils down to the same thing.

As for the nominal codes in Sage, that's also something that will come with practice - the more you use it, the more those codes will start to work their way into your memory, all by themselves. You won't remember them all (especially as they won't always be the same with different companies), but you'll find that you'll start to remember some of those you use more often. For the others, you'll either start to remember the general ball park area*, or you'll begin to instinctively know roughly where you'd expect to find it.

* The default nominal codes are reasonably logically laid out, with all the codes below 4000 being on the balance sheet, and all those from 4000 upwards being profit and loss. Within those ranges, you'll usually see that (for example) those starting with a particular number usually go in a particular section on a balance sheet or profit and loss account. I won't list the ranges - instead, make it an exercise for yourself to look at a list of the nominal codes in one of your practice set ups, and see how they relate to where things go on a set of accounts.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

VinceH wrote:

When you're inputting a value, and you put an amount in the net field, depending on the tax code in use, the VAT amount will usually be worked out automatically - but in some instances, you might need to work out the VAT from a gross amount. Just enter the gross amount in the net field, and press.. er, I can't remember now if it's F9 or CTRL-F9 (The latter, I think) - this will do the calculation for you.


 Please tell me that wasn't available in 2006/7!  There would be a button the screen that said split nett or summat similar. F9 would have been so much easier.

PS I spent ages once trying to work out how to cross wording out, without success, but a google on saturday helped me with that 20% post on Saturday. I must have been using the wrong search terms before.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

I'm afraid it was indeed there in 2006/7 - I'm pretty sure it's been a standard function since the DOS days.

It's useful to be able to 'cross out' text (sometimes for good reason, sometimes for humorous effect, and some forum software has a button to do it - but not the software used for this one, apparently, so to (mis)quote the seven dwarfs...

Hey ho, hey ho, it's off to work the HTML editor we go...



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Oh yeah - just remembered a couple of other handy keyboard shortcuts for Sage...

If you are in a numeric field (such as the net value) there's a little icon you can click on to call up a simple calculator. This can also be called up by hitting F4. However, if you hit F2 anywhere in Sage (more or less) the Windows calculator is launched.

(The F4 one is useful because the final result is passed back to the field you were in)

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 396
Date:
Permalink Closed

thanks for replies

__________________


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

What exam are you studying for e.g. Is it IAB or AAT? What level ?

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Are you using two sales ledger accounts? You could change the default nominal code and/or department

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Sarah and Chris
Rafal in doing AAT level 2 so it's from a training perspective at the mo.

__________________

 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



Senior Member

Status: Offline
Posts: 396
Date:
Permalink Closed

MrsV wrote:

What exam are you studying for e.g. Is it IAB or AAT? What level ?


I am doing aat level two. I am preparing for computerised accounting exam. We will use sage during exam.

__________________


Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Totally agree with Vince.

To learn something, regardless of what it is, Sage, changing oil on your car, or even decorating- you've got to dive in and get your hands dirty.

Find some study texts (not Sage related) which go through certain bookkeeping exercises and adjustments, enter them all into Sage and see whether your end TB matches the TB in the book.

If I try to learn something myself I pick it up better and remember it for longer, than that of following steps in a book.

By all means learn the foundation steps from the Sage manuals, after that, as above ;)






__________________

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.

 



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

VinceH wrote:

With dates, don't forget that you only have to enter the month and year if they differ from the month and year today. (So if entering 12th March, 2017, just enter 12 and press tab to move on to the next field. If entering 12th February, 2017, just type 122 and press tab.)



With dates, if I'm entering several from the same month I'll change the program date to that month so I only need to hit 12 as above. Never knew about the F4 and calculator thing. I'm using that all the time and was wondering why there was no keyboard shortcut for it.



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

FWIW it's just occurred to me to look in Sage's 'Help' to see if there's a list of these shortcut keys - and there is, but it doesn't take much searching for it; the list is directly accessible from the Help menu itself. The resulting page is a web page on Sage's site.

(So it's particularly annoying that the software launches the page in Internet Explorer, bypassing your system settings if you have a different browser configured... but that's Sage for you.)

Edit: pasted the link in as plain text and the forum was partially recognising it, which meant it didn't work, so I've turned it into an inline link.

Edit 2: And I promptly broke the link myself, so let's try again...

Edit 3: (After much previewing and editing...) Taken the link out. It doesn't want to play ball with the forum. Just click the menu item in Sage!



-- Edited by VinceH on Thursday 30th of March 2017 02:26:02 PM



-- Edited by VinceH on Thursday 30th of March 2017 02:27:38 PM



-- Edited by VinceH on Thursday 30th of March 2017 02:34:06 PM

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Last years version of sage has two calc net shortcuts - F9 and F3! Bloody annoying. I tend to use the calc net button, but in that same version the calc net option is at the top of the screen and the save is at the bottom. Hope they sacked the person who had that dumb idea. Think they have reverted back for the new software, although Ive not got it to check. Had a phone call yesterday offering sage cover at £1500+ pa for sage pro but it comes with downloadable software (rather than a perpetual disc) so when I said I wanted the disc option he lied and said it was no longer available. He also advised that they dont JUST do cover, you can only take it with an upgrade. But they now offer up to 10 companies and 10 users for the same price. Kept that story up right until the end of the call, after having listen to me have a few rants about why downloadable is not an option for all clients needs and generally throwing back a reason why everything he said was rubbish re the cloud and sage never listening to their customers, when he finally admitted a perpetual licence on a disc was fully available....but only for the next year or two. He was still trying his sales patter as I put the phone down.

__________________

 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



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

i tried to post the link aswell Vince - nada! Mind you its easier enough to find on the helpfiles - its  right on the front page, so no searches required.



-- Edited by Cheshire on Thursday 30th of March 2017 07:14:49 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



Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

Cheshire wrote:

Last years version of sage has two calc net shortcuts - F9 and F3! Bloody annoying. I tend to use the calc net button, but in that same version the calc net option is at the top of the screen and the save is at the bottom. Hope they sacked the person who had that dumb idea. 


I tend to use "Alt   S"  when I save to avoid using the mouse as much as possible.



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Veteran Member

Status: Offline
Posts: 99
Date:
Permalink Closed

I've recently discovered the "import" function on Sage, it is an absolutely brilliant time saver for a client I have with a large amount of repetitive bank statement transactions, due to them having several shop branches and so at least 20 or so card machine bankings per day, plus electronic payments for wages etc.
They import the statements into a spreadsheet format for me and send it over, all I have to do is add in a few extra columns to identify the transaction type / VAT / tax codes etc and then save and import. Voila! It's all on Sage.

This also works in Xero, although I mainly use it there because I really don't get on with Xero and find inputting anything on there incredibly time consuming.

I get the impression that the new Bank Feeds feature in Sage was supposed to do all this without the need to import, although after a lot of problems with it was told by Sage themselves that it was never meant to be used for companies with a lot of bank transactions........ just....what......

Having typed this out now, I realise it probably won't help with your exam!! Something that might help when you take on your own client's, however :D

__________________
Faye


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Faye
OMG - that import option has saved a lot of time in the past. Takes a while to get the file right the first time if you are not used to it, knowing what goes where, but once mastered a doddle!

Sage have supposedly improved their Bank feed for Sage 50 products so it can be used for companies, but Ive not seen nor used it yet (maybe shouldve used the freebie ticket offered to the sage summit to find out!) but if they bank with certain Banks they can just do a mass import (for up to thousands of items per month +) via a product called Bankline. They need the right bankline module and its only provided by NWB and RBS but has been feeding data into Sage since the 1990s.

__________________

 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



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Yup - I've been using Sage's import function for donkey's years.

Where I am today, for example, they raise a couple of hundred sales invoices each month at month-end (using their own Sage Instant). I've set one of their invoice summary reports so that they just have to run the report to email, and a CSV file is sent straight to me ready for me to import into their company on my Sage 50.

Another place, their invoicing program (my "temporary" solution, written back in the early 2000s, which they continued using even when I was no longer looking after their books for some years) creates a CSV file as it goes; I grab that (and reset it to empty) when I need to, and that file is again imported into their company on my Sage 50.

When it comes to Xero, though - one of my clients is switching to Xero, so when I get the first lot of stuff from them when they're up and running with it, I'll make a point of looking for the import function. So many thanks for that tip, Faye!

__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Hmm. I just noticed your picture and laughed. Then I read the text underneath. :|



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)

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