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 have recorded 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.


Download Practice Workbook


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.

Read More: Create General Ledger in Excel from General Journal Data


Step by Step Procedures to Make Journal Entries in Excel

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


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.

Read More: How to Make a Trading Journal in Excel (with Easy Steps)


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.

Read More: How to Create a Bullet Journal in Excel (with Detailed Steps)


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. You can visit our Exceldemy site for more details on Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo