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?