The Book-keepers Forum (BKF)

Post Info TOPIC: Payroll software and reconciliation.
Seb


Veteran Member

Status: Offline
Posts: 39
Date:
Payroll software and reconciliation.
Permalink Closed


Hello Folks,

 

Couple of dumb questions;

1) If you use Payroll software will it keep a running total of all entries for the year? Should like at year end a report can be pulled which shows total paid, total NIC 1 / secondary / 1a etc.

 

2) Leads on from Q1 Assuming a report can be pulled I imagine a reconciliation goes as such-

Opening balance plus PAYE expenses incurred, less what has been paid to HMRC, leaving the B/S total owing to HMRC, using the report to verify the BS year end liability. 

 

Anywhere near close?

 

Thank you very much.

 

 



__________________
Seb


Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

I can only speak for Moneysoft payroll but a whole cariety of reports can be pulled off.   Details of employees NI payments, tax deductions, employer summaries to name, hours worked if hourly  but 4.

Moneysoft doesn't let you enter PAYE payments paid, as that is more an accounting function, but you can certainly see a list of payments that are due each month

Theres a 30 day trial if you want to have a play.



__________________

John 

 

 

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

Seb


Veteran Member

Status: Offline
Posts: 39
Date:
Permalink Closed

Thank you John.

I'll look into the free trial.

Does the method of reconciliation I mentioned seem fair enough?

Thank you

__________________
Seb


Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

12Pay includes the ability to enter actual payments made to HMRC, and its P32 report shows a month by month summary of the various components owed to HMRC and a reconciliation of payments against that.

__________________

Life's a reach, then you gybe

 



Master Book-keeper

Status: Offline
Posts: 3904
Date:
Permalink Closed

Ah sorry Seb, I misunderstood your last question.  There's a P32 report on Moneysoft too, which shows payments due to HMRC each month, but automatically assumes the payments have actually been made.  Sounds like 12pay will be better suited for reconciliation purposes.



__________________

John 

 

 

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



Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

Leger wrote:

Ah sorry Seb, I misunderstood your last question.  There's a P32 report on Moneysoft too, which shows payments due to HMRC each month, but automatically assumes the payments have actually been made.  Sounds like 12pay will be better suited for reconciliation purposes.


In many cases the reconciliation isn't particularly useful, and a lot of sites with simple needs don't bother with it.

But it becomes very useful in cases where for example there have been historic underpayments, overpayments, CIS recoveries, revised FPS's for previous months, etc. It then becomes easier to see how much you owe now, based on total debt to date and total payments to date.

This is also helpful if you pay quarterly (the P32 in 12Pay includes quarterly totals as well as the annual total to date)



__________________

Life's a reach, then you gybe

 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Hi Tom, may I ask how you'd reconcile this particular account? I'd have sided with Seb's logic - if there is a better way?

__________________

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.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi John
You can opt to show the P32 items as not paid in Moneysoft so that they bring forward the balance each month. I do recall using that for a client in the very early days of me using Moneysoft although I dont tend to these days, just tell people that its only for the month and cannot be relied upon for b/forwards - only because for a few I cannot see whether they have paid for not (white label type or payroll only clients, or indeed any where you dont get their bank statements often enough!!)

Johnny - dont you just reconcile the PAYE nominal/account/ledger whatever you want to call it, much as you would the net wages? Sorry probably being a bit thick here as my brain is battered after 14 hours already done today!

__________________

 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



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Hey,

Well because I've never been shown the way I usually go overboard. I'd want to see the 'official previous year end TB' together with every report up to year end - hoping everything reconciles to the year end owed to HMRC.

Not knowing how it is done by a Chartered leaves me to do it as an Auditor- sampling V census.

Not saying a Chartered performs sampling, but I have to be extra careful.



__________________

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.

 



Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

abacus12345 wrote:

Hi Tom, may I ask how you'd reconcile this particular account? I'd have sided with Seb's logic - if there is a better way?


 Well I can only answer the question with reference to 12Pay. In that software if you've entered the payments to HMRC, the CIS suffered, and any funding payments from HMRC then there is no more reconciliation to be done; the P32 report will show the outstanding figure based on the PAYE monthly amounts owed net of the detailed payments.



__________________

Life's a reach, then you gybe

 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Tom,

Thank you for your reply.

If it's good enough for you.

Some can't be arsed with backing up figures, I like to cover my bases.

I understand your sentiment- thank you.

__________________

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.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

abacus12345 wrote:

Hey,

Well because I've never been shown the way I usually go overboard. I'd want to see the 'official previous year end TB' together with every report up to year end - hoping everything reconciles to the year end owed to HMRC.


 I would expect nothing less Johnny.

Personally I dont consider it overboard but doing a good/thorough job.



__________________

 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



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Thanks :)

__________________

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.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

So, who is in the piccie this time Johnny-are we seeing the real you?

__________________

 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

Seb


Veteran Member

Status: Offline
Posts: 39
Date:
Permalink Closed

Hi guys, thank you for your replies - reports, schedules and reconciliations = never ending learning.

__________________
Seb


Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

abacus12345 wrote:

Tom,

Thank you for your reply.

If it's good enough for you.

Some can't be arsed with backing up figures, I like to cover my bases.

I understand your sentiment- thank you.


 Your reply suggests that you think that there is something more that could be done in payroll software for to help reconcile the HMRC account, but I'm not able to imagine what it is.



__________________

Life's a reach, then you gybe

 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

No, my reply suggests no such thing.

My reply is to question how is best to reconcile the figures submitted through payroll software to a nominal account, whether it be 'a' HMRC account, or accounts split - such like PAYE and NI.

Maybe I've misunderstood the initial question.

As far as I'm concerned what is submitted through payroll are figures belonging to the past. I was asking what is the best report to use to reconcile against the nominals within the accounts.

I read the initial question as; if I submit X months worth of wages in a financial year how is best to reconcile those from the payroll software to a TB, year end summary, or a collective of each individual employee? That was my question to you.



-- Edited by abacus12345 on Sunday 14th of May 2017 11:10:09 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.

 



Senior Member

Status: Offline
Posts: 421
Date:
Permalink Closed

Ah, Ok got it.

Firstly, I've never seen any reason for splitting the HMRC liability into several nominal accounts, so I would have just one account for it. (PAYE/NI/Student loan etc)

So the P32 report with detailed payments gives one reconciliation that all is well with payments to HMRC.

To tie that in with the nominal/TB in my own business I had a monthly spreadsheet of reconciliations, a worksheet tab for each one. The HMRC PAYE tab of that would have a screenshot of the relevant nominal ledger account in the accounting system, and a screenshot of the P32 report. Usually these would show the same balance owing unless there was some kind of error or unanticipated complexity. If they didn't agree then some Excel cells could be used to explain the difference.

__________________

Life's a reach, then you gybe

 



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Thank you very much.

That is the answer I was looking for.

Thanks again.

__________________

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.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Jonny
You can download a free trial period of moneysoft and there is a sample report mode you can play with - or of course just set up a dummy company and see what reports you can grab. These will at least give you an idea of what is possible. Actually Im surprised you havent what with being the resident BKN software tester!!

__________________

 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



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Ha ha yes quite! Although the trick is knowing which report should be used for verification purposes. I'd not thought about a screenshot before. The other issue is having reams and reams of information for a simple set of accounts. But if that's how it is to be. It's quite frustrating that only bank reconciliations are really covered in education - But again, that's just the way it is! Lol.

__________________

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.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Strictly speaking it should be simple enough. If all staff are paid on time and PAYE is too then there should only be an o/s amount for the last pay period. Ok for net wages this might encompass more than one pay period, but it shouldnt be out by much.

OK, I know .....I woke up from a dream. Real life takes over and clients dont pay their bills on time, pay the staff the wrong amount, pay part payments by way of advances to staff, blur blur blur......big tick back excercise. Ive got one on the go at the mo - 'reet' nightmare!! If you are really bored I can pass it over to you! Well I could if I had time to redact all the info, by which time I might as well have done it. Seemed like a good idea though.

__________________

 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



Guru

Status: Offline
Posts: 1363
Date:
Permalink Closed

Ha ha! Got to love tick and bash exercises. You're right, all is well if bills are paid on time. Even better is when all payable nominals, such like VAT, coincide with an accounting year-end.

__________________

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.

 

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