Skip to Content
Oct 14, 2019 at 02:02 PM

Need help with improving/automating how bank reconciliation is done and EFT issue when clearing

35 Views Last edit Oct 14, 2019 at 02:01 PM 3 rev

Currently, I use a multicash version for bank files and the files are imported by using FF_5.

When doing bank reconciliation, I have to import the payment summary for each G/L account into excel. This is done with SQ01 for ACH/ETF and FCHN for cheques.

Once the payment summary is done, I have to figure out what payments/amounts equal to the amount sent from the bank in the bank statement.

Example: Payment summary may have a payment for 50, 100, 200, 300, 400, 500 dollars. Payment left bank for 150, so I know the 50 and 100 make that up. When I'll do bank clearing, I know to clear the 50 and 100 with the 150. Cheques clear 1 for 1.

Is there anyway to get ACH and ETF's to clear 1 for 1 or is there a problem with my bank file?

Also, is there a way to make this process faster? Is there a T-code that I can that will automatically match each payment for me?