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 Settings
Page
This page
records the required information about the Contractor,
such as the Company Name, Address and Tax information.
Also the
Tax Year can be selected. 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.
Also the
Settings Page stores the current (any any changes to
the) VAT Rate.
SubContractors
Record
all the necessary details about each SubContractor on
this page. 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.
Self
Employed
Name, Trading Name, Address, Unique Tax
Reference (UTR), National Insurance Number (NI),
VAT Registered or not, and Verification Details.
Partnership
As for Self Employed above, plus Name, Unique
Tax Reference (UTR) and National Insurance
Number (NI) for the business partner.
Limited Company
Name, Company Name, Address, Company Unique Tax
Reference (UTR) and Company Registration Number,
VAT Registered or not, and Verification Details.
The
SubContractor information entered feeds through to the
rest of the spreadsheet.
Transactions
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.
Monthly
CheckList
At the
end of each month, this checklist 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.
Monthly
Return
From this
page, a report is printed giving all the necessary
information to complete your CIS Monthly Return
(CIS300).
The Tax
Period is selected from the previous page, the Monthly
CheckList.
Statements
On this
page you can select what Statements you wish to print.
Selecting
from:
Entering a Date Range
Past Tax Period
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.
Cost
From
only
£40.00 + vat
[More...]
Specifications
Will work on
Microsoft Excel 2003 and 2007
Spreadsheet Size
(approx) before any data
Excel 2003 - 30MB
Excel 2007 - 6MB
Share Workbook
Function - Not Recommended
Need Macros Enabled -
No
Max. No. of Years of
Transactions - 6 Tax Years starting with 08 / 09
Max. No. of
Transactions - 5000 Transactions
Max. No. of
SubContractors - 100
Help Page - No
