Up to this point I've pretty much done small jobs and service work. I just got roped into a large remodel (electrical +30k not including fixtures) and the change orders are piling up. I'm guessing the change orders are up to 10k or so. I'm finding it difficult to keep track of the change order credits/debits for rough and trim parts. I made a spread sheet in excel and have been religiously keeping track of it but I'm wondering if there is any examples or ideas you guys can share with me.

Thanks,
Byron