HomeHow ToHow to Make a...

How to Make a Business Account Ledger in Microsoft Excel

Microsoft Excel has become a financial data management spreadsheet tool from Microsoft. Take advantage of a free general ledger template if you have problems creating equations, pages, and other Microsoft Excel fine points. It’s easy to enter data because of the themes, and there aren’t many that provide cumulative totals. So, let’s look at the most effective techniques to create an Excel business account ledger. 

Step 1

Use a free Microsoft Excel ledger template from one of the many online resources. This design must be compatible with all versions of Excel. All the transactions in such an accounting system are recorded in the general ledger. Multiple entry bookkeeping is required for general ledgers and suitable accounting procedures, impacting several users per transaction. 

Step 2

Locate the cell just above “1” on the right side of the letter “A” and place the cursor there. This command will highlight the full page of the ledger accounts worksheet. Hold down the “CTRL” and “C” keys simultaneously to duplicate the sheet. Add a new sheet by clicking on the “Insert” item in the menu bar and then the “Worksheet” button Press “CTRL & V” to copy the general ledger forms to a new spreadsheet from the upper-left corner column, which is above “1” as well as to the left of A. A total of eight general ledger items can be made in this template. 

Step 3

At least five little sheets are needed to keep track of 45 separate accounts. “Bank Accounts” should be the title of the first document. It must contain information about your verification, cash on hand, or payroll accts. “Rename” can be founded in the context menu by right-clicking the “Sheet 1” tab & selecting it from the list. That is where you’ll want to keep track of your “Income.” This includes sales, maintenance, and fee refunds.

Check out: MS Office app is available for Android and iOS devices

The “Expense” accounts have to be on the third sheet of the spreadsheet. Taxes & licensing fees are also included in this category. Equity accounts, such as the original cost, any owner-draws, and any investment back into the business, must be listed on the financial documents page. Equity accounts. Credit card debt and other types of unsecured debt should be included on the last page of the financial statement. 

Step 4

Extra sheets should be generated for places with more than nine accounts. “Expenses 2,” for instance, should be formed if the class has more than 9 clients so that “Expenses 3” can be renamed. Each new customer account requires a different account number. Starting points for all term deposits are 10–income categories (20), expenditures (30), shareholders’ equity (40), and liabilities (30). (50). 

Step 5

Consequently, each general ledger item does have its own set of entries in the general ledger. Make sure you don’t overlook them. The table’s dates and descriptions and the sequence in which they occur are self-explanatory. To complete post-transaction verification, it is necessary to enter the other account’s login. The other columns are debit, credit, and balance. 

Step 6

The balance is often increased when one pays for something, yet the balance is decreased when one does not pay for something. For every debit, there must be a refund. Another method to look at it is as follows: These concepts are separate: “what you got” and “where it came from.” 

Paying $400 for an electric bill is an example of this. You get a check taken from your company’s bank account to cover the cost of this. Are you aware of what you’ve gotten? Because you used $400 worth of electricity, this Utility account (#3010) would be debited $400. When you think about it, how did that happen? As a result, you should deposit $400 in your bank account (#10010). 


An introduction to fundamental accounting principles and Microsoft Excel applications was covered in this tutorial. Excel’s best practices for creating a business account ledger. Hopefully, it will make the process more accessible with the financial accounting for your small firm. 

Other accounting-related functions can be found in Microsoft Excel. It is possible to develop your financial spreadsheets & analyze your spending when you better understand accounting.

Check out: Convert Any Excel File to PDF for FREE With PDFBear

Most Popular

More Articles

GAMERSMENU: How to Start A Gaming Blog?

Blogging is one of the most effective methods to grow an...

How To Use Routersploit In Unrooted Android device

A Router is a physical device or a virtual appliance that...

How to Split PDF Pages without Downloading Software?

There are reasons to split PDF files, and they mainly apply...

Setting Up a 4G LTE Wi-Fi Network as an Alternative

Why should you consider setting up a 4G LTE wi-fi Network...

Read Now

How To Set Up Microsoft Office 365 From The Scratch

If you have a small business and want to scale its operation in the nearest possible time, you need to do one or two things to set the right foot for your business. One of the things you need to do is integrate technology into your business...

How To Fix HP Photosmart Printer Error Code oxc19a0020

In this article, we will discuss HP printer error code oxc19a0020. To understand how to fix this problem, we will need to know the reasons to address this issue with your HP printer.This error arises due to the regular use of your HP printer. This problem can...

Five Tips To Improve Home Internet Connection

The Internet has become an inseparably connected part of our daily lives. Especially during this pandemic, we realized the true significance of the Internet. Due to nationwide lockdown, all school classes, college classes, office meetings, seminars, and a range of other activities became increasingly reliant on the...