Require a
system to record payments and deductions for
SubContractors?
This
spreadsheet allows you to keep details on all your
SubContractors, including Verification Numbers, payments
and deductions made to SubContractors. From this
data, you can produce a monthly report to complete the
CIS 300 Monthly Return along with printing the required
statements to send to SubContractors.
The
system covers six Tax Years starting with 08 / 09.
The
spreadsheet has two Modes, Normal Mode where you can
only enter transactions from the current system Tax
Period, and the Amend Mode, where you can add / amend
Transactions to previous Tax Periods.
Currently, there are three Tax Rates used for the CIS
Scheme, Gross, Standard and Higher Rates. The
system will allow for up to ten different Tax Rates at
any one time, just in case. Also the system allows
for up to ten changes to any of the Tax Rates, ie, the
Standard Rate is currently 20%, but could change to 22%
at some point, you never know.
The
spreadsheets allows for up to 100
SubContractors. Depending on the
business status of each SubContractor,
various data fields appear to enter the
required information.
The
SubContractor information entered feeds through to the
rest of the spreadsheet.
Enter all
the payment details selecting the SubContractor from a
dropdown list.
Columns
for:
Selecting SubContractor, Tax Rate*, VAT applicable*,
Payment Date, Reference, Labour amount, Materials
Amount, VAT Amount**, Total Bill, Other Deductions,
Tax to be Deducted*, Tax Actually Deducted, Total to
be Paid*, and Total Actually Paid.
*
entered automatically fed from SubContractors
details
** entered automatically if SubContractor is
VAT Registered, but can be amended if different to
actual bill.
At the
end of each month, a checklist page helps you through
what's required to be done.
Tells you
how much CIS Tax Deducted for each Tax Period to be
paid.
Record
Tax Payments made.
Warnings
appear for adjustments that need to be made to previous
returns.
When ready, a report is printed giving all the necessary
information to complete your CIS Monthly Return
(CIS300).
SubContractor Statements can be printed
at any time, selecting a Date Range,
Previous Tax Period or the Current Tax
Period.
Then
selecting from the list of SubContractors and type of
Statement you require (Original, Duplicate or Amended),
you can print a Statement. The list of
SubContractors will only include SubContractors who were
paid during the selected Date Range or Tax Period.