How to Create a General Ledger in Excel Tutorials
Microsoft Office provides links to general ledger templates pre-designed for Excel workbooks. These time-saving, formatted layouts can include just one worksheet or multiple worksheets. For example, a multi-tab workbook can contain worksheets for year-to-date budget summary, monthly expenses, plus detailed worksheets for each account, such as office, staffing or equipment. These free, downloaded templates can be adapted to your business needs.
Open the Excel program to display a new workbook.
Click the “File” tab on the command ribbon to open a list of commands.
Click “New” on the list to display a gallery of "Office.com" templates.
Type “general ledger” in the “Search Office.com for templates” text box. A gallery of thumbnail images appears in the middle pane.
Click the preferred thumbnail link. Preview the expended version in the right pane.
Click the “Download” button in the right pane. The general ledger template copies to the new worksheet.
Type the account numbers, account titles and the data for the actual, budget, remaining budget $ and remaining budget %.
Click the template's other sheet tabs to view and update, if applicable. For example, "Monthly Expenses."
Save this workbook in an accessible file location.