Fixed asset analysis
This release includes optional sheets to analyse fixed assets and reconcile amounts to the accounts.
The
Fixed asset note
is an optional sheet which can be added to the calculation. This replicates the layout of the fixed asset note in the accounts and provides values to reconcile fixed asset additions and disposals.
The sheet includes 3 columns to classify the fixed asset movements, but additional column can be included if required. This is done by selecting Insert line item from the menu and choosing from the list of asset types. Additional asset types can be added if required.
Capitalised revenue expenditure
A new sheet has been added to track the movements on capitalized revenue expenditure and to adjust the trading result. The sheet can be inserted from the
Insert sheet
menu.
To complete the sheet, enter rows for each asset, enter either a writing down period or percentage depending on whether you want a straight line or reducing balance calculation of the depreciation. The depreciation will then be allowed against the total depreciation which has been identified in the profit and loss account.
Where there is more than one trade it is necessary to allocate the adjustment to each trade as required.
This release includes new sheets to analyse movements on pension contributions, provisions and also to adjust for capital items included in the profit and loss account.
These sheets require you to use the Income statement and are unavailable until it has been added to the calculation.
Due to the need to identify the classification for the tax return and the nature of the adjustment a new
Analysed as
column has been added which contains a drop down of the potential tax treatments that can also be applied to the row.
A new pension contributions sheet has been added which tracks the movement on the balance of the pension contributions and adjusts the trading result for the difference in the value in the income statement and the amount that was paid in the period.
On the
Income statement
select
Pension contributions
from the
Analysed as
column. Next insert the
Pension contributions
sheet from the
Insert sheet
menu. This will insert the pensions sheet and will automatically include the row from the Income statement which was identified as Pension contributions.
Where there are multiple pension schemes which need tracking it is necessary to add rows for each scheme in the Income statement.
A new provisions sheet has been added to adjust values in the
Income statement
and track the movement in the provision.
On the
Income statement
select
Provisions
from the
Analysed as
column. Next insert the
Provisions
sheet from the
Insert sheet
menu. This will insert the sheet and will automatically include the row from the Income statement which was identified as Provisions.
Where there are multiple provisions which need tracking it is necessary to add rows for each scheme in the Income statement.
To make the adjustment where there are capital items included in the income statement an option has been added to the
Analysed as dropdown.
To adjust the trading result for capital items, select Capital from the dropdown, this will add a row in the reconciliation section of the
Capital allowance additions
sheet.
Depreciation and P/L on disposal
The analysed as column now includes options for Depreciation and P/L on disposal to reconcile the depreciation charge or the profit / loss on disposal on fixed assets between the Income statement and the balance sheet entries. Depreciation will reconcile to the
Fixed asset note
and
P/L on disposal
will
reconcile to the
Disposals analysis.
Partner allocation summary
Due to online filing limitations at HMRC certain amounts cannot be included on the Partnership statement (for example additional trades are filed on PDF copies of the form). We have also received feedback from customers that in some circumstances partnerships may not want to include all the elements of the calculation of a partner share to HMRC or other partners in the partnership.
We have therefore added the Partner allocation summary to ONESOURCE. This collates all the partner shares entered into the individual allocation sheets and presents the result into a single sheet. You can add more than one copy of this sheet if you are preparing the return on more than one base, in this case you should select the basis you require in the drop down on this sheet.
To add the Partner allocation summary select Insert sheet and then Partner allocation summary. After the sheet has been inserted select the required basis from the dropdown menu at the top of the sheet.