Accounts & Finance Business finances, including banking, bookkeeping, VAT and other taxes

Go Back   UK Business Forums > Business forums > Accounts & Finance
Reply
 
Thread Tools Display Modes
  #1  
Old 30th January 2010, 15:14
Kristian Kristian is offline
I'm just testing the water here.
UK Business Forums Free Member
 
Join Date: Jan 2010
Posts: 2
Thanked 0 Times in 0 Posts
Payroll Journal Entries for Month End

Hi All,

I am processing payroll journal entries for a month end, and really need some assistance. I have employee's who have had a pay advance of £100 through the month. The payment has already been posted on Sage from the bank a/c (1200) to Net Wages (2220)

As the advance has been deducted off net wages on the payroll report it is leaving my dr side (Gross Wages, and ER NIC) heavier than my cr side (net wages, ER NIC, EE NIC, PAYE) by £100.

What on earth do I do with the cr side of the journal to make it balance?

Kris
Reply With Quote
  #2  
Old 30th January 2010, 15:33
Jenni384's Avatar
Jenni384 Jenni384 is offline
There is no life outside of UKBF for me.
...UK Business Forums Full Member...
 
Join Date: Oct 2007
Location: Wiltshire
Posts: 4,754
Thanked 1,522 Times in 1,126 Posts
The monthly payroll journals should be normal. The only difference is you've got 2 payments Cr bank Dr net wages (the advance and the balance) instead of just the one at month end.

I take it the £100 has been run through payroll and had tax and NI deducted?
__________________
Farrant Frost: Top 5 Progressive Practice 2010
Local and online accountants
Twitter @allbeanscounted
Reply With Quote
  #3  
Old 30th January 2010, 15:39
Kristian Kristian is offline
I'm just testing the water here.
UK Business Forums Free Member
 
Join Date: Jan 2010
Posts: 2
Thanked 0 Times in 0 Posts
Hi Jenni,

Yes the advance payment has already been posted on Sage as it was a BACS payment, so it has been posted as a bank payment from the bank account to Net Wages. The deduction is then on the payroll report. Do I have to Cr the Bank Account and Dr Net wages again then when doing the journal. I have it on an excel spreadheet if you want to see it. I'm getting really frustrated with it now though as I can't seem to get my head around it.

Kris
Reply With Quote
  #4  
Old 30th January 2010, 15:45
Jenni384's Avatar
Jenni384 Jenni384 is offline
There is no life outside of UKBF for me.
...UK Business Forums Full Member...
 
Join Date: Oct 2007
Location: Wiltshire
Posts: 4,754
Thanked 1,522 Times in 1,126 Posts
Hiya

I'll PM you my email and if you send the spreadsheet I'll have a look at it for you
__________________
Farrant Frost: Top 5 Progressive Practice 2010
Local and online accountants
Twitter @allbeanscounted
Reply With Quote
The Following User Says Thank You to Jenni384 For This Useful Post:
Kristian (30th January 2010)
  #5  
Old 30th January 2010, 15:59
Williams lester's Avatar
Williams lester Williams lester is offline
There are concerns over my Forum/Life balance.
...UK Business Forums Full Member...
 
Join Date: Oct 2008
Location: Cardiff
Posts: 1,897
Thanked 343 Times in 288 Posts
Quote:
Originally Posted by Jenni384 View Post
Hiya

I'll PM you my email and if you send the spreadsheet I'll have a look at it for you
Nothing better to do on a Saturday night Jenni??
__________________
Dave Poole - WL accountants - www.wlaccountants.co.uk
e:dpoole@williams-lester.co.uk

ALL-TOGETHER-NOW - Bookkeeping, accounts, payroll, tax and more!
Reply With Quote
  #6  
Old 30th January 2010, 16:45
Jenni384's Avatar
Jenni384 Jenni384 is offline
There is no life outside of UKBF for me.
...UK Business Forums Full Member...
 
Join Date: Oct 2007
Location: Wiltshire
Posts: 4,754
Thanked 1,522 Times in 1,126 Posts
Quote:
Originally Posted by Williams lester View Post
Nothing better to do on a Saturday night Jenni??
I'm just making a video montage of a pole jam I went to today while my boyfriend cooks me dinner! Happy to help out while I relax

I think I sussed it out too
__________________
Farrant Frost: Top 5 Progressive Practice 2010
Local and online accountants
Twitter @allbeanscounted
Reply With Quote
  #7  
Old 30th January 2010, 17:04
Williams lester's Avatar
Williams lester Williams lester is offline
There are concerns over my Forum/Life balance.
...UK Business Forums Full Member...
 
Join Date: Oct 2008
Location: Cardiff
Posts: 1,897
Thanked 343 Times in 288 Posts
Quote:
Originally Posted by Jenni384 View Post
I'm just making a video montage of a pole jam I went to today while my boyfriend cooks me dinner! Happy to help out while I relax

I think I sussed it out too
Sounds good! I am trying to make a beer bottle pyramid from empties after filing our last 4 returns this afternoon.
__________________
Dave Poole - WL accountants - www.wlaccountants.co.uk
e:dpoole@williams-lester.co.uk

ALL-TOGETHER-NOW - Bookkeeping, accounts, payroll, tax and more!
Reply With Quote
  #8  
Old 16th August 2010, 23:32
rakhee rakhee is offline
I'm just testing the water here.
UK Business Forums Free Member
 
Join Date: Aug 2010
Posts: 1
Thanked 0 Times in 0 Posts
Payroll Journal with SMP Deductions

Hello

Please can anyone help me with payroll journal with SMP and advance deductions?
Reply With Quote
  #9  
Old 17th August 2010, 06:46
elainec100@cheapaccounting's Avatar
elainec100@cheapaccounting elainec100@cheapaccounting is offline
There is no life outside of UKBF for me.
...UK Business Forums Full Member...
 
Join Date: Nov 2005
Posts: 12,987
Thanked 2,871 Times in 2,319 Posts
Quote:
Originally Posted by rakhee View Post
Hello

Please can anyone help me with payroll journal with SMP and advance deductions?
yes we can but need more info
__________________
Award Winning, most active UK Business Forums accountant and the only CheapAccounting.co.uk on here
Free Guides, Great fees, Kashflow, Xero, FreeAgent, Clear Books

Business Advice - click here
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with payroll journal entries scedminc Accounts & Finance 11 28th May 2012 15:49
Dealing with credit issued from paypal - Journal entries ?? Page Accounts & Finance 0 21st January 2009 10:02
Costly payroll problem!! Lexpay General Business Forum 0 19th November 2008 22:39
Hello from the Payroll Excel team ridders Introductions 5 31st January 2006 20:49


All times are GMT. The time now is 01:22.

  AddThis Social Bookmark Button