Payroll Journal in Sage 50 Accounts Part1

Payroll Journal in Sage 50 Accounts Part1

Video Cast: 

STEPS:

hi guys welcome to accounting online today I will show you how to post table journal in a 2d counts but before doing that I will take you to a couple of sheets firstly it is called P 32 which is employed symmetrical and the next one is called payments emergency you should have these two sheets if you want to force your fatal course in page you will have these two sheets either from your accounting or if you’re running fatal in house you can run these to depose from your period software okay so I have this excel file with me I put the name of the company no top tier on course for April this is the month we are going to go sleep it’ll cost for in say 50 counts now there are different elements of hero journal the first one is called gross wages or gross salary next one is called employer and I next one is called neck night wages and then we have pain then you have employee Ni and then we have encoder and I okay if I just add one more column and here I put any codes for these two first two heading the first two elements they will go to profit m-most report and these two and these four elements will go into balance sheet which is VF okay now it’s important to put the nominal codes MC stands for nominal code cookies see what are the mobile codes for gross for this moment code for Las Vegas 850 pounds okay we’re going to go to overheads and then here it shows the Las Vegas the grocery it is seven thousand so you can put seven thousand here down in the middle and we have employ Illinois is employed or not is the cost which is non-directive and it is seven thousand six x one is going to be next ladies radius is going to be in current liabilities so this is varies and this is met reduce triple G goes you know any a PE this is federal taxation under current liabilities so you can put pay double to one one double two one zero sorry and the employer and nine this is called in national insurance okay in Sage we only have one normal call for both ni one is called employer and I and the other one is employee ni you can put both of these cost in the same mobile code you can also have different online code for employee and I and B and the different one for the employer they’re not but for the moment I’m going to put everything into the same moment code which is double to one one okay now we’re going to have the figures from the reports which I showed you earlier okay let’s take the defaults from here so the first one is going to be gross reviews so you find it gross for use in this column the first column taxable gross which is 1 0 1 7 8 9 8 1 0 1 7 8 1 9 8 the next one is going to be employer and I which is here six five three one five seven six five three point five seven okay then we have neck ladies next ladies is going to be this a double five two point eight zero it’s going to be a double five two point eight zero and then you have PE PE here one W 4 10 4 6 and 1 this is before point four six and you having Chloe a knife its 401 72 over one point seventy two and then I can put the link for encoding it’s very important to see that both sides they would encourage their equal otherwise page won’t get deposed and in the system one that you force the general if the both sides are not equal it can take the difference and you see the difference this is real okay once we are here I want to show you something which you will see from p32 import image record here it shows employment allowance employment allowance is the loans given to the small companies which is currently three thousand pounds for tax year 1718 so if you see any figure here it means you are not going to pay any employment loans until you cause three thousand pounds to incorporate that in payroll journal what you need to do is I will be adding two more rows here okay and employer ni is going to be here and then employed and are gonna be here if we are getting allowance for employer and I for employer ni it means that is not the cost for the company because small companies are receiving an allowance from government until three thousand pounds so what you have potater we need to reverse the expense which is going in profit loss and then we need to this diversity liability which is going into the bank sheet because these two elements will cancel each other so this is going to be seven thousand six and this is going to be double two one one so what we need to do is we just need to put these so here expenses debit to cancel it will put the link from here which is going to be credit and here liability is credit and we’re going to put the link to make a debit so both of these two elements cancel each other a company is not going to face any employment employer allowance employer ni okay so this the figure and it comes here okay take the difference of these two it comes in once we are here I’m quickly go to sage okay these are different modules I will come here which is normal and cold codes module and I’ll go to journal entry here in the reference this is not mandatory if you see any field in the star sign on top it is going to eliminate see where this is not energy but still I will put FD which is le journal April 2017 and all the journals try to pull them at the month end whether you are posting prepayment journal or accrual journal or depreciation journal yeah so this I will post me and I journal at the month ng 2017 and here I will put groceries this is going to be in GW put April 2017 and I will be this okay three one zero one seven eight nine eight one zero one seven eight point nine eight the next one is going to be seven thousand six give er I’ll put short form of employed and I at er ni April 2017 which was how much 653 57 so this is 6 4 to 3 3 to 7 ok the next one was neck radius which is NW April 2017 how much that was it was a double 5 to 8 cm and m5 to fine idea then you have king which is double to 1 0 this is a April 2017 okay the next one is going to be 1 double to 4.46 1 double to 4.46 then we have in for Eni for it is EE and I fo 2017 and not much Jack was cs4 or 172 before 1.72 and you have employed either Gloria and I in eco 2017 and this is this launched 653 point 57 now we have two extra lines for employment allowance if we did not have any employment allowed let’s see if I could not see weren’t see anything here it means I shouldn’t be forcing these two lines they can be two things either the company is not small or the company has already used all of his employment allowance so you shouldn’t be posting anything here okay now we have this thing here same thing you’re going to call this one in there okay so we’re going to put 706 and if I press f6 so it is going to copy the above cell but I will put employed ni or employer er ei mm announced.