I'm not sure if my strategy is what you are looking for but what I have done is set up a spreadsheet called "Family Expenses". The rows were all the places I paid bills to like At&T, auto insurance, trash, taxes, home insurance, etc. The columns are Jan., Feb., March, etc. Since we normally pay a bill each month, one line is sufficient. Groceries bills are all kept in a folder and each month I add them up for that month only and enter the grand total in the line for Jan., Feb., etc. This only give me a basic idea of what I spend each month on groceries but not the detail of how much peanut butter is at Meijer versus Aldi. It at least tells me what I spend each year and then I try to cut corners on some of those bills. This has worked so well for me and it is all contained into one spreadsheet since there are multiple tabs I just create a new tab for the new year.
With two of the three kids out of the house for now it almost doesn't matter so much anymore regarding groceries because we just don't need as much stuff anymore. I never buy a grocery cart full of stuff anymore. We get milk, eggs, yogurt once a week and a few other things but never a big bill anymore. We've just entered a new part of life and it is strange.
Alice