Produce Industry Credit Council
Electronic Data File Specifications

Why provide a digital file copy of your Accounts Receivable file?

Adding your information anonymously to that provided by other suppliers allows you to see the most complete and current credit information available in our industry - far better than previously available. The more firms that participate, the more detailed the information that PICC members have regarding debtors. As a data file contributing PICC member, you have exclusive access to all of the collated aged A/R information available on the Delinquent A/R report. Obviously, all of these firms are not credit risks. However, the information here could be useful in evaluating your company's potential exposure. Generally, RBCS will not have to request individual credit experience reports from firms that provide digital A/R files each month. Not only will the quality of the information that we return to you be higher, but you and your staff will receive many less individual fax and email requests for information about your accounts. You save time and hassle. The following file formats can be used to transmit A/R files. If you have questions or comments, please contact us at 800-252-1925 or email lchubick@rbcs.com A/R information that is to be sent digitally should meet the following specifications. Either spreadsheet (.xls) or comma delimited. The file should contain a minimum of the following data fields: Spreadsheet: Unique Customer Account Number/ID * or RBCS PIN number * Company name Location - city, state Amount over 30 days Amount over 45 days Amount over 60 days * Please send either your unique customer account number/ID or the RBCS pin number. Comma delimited: ".txt" - file with the same information described above. (delimited with quotes and commas) Once you have your file ready, please e-mail it to lchubick@rbcs.com Questions regarding acceptable file formats should be sent to Lesley Chubick, lchubick@rbcs.com or call me at 800-252-1925 ext 737.