A good accounting software will do the work for you. Accounting for a business on spreadsheets is going to be similar to using the old green ledger paper and balancing accounts manually. Nobody does that anymore, because it’s too time consuming, and accounting software like quickbooks only costs $100-$200. If you use the software correctly, it should save you more than that in labor (even if you’re doing it yourself) each month. And, it will produce reports (inventory, P/L, Bal. sheet, cash flow) on the fly to let you know how you’re doing and where you can improve.
Anytime you use software it’s should make your life easier and more efficient. Sometimes people don’t use the software because they can’t justify the cost is worth it. But, we’re only talking $99 here, it’s definately going to be a worthy investment.