Import external transaction spreadsheet succeeded but not showing in Manage Transactions?

Summary:

The import of external transaction spreadsheet succeeded but as I check the for all of the transactions in the Bank Statements and Reconciliation module, nothing is showing under Manage External Transactions.

What could be causing this? Where else do I need to go to complete the process as there's nothing in the instructions.

Content (required):

Notes:

Bank account is exactly as per bank name set up

Dates are MM/DD/YYYY

Split the cash clearing and offset account codes for each accounting segments, and filled in the required fields.

It should have come up with an error if there was anything missing.