Create Chart of Accounts for Construction Company in Excel

Step 1 – Prepare a List of Assets

  • Current Assets include cash, accounts receivable, etc.

List of Assets Create Chart of Accounts in Excel

  • Long-Term Assets include Land, Buildings, Vehicles, etc.

List of Assets Create Chart of Accounts in Excel


Step 2 – Make a List of Liabilities

Liabilities are the obligations that an organization has to pay to a business entity.

  • Current Liabilities are the liabilities an organization has to pay within one year. These include Accounts Payable, Notes Payable, etc.

  • Long-Term Liabilities are the liabilities an organization has to pay over one year. These include Bonds Payable, Long-Term Loans, etc.

List of Liabilities Create Chart of Accounts in Excel


Step 3 – Create a List of Revenues

Generally, the accounting period is 1 year. Revenues are not only the money that an organization generates.

  • Revenues include Sales Revenue, Service Revenue, etc.


Step 4 – List Out Accounts Under Expenses

  • Expenses include material costs, equipment costs, salaries and wages, office rent, etc.

Expenses Create Chart of Accounts in Excel


Step 5 – Prepare a List of Equity Accounts

  • Equity (also known as Owner’s Equity) is the owner’s or shareholder’s contribution to the company. Equity includes Capital Stock, Retained Earnings, etc.


Things to Remember

  • The chart of Accounts varies from one organization to another.
  • Account Numbers are used for reference purposes.

Download the Practice Workbook

You can download our sample workbook to use as a template for your company and expand it if needed.

<< Go Back to Excel Chart of Accounts Templates | Accounting Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo