We have covered Accounting Worksheet topic in great detail. No, in this post we will cover How to make an accounting worksheet in excel.
Create a 11 column table in Excel Worksheet. First column is used to describe the name of the accounting head. Rest of the columns are used un-adjusted Trial balance, adjustments, adjusted trial balance, income statement & balance sheet debit and credit columns. You can see a snap of the worksheet created in MS Excel for better understanding below:
As you can see that in 1st columns A, we wrote the name of charts of accounts. After that, we use two column B & C for un-adjusted trial balance for debit and credit balances. Then, column D & E has been used to pass on any adjusting entries. We have also covered Adjusting Entries in great detail in recent past. These are used to update unadjusted TB to prepare the final set of trial balance.
After adjustments, column F & G is showing the adjusted trial balance of accounting head either in the form of debit or credit balances. Lastly, income statement and balance sheet columns