Issue/Symptom/Question

How Do I Create a Bank Reconciliation File to upload bank transactions?

What bank reconciliation file formats are allowed?

What information must be included in the bank reconciliation bank transaction file?

Is there a certain order that bank account information must be input into the file for it to work correctly?

Applies To

PENTA Web > Accounting Module > Bank Reconciliation

Creating a New Bank Reconciliation with a Bank File containing cleared transactions

PENTA Version 21.2 and up

Resolution/Fix/Answer

File Format: Currently, only .csv files are supported for uploading bank transactions into a bank reconciliation statement. When saving an Excel spreadsheet, the user can switch the file format type from .xlsx to .csv

...

The columns should be in the following order: "Date", "Description", "Reference", "Withdrawal", "Deposit"

Check with your bank to see if a request is needed for an output file in the format.  Some banks are configurable on the output file.

The transactions can be entered in any order, so long as they are complete and abide by the following rules:

...

Here is a sample screenshot of a few basic bank transactions in an Excel document - this can be saved as a .csv file and will upload properly:

Cause 

Getting an error when trying to upload a Bank Reconciliation bank transaction file