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

4 Comments
  1. Hi,

    Do you have ready complete XL file for construction accounting system

    • Hello Ahmed Hallak,

      Thank you for your question! While we don’t have a single all-in-one Excel file that covers every aspect of construction accounting, we do have a comprehensive template for construction company financial statements that many users find helpful for accounting purposes. You can download it from the link below:

      Construction Company Financial Statements in Excel

      Regards
      ExcelDemy

  2. Please help me

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo