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: