Hi Neil, I have created a report that helps them reconcile what has been paid. I use the Suppliers / Day Books / Day Books: Paid Invoices (Summary) report as the base and have adapted it to calculate the CIS deduction which is OK for the supplier that has asked for it. If you have a number of suppliers asking for it all on different deduction rates this may become more complex but they may just be happy to have the standard report. However, what you are asking for would be nice to see formally in the CIS section.

Thanks Paula. That would work as an extra report. It is not unusual for me to "fudge" existing reports to cater for CIS which Sage does not, yet, do well. Each week I generate a supplier totals, only, version of the Invoices by Due Date report to facilitate FD sign off for the payment run. I had to "fudge" this to calculate CIS deductions. With CIS Statements, my issue is that the subcontractors became accustomed to a line listing invoices on the statement that the accountants used to produce manually. When we moved to the Sage CIS module we lost this. I have adapted the CIS statement to have a line for this, immediately after the month ending date line, picking up the top line manually entered on the communications list in supplier maintenance. I now seek the holy grail of automatic population of this line based on activity! :-)

Hi Neil,

If you have a specific report in mind, please get in touch with us either by calling on 0845 111 55 55 or via Web Chat and we can discuss the best way to get this information to appear.

Hi Adam,
Nothing too fancy. I am just looking to extend the, standard, CISMONTHLYSTATEMENT report to have an extra line showing Invoice numbers. My "work in progress" version has a middle section :-

Construction Industry Scheme
Statement of payment and deduction for month ending: 05/12/2017
Invoice Numbers: 1234, 1235, 1236

Does that make sense?

ManyThanks

Neil

Hi Neil,

Yes that makes sense.  Please give us a call so we can discuss the best way of designing this with you.

I have now been able to produce batch CIS statements to pdf, for a period, using an excel spreadsheet connected over ODBC to Sage 50. Visually the Statements look like the standard Statements but I now have an extra line showing the included subcontractor invoices.

Hi Neil,

I'm glad to hear you have the statement you're looking for.

If you have any further issues, please let me know.