Business inventory sheet

A friend of mine was starting a new business and asked if I could make an organizational system that would track all the expenses and calculate profits. 

Short summary: 

Keep a master list of every component you buy (Supplies) and log each supplier order against it (Purchases). You write down what physically goes inside one box (Kit) and what you charge for it (Products). You log every order that comes in (Sales) and everything you spend that is not stock (Expenses). Summary then answers the only two questions that matter week to week: how many kits must I sell this month to cover my costs, and is my bank balance going up.

The chain runs: what you paid a supplier → cost per unit → cost per kit → margin per sale → profit per month.

Feel free to download and share or suggest improvements. If you find an error dont hesitate to contact me!

Business Inventory Sheet