P11 Report

The totals at the bottom of the Taxable Pay To Date column represent the cumulative taxable pay for each employee over the payroll year, @pezza72. Let me provide extra details to help clarify this for you.

Additionally, you may find this article helpful for guidance on running various reports to assess your payroll within QBO: View reports in QuickBooks Online Standard Payroll.

I've also included this resource to assist you in handling and reporting benefits in kind provided to your employees: Managing P11D forms in QuickBooks Online Advanced Payroll. 

The information I provided help will help you clarify why the totals are accumulating as they do, Andrew. I'm always here to help, and know that you're not alone in trying to figure out any of your QBO-related concerns.

Thanks @KayePe 

It still seems weird to me though.  We only have 1 carer and it is suggesting that the total taxable pay to date is 16428 when their total tax pay to date is only 4140.  The column is already cumulated each time in each month, so I just don't see what point of summing the cumulative total again serves.  It doesn't show the total deductions for all employees for the whole year as if it did it would be the same as the last months row.

Does this mean that the "Tax due to Date" will also be the same and will end up summing all of the already running totals again? I guess I will find out if they ever become liable for tax.  The figure just doesn't make any sense (to me atleast).

I get that this may be how they designed it, but for me, it just seems to be designed wrong :)  But that's ok, if it isn't used in any other figures or calculations anywhere else and isn't used anywhere other than for viewing I can simply ignore it and just look at the last months row for the real total tax paid to date for the year.

Thanks

Andrew

I appreciate your continued engagement on this matter, Andrew.  Let me elaborate further on your observation concerning the Taxable Pay to Date column. 

The totals displayed at the bottom of the column represent the cumulative taxable pay for each individual employee accumulated throughout the entire payroll year. The grand totals, as present in the bottom rows, are derived specifically from the amounts indicated in the Taxable Pay To Date column, which summarizes all earnings up to that point.

Additionally, it has been deliberately crafted to calculate values for each individual pay period on a per-row basis.

Consequently, you can view the data without concern for its impact on payroll processing or financial reporting. Your calculations will remain consistent and unaffected by these cumulative totals.

Keep us notified by commenting below for anything else you need assistance handling payroll reports. We're always ready to assist you.