Thanks Kappy for the multiple suggestions. I did re-index my spotlight db as you suggested and strangely the size of the system went up about 10gb. I read through all of your suggestions (all good ones) and tinkered where appropriate without really changing much.
What I've figured out (or at least hypothesise) is that System in the get info or storage tab of About this Mac is not the same as my system folder, the actual OS. I couldn't see how someone could have a 230gb system file or nobody could ever use a mac with for example a 250gb drive which I think Apple still sells in cheaper macs. So I checked my actual system folder and (duh) and its orders of magnitude smaller, roughly 8gb.
What I've come to realise is that System in the About My Mac tab actually includes things like my music in the iTunes library (not the streaming stuff from Apple Music but the stuff I've burned from CD). It also seems to include iBooks books and pdfs and movies/home videos, etc. That makes much more sense to me now and I checked this hypothesis by deleting some iBooks from my mac and sure enough the System on the About My Mac tab was reduced an appropriate amount. I have a fair number of videos I burned in iTunes and I assume that accounts for a bunch of the 230gb the system reads at.
Thanks for your time
atb