PayPal issued an advisory about a change it’s making that could impact some merchants’ reconciliation process. PayPal called it part of a planned technology update.
Here’s how it described the change and its impact on merchants:
What’s changing
Currently, the bank reference ID is a random alphanumeric value such as 4BW22AXTR6JBA, 548J2AXTR5JEJ, etc.
After the change, the bank reference ID will be a numeric-only value such as 1013045898212 or 1012973298624.
This numeric value will also appear in settlement reports for subscribed merchants.
What’s not changing
There will be no impact to the Custom Memo descriptor field.
Expected impact
Merchants who are using the bank reference ID for downstream processing such as reconciliation on their end will need to adapt their processes to this change. The encrypted merchant account number will be available as a separate field in settlement reports.
If merchants have any custom developments using this field and need additional time or have any questions, they should contact their PayPal support or account managers.
PayPal said it would change the bank reference IDs for transactions beginning May 5, 2021.
Long strings of digits will be converted to scientific notation if casually imported into Excel. Really long numbers like USPS tracking numbers will lose precision. In this case numbers may be captured by importing them as text:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_o365b/excel-csv-files-converting-long-numbers-to/32fe77a7-2201-4da6-8614-cfe90aba4ff6?auth=1