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 D...
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.