CIS - Breakdown on CIS Suffered Report
It would be a massive help if you could click on the figures on the CIS suffered report to see which customer invoices make up the report figures. Clients often ask me which invoices are included and I have to manually work out where the figures come from
Mandy Carter
shared this idea
Hi all, wanted to share a workaround here for those who aren't already aware.
You can run the Account Transactions report on a cash basis and if you filter it by the CIS Labour Income or CIS Asset account, you can see the invoices which have been included in the CIS Suffered report.
We don’t have any plans in the near term to expand functionality on the CIS Suffered report. If anything changes in this space, we’ll update you on this idea!
-
Elaine Hardy
commented
We are finding it fiddly to reconcile the amounts held in the two CIS control accounts on the balance sheet to the CIS return and CIS suffered report.
As CIS tax deducted is included on the CIS return at the point it is paid, then there can be a gap where the amount on the TB in the CIS Liability account does not reflect the amount on the return.
It would be useful to be able to run a report to show CIS tax deducted from the purchase invoices which haven't been included on the return (i.e. unpaid purchase invoices). This could be in the form of a column on the Aged Payables report grouped by contact group (Sub-Contractors) which shows the amount of CIS tax not yet deducted from the sub-contractor; and visa versa for CIS suffered.
At the moment we are running this report, exporting it to Excel and then manually adding a column and the amount of CIS tax not yet included on the return. Would be good if we could remove this manual process, and I'm open to suggestions if anyone has a better way to do this.
Thanking you in anticipation.
-
Aaron Brown
commented
Yes this would be a massive help to be able to click on the figure and see what it is made up of when you are trying to reconcile accounts, not very helpful to have to run account transactions report as well
-
Michelle Worthy
commented
This would be so much easier than trying to work out which invoices that have been paid have been included as the CIS asset code brings invoices in when they have been raised not paid.
-
Chrisella Brown
commented
Yes a detail breakdown of each invoice per Contractor showing the same columns as the CIS Suffered report. This would make it much easier to reconcile the CIS Suffered against the Contractors CIS Statement.
-
Claire Robotham
commented
This would be very helpful for me. My accountant asks for a detailed report showing all invoice lines, per tax month for CIS contractor clients. This is something I have to do manually each month e.g. so that we can see the CIS entries per invoice per CIS contractor client.
-
Laura Rostron
commented
You can get around this by using the account transaction report for CIS Asset, click 'more' and change to cash accounting - this will give a detailed report of all the CIS suffered in the period.
-
Jayne Chapman
commented
This is definitely needed, my company deals with multiple CIS suffered customers and it is awkward to reconcile. Happy to still have a summary report but definitely need a drill down or detailed transaction report please
-
Lynne Huddleston
commented
Where more than one payment has been received from a customer that has CIS suffered in the reporting month - to be able to drill down and see each transaction CIS suffered applies to.