How to Create a Material Balance Sheet in Excel – Easy Steps


Overview of the Material Balance

The Material balance is quite common in Chemistry, especially in chemical reactions. It refers to the balance of materials or masses on both sides of a chemical reaction. It is also known as mass balance. A chemical reaction contains: the reactants (on the left) and the the products (on the right. The mass of these two sides needs to be equal in every chemical reaction.

Read More: How to Make a Forecasting Balance Sheet in Excel

Create a material balance sheet for the neutralization reaction of Hydrochloric Acid (HCl) and Calcium Hydroxide [Ca(OH)2].

Step 1 – Select the Reaction to Create a Material Balance Sheet

Select a random chemical reaction. Here:

2HCl  +  Ca(OH)2  =  CaCl2  +  2H2O

2 mole HCl reacts with 1 mole Ca(OH)2 and produces 1 mole CaCl2 and 2 mole H2O.

Select the Reaction to Create Material Balance Sheet in Excel

Read More: How to Create Common Size Balance Sheet in Excel

Step 2 – Find the Molecular Weight and Number of Moles

Calculate the molecular mass by using the atomic mass of each element and get the number of moles in the reaction. The coefficient of each material is considered to be the mole number of that material.

Read More: How to Make Automatic Balance Sheet in Excel

Step 3 – Balance Calculation

Calculate the amount of materials to complete the reaction:

  • Select D14 and enter the following formula.


You will get the amount of HCl in grams.

Balancing Equation to Create Material Balance Sheet in Excel

  • Press Enter and drag down the AutoFill  to get the amount of other materials.

Read More: Rental Property Balance Sheet in Excel

Step 4 – Generate the Material Balance Sheet Result

Calculate the mass of the Reactants Side and the mass of the Products Side.

  • Select D19 and enter the following formula to get the mass of the Reactants.


Calculate the total mass of the Products Side.

Mass of Reactant Side of the reaction = Mass of Product side of the Reaction

How to Create Material Balance Sheet in Excel Result

Download Practice Workbook

Download the workbook.

Related Articles

<< Go Back to Balance Sheet | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan
Mehedi Hasan

Mehedi Hasan, a BSc graduate in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a pivotal role as an Excel & VBA Content Developer at ExcelDemy. Fueled by a profound passion for research and innovation, he actively engages with Excel. In his capacity, Mehedi not only adeptly tackles intricate challenges but also showcases enthusiasm and expertise in navigating tough situations with finesse, underscoring his unwavering dedication to consistently delivering exceptional and high-quality content. He... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF