The rows in this sheet are populated automatically using data from individual entities. Each row in the table shows data relevant to each entity. Insertable columns allow you to specify dates and amounts of group payments and allocate them to the individual company’s tax liability. These amounts can then be pushed down to populate the Tax payments and interest sheet in the entity calculations.
The rows and columns in this sheet are populated automatically using data from individual entities. Companies with outstanding tax liabilities are shown in rows going down the sheet and companies with available overpayments are shown across the top. Here you can allocate amounts of tax overpaid in group companies and surrender them to other group members. These amounts can then be pushed down and linked to the Tax calculation sheet in the entity calculations.