Using Excel to Create Business Account Ledgers

5Keeping track of your account ledgers manually can be quite a headache. Every business transaction will require you to do the necessary calculations and key in the digits manually. With the rise in technology, it has now become easier to keep track of your business transactions. This is through the use of Microsoft Excel’s ledger templates. With these templates, it is quite easy to create your ledgers. You can easily customize the categories and codes. To make it even better, you can easily reuse the same forms from the start. Microsoft Excel does all the saving for you. All you have to do is retrieve the forms and key in the required figures when necessary.

Getting to open the ledgers using Excel is quite simple. All you have to do is follow the steps below:

#1: Open a new Excel tab and click on the ‘File’ tab. Click on the ‘New’ link. A new window contain the available templates will appear on the screen.  Key in “Ledgers” in the search box and perform the search. You will get a couple of ledger templates to choose from. Keenly go through the available leger templates and choose one that best fits your kind of business. You will be required to download it in order to access in in Excel.

#2: The next step is to edit the content of the ledger template. In most cases, the ledger templates will come with general wordings in the various fields. You are required to erase these generic wording and key in the exact information of your business where necessary. The same applies to the G/L Code column. It is up to you to customize it whoever you want. To start with, if the term G/L Code does not impress you, then edit it to GL Code or whatever you prefer. On the other hand, the first cell on the column will also come with a generic number. It is up to you to key in whatever number you want to start the ledger with.

#3: The next step is general modifying all the placeholder texts used in the template. Enter your business name, money budgeted and remaining fields plus any other required fields.

#4: If you feel that you ledger template is now ready to go, the final step is to save it. Click on the ‘File’ tab then ‘Save As’ and finally ‘Save’. Name the ledger file in a manner that you can easily distinguish it; that is if you have a number of them saved up in your computer.

Link:

http://www.futureaccountant.com/accounting-process/study-notes/ledger-account-balancing.php

http://womeninbusiness.about.com/od/glossaryofaccountingterm/g/definition-ledger.htm

Leave a Reply

Your email address will not be published. Required fields are marked *

Proudly powered by WordPress
Theme: Esquire by Matthew Buchanan.