Import bank statement from CSV file. Semi-automatic bank reconciliation.

Keywords: Import bank statement from CSV file, semi-automatic bank reconciliation.

Beigesoft™ EIS allows you to:

  • import bank statement entries from a CSV file.

  • if an entry has status "VOIDED" (canceled), then the matching entries (if found) will be listed for reversing (canceling)

  • entries with other status allow to create new records, the matching entries (if found) will be listed anyway to prevent duplicates

Example of semi-automatic bank reconciliation.

Assume Bob received two prepayments from Mini-market on Jan 25, 2016, it's a check#175762 for 23.15USD, and a check#175763 for 33.15USD. Bob posted these checks into Beigesoft™ EIS.

Bob received on Jan 26 a bank statement, its CSV file is:

01/25/2016,Mini-market check #175762,VOIDED,23.15,wrong signature

01/25/2016,wrong check fine,OK,-11.15,

01/25/2016,Mini-market check #175763,OK,33.15,

01/25/2016,Mini-market check #175764,OK,43.23,

01/25/2016,Mini-market check #175765,OK,20.00,

That is check#175762 wasn't accepted, there is additional fee 11.15, check#175763 is already posted, and there are two other checks that Bob hasn't posted yet.

First, Bob created a "CSV Method" for that file: