I found the family in Monifieth, Angus on the 1851 Scotland census at Ancestry listed as Berrts. I couldn't find them at ScotlandsPeople under Beats or by just searching Be*. When I searched another name on the same page that entry came up in the search results but it said there was no image available. Here's the entry:
1851 census - Brook Street, Broughton Ferry, Angus
John M Bertts, head, 38, auctioneer, born Dundee, Forfarshire
Agnes Bertts, wife, 34, born Edinburgh, Midlothian
John Bertts, son, 13, born St.Vigeans, Richmond
Charles Bertts, son, 10, born Dundee, Forfarshire
George Bertts, son, 9, born Dundee, Forfarshire
David Bertts, son, 5, born Dundee, Forfarshire
William Bertts, son, 4, born Dundee, Forfarshire
Marray I Bertts, son, 1, born Monifieth, Forfarshire
Virginia Bertts, daughter, 3 Mo, born Monifieth, Forfarshire
The family is at 30 Reform St, Dundee, Angus on the 1861 Scotland census. At Ancestry they are listed as Bealls but at ScotlandsPeople they are Beatts.
John M Beatts, head, 49, auctioneer & vatualor, born Dundee
Agnes Beatts, wife, 46, born Edinburgh
George W Beatts, son, 19, saddler, born Dundee, Forfarshire
David Beatts, son, 15, clerk, born Dundee, Forfarshire
William Beatts, son, 14, druggist, born Dundee, Forfarshire
Murry T Beatts, son, 11, born Dundee, Forfarshire
Virginia Beatts, daughter, 10, born Dundee, Forfarshire
Agnes Beatts, daughter, 8, born Dundee, Forfarshire
Robert Beatts, son, 6, born Dundee, Forfarshire
From the 1871 census, the family is at 31 Millars Wynd, Dundee, Angus:
John M Beatts, head, 58, auctioneer, born Dundee, Forfarshire
Agnes Beatts, wife, 54, born Edinburgh
David Beatts, son, 24, auctioneer's clerk, born Dundee, Forfarshire
Murray T Beatts, son, 21, engineer in steam sup, born Dundee, Forfarshire
Virginia Beatts, daughter, 20, music teacher, born Dundee, Forfarshire
Agnes Beatts, daughter, 18, government pupil teacher, born Dundee, Forfarshire
Robert Beatts, son, 16, chemist's apprentice, born Dundee, Forfarshire
On the 1881 census at 8 Forfar Road, Dundee, Angus:
John McLean Beatts, head, 68, auctioneer, born Dundee, Forfarshire
Agnes Beatts, daughter, 28, housekeeper, born Dundee, Forfarshire
I couldn't find John Beatts on the 1891 census but I did find a death for John McLean Beatts, 82, in 1893 in St. Andrews, Dundee at ScotlandsPeople. There is also a death registration for Agnes Budge Beatts, 65, who died in 1880 in St. Andrews, Dundee.
Jacquie