I have run the CIS Payment Deduction Report for each of my subcontractors for each month of the last financial year, but the "Gross Amount Paid" column is showing the same figure as the "Amount deducted" for all bar one month, when the "Gross Amount Paid" column is showing the same figure as the "Amount liable to deduction" figure.
What should the "Gross Amount Paid" column actually show, and why isn't it consistent?
I have run exactly the same report and just changed the date parameters or the supplier parameters, nothing else. I am using Quickbooks Online Advanced
Hello there, TomY78,
I'm here to provide some insights about the amounts showing up on the CIS Payment and Deduction Statement report. The data on this report depends on how much the amount is subject for CIS computation. And, it shows and focuses on the liability deductions.
You can contact our state agency or accountant for the computation. I'm adding this report to learn how this works in QuickBooks: CIS in QuickBooks Online.
If you need to customize this report to display the individual statement of your sub-contractors, please follow these steps:
In case you want the same customization settings for future use, you can take a look at this article to learn more about memorizing a report in QuickBooks Online.
Stay in touch if you have any follow-up questions or concerns about CIS. I’ll be right here to assist further.
Thanks for your email but that isn't the problem. I know how to run the report, it's the results which were incorrect and not consistent. However, I have figured out why it is wrong, I just don't know how to fix it as I think it's a technical problem with the report setup/design/configuration/formatting.
In Customization - if you Show All columns in the Show non-zero or active only the report is correct.
If you change it to Show Active Columns or Show Non-Zero columns, the report is no longer correct as the figures change.
Hello TomY78, Can you reach out to us on FaceBook or Twitter as a DM/PM under QuickBooks UK with a screenshot of the report showing correctly and incorrectly and your email address so we can speak to our senior technicians about the cis payment report inconsistancies.Thanks
Hello TomY78, Can you give us a call on 08082345337 and we can do a screen share to investigate the inconsistency in that report you are seeing as we really need to look at the figures to have an example. if this needs to be escalated to our engineers.