Shopping Cart
Montego Data Store Shop

Montego Data Limited Produce An Excel Spreadsheet package to help the Small Business with its statutory form creation as required by the Inland Revenue. Since these forms are laid out the same as the official forms it is easy to transfer the calculations to the official forms. No doubt the Inland Revenue would consider accepting the computer produced forms as produced by this product.

Validation Button

Checks if the data is acceptable on all the entry fields.
The normal data entry will point out you have made an error on an entry field but not force you to fix the error.
This means it is possible to complete the form badly
It might be that you are trying to exit the application and not save the file.
If the Validation Button fails the entry fields it places you on the first entry field error.
You should ensure that your form is error free before attempting to print the forms.

---

Pay Slip Button

There is no mandatory requirement to produce this form. It does however provide useful detail that can be cross referenced to P11 and P14 forms.

---

Self Assess Button

This creates a tax summary and not the entire personal self-assessment output.

---

P14 Button

The P14/P60 is one of the most important forms.
The Company should provide the employee with a copy of this form.

---

P11 Button

---

P35 Button

This form has in recent years had the IR35 personal services question added to it.
PageTop

---

Dividend Button

This produces a word document covering the statutory minimum paperwork when distributing a dividend.

---

Company Edit Boxes

These fields in particular the Company Name are used throughout the application.

---

Tax Office Edit Boxes

The Tax Address fields such as Tax Office Name Tax Office Number are used on the P14

---

Rates and Bands Display

These are for the current year.
Some of the forms use these numbers for the internal calculations
but be warned not all the calculations are supported in this fashion.

---

Employee Fields

Column FileName

This is how Cut Red Tape assigns the spreadsheets to each employee.
You are advised to use only characters and numbers (the underscore character is acceptable)
If you attempt to enter a character that would conflict with the Excel's programatical needs it is replaced with the ( _ ) character.

Column AnnualPay

This Employee Data Column is central to the calculation of all the spreadsheets

Column Dividend

This Employee Data Column is used only by the Self Assessment Spreadsheet

Column Surname

This personal data is used on a number of the forms

Column Forename

This personal data is used on a number of the forms

Column Secondname

This personal data is used on a number of the forms

Column TaxCode

This is used on the Pay Slip SpreadsheetBR> This is used on the P14 Spreadsheet
This is used on the P11 Spreadsheet

Column Director

This column is either a * or a blank
It is used on the P35 Spreadsheet
PageTop

Column NINumber

This is used on the Pay Slip Spreadsheet
This is used on the P14 Spreadsheet
This is used on the P11 Spreadsheet

Column BankCode

This Employee Data Column is only used on the Pay Slip Spreadsheet

Column BankAccount

This Employee Data Column is only used on the Pay Slip Spreadsheet

Column Payroll

This is used on the P14 Spreadsheet
This is used on the P11 Spreadsheet
and also on the Pay Slip Spreadsheet

Column BirthDate

The format of this Employee Data Column as required by the Inland Revenue is ddmmccyy.
Where dd means the day and mm means the month and cc means the century and yy means the year.
This is used on the P14 Spreadsheet
This is used on the P11 Spreadsheet
PageTop

Column Sex

This should be completed with either a M for Male or a F for Female.
This is used on the P14 Spreadsheet

Column Road

An address detail line.

Column Town

An address detail line.

Column County

An address detail line.

Column PostCode

An address detail line.