I doubt there is a way using a CSV file (I have heard there isn't.)
Instead, you can convert the CSV file to an IIF file for import. Use our BRC IIF Transaction Creator to convert the file to bank checks and deposits for import into your bank register.
