How to prepare a Ledger using Microsoft Excel

How to prepare a Ledger using Microsoft Excel

How to prepare a Ledger using Microsoft Excel
Image Source - https://flic.kr/p/VnGghC
More often than not, as an accounting professional you need to prepare Ledgers. You may be using the application software which might have been set up for your organization specifically. In this article we will focus on preparing a ledger using Microsoft excel application.

What if you need to prepare ledgers or a statement of accounts separately using Microsoft Excel? In case you are supposed to prepare various ledgers within a short span of time, then, how do you do that?

If you have a reasonable knowledge of Microsoft Excel and its formulas and functions, then, you can perform this assigned task quickly as well as efficiently.

However, if you think you need some help in that, then this article might be of some help and assistance for you. Below are the steps that you may follow to prepare a ledger successfully.

Step One: You need to identify the statement of account or a ledger you are going to prepare belongs to which Components of balance sheet or Income statement, so that you can assign the debit and credit and balance and the formula in a specified cell of MS Excel accordingly.

Step Two: Give Column headings starting from A5 to F5 in this way, Date, Reference Number, Narration, Debits, Credits and Balance. (Note: These are the columns that are used generally)

Step Three: Write “Opening Balance“ in C6 and provide opening balances under F6 - with debits and credits accordingly in D6 an E6. Type or copy this formula in the cell F7 without brackets [=F6+D7-E7]. Now that the formula is ready to be copied downward to other cells of the same column, do it accordingly. You can copy and paste the formula in accordance with the required number of rows.

Step Four: Enter the corresponding details accordingly in the specified columns.You will see that each row will provide the corresponding balance.

Finally, at the topmost column, starting from A1 to A3-with required range, you can write name of your company, account name, month and year of Ledger.

You can use gridlines to make your ledger appear good. You can also adjust the column widths as per your requirement. This way, you will have prepared the Ledger or Statement of Account successfully.

 


Let us know how you like this article. Like it and Rate it below.
1.36K 0
0
0 stars - by 0 user(s)

Related Articles

Individual Voluntary Arrangement or IVA, was introduced by the Government with the idea of allowing the creditors to recover more money from the debtors than they could have recovered in case of bankruptcy. The debtors need to understand the differences between both IVA and bankruptcy in order to make their choice.

As promised, Mutual fund will be one of the investment opportunities I want to discuss to you. It has already been defined generally from the pooled funds but let me elaborate more on its specifics.

Are you bored with the job which entails working from 9 to 9? Do you want a job which can be done from the comforts of home? Are you on a look out for a part time work which you can do to supplement your income? If your answer is yes, then this article can help you immensely. This article brings you the top 5 ideas for earning from home without venturing outdoors.Read on to know how to work from home and make money at home.

.

Post Your Comment

There are no comments yet.