The overall voltage gain in the circuit is not matching my simulation result. What am I doing wrong?
0% chance your simulation will match reality.   Real components have tolerances, significant  especially for caps and transistors.   I'm surprised you got as close as you did.