I have created a Journal entries sheet in Excel which have one month sample transactions entered in it now I am trying to create Ledger from that sheet using Pivot table but problem occurs that the Dr. and Cr. amounts of entries are not lying in their corresponding cells. I mean that Dr. and Cr. amounts of a  transaction are misaligned according to date entry. Can you help?

​I have created a Journal entries sheet in Excel which have one month sample transactions entered in it now I am trying to create Ledger from that sheet using Pivot table but problem occurs that the Dr. and Cr. amounts of entries are not lying in their corresponding cells. I mean that Dr. and Cr. amounts of a  transaction are misaligned according to date entry. Can you help?  Read More

​