Note: The .csv file must be closed when performing the import. Additionally, once the file is imported, it cannot be re-imported.

1. The .csv file must contain the Date, Account number, Amount paid, Subcategory, Memo.

2. The Date format is DD/MM/YYYY.

3. The Account number format is xx-xx-xx xxxxxxxx.

4. The Amount format is xx.xx.

5. The Subcategory format is either STO, DIRECTDEP, Payment, FT or OTH.

6. The Memo format is surname firstInitial middleInitial (where relevant) client/claim ref STO/BGC/BBP/FT.

From the Distributions menu item, click Import Bank Statement. A message displays informing you that the import is taking place.

Note: If there are corrupted rows or some clients cannot be found in LogiPlan, a .csv file generates with the same name as the source .csv file with "Invalid_Rows" appended to the name and saves it at the same location the source .csv is stored.

Note: If Admin > Payment Plan > Show Invalid Rows on Distribution Import is ticked, the Invalid_Rows.csv opens automatically.

Click Search and open a client with an ID whose payment was imported.

From the Billing tab, the imported payment is listed in the Payment Schedule and a note is added to the Notes tab.