Hi Richard, and welcome!
I'm hoping you're using v8, in which case you can use the [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=001182"]recently discussed[/url] Multi-Column Region feature. How unusal to have 2 MCR posts in a day!
Based on your sample, in the Report window, I went to the Template menu and selected Multi-Column Region... Then I set Multi-Column to active and set the number of columns to 2, the left position to 1, and the width of each column to 20.
I then defined a new detail template creating fields on 123 and 100.00. I began the Balance field a few postions left of the 1, so as to properly trap both balance columns. This may change if the Balance columns in your actual report are spaced differently.
This generated the results you're after.
Let us know how you make out with this.