How to Make Journal Entries in Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Every business industry is built on some investments and planning. In order to observe its growth of it, we like to record every investment in the business. It needs to be updated every limited period to observe the financial growth of the business. For this, we need to make journal entries on every single matter related to money. In this article, I am going to discuss how to make journal entries in Excel. I hope it will be helpful for every business analyst.


What Is Journal?

A journal is a thorough account that documents all of a company’s financial activities. It is used for account reconciliation in the future and for the transfer of data to other official accounting records, including the general ledger.


How to Make Journal Entries in Excel: Easy Steps

In order to maintain objective records, journaling is crucial. It also enables quick reviews and records transfers later on in the accounting process. Here, I am going to discuss the whole procedure in 3 steps on how to make journal entries.

  1. Formation of an Initial Balance Sheet
  2. Generate Financial Statements for a certain period
  3. Make entries in the journal

1. Formation of an Initial Balance Sheet

At the beginning of the journal entries, we need to make an initial balance sheet. The steps are described in the below section.

Steps:

  • Take into account every expense at the start of the business and organize them in a perfect way. In my case, I have taken a dataset related to the starting condition of the production business. I have organized the data in Particulars, Credit/Debit, Debit, and Credit columns.

How to Make Journal Entries in Excel

  • Next, input the following formula to have the debit summation.
=SUM(D5:D12)

Here, the SUM function has returned the output of the summation of cells D5:D12.

  • Press ENTER to have the summation.

How to Make Journal Entries in Excel

  • Use Fill Handle to autofill the right cell to have the credit total.


2. Generate Financial Statements for a Certain Period

In order to make journal entries, we need to have some financial activities enlisted. For this, we can consider a certain period to have some financial statements. With that, we can generate financial statements.

Steps:

  • Enlist the financial activities for a certain period. Here, I enlisted the financial activities of a company in the month of July 2022.

How to Make Journal Entries in Excel

  • Rearrange the financial activities into a balance sheet mentioning debit and credit.


3. Finalize Journal Entries in Excel

Finally, make entries the financial data in the journal. This updated journal will help us to analyze the overall present condition of the company and plan to march forward.

Steps:

  • Consider every financial statement into account considering both the initial balance sheet and the newly created balance sheet.
  • . Calculate every financial statement with these two sheets.

I input the following formula to have the present Machines condition.

=Dataset!D5+Entries!E18

Here, I added the total value of the machines.

How to Make Journal Entries in Excel

  • Press ENTER to have the result.

For Inventory, I just mentioned it from cell D6 of the worksheet named Dataset.

How to Make Journal Entries in Excel

  • Make entries of every financial statement in the journal following the above procedure.

  • After that, input the following formula to have the debit summation.
=SUM(D5:D16)

Here, the SUM function has returned the output of the summation of cells D5:D16.

How to Make Journal Entries in Excel

  • Hit the ENTER button to have the debit total.

  • AutoFill the right cell to have the credit total.

How to Make Journal Entries in Excel

As both debit total and credit total are equal, we can certainly say that our sheet is balanced.


Download Practice Workbook


Conclusion

In the end, I like to add that I have tried to explain step-by-step procedures of how to make journal entries in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below.


Related Articles


<< Go Back to Journal Entries in Excel | Excel for Accounting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo