How do you stay consistent tracking purchases in spreadsheets?

I’ve been talking to sellers about operations, and one thing keeps coming up: everyone knows they should track every purchase (order date, tracking, units received, damaged inventory, pricing) but most people hate actually doing it.

One seller mentioned his tracking system saved him $15K last year when Amazon lost inventory because he had proof of what he sent. Another said documentation saved his account during a supplier verification audit. So the value is obvious. But the execution sucks. Manually updating spreadsheets after every order is tedious, and it’s easy to fall behind when you’re busy.

For those of you who actually maintain purchase tracking consistently: • What’s your system? • How do you stay disciplined about it? • How long does it take you per invoice? • Do you automate any parts of it? Curious what’s working for people who’ve figured this out.