Hi Experts!
I'm hoping someone can assist with a formula that I hope Excel can do! We have a customer who sends us money for payment through ACH. They have several invoices with us but all we receive is a total amount in our bank account and no remittance advice. Is there an Excel formula where you can plug in the open invoices and the total paid and Excel can determine what amounts add up to the total paid? (hopefully this description makes sense)
Thank you so much in advance!
Kate
I'm hoping someone can assist with a formula that I hope Excel can do! We have a customer who sends us money for payment through ACH. They have several invoices with us but all we receive is a total amount in our bank account and no remittance advice. Is there an Excel formula where you can plug in the open invoices and the total paid and Excel can determine what amounts add up to the total paid? (hopefully this description makes sense)
Thank you so much in advance!
Kate