How to import or automate clearing checks/wires or deposits in MDSL

How to import or automate clearing checks/wires or deposits in MDSL

This question is not answered

Hi,

Right now, I clear all the checks and deposits manually by going into the bank reconciliation module and checking the box for each check that got cashed and entering the date it got cashed, which takes time and concentration and verification. Thank goodness we have several accountants because we have over 100 active bank accounts.  

Is it possible to automate or import the checks/deposits that got cashed/cleared in MDSL? If so, can I please get help on this?

Thank you!

Lyn

All Replies
  • Lyn,

    In BR setup>Bank Import tab, you define your import file format.

    In this example, select Comma Separated, set Account Number to 1, Serial/Check Number to 2, Date to 3, Amount to 5, and Description to 4, and select the Decimal Point Included in Amount check box.

    Then in Bank Rec screen,  you select the tab at the bottom right for Bank Import File.

    Here is an example of the comma separated import file.

    3584341,000002,10/31/1999,International,-25728.15

    3584341,000013,12/04/1999,International,-550970.92

    3584341,000014,12/01/1999,Alphabet,-136565.83

    3584341,000015,12/07/1999,Square,-71455.27

    3584341,INTEREST,12/15/1999,Interest,2.35