# Automatic Mapping through Logic Account Code introduced in Import Masters/Taxes from Excel

**Automatic Mapping through Logic Account Code introduced in Import Masters/Taxes from Excel**: A new option added in Export/ Import Masters/Txn from Excel to automatically map account if Logic’s account code is given.

 **Common> EITxnFromExcel**

Import JV(Normal) From Excel: Click on help button. Excel Column Help window will appear on your screen. Select Account Code and Press Ok button.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FXOm3xU6MuKtQZSW4FOcJ%2Fimage.png?alt=media&#x26;token=0c22edc3-5004-44fe-8d56-c968e65c0037" alt=""><figcaption></figcaption></figure>

Import Bank Receipts From Excel: Click on configuration button. Select account code and click on ’Save’ button.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fx4wGkg5iaaGldn4BPiKF%2Fimage.png?alt=media&#x26;token=ee9ae0b0-32f1-474a-980b-56ecb42eda31" alt=""><figcaption></figcaption></figure>

Import Bank Payments From Excel: Click on configuration button. Select account code and click on’Save’ button.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FwDPuxP1m0yTobrMKeG4y%2Fimage.png?alt=media&#x26;token=8a16d2ec-efec-4451-9d5f-c56e80696185" alt=""><figcaption></figcaption></figure>

Import Cash Receipt From Excel: Click on help button. Excel Column Help window will appear on your screen. Select Account Code and Press Ok button.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FzIPA48krS2oy2HqyUxlh%2Fimage.png?alt=media&#x26;token=418cfc98-4658-46e2-a185-bb35688f4d2d" alt=""><figcaption></figcaption></figure>

Import Cash Payment From Excel: Click on help button. Excel Column Help window will appear on your screen. Select Account Code and Press Ok button.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fy2VCTMKIN2WRFx2FBr6N%2Fimage.png?alt=media&#x26;token=d0ab49f5-e23b-462c-92b3-20294a88888e" alt=""><figcaption></figcaption></figure>