Enter your idea

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.