What are the required fields and worksheets to fill-in to create a bank statement in spreadsheet?

Summary: What are the required fields (what are the values to use for these fields ) and worksheets to complete the bank statement to upload by spreadsheet?

Content (required): I must be missing something in the spreadsheet because even though I've correctly put the debits and credits around for negative and positive opening balances and for the statement lines which should balance. It's still saying the balance is out by double the opening balance.

For example:

OPBD = 62146.16 (DBIT negative balance)

CLBD = 10400.00 (CRDT positive balance)

The following statement lines DBIT = Payment, and CRDT = Receipt.

Why then is the statement balance showing to check which is double of 62146.16?