I eventually found the issue. There were some earlier transactions in the Charts of Accounts before the balance which impacted it.
View solution in original post
