refunds for BCOL help to process- Pending refunds on BCOL side to be completed

[pstemkens]

https://docs.google.com/spreadsheets/d/13joF294Ylt8dYFAHz-fw7JuxQPWRqFn0yzi17SP6LRo/edit#gid=0

1. the date of each listed transactions in the spreadsheet
2. corresponding BCROS Account number for each listed transactions in the spreadsheet
   Some of these accounts have hundreds of transactions a day.
3. clearer description of what the “payment_account_id” column number stands for? (column A).

Eg. As an example I looked up “bcol_account_id” = 778111 (found Morton Law LLP). Looked up Morton Law in BCROS and found BCROS #2506 but the “payment_account_id” is 2923 which in BCROS is a “Roland LeBlanc” account.

[pstemkens]

@seeker25 , Dennis has come back with a few questions. Can you please provide more details?. thanks

[pstemkens]

@seeker25 , Dennis has responded:

All done. There are four (4) categories of reversals.

ARD = All Reversals Done:
• these billing records were shown as previously reversed in the past
BILLING RECORDS MISS-MATCH:
• these billing records from BCROS do not march what the BC Online Billing Records show. You will have to contact the BCOL Administration on how to handle these reversals?
REVERSALS:
• these billing records had not previously been reversed and are now completed
TOO OLD:
• these billing records are too old to bring up their billing records under the BCOL system. You may need to send this list over to the BCOL Administration for confirmation of reversals? They have access to the archive billing records.

[pstemkens]

https://docs.google.com/spreadsheets/d/1lVBdv-cY6mCxb2aYFu1NEcoG6Se-_LAJ/edit#gid=1139765633
Here is the updated spreadsheet from Dennis.

[seeker25]

Shooting high on this one, it's alot of analysis and looking through and talking to different people