Import Scenario - import bank transaction via csv data provider

Hello ​@MarkD,

Could you please clarify which field the “Amount” field on the “Import Bank Transactions” screen is mapped to?

Regards,

Vard

It is mapped to both Receipt (for positive amounts) and Disbursement (for negative amounts) which can be found in the import scenarios I’ve attached earlier, but here’s the screenshot of my mapping:

I’ve attached the CSV file as well.

​@MarkD 

Am I explaining this to you correctly? If Amount is negative, the value should go to Disbursement and Receipt should be 0; if Amount is positive, the value should go to Receipt and Disbursement should be 0.

Is this what you requested?"

Regards,

Vard

​@Vard86 

Receipt - If the value of Amount is greater than 0, use Amount; otherwise, use 0.

Disbursement - If Amount is less than 0, remove the minus sign and show it as a positive number; otherwise, show Amount as it is.

hey ​@MarkD , can you please share the xml file of your import scenario?

Attached as requested ​@harshitasethia74 - please also advise how do I enter the beginning and ending balance in my CSV file as it shouldn’t be per line. There is only one field for each balance:
 

Hi ​@MarkD ,
For the beginning & ending balances:

I have also modified the import scenario which I am attaching here.

For ending Balance, you would need to manually enter since, it should match the Calculated Bal.

Hope this helps!!