Preparing a Accounting Worksheet following 8 Simple Steps

For preparing a accounting worksheet one must follow 8 Simple Steps to verify accounting information accuracy before preparation of financial statements.

Columns of worksheet are drawn mainly as per necessity. Number of columns of worksheet depends on the demand of the particular organization.

The following rules are generally followed in preparing worksheet:

Preparing a Accounting Worksheet following 8 Simple Steps

  1. Name of business organization and preparation date

    At the beginning of worksheet the name of the organization for which worksheet is prepared is to be written in bold form and also the date of preparation of worksheet is to be mentioned.

  2. Drawing column and mentioning the head of the column

    Drawing column titles are to be mentioned there.For example, serial number in the first column, title of accounts in the second column and thereafter pair columns such as;

  3. Unadjusted Trial Balance

    After the serial number and accounts title columns, in unadjusted trial balance, pair column ledger accounts balances are posted straight to check the agreement of trial balance.

    This trial balance is called pre-closing trial balance as it is prepared with the ledger balances before keeping accounts of adjustment items.Debit and credit balances of ledger accounts are written in the debit and credit columns of the trial balance respectively.

  4. Adjustment column

    At the end of accounting period the items or transactions which have not been accounted for are written in the debit and credit of adjustment columns.

    At the time of making adjustments if there does not exist any item in the trial balance for debiting and crediting, these adjusting items are to be written below the trial balance under appropriate head(s) in debit and credit columns of adjustment.

    To identify the adjusting items separate code number for each item be given in debit and credit columns. Thereafter debit and credit columns of adjustments are totaled for assuring their agreement.

  5. Adjusted trial balance column

    Writing necessary adjustments in the adjustment column, balance of every account relating to adjustments is ascertained and thereafter all ledger account balances including adjusted ledger balances are recorded in the debit and credit columns of adjusted trial balance.

    That is, unadjusted balances of trial balance are adjusted as per rules and these are written down in the column of adjusted trial balance.

    Writing all ledger balances – adjusted and unadjusted in adjusted trial balance totals of debit and credit are ascertained to prove arithmetical accuracy of the ledger accounts.

  6. Income statement column

    All periodical expenses and incomes of adjusted trial balance are written in debit and credit column of income statement respectively.

    The difference between total income and total expenses of income statement is called profit or loss. The profit / loss of income statement is transferred to balance sheet if retained earning statement is not prepared.

  7. Retained earnings statement

    In case of joint stock company, retained earning column is kept in the worksheet before balance sheet column.

    Here previous year’s profit / loss if any and income / loss of income statement of the worksheet are written in the credit money column and distribution of items regarding distribution of profit such as, dividend paid, proposed dividend, income tax paid, creation of fund are shown in the debit money column of retained earnings statement.

    The difference between the totals of debit and credit columns is transferred to balance sheet column of worksheet.

  8. Balance sheet

    All assets and liabilities of adjusted trial balance including balance of income statement / retained earnings statement are written in the debit and credit columns of balance sheet of worksheet i.e., assets are written in debit money column and liabilities, owners equity are written in the credit money column.

Totals of debit and credit column of balance sheet are equal. From the above discussion it is said that the number of columns of worksheet and titles of columns depend on nature and demand of the business concern.