Skip to main content
P
pezza72
October 28, 2024
Question

P11 Report

  • October 28, 2024
  • 1 reply
  • 0 views

This doesn't really have any impact on me (or atleast not that I am aware of yet) but just looking at a downloaded PDF of the P11 report and I think there may be an error in the totals table.

 

On the "Taxable Pay To Date" column, the Totals row at the bottom is adding this up, but this doesn't really make any sense since this column is intended to be cumulative.  Of course, if this is expected or there is a purpose behind it, I would be grateful if someone could explain.

 

As I say, this might not have any effect on anything else, but just thought I would call this out for review.

 

Thanks

Andrew

1 reply

K
KayePe
October 28, 2024

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.

 

The cumulative feature calculates values per row, while the Total row calculates based on the amounts in the Taxable Pay To Date column. Please note that this only provides an overview of total earnings and is for informational purposes only. Rest assured, the total amount in question will not affect any calculations or results on your end.

 

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.

P
pezza72Author
October 28, 2024

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

L
LouiseG12
October 29, 2024

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. 

Terms & ConditionsAccessibility statement