No matter what business you’re into now, you always need accounting ledger. It helps you keeping track your business and assess whether you profit or even lose.
No matter what business you’re into now, you always need accounting ledger. It helps you keeping track your business and assess whether you profit or even lose. Anyway, instead of bringing your accounting manual ledger anywhere, you can make a ledger in Excel. First, it’s not as heavy as accounting manual ledger. Second, it’s easier to use.
Now, how to create it? Follow these steps to know how to create a ledger in Excel:
1. Open Microsoft Excel
Yes, of course you should open it first to create a ledger in Excel. Anyway, you will find business ledger when you type “ledger” in the search box. It appears when you click “File” tab, and then choose the “New” link. Now, choose the most suitable business ledger and double-click to start it.
2. Rename Template
Rename the business ledger template with your own business name. Just in case it won’t make you confused once you close it and want to reopen it.
3. Locate The G/L Code
The next thing is locating the G/L code column on the template. It can be in the first or far left on the grid. You can also rename the G/L code with your own code by click into the cell and type over.
4. Change The Code
Change the code into the one that you want to start the ledger with. It can be “1”, “100”, or “1000”, depends on your business.
5. Manage The Column
Now, manage the column by changing the name first. You can fill it with your business product or anything related to your business. It’s like moving your manual ledger into Excel.
6. Save As
Don’t forget to save as the ledger in Excel once you finish it.
We also have more printable template you may like:
Printable Counseling Soap Note Templates
Rectangular Box Template Printable
Printable Emergency Contact Form Template Medical
If you want a simpler ledger, then you might try to create ledger in Word. It isn’t as complicated as ledger in Excel but of course it makes the features simpler. But, if you’re okay with that, here are the steps to create ledger in Word:
1. Open Microsoft Word and then make a new document.
2. After that, click Insert and then choose Chart.
3. Now, let’s choose the Chart that you want. Is it column? Pie chart? Or something else? Click OK after you’ve done.
4. Enter your data to the spreadsheet and it will be automatically changed into the chart.
Article written by Shasmitha Mutiara, last updated on Apr 15, 2021 and edited by Printablee Team.
Have something to tell us?
Comments
I found the Accounting Ledger Template Printable to be a convenient and user-friendly tool to keep track of my financial records efficiently. It's simple and effective, helping me stay organized in a hassle-free way.
The printable accounting ledger template is a practical tool for efficiently organizing and tracking financial transactions, providing a clear and systematic record that simplifies the process of managing finances.
Printable accounting ledger templates allow individuals and businesses to maintain accurate financial records and organize financial transactions efficiently, improving record-keeping and overall financial management.
The printable accounting ledger template allows users to efficiently keep track of financial transactions and organize them in a clear, systematic manner for accurate record-keeping.
I found the Accounting Ledger Template Printable very helpful for keeping track of my expenses and managing my finances. It's straightforward and easy to use. Highly recommended!