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 from Author

Dr.Fone: How To Unlock Disabled iPhone?

Taking care of your iPhone in situations that can cause issues,...

How to Become a Successful Copywriter?

The first step in learning how to become a successful copywriter...

PDF Drive: Search & Download eBooks From pdfdrive.com

PDF Drive app is a free online PDF search engine that...

How to Record Powerpoint Presentations with Audio (100% Works!)

PowerPoint slides are the go-to tool for providing supporting content that...

Read Now

How to Decide to Say Yes or No?

How to Decide to Say Yes or No? A question that requires a simple answer or a confusing one? Is it that easy to choose between two definite answers?  The answer is simple yet confusing at the same time. Choosing between yes or no to reply to others...

GAMERSMENU: How to Start A Gaming Blog?

Blogging is one of the most effective methods to grow an audience, get your thoughts out there and maybe make some or much money while doing what you love. Gaming is more popular than ever in today's world, so now is the best moment to start your...

How To Use Routersploit In Unrooted Android device

A Router is a physical device or a virtual appliance that helps forward data between connected systems on a computer network. It inspects the given data packet’s destination IP address, finds the best way for the package to reach its destination, and then forwards it. It is a...

How to Split PDF Pages without Downloading Software?

There are reasons to split PDF files, and they mainly apply to when you need to use some parts of the PDF. You may want specific information from a large PDF. You could also want to split PDF to make the sharing easier. Whatever the case is, you...

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

Why should you consider setting up a 4G LTE wi-fi Network as an alternative to broadband? A few reasons come to mind. You could be traveling outside your coverage area (and having poor reception), or maybe your cell phone signal is quite spotty and unreliable in your...

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

How to Get a Instagram Verified Badge?

According to Instagram, accounts having the verified badge “indicates that Instagram has approved that account is the official representative of the public figure, celebrity or top brand it expresses.” In simple words, when you view the blue checkmark, you identify you’re following the Instagram verified badge account instead...

How To Find The Best Music Production Courses Online?

These days, you have numerous options when it comes to finding music production courses on the internet. Then, too many choices and information overload make it a bit challenging to choose the best course that you need to advance your career in the music industry. The best...

How To Fix the “iPhone is Disabled” Problem?

Your iPhone comes with optimal security measures to protect your data. The screen lock is the first layer of protection against people who want to breach your phone. But it may sometimes work as a disadvantage. In some cases, it may end up disabling your phone due...

How To Spy on Pc Using Android with OgyMogy?

Digital devices have got importance, and people love to have cellphones, PCs, and computer devices. More than that, the internet has integrated with our lives. People love to invest in laptop and desktop devices and get access to the internet. They also want to spy on PC...