How to Create a General Ledger in Excel – 4 Steps

 

Step 1 – Input Fields and Choose the Range

Select data to input into the General Ledger. A typical ledger has 5 fields: Serial no., Date, Description, Debit, and Credit.

Bold the names and increase the font size in the headers.


Step 2 – Creating a Pivot Table

Here, 13 rows will be inserted.

  • Select B4:F17. Procedures to Make General Ledger in Excel
  • Go to the Home tab and select Format as Table. Choose a type of table.

Procedures to Make General Ledger in Excel

  • In the confirmation box, check My table has headers.
  • Click OK.

  • The table will be displayed.

Procedures to Make General Ledger in Excel

  • Select Borders and go to Line Style.
  • A thick line border was selected here.

Procedures to Make General Ledger in Excel

  • Draw lines and separators.

  • Select the entire table and go to Table Design.
  • Select Total Row to display a Total row at the end of the table.
  • Use Line Border for this row.

Procedures to Make General Ledger in Excel


Step 3: Entering Calculation Functions in Table

  • Click the last cell in Debit. Here, E18.
  • Click the small arrow on the right.
  • Select Sum.

Procedures to Make General Ledger in Excel

  • In total days, select C18 and choose Count.

  • This is the output.

Procedures to Make General Ledger in Excel

  • Since there is no data in the table, the total field is showing 0.

Step 4: Analyzing the General Ledger

Enter data.

Procedures to Make General Ledger in Excel

The Debit and Credit data type is selected as Accounting.

To see the amounts of Debit or Credit for each description:

  • Select the entire table and go to Insert.
  • Select From Table/Range in Pivot Table.

Procedures to Make General Ledger in Excel

  • In the dialog box, select New worksheet and click OK.
  • A new sheet containing the Pivot Table field panel on the right will be displayed.

  • Select the fields.

  • Here, Description to categorize based on Description, Debit, Credit, and other fields.

This is the output.

Procedures to Make General Ledger in Excel

 

Read More: How to Make a Bank Ledger in Excel


Download Practice Workbook

Download the practice workbook here.


Related Articles


<< Go Back to Ledger in Excel | Excel for Accounting | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nasir Muhammad Munim
Nasir Muhammad Munim

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo