Spot on about the audit. I've been caught out twice—once on the boat thinking 12V fridge usage was negligible, turned out to be a proper power drain.
The bit nobody mentions: factor in vampire loads. Inverter standby, solar controller, monitoring kit all nibble away. On my tiny house setup I reckon about 2-3% daily loss just from stuff being switched on.
Also worth doing your audit across different seasons if you can. Winter usage on the boat is wildly different from summer—heating, shorter daylight hours, less solar generation. Designed my system around worst-case (Feb basically) and now I've got comfortable headroom rather than constantly sweating the battery voltage.
Spreadsheet method works dead well. Columns for each appliance, watts, hours per day. Chuck in some contingency too—real-world always uses more than theory.