Filter for Journal Entries that Balance

[bwoodall623]

I have a workflow that takes data from one system and transforms it into a template that will create multiple journal entries for importing into a financial software. I need to ensure that each entry balances (debits = credits) by date. Each entry will have a minimum of 2 lines but no maximum. All entries will be on a single csv file. In my example screenshot, the entry for 1/1/24 is 4 lines, while the entry for 1/5/24 is 9 lines. What is the best way to filter out all lines for a date that does not balance? 

[caltang]

Can you post some sample data? We can show you a few ways.

[mkeiffer]

I created this workflow (also attached as a packaged workflow) based on the screenshot of the GL data that you had posted.  Let me know if this is what you were looking for and if you have any questions about the workflow.  Thanks!