Download Accounting Journal Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Triangular Graph Paper

Triangular graph paper is the most useful for graphing relationships between 3 data components (or …

Read More

Money Manager for Kids

Money Manager for Kids is an important life skill that you can teach to children at …

Read More

Credit card payment calculator

Our new Credit Card Payment Calculator will help you calculate your minimum payment and estimate how long …

Read More

Paycheck Calculator

Use our Free Paycheck Calculator spreadsheet to estimate the effects of deductions, holdings, federal tax, and …

Read More
Search
Generic filters

An accounting journal is an accounting worksheet that allows you to track each of steps of the accounting process, side by side. This accounting journal template includes each step with sections for their debits and credits, and pre-built formulas to calculate the total balances for each column.

General Journal

Thus, For accounting purposes, a journal is a physical record or digital document kept as a book, spreadsheet, or data within accounting software. So, When a business transaction is made, a bookkeeper enters the financial transaction as a journal entry.

Types of Journal in Accounting

  • Purchase journal.
  • Sales journal.
  • Cash receipts journal.
  • Cash payment/disbursement journal.
  • Purchase return journal.
  • Sales return journal.
  • Journal proper/General journal.
A complete journal entry is build of 6 elements: a reference number, date, account section, debits, credits, and a journal explanation. Therefore, You can record these journal entries into either a General Journal or a Special Journal. Moreover, There are three main types of journal entries: compound, adjusting, and reversing.

Book of Original Entry

One important key to journal entries is that they need to contain enough information to clearly reflect the actual transaction. Moreover, instead of only having account balances, we can look back at journal entries to see what really happened and if anything was recorded incorrectly.

Thus, A journal entry has the following components:

  • The date of the transaction
  • The account name and number for each account impacted
  • The credit and debit amount
  • A reference number that serves as a unique identifier for the transaction
  • A description of the transaction

What Are Debits and Credits?

So, Under the double-entry bookkeeping method, debits and credits in a journal entry must be equal. Therefore, Journal entries must also be consistent with the general accounting equation which describes the balance sheet:

Assets = Liabilities + Owner’s Equity

Using this equation, debits are record on the left, and credits on the right. So, This means that debiting an account on left side of the equation — an asset account — increases that account. Debiting an account on right side of the equation — a liability or an equity account — will decrease the balance in that account.

A credit amount has opposite effect. Crediting an asset account decreases the balance, while crediting a liability or equity account increases it. Thus, Over the income statement, revenue accounts are increase by credits, and expense accounts are increased by debits.

Download Accounting Journal Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Accounting Journal Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: