Free Google Sheets Ledger Template [and How to Use] 2022

Every business should maintain a daybook to keep their fiscal records organized. Ledgers help businesses track profits, libra assets and expenses, and keep track of all their transactions .
traditionally, companies maintained their ledgers in the shape of registers. But with the advancement of technology and the handiness of spreadsheet software, creating and maintaining ledgers has become a solid lot easier.

Using a pre-built ledger template in software like Google Sheets further speeds up the summons, as you spend less time creating tables, performing computations and updating multiple accounts at the like prison term .
In this tutorial, we will explain ledgers and ledger systems in brief and then help you create your own Google Sheets daybook template with a few basic steps .
We’ve created a free Google Sheets ledger template that you can save and start using right away. Keep reading to learn how to use it.
NOTE: Click on File > Make a Copy to be able to edit your template. DO NOT request edit access !

What is a Ledger?

A daybook is a fiscal document that is used to track your assets and expenses. It lists all your fiscal transactions in divide balance sheet accounts, so that you can well review your transactions when needed. It besides helps you keep lead of finances and identify errors .
Every libra sheet bill in a ledger contains information related to the occupation ’ randomness assets, liabilities, revenues and expenses .

Different Types of Ledgers

There are basically three main types of ledgers :

Sales Ledger

besides known as a Debtor ’ sulfur daybook, a Sales ledger consists of all accounts related to customers who purchased goods or services on citation. Some of the accounts that a Sales daybook might have include Accounts Receivable, Trade Debtors or Sundry Debtors .

Purchase Ledger

A Purchase daybook consists of all accounts related to sellers from whom goods or services have been purchased on citation. Some of the accounts that this ledger might have include Accounts Payable, Trade Creditors or Sundry Creditors. One can see the total money owed in a trial Balance .

General ledger

A general ledger is a compilation of all the ledger accounts owned by the business. This type of ledger consists of accounts such as assets, liabilities, revenues, expenses, etc .

Why Create a Ledger Template?

Creating a daybook from chicken feed can be helpful if you have very specific requirements for your clientele. however, most businesses need more or less the same types of records and fields. Using a daybook template can cut the measure of time needed to create a template in one-half .
furthermore, you get a structure document that you can simply copy and rename for each bill. You can customize the template according to your requirements and then directly start filling in your records .
In this means it provides you with a standardize fiscal record-keeping system, from which you can well retrieve whatever information you need to and perform subsequent analytics with the retrieved data .

What Does a Simple Ledger Template Consist Of?

A ledgertypically consists of unlike types of accounts like assets, liabilities, gross and expenses. Each daybook report can have its own page, and some can even have their own sub-ledgers. All accounts have more or less the like fields, so you can use a childlike daybook template that you can duplicate for each type of report .
Note: A ledger template may besides be called a balance sheet template .
The chief fields that a daybook template typically contains include :

  • Date: This column tracks the date of each transaction
  • Reference: This contains the page number or record number of a transaction in some other reference ledger. For example the same entry might be entered as a debit entry in one account ledger and a credit entry in another account ledger.
  • Account: This is usually a dropdown that lets you select the account corresponding to a given entry.
  • Explanation: This lets you write further details about the transaction.
  • Credit Amount: This contains an amount transferred from the present account
  • Debit Amount: This contains an amount transferred to the present account
  • Balance Amount: This contains the amount remaining in the account at each transaction after adding the credited amounts and subtracting the debited amounts.

How to Create and Use a Google Sheets Business Ledger Template

Let us now see how you can create a daybook from a pre-built ledger template. You can use this as a General Ledger template, or can customize it into a Sales Ledger template .

Decide on the Design

The first tone in creating a daybook template is the design phase. In this step, you need to make an sketch or format for each page or ledger account. This purpose or structure is normally coherent for all accounts, so that they can well be referenced and retrieved when needed .
Make indisputable you include the above elements, along with any other fields that might be relevant to your business .

Create your Ledger Template or Use a Pre-designed One

once your design is ready, you can set up your ledger. Download a copy of the ledger template provided in the connect below :
NOTE: Click on File > Make a Copy to be able to edit your template. DO NOT request edit access !
here ’ s how the template looks :
Google Sheets Ledger Template After downloading the template, you can customize it according to your requirements. Change the color scheme, fonts, or sizes, and add, remove or rename column as you require ( according to your distinct purpose ) .
Consider how many accounts you need and if you need multiple pages or subpages for each score. once you ’ re done, you can make copies of the template, in the form of separate tabs ( or sheets ), one for each account .
now you can start filling in the details. For each account page, make sure you put the appropriate date rate in row 2 ( shown in the image below ) .
date range

following, figure an total for your account ’ mho opening poise .
opening balance ultimately, you may start adding details for each transaction as needed .

Getting Familiar with the Google Sheets Ledger Template

Before moving promote, it is significant first understand the structure of our Ledger template, so that it is easier for you to fill in the transaction details .
The crown character of the sheet consists of the ledger championship and date scope .
ledger title and date range After this, there ’ s a slot for you to enter the afford balance for the date stove mentioned .
On the right side of the plane, there is a small postpone consist of the names of different accounts, along with initials stating whether the represent score is a debit or credit history. Let ’ s call this postpone the ‘ Account list table ’ .
account list table The main contribution of the template consists of a larger board with 7 columns :

  • Date
  • Reference
  • Account
  • Explanation
  • Credit
  • Debit
  • Balance

We already discussed what each of these columns represent in an earlier segment of this tutorial. Let ’ s call this table the ‘ Main Table ’ .
main table The table has been activated with filters, allowing you to filter your transaction records according to your requirements .
The Balance playing field of this table has already been populated with the appropriate formula to calculate the balance from the debit and credit amounts that you enter .
The Date battlefield has been pre-formatted to convert your embark date into a uniform format, while the Account field has data validation activated in the class of a dropdown list to ensure that you lone enter the preset history names .
dropdown list You might obviously want to have other report names in your template design. The dropdown number can easily be adjusted as follows :
To change the name of an account, merely make the edit in the Account List table .

  1. If you need to remove an account name simply delete the entire row corresponding to the account name. Make sure you don’t end up deleting any existing entries in the main table, though.
  2. If you need to add newer accounts, then add the names of the accounts to the ‘Account list table’. Simply add the new account names at the end of the table, instead of trying to insert new rows (as this would affect the formulae and formats in the Main Table too.
  3. Once your accounts list contains only the names of your required accounts, the changes should get automatically updated in the dropdown lists of the Account field in your Main Table.
  4. If you don’t see the changes reflected, select all the cells of the Account field, navigate to Data->Data Validation and adjust the range specified in the input box next to ‘List from a range’ so that it contains the range of cells that make your account list in your Account List table. For example, if your accounts list now has account names from the range I10 to I16, then make sure the input box contains the range “=$I$10:$I$16”.

data validation criteria

  • Click Save to close the Data Validation dialog box.

The dropdowns of your Main Table ’ s Account field should now show your new tilt of accounts .
You can find out more about data validation and dependent dropdown lists here : How to Create a Dependent Drop Down List in Google Sheets
Note : If you prefer not to have a dropdown tilt in the Account field of your Main table, then plainly select the ‘ Remove Validation ’ button in your Data Validation dialogue box alternatively of Step 5 .
finally, the headers of your Main postpone contain totals for the Debit, Credit, and Balance fields. These are besides automatically computed as you enter newer transactions into the mesa .
Debit, Credit, and Balance note that cell G7 computes the final balance left after removing the entire debit and adding the sum credit to your opening poise. It does not find the entire of the Balance column .
This means this cell helps you identify errors in your entries. If you find the final balance in the Balance field and the full libra in cell G7, it means there must be an error in your transaction entries .
Final balance Another important thing to note is that the sheet has been protected to ensure that the exploiter does not incidentally write over any of the cells containing a convention. If a drug user does attempt to enter something in any of these protect cells, they are shown a admonitory that asks the drug user if they are certain they want to edit the cellular telephone .

Maintain your Ledger

once you have your ledger set up, you can start recording your transactions. If you find you ’ re out of rows to enter newly records, merely press the ‘ Add ’ button at the bottom of the tabloid to add 1000 more rows .
add button Note : You can read more about how to add multiple rows in this article : How to Quickly Insert Multiple Rows in Google Sheets
Every once in a while, make sure that you review your ledger for errors. This can help reduce likely mistakes that can affect your occupation .

Conclusion

In this tutorial we showed you how to create a Google Sheets Ledger template. alternatively of trying to build one from scratch, it ’ mho easier to just download the template that we provided and then customize it to your requirements .
Click here to download Spreadsheet Point’s free Google Sheets Ledger template.

Note: Click on File > Make a Copy to be able to edit your template. DO NOT request edit access !
We hope this tutorial was helpful .
Related Reading: Free OKR Template for Google Sheets (and How to Use It To Hit Your Targets)