Convert your daily General Journal data into a more extensive, yet focused, General Ledger using Excel in this tip from Mary Ann Richardson.

Using Excel as a General Ledger . It's important to note that every business is different from one another and will, therefore, have different reporting needs.

Open Microsoft Excel, click the "File" tab, and then choose the "New" link. When the Available Templates window appears, type "ledger" into the search box, and then click the arrow button.

To record wages, you should first list the components of employee salary in the form of a general ledger. Social security tax is one of these components. Payroll Clearing Accounts and Balance Sheets ...