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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , and premium Excel consultancy services for Excel and business users. Feel free to contact us with your Excel projects.
Naimul Hasan Arif
Naimul Hasan Arif

Hello everyone, I am Naimul Hasan Arif, graduated from Bangladesh University of Engineering and Technology (BUET). I am working as an Excel and VBA Content Developer. I try to remain dedicated to my duties and give my best with my skills & knowledge.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo