Ok thanks. Not sure where the AR aging report is generated from. Is it in
Quickbooks?
On Thu, Sep 21, 2023 at 12:00 PM Joey Taylor <joey.taylor@thekey.com> wrote:
> Hey Daniel,
>
> I am adding Tim to this convo as I do not have access to Quickbooks or
> handle anything regarding accounting!!
> I am sure he can help!!
>
> Thanks
>
> On Thu, Sep 21, 2023 at 10:01 AM Daniel Barakat <daniel.barakat@thekey.com>
> wrote:
>
>> Hi Joey.
>>
>> Based on a discussion we had with Elizabeth and Tim, we need to write
>> these off. Are you able to do that on your end? These are customer
>> balances sitting on the AR aging
>>
>>
>> Thanks
>>
>> ---------- Forwarded message ---------
>> From: <eclark@thekey.com>
>> Date: Fri, Aug 25, 2023 at 2:30 PM
>> Subject: FW: Canada Aged Balances- Write Off Proposals To Date
>> To: Brian Fialko <brian.fialko@thekey.com>, Daniel Barakat <
>> daniel.barakat@thekey.com>
>>
>>
>> Hi There
>>
>>
>>
>> How do we clear these items? Seems they’re “open” and need to be applied
>> to one another, but not sure how that works on your end (for montreal).
>>
>>
>>
>>
>>
>>
>>
>> Elizabeth Clark
>>
>> *Director, CI & Transformation*
>>
>> *Long Term Care Insurance, Onboarding*
>>
>>
>>
>> *TheKey*
>>
>>
>>
>>
>>
>>
>>
>> *From:* eclark@thekey.com <eclark@thekey.com>
>> *Sent:* Tuesday, August 22, 2023 12:01 PM
>> *To:* 'Timothy Thomas' <tt@thekey.com>; 'Gerard Draetta' <
>> gerard.draetta@thekey.com>; 'Daniel Barakat' <daniel.barakat@thekey.com>;
>> 'Brian Fialko' <brian.fialko@thekey.com>; 'Chuck Terlesky' <
>> cterlesky@thekey.com>; 'Cheryl Cartwright' <ccartwright@thekey.com>;
>> 'Sharon Speirs' <sspeirs@thekey.com>
>> *Cc:* 'Laszlo Kovacs' <laszlo.kovacs@thekey.com>
>> *Subject:* Canada Aged Balances- Write Off Proposals To Date
>> *Importance:* High
>>
>>
>>
>> Hello All-
>>
>>
>>
>> We met for one of potentially 2 more sessions, to discuss the aged
>> balances for both our NS integrated and non-integrated locations. Below is
>> the link to an AR file w/updated data for our next call(s), and *action
>> items *to help move us forward. Please let me know if anything below is
>> misrepresented or if I’ve missed something.
>>
>>
>>
>> *File Linked here.
>> <https://docs.google.com/spreadsheets/d/13RViwfkGDu8dB6VOO82omwG2EJtYb5Yf/edit?usp=sharing&ouid=114633849602778058975&rtpof=true&sd=true>
>> *
>>
>>
>>
>> *Send to TSI & Write Off Tab ($67,861.40):*
>>
>>
>>
>> Clients on this list were approved to w/o during our last meeting due to
>> the age of the balance.
>>
>> - *Tim/Team* should do one final pass to ensure there are no active
>> clients on this list before we move forward. Please reply all to this email
>> to confirm.
>>
>>
>>
>> Once approval is received from Tim:
>>
>> - *Brian/Daniel* can w/o balances for Montreal & Winnipeg
>> - *Gerard *can w/o balances for Toronto
>> - *Gerard* will work to get files to our 3rd party collections
>> partner TSI
>>
>>
>>
>>
>>
>> *Net_Negative Tab (-$144,726.70):*
>>
>>
>>
>> Clients on this list may have some open invoices however, their balance
>> is net negative. Clients here need payments applied out to any open
>> balances and should be refunded to clear these funds from our books.
>>
>> - *Tim/Team* should do one final pass to ensure we’re aligned. Please
>> reply all to this email to confirm.
>>
>>
>>
>> Once approval is received from Tim:
>>
>> - *Gerard *should have the team apply all funds in NetSuite/ClearCare
>> > Send Check Requests to AP for each client.
>>
>>
>>
>> *Future AR Meetings:*
>>
>> Waterloo, Oakville, Winnipeg needs to be reviewed in future sessions to
>> better understand the 91+ balances. These totals could be 93 days old, or
>> 400 days old, which cannot be identified using the aging formats we have
>> received thus far. While we have noted any perceived write off’s needed, we
>> need that line-item detail before we can call these locations complete.
>>
>>
>>
>> *Elizabeth *will work to get updated aging’s pulled.
>>
>>
>>
>>
>>
>> *Completed Review:*
>>
>> Montreal, Alberta, Toronto- All AR Review is complete. In our initial
>> call we isolated accounts that arent collectable/have negative balances.
>> Outside of these clients, the Accounts Receivable team should move forward
>> with client/payer contact.
>>
>>
>>
>>
>>
>> Kind regards-
>>
>>
>>
>> Elizabeth Clark
>>
>> *Director, CI & Transformation*
>>
>> *Long Term Care Insurance, Onboarding*
>>
>> *TheKey*
>>
>> Office|Cell : 619-822-4855
>>
>> eclark@thekey.com
>>
>>
>>
>> *TheKey.com <https://www.thekey.com/>*
>>
>>
>>
>> [image: TheKey] <https://homecareassistance.com/>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
> --
>
> Joey Taylor
>
> *Regional Care Solutions Manager*
>
> 514-907-5065
>
> TheKey.ca <https://thekey.ca/>
>
> [image: TheKey]
>