Suffice to say one of the many reasons Scotland voted against the last referendum was because they knew the SNP haven't got a fucking clue how to run a country, and it would have been financial suicide.
In 2020-21, Scotland (including a geographical share of North Sea revenue) raised £62.8 billion in 2020-21, compared to £99.2 billion of public spending for Scotland. Note that in particular spending was higher due to the response to the coronavirus pandemic. Figures for previous years are also available in the latest GERS publication for comparison.