Investigating accretion behaviour In cataclysmic variables using all sky survey photometry