Writing reports without context of how the software sees your data, is always hard. Which is why during custom report development I always also show (Select … in Manager terminology) extra information such as:
- General ledger account → name (& code)
See this post for more details Custom Report Not Returning Transaction Type Properly - #12 by Patch