Forum Discussion
Pivot Table Dr. & Cr. column values are Misaligned
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?
2 Replies
The pivot table aggregates by date and account. So all entries on acct 3150 on August 2 will show on the same row debit and/or credit.
You need to include a journal entry number between the Date and Account field in the Rows area but you don't seem to have such a number number in the source data.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
