How to Create a Financial Ledger on a Spreadsheet. Managing the day-to-day finances of your business is essential. You need to know where money is coming from, where it's going and the amounts ...

To use Excel to create a General Ledger from General Journal data, you can set up a worksheet, which includes a number of array formulas that sum up the transaction into the proper accounts.