Sounds to me like copying data from Excel for Mac is inserting an extra carriage return/form feed character. What happens if you paste into TextEdit first, then copy from there and paste into the transaction?
The above applies to the window when it is opened for the first time. If the window is already open and I choose Window/Restore Position, the window takes the correct position. Namely, the upper left ...