To set up a balance sheet for a sole proprietorship, list assets and liabilities to capture the company's overall financial picture as well as its financial relationship with its owner.

Although a running balance is commonly maintained on the same Excel worksheet as the debits or credits, you can also keep a running balance with figures that reside on different Excel sheets.