I am reconciling my gross salary: Sage Accounts against Sage Payroll. Which report would you advice to use?
I tried Payment Summary History Part 1 - By Date; as far as I understand my Gross pay post sacrifice should agree with sage payments nominal 5500 (staff gross salary) but my gross amounts do not agree.
Not sure whether I am using the right report, or there was something wrong with the nominal codes and the gross figures were posted incorrectly. I always post salary journals by using automated Nominal link in Sage Payroll. I checked my monthly Payment Summary ( Part 1) reports against the Payment Summary History Part 1 - By Date and all numbers agree. All other amounts such as NIC, tax and NET payments agree, all is fine except gross payments.
Hi Monita
I dont use sage payroll (far too expensive and better/cheaper options out there) so cannot advise specifically what reports you need, but couple of questions - is it sage one cloudy payroll? What I m getting to is - dont sage payroll offer cover as part of the package? I know sage accounts dont, but as long as you have access to the right reports from payroll you can easily drill down and get what you need from the accounts package to check it off.
Other question - could the issue have something to do with the errors via your other post, ie couple of rollbacks/errors invovled in payroll from what I can gather from that, which mightve been fed into accounts package and not reversed out and re-input.
Try ordering a P11d for all, which you should be able to get in excel format, plus a nominal activity report (excluding no transacations) from accounts package into excel and try to see where the differences lie. Check your brought forward balances in accounts - might have something to do with that eg Accountants adjustment at start of the year. 5500 nominal is unusual. usually c6xxx range for direct costs as far as I was aware, but have you another in the indirect section - usually 70xx region as there might be balances in there.
__________________
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
