Accounting Worksheet – Meaning, Objectives, Benefits, and Format

What is Accounting Worksheet?

Accounting Worksheet is basically a spreadsheet tool that assists bookkeepers and accountants in completing the accounting cycle. Or, we can say that it helps accountants to get ready the year-end reports. These reports include trial balances (adjusted and unadjusted), adjusting journal entries, and financial statements.

The primary objective of preparing these sheets is to ensure the financial accuracy of the accounting reports. Also, it helps to ensure that the entries are correctly posted, as well as to track the changes in accounts from one period to another.

We can say that this worksheet is a large table of data. It is an informal document that isn’t intended for outsiders or third parties. This document is not mandatory to prepare, or we can say it is an optional intermediate step for accountants. Accountants usually prepare it at the end of the accounting period.

Objectives/Benefits of Accounting Worksheet

Following are the objectives of preparing the accounting worksheet:

  • The main objective is to assist in making financial accounts and other reports.
  • It helps to keep track of different accounting steps and, thus, helps to reduce errors.
  • It can also work as an analytical and summary tool. This is because the worksheet shows how the accounts were initially posted to the ledger and what all adjustments were made to it before moving it into the financial statements.
  • The worksheet helps to maintain accuracy, as well as saves time.
  • It helps to track changes in accounts from one period to another.
  • Accountants may give the worksheet to outside auditors as evidence of the accuracy of the accounts.
  • It ensures that an accountant doesn’t forget to post adjusting entries.
  • The worksheet also gives an idea of the financial health of a company.

Drawback

Talking about the drawbacks, there aren’t many. The only drawback is that these worksheets may carry errors or formula inaccuracies as they aren’t linked to the accounting database and are maintained manually.

Format of Accounting Worksheet

Since an accounting worksheet is mainly for internal purposes, its format can be flexible. Or, we can say that companies can customize their format to fit their needs.

Similar to the trial balance, an accounting worksheet also carries a heading. This heading includes the company’s name, relevant time period, and the title of the report.

A usual worksheet lists the name of accounts in the first column. And the following columns show the debit and credit of the trial balance (adjusted and unadjusted), income statement, and balance sheet.

To be specific, this worksheet usually has five sets of columns, starting with the unadjusted trial balance accounts and ending with the financial statements. Each column is further subdivided into debit and credit. And the totals of each column come at the bottom.

How to Prepare?

As said above, except for the first column (account name column), all other columns are subdivided into debit credit columns.

Now, an accountant needs to take the account balances from the trial balance (unadjusted) and put those in the relevant trial balance column on the worksheet.

Similarly, an accountant needs to record the adjustment journal entries under the ‘adjustment’ column and in front of the relevant ledger account.

Next, an accountant needs to calculate the new balance of the accounts by taking the balance of each account in the unadjusted trial balance column and the adjustment entry for that account. This gives the balance of that account in the adjusted trial balance. Now an accountant can use this for preparing financial statements.

Moreover, both the debit and credit columns of the adjusted trial balance should match. This would ensure the arithmetical accuracy of the adjusting entries.

In a nutshell, we can say that an accountant transfers unadjusted trial balances from the software to the worksheet. Then the unadjusted trial balance is adjusted in the worksheet to find out the impact of possible adjusting entries. From here, if all things are okay, the accountant posts the entries into the financial statements.

Accounting Worksheet Example

Let’s take a simple example to understand the preparation of an accounting worksheet.

Company A is in the business selling TVs. It makes an accounting spreadsheet before preparing the financial statements. During an accounting year, Company A needs to make two adjustments. The first is for the advance payment of rent of $1,500. And second is for a $2,000 depreciation expense. The accountant has already transferred the account balances from the trial balance into the worksheet under the column ‘Trial Balance.’

                        Company A worksheet for the year ended December 31, xxxx

Account Name

Trial Balance

Adjusting Entries

Adjusted Trial Balance

Income Statement

Balance Sheet

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Debit

Credit

Land

$25,000

   

$25,000

   

$25,0000

 

Machine

$15,000

   

$15,000

   

$15,000

 

Accumulated Depreciation

 

$15,000

 

$2,000

 

$17,000

   

$17,000

Prepaid Rent

  

$1,500

 

$1,500

   

$1,500

 

Accounts Payable

 

$20,000

   

$20,000

   

$20,000

Cash

$10,000

  

$1,500

$8,500

   

$8,500

 

Depreciation

  

$2,000

 

$2,000

 

$2,000

   

Cost of goods sold

$75,000

   

$75,000

 

$75,000

   

Other Expenses

$6,000

   

$6,000

 

$6,000

   

Total

 

 

 

 

 

 

 

 

 

 

In the above example, we have considered only a few accounts for simplification purposes. In the real world, we need to take all the accounts in the worksheet. Once we take all accounts, the debit and credit side of Trial Balance, Adjusting Entries, and Adjusted Trial Balance should come equal.

For the income statement, the difference in the debit and credit columns means a profit (or loss). After we transfer this profit (or loss) to the relevant debit or credit column of the Balance Sheet, the debit and credit sides of the Balance Sheet should also match.

Final Words

The accounting Worksheet is a crucial tool to ensure the accuracy of accounting entries. It is an internal document that assists in the preparation of financial statements. A point to note is that all the accounts in a company’s accounting records come in at least one column in the worksheet. This helps in preventing most accounting errors. Though it is not compulsory for a company to prepare this worksheet, preparing it undoubtedly makes it easy to prepare financial statements.



Sanjay Borad

Sanjay Bulaki Borad

MBA-Finance, CMA, CS, Insolvency Professional, B'Com

Sanjay Borad, Founder of eFinanceManagement, is a Management Consultant with 7 years of MNC experience and 11 years in Consultancy. He caters to clients with turnovers from 200 Million to 12,000 Million, including listed entities, and has vast industry experience in over 20 sectors. Additionally, he serves as a visiting faculty for Finance and Costing in MBA Colleges and CA, CMA Coaching Classes.

Leave a Comment