Note: You must be logged in to be able to view, edit, or delete spreadsheet details.
To view spreadsheet details:
These are the months that you have entered using the Add Month form.
This is the total amount of money your company has invoiced for a particular month. It is the sum of all the invoice amounts entered using either the Add Month or Edit Month forms.
This is the amount of VAT charged on the invoices raised. Values in this column are calculated by the software.
This the amount invoiced plus VAT. Values in this column are calculated by the software.
This is calculated by multiplying the gross receivable by the VAT flat rate percentage. For a particular month, this is the amount of VAT you will have to pay if you are using the VAT Flat Rate Scheme. If you are not using the VAT Flat Rate Scheme, ignore this column. Values in this column are calculated by the software.
Depending on whether the bank interest and other revenue check boxes are selected or deselected when adding or editing a month, the VAT Payable is calculated using one of the following:
a) If both check boxes are selected:
VAT Payable = VAT flat rate percentage x (net invoice amount + VAT + bank interest + other revenue)
b) If only the bank interest check box is selected:
VAT Payable = VAT flat rate percentage x (net invoice amount + VAT + bank interest)
c) If only the other revenue check box is selected:
VAT Payable = VAT flat rate percentage x (net invoice amount + VAT + other revenue)
d) If neither check box is selected:
VAT Payable = VAT flat rate percentage x (net invoice amount + VAT)
This is calculated by subtracting the VAT payable from the VAT charged. Your company gets to keep this amount, which you could typically take as part of a dividend. Note though that this amount is included in the corporation tax calculation (see below).
This column is only applicable if you are using the VAT Flat Rate Scheme. If you are not using the VAT Flat Rate Scheme, ignore this column. Values in this column are calculated by the software.
This is the gross monthly salary bill for your company. You entered this value when you either added or edited the month.
This is your company's monthly income tax bill. You entered this value when you either added or edited the month.
This is your company's monthly employees national insurance (NI) bill. You entered this value when you either added or edited the month.
This is your company's monthly employers national insurance (NI) bill. You entered this value when you either added or edited the month.
This is what is left after income tax and employees NI have been taken off your gross monthly salary(ies). Values in this column are calculated by the software.
This is the amount of bank interest paid into your company bank account. You entered this value when you either added or edited the month.
This is any other revenue that has been paid into your company bank account. You entered this value when you either added or edited the month.
These are expenses, for example, travel expenses that have been taken out of the company bank account, which do not form part of your salary of dividend. You entered this value when you either added or edited the month.
This is the monthly desk/office rent. You entered this value when you either added or edited the month.
You entered bank charges when you either added or edited the month.
You entered your company's accountancy fee when you either added or edited the month.
These are pension contribtions that have been paid by the company. You entered this value when you either added or edited the month.
These are additional deductions that have been taken out of the company bank account, for example, insurance contributions. You entered this value when you either added or edited the month.
This is the amount of corporation tax due for the month. It is calculated as follows:
corporation tax rate x ((invoice amount + bank interest + other revenue + VAT surplus) -
(accountancy fee + gross salary + employers NI + other deductions + expenses + bank charges + rent + pension contributions))
This is the maximum dividend that can be taken this month. It is calculated as follows:
(invoice amount + bank interest + other revenue + VAT surplus) -
(accountancy fee + gross salary + employers NI + other deductions + expenses + bank charges + rent + pension contributions + corporation tax due)
This is the total amount that you can expect to pick up (extract from the company bank account) for each month. It is calculated as follows:
expected dividend + net salary + expenses
This is the actual dividend you have taken out of the company bank account. You entered this value when you either added or edited the month.
This is the difference between the maximum dividend that can be taken and the actual dividend you took.
This is the expected retention for the month. It is calculated as follows:
100 x (expected total pickup / invoice amount)
Note: this amount does not take into account any additional PAYE (Pay As You Earn) income tax you may owe if you are a higher rate tax payer. If you do pay a higher rate of tax on some of your personal income, the retention rate will be lower than that indicated here.
Any comments you enter using the Add Month form, or by editing the month, are shown here
This row shows the sum of the various columns described above, for the currently-displayed year.
This row shows the sum of the various columns described above, for all the years entered into the application.
To edit spreadsheet details:
For an explanation of the fields, click here.
To delete one or more months from the spreadsheet:
Additional help and information relating to Earnings Tracker is available at: http://www.dixondevelopment.co.uk/earningstracker.htm