# Kefiya

## Introduction

Kefiya is a customer app for ERPNext that will allow us to easily match our bank transactions to Sales Invoices and other transactions in our system.

This app is optimized for the german market but will also be able to foster processing of non-german banks if certain aspects are met. If you are looking to get your bank to work with the system contact our sales at [https://phamos.eu/contact](https://phamos.eu/contact).

## Kefiya Settings

On this page we can make overall settings that are relevant for the integration with ERPNext and the functionality of the custom app.

## Importing Bank Transactions

### via API

#### Kefiya Schedule

Here we can setup a schedule in what frequency data is fetched from the Kefiya Login. This

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-08/scaled-1680-/5usimage.png)](https://doku.phamos.eu/uploads/images/gallery/2024-08/5usimage.png)

### Manually

### Bank Transaction

The [<span style="text-decoration: underline;">Bank Transaction</span>](https://doku.phamos.eu/books/erpnext-benutzerhandbuch-v15/page/bank-transaktion-bank-transaction "Bank Transaktion (Bank Transaction)") Doctype is a standard Doctype from ERPNext in which our uploaded bank statement date will be merged into.

### Kefiya Bank Statement Import

This Docytpe is used to manually import \*.csv files that we have downloaded from our bank. These \*.csv files need a specific format to work. From the imported \*.csv file we will be creating Bank Transaction records.

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-03/scaled-1680-/Awjimage.png)](https://doku.phamos.eu/uploads/images/gallery/2024-03/Awjimage.png)

##### Actions

Start Import will create Transactions (Bank Transactions) in our system from the import file uploaded.

##### Fields

<table border="1" id="bkmrk-description-fieldnam" style="border-collapse: collapse; width: 100%; height: 89.4px;"><colgroup><col style="width: 33.3333%;"></col><col style="width: 33.3333%;"></col><col style="width: 33.3333%;"></col></colgroup><tbody><tr style="height: 29.8px;"><td style="height: 29.8px;">**Description**  
</td><td style="height: 29.8px;">**Fieldname**  
</td><td style="height: 29.8px;">**Explanation**  
</td></tr><tr style="height: 29.8px;"><td style="height: 29.8px;">Company  
</td><td style="height: 29.8px;">company  
</td><td style="height: 29.8px;">Link the company for which we will want to import the data for.  
</td></tr><tr style="height: 29.8px;"><td style="height: 29.8px;">Bank Account  
</td><td style="height: 29.8px;">bank\_account  
</td><td style="height: 29.8px;">Link the Bank Account from which the import data is from</td></tr><tr><td>Bank  
</td><td>bank  
</td><td>Link to Bank from bank\_account  
</td></tr><tr><td>Import File  
</td><td>import\_file  
</td><td>Here we can attach the file that shall be uploaded and where the transactions will be imported from.  
</td></tr></tbody></table>

#### Banks that are included

- DKB (pending)

### Bank Account Wizard

Now where Bank Transactions have been imported we are confronted with two cases. 1. The IBAN is known to our system and the Bank Transaction can be appended to a Bank Account record or 2. it can not be identified and we will need to create a new Bank Account record to which it can then be matched in future. For this we have the Bank Account Wizard.

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-05/scaled-1680-/nT5image.png)](https://doku.phamos.eu/uploads/images/gallery/2024-05/nT5image.png)

## Matching Process

One Bank Transactions are present in the system and are not fully reconciled they will be visible in a page that is designed to assign the records from the bank statement to unpaid Sales Invoices and other transactions in our system.

## Assign Payments Wizard

### Reconcile Payments

To quickly reconcile bank transactions towards sales invoices we use the Assign Payment Wizard. Here we see all Sales Invoices that are unpaid and respective bank transactions that might match. The matching process is done via the customer link. <span style="text-decoration: underline;">Read here for details on the matching process.</span>

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-03/scaled-1680-/ZP1image.png)](https://doku.phamos.eu/uploads/images/gallery/2024-03/ZP1image.png)

## Unreconcile

In case we have wrongly reconciled a Bank Transaction towards a Sales Invoice we will want to undo our action. To do this we need to "Unpay" the Sales Invoice and "Unreconcile" the Bank Transaction. After that both records will reappear in the Assign Payment Wizard.

##### Unpay Sales Invoice

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-03/scaled-1680-/zNIimage.png)](https://doku.phamos.eu/uploads/images/gallery/2024-03/zNIimage.png)

##### Unreconcile Bank Transaction

[![image.png](https://doku.phamos.eu/uploads/images/gallery/2024-03/scaled-1680-/KOuimage.png)](https://doku.phamos.eu/uploads/images/gallery/2024-03/KOuimage.png)