UK Government officials claim the report, by the Scotland Office and the Treasury, shows the “oil black hole” has risen from £20bn to £23.5bn in the last 30 years.

Scotland Office Minister Ann McKechin said the figures undermined the case for full fiscal autonomy or separation from the UK.

She said: “We know oil is important to the Scottish economy but too many people think it is some sort of magic bullet.

“These figures show that even with all the UK tax from oil and gas for the past 30 years Scotland would need to find £23bn from somewhere to cover our spending over that period.

“Those who tell you that we can start a separate country on the back of our oil revenues are very misguided.”

The report, which will be published next month, shows a 17.5% rise in the deficit from Treasury research published in June which claimed the deficit since 1980 was £20bn.

The updated figure takes into account figures from the 2007-08 financial year.

They show a Scottish deficit of £11.1bn and say that even if Scotland was given all the £7.6bn UK oil and gas tax revenue from the year, the deficit for last year alone would be the £3.5bn figure. The £11.1bn is the difference the Scotland Office and Treasury have calculated between all government expenditure in Scotland by the UK and Scottish Governments and local authorities and all government revenues in Scotland.

It includes the Scottish share of UK Government expenditure that relates to all of the UK such as defence, overseas representation and debt servicing. The new research claims that even if all UK oil and gas receipts had gone to Scotland, only in nine of the last 28 years would Scotland’s finances have been in surplus and the last time it would have happened would have been 1988.

It says oil and gas receipts are equivalent to between a quarter and a third of the entire budget of the Scottish Parliament and they have been at the mercy of fluctuations of recent year-on- year 20% fluctuations.

The report claims that in comparison, oil and gas tax revenues in the past three years have represented between 1.7% and 2.5% of all UK tax receipts making the UK as a whole better able to cope with such fluctuations.

A spokesperson for the First Minister said the report was a “grotesque attack on Scotland by a Labour Government whose woeful mismanagement of the economy has put the UK into almost £180 billion of deficit this year”.

“The Government Expenditure and Revenue Scotland (GERS) official study shows that in the three years to 2007-08 Scotland ran a cumulative current budget surplus worth £2.3 billion. Over the same period, the UK had a cumulative current budget deficit of £24 billion.

“Scotland’s oil and gas industry is the only thing keeping the London Treasury afloat and the recent Pre-Budget statement showed that over the next six years £50bn worth of revenues will flow to London -- up £10bn on the Budget forecast in April.”

The spokesman said Ms McKechin’s comments about fiscal autonomy and independence were “simply ridiculous”.

He added: “It is just not credible to claim that Scotland cannot be successful in managing our own affairs, especially after years of economic mismanagement from Downing Street.

“The Scotland Office is now spending its time working against Scotland’s interests rather than standing up for Scotland at Westminster -- it is the anti-Scotland Office.”