How to view, edit, and delete spreadsheet details

Note: You must be logged in to be able to view, edit, or delete spreadsheet details.

To view spreadsheet details:

  1. Click View/Edit Spreadsheet from the menu bar.
  2. Select a financial year and the spreadsheet columns you want to display.
  3. Select or deselect check boxes to determine the columns to be displayed in the spreadsheet. If, for example, your company is not registered for VAT you may want to hide all the VAT-related columns because they are of no interest to you.
  4. Click the View/Edit Spreadsheet button.
  5. Use the scroll bars to move around the spreadsheet.

Month

These are the months that you entered using the Add Month form.

Amount Invoiced

This is the amount of money your company has invoiced for a particular month. You enter values in this column using the Add Month form, or by editing an existing month.

VAT Charged

VAT is 17.5% of the amount invoiced. Values in this column are calculated by the software.

Gross Receivable

This the amount invoiced plus VAT. Values in this column are calculated by the software.

VAT Payable

This is calculated by multiplying the gross receivable by the VAT flat rate percentage (see How to set static values). For a particular month, this is the amount of VAT you will have to pay. Values in this column are calculated by the software.

VAT Surplus

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. Values in this column are calculated by the software.

Accountancy Fee

This is your monthly accountancy fee, which you set up on the static values form (see How to set static values).

Gross Monthly Salary

This is the gross monthly salary bill for your company. You entered this value using the How to set static values form.

Income Tax

This is your company's monthly income tax bill. For a particlar month, you enter this value using the Add Month form, or by editing an existing month.

Employees NI

This is your company's monthly employees national insurance (NI) bill. For a particlar month, you enter this value using the Add Month form, or by editing an existing month.

Employers NI

This is your company's monthly employers national insurance (NI) bill. For a particlar month, you enter this value using the Add Month form, or by editing an existing month.

Net SalaryM

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.

Bank Interest

This is the amount of bank interest paid into your company bank account. For a particlar month, you enter this value using the Add Month form, or by editing an existing month.

Other Revenue

This is any other revenue that has been paid into your company bank account. For a particlar month, you enter this value using the Add Month form, or by editing an existing month.

Expenses Taken

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. For a particular month, you enter this value using the Add Month form, or by editing an existing month.

Pension Contributions

These are pension contribtions that have been paid by the company. For a particular month, you enter this value using the Add Month form, or by editing an existing month.

Other Deductions

These are additional deductions that have been taken out of the company bank account, for example, insurance contributions. For a particular month, you enter this value using the Add Month form, or by editing an existing month.

Corporation Tax Due

This is the amount of corporation tax due for the month. It is calculated as follows:

(invoice amount + bank interest + other revenue + VAT surplus) -
(accountancy fee + gross salary + employers NI + other deductions + expenses + pension contributions)

Maximum Dividend that can be taken

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 + pension contributions + corporation tax due)

Expected Total Pickup

This is the total amount that you can expect to pick up for the month. It is calculated as follows:

expected dividend + net salary + expenses

Actual Dividend Received

This is the actual dividend you have taken out of the company bank account. For a particular month, you enter this value using the Add Month form, or by editing an existing month.

Difference

This is the difference between the maximum dividend that can be taken and the actual dividend you took.

Expected Retention

This is the expected retention for the month. It is calculated as follows:

100 x (expected total pickup / invoice amount)

Comments

Any comments you enter using the Add Month form, or by editing the month, are shown here

Year Totals

This row shows the sum of the various columns described above, for the currently-displayed year.

Grand Totals

This row shows the sum of the various columns described above, for all the years entered into the application.



Edit a month

To edit spreadsheet details:

  1. Click View/Edit Spreadsheet from the menu bar.
  2. Select a financial year and click the View/Edit Spreadsheet button.
  3. Click the name of the month you want to edit.
  4. Edit the details for the month and click Update Values.

For an explanation of the fields, see the help for the Add Month form.



Delete a month

To delete one or more months from the spreadsheet:

  1. Click View/Edit Spreadsheet from the menu bar.
  2. Select a financial year and click the View/Edit Spreadsheet button.
  3. Select the check box(es) for the month(s) you want to delete.
  4. Click the Delete Selected Month(s) from Database button.

Caution: You are NOT prompted to confirm the deletion(s), so be careful!