Note: You must be logged in to be able to perform this task.
To add a new month to the Earnings Tracker spreadsheet:
This drop down list contains a list of financial years. The default is taken from the default settings.
Enter up to five characters to describe the month, for example, Jan, Feb, Feb1, mar 1, and so on. The application is very flexible about what you enter, but you should obviously use meaningful names.
This is a compulsory field.
Enter up to eight invoice amounts. Optionally, you can also enter the client name or reference (up to 30 characters of free format text), and another piece of information (up to 30 characters of free format text), for example, the invoice number.
The invoice fields must contain a value, even if it is '0'.
Enter any bank interest paid into your company bank account this month.
This field must contain a value, even if it is '0'.
Any bank interest received needs to be included in the VAT Flat Rate Scheme calculation. For this reason, this check box must be selected (checked). The default setting for this check box is controlled by the Set Default Values page, which is checked by default (by the software).
The reason you have the option to de-select (uncheck) this check box is so that if the law changes in the future, and bank interest does not need to be included in the VAT Flat Rate Scheme calculation, you can deselect it (without the software needing to be updated).
Enter any other revenue received this month that has not been included on an invoice. This might be, for example, revenue from Google Adsense, or perhaps a refund that was due to you.
This field must contain a value, even if it is '0'.
Optionally, in the Details field, you can enter up to 100 characters of free format to describe what the revenue is.
Depending on the source of the other revenue, you may need to select (check) this check box. Refer to the HM Customs & Excise website to see whether or not the revenue needs to be included in the VAT Flat Rate Scheme calculation.
Enter the total gross salary bill for your company for this month. If more than one person is drawing a salary from your company, enter the combined salaries here. You can get this information from your/their payslip(s). By default, the value entered in this field is taken from the default settings. You can change it here of you want to.
This field must contain a value, even if it is '0'.
Enter the amount of income tax paid this month. If more than one person is drawing a salary from your company, enter the combined income tax amount for them here. You can get this information from your/their payslip(s).
This field must contain a value, even if it is '0'.
Enter the amount of employees national insurance (NI) paid this month. If more than one person is drawing a salary from your company, enter the combined NI amount for them here. You can get this information from your/their payslip(s).
This field must contain a value, even if it is '0'.
Enter the amount of employers national insurance (NI) paid this month. If more than one person is drawing a salary from your company, enter the combined NI amount for them here. You can get this information from your/their payslip(s).
This field must contain a value, even if it is '0'.
Enter your company's monthly accountancy bill here. By default, the value entered in this field is taken from the default settings. You can change it here of you want to.
If you pay your accountancy fee annually instead of monthly, you can leave this field set to zero for 11 months of the year, and just enter the full accountancy fee when you are adding the 12th month.
This field must contain a value, even if it is '0'.
If you rent an office or a desk in an office, enter the monthly rent here. By default, the value entered in this field is taken from the default settings. You can change it here of you want to.
If you pay your rent annually instead of monthly, you can leave this field set to zero for 11 months of the year, and just enter the total annual rental amount when you are adding the 12th month.
This field must contain a value, even if it is '0'.
Enter any expenses that have been withdrawn from the company bank account this month, which are separate from salaries, dividend payments, and other outgoings, for example, travel expenses.
This field must contain a value, even if it is '0'.
Optionally, in the Details field, you can enter up to 100 characters of free format to describe what the expenses are.
Enter any bank charges that have been paid by the company this month.
This field must contain a value, even if it is '0'.
Enter any pension contributions that have been paid by the company this month.
This field must contain a value, even if it is '0'.
Enter any additional outgoings that will be deducted from the company bank account this month, for example, insurance premiums.
This field must contain a value, even if it is '0'.
Optionally, in the Details field, you can enter up to 100 characters of free format to describe what the other outgoings are.
If a dividend payment has been made this month, enter it here. Enter the combined figure for all shareholders who received a dividend payment, for example, if two shareholders received £6,000 each, enter £12,000 here.
This field must contain a value, even if it is '0'.
Optionally enter any additional comments here (free format text). You can enter as much text as you want to.
Enter the standard rate of VAT, flat rate of VAT, and corporation tax rate. By default, the values entered in these fields are taken from the default settings. Although they are values that should very rarely change, you can change them here if you need to.
Note: If you are not registered for VAT, or you are not using the VAT Flat Rate scheme, you can simply ignore (or hide) the appropriate VAT columns when you view a spreadsheet.
Additional help and information relating to Earnings Tracker is available at: http://www.dixondevelopment.co.uk/earningstracker.htm