Multiple due deposits via Excel

OPD & IPD Multiple due deposits via Excel

In this article, we will see how we can simplify our TPA and other due deposit via a single Excel file.

Step:1

First, you need to log in to our HIS (Hospital information system), to login into HIS you need to follow this article.

https://help.sonihospitals.net/knowledgebase.php?article=79

Previously we follow the below article steps to deposit multiple payments in our HIS.

https://help.sonihospitals.net/knowledgebase.php?article=82

Now we are going to the steps easier with a simple Excel format.

Step:2

Click on the IPD module & select the Multiple Due deposit(excel) options from the activity section.

Step:3

After that you need to fetch the Multiple deposit format from the server data folder & for that, you need to press the Windows key + R from your keyboard & you will get a small box called RUN.

On that RUN box, you need to enter this path & then click OK. You will see an Excel file where you need to open that file & get payment data into that Excel according to that format.

\\172.22.22.12\GS_MyData\MultiDueDeposit

Excel format will look like this.

Note:

Balamt= balance amount or Bill amount of that patient.

Depamt= Deposit amount of that particular bill or Received amount of that bill.

Disamt= Deduction of any if happened on that bill.

TdsAmt= TDS deduction of that bill.

writeoff= Any write-off you want to add.

Step:4

After preparing the Excel format from that link you need to open the Multiple due deposits (excel) screens & click on the Get from Excel button on the left-hand TOP.

You will see your Excel data here, please verify the data properly.

Step:5

Now you need to click on the payment mode you want to select, In the TPA case most of the payment type is NEFT or Cheque.

When you click on the NEFT radio button you will see a small screen in front of you where you need to fill up every data very accurately & then click on the OK button.