I have a filter saved on the Bills Screen that I have to use to create Remittance Reports for our vendors. When we bought into Ramp one of the selling points was the automatic remittances but what actually gets sent is useless to most AR Departments.
No one wants pdfs.
If I were a vendor I would like to have a .csv file with the following fields delivered for each payment batch (this is what I currently send manually to our larger vendors:
- Company Name
- Invoice Number
- Invoice Date
- Invoice Amount
- Payment Date
- Payment Amount
- Payment ID / Check Number / Credit Memo Number
- Payment Method (Check / ACH / Card / Credit Memo)
The Payment fields would be duplicated for all invoices on the same batch, but its critical to most that the Invoice numbers have individual lines.
Help us help our vendors without requiring manual remittance creations please!