I generally try to roast 2 batches each weekend.
Each roast yields around 600g. 1.2k in total.
Usually these go into 4 sealed bags (one-way valve thingies) and go into the pantry until required.
My aim is to be a week or 2 ahead with my roasting unless I do a variety that I have a specific resting time in mind for.
Just the 2 of us will go close to consuming 600g in a week.
Visitors etc. might take us over the 1kg
Sometimes a bag or 3 is given away.
If we get to a point where we have a few extras in the pantry, then I might only roast 1 batch for the week or sometimes none at all. Although I do get edgy when I have not roasted any for a week - I spend time panicking that there will be a RUSH of visitors to drink it all down. Paranoid? Paranoid? I wouldnt be so paranoid if it wasnt for the fact that everyone is looking at me! - but I digress
Basically, I have learned the hard way, it is better to dump small amounts of beans past their prime because you have plenty, than have no beans (or a roast too young to enjoy).
I also have a spreadsheet, but it is really a tracker of inventory more than anything.
Hope that helps.