In bygone years I have been rather haphazard, but since I have been retired, and got some medium format gear in 2006 and resurrected what passes for a darkroom, I have instituted a system that meets my needs. I store the negatives in archival pages in ring binders with each page identified with a roll number, film, subject and date. The roll number, since a series of GAS attacks, includes a prefix 'SQ' for the SQ-A, 'Pk' for the Perkeo II, etc.
On the computer I have an Excel spreadsheet, one page per roll, where I record more info including one line entry per frame that may include subject, exposure, filter, (lens if that is interchangeable) and possibly a short note. Being a retired computer geek, I have slowly evolved that into a master index page, a subject index page which has entries grouped by year and then camera (with 'Misc' for an assortment of little used cameras). The subject entries include the topic/location, date, and a clickable link to the associated roll pages.
When I'm "seriously working" I carry a small voice recorder into which I blather about exposure and any comments about the scene and subject. I later transcribe that to the spreadsheet page(s). I imagine if I were shooting a dozen rolls a day and under deadlines, much of the above might fall by the wayside!
Additional geekery has added some pages that track film purchases and a film index that allows clicking to individual roll pages from various film types so I can see how many rolls of PlusX I have left [sniff!] and what I shot on what, etc. Each individual roll page has links to go back to the Master Index, Subject Index and Film Index, plus also a note on processing -- either the lab if color, or the developer, temperature and time for B&W done here, as well as a summary of how they came out ("a little thin" etc.).
It sounds more complicated than it is. :confused:
(I am also known to use ExifTool to put the camera make, model and exposure into files from any frames I scan.
)