Upload Customer Remittance Advice to SAP for auto allocation to invoices

Hi,

Here's the story, we receive excel files from customers that are rather large and I was hoping I could get a proposal together with information on how we can automate the allocation of payments to customer debtor account.

I do not have access to any SAP sites and our IT department is giving me the run around, so I have turned to all of you for some help.

Please remember that I am in the receivables are and all remittances (spreadsheets) get sent to us straight from the customer via e-mail never from the bank.

I am hoping this is enough info for you guys?!?!?

Let me know if you need to know anything else.

Oh and we are working with ECC6.

Thanks

Belinda