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

6 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

  3. I want to Construction Accountant software

    • Hello Ei,

      This article provides an Excel-based chart of accounts template for a construction company, which can help you organize income, expenses, assets, liabilities, and project-related accounts.

      If you are looking for full construction accounting software, you may consider software that supports job costing, project budgeting, invoicing, payroll, vendor payments, and financial reporting. You can also use our Excel template as a starting point before moving to dedicated construction accounting software.

      Regards,
      ExcelDemy

Leave a reply

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo