Follow these steps to set up a general ledger accounting system in Excel. A small business can use Excel as a substitute for expensive accounting software.

How to Set Up a General Ledger. The general ledger is a tool accountants use to record transactions. Each time a company makes a transaction, a corresponding journal entry must be made.