x Processing Overdue Accounts

Open with Excel

Click on top left cell to highlight all cells in blue as indicated. Then double click on line of one of the cells across the top as indicated.

Delete all rows with zero amounts in all of the aging columns.

Save report to “Dropbox”

Open current Debtors Report - Operations Manual 2015/ Reports

Have them both open so that you can cross reference them.

Follow the Steps below and action each of these overdue accounts

Use the exported report or simply use the online report to update our Overdue Payments spreadsheet.

DROPBOX> Admin> DEBTOR Reports> 2018 Debtors Report

• 1. Fill in the name of the client

  2. What Product, Program or Coaching Group are they from?

     1. eg, June 2016 or Feb 17 or MMMP or WWW etc.

  3. Double check that their access to this program has been removed and mark this on the document

  4. REHAL AND SANDY CHECKING TAGS CAMPAIGNS WP ACCESS ETC

  5. Click Tags in their profile

  6. Look for the groups tag eg. GROUP: June 2016

  7. Remove the Group tag but Keep GROUP: June 2016 Emails (as we want to keep reminding the client of their program.

  8. To Remove - Click the X on the right hand side

  9. Fill in the last date that a payment was due on spreadsheet

• • 1. On their general profile - scroll down until you see Orders

    2. Find the product that has an outstanding amount due and click the order name.

    3. Scroll down until you see the payment dates.

    4. Find the latest date what was meant to have a payment processed.

• 10. Calculate how much the client has outstanding.

• • 1. Note the product/s that have an outstanding amount

    2. Add this total up and this will be the amount overdue

• 11. Note how many payment are behind. They might have 2 months outstanding = 2

  12. Record how much money they have left to pay off

• • 1. When you are viewing an order on the very right there will be a column called remaining Bal.

• 13. Follow the process below with each Actioned Step

Action Step 1 (DAY 1): Contact Via Email

Hi NAME

I'm NAME, the membership co-coordinator for WWW/ISCA/WW (choose an appropriate name to match product purchase). By now you've probably received an automated email from our Membership system about your outstanding payment for PRODUCT/PROGRAM and realised your access to that product has now been blocked.

I just wanted to personally reach out to you to see if you need any assistance making payment and getting up to date. You could pay by another CC or make a Paypal payment if you prefer. Let me know if you need help to update your CC info so we can get you back on track and up to date and access the program you purchased.

Also, please take a moment to re-read the T&C you agreed to when you first joined - PUT A LINK TO THEM HERE

If you would like to update your card details we have on file please do this here: https://qs101.infusionsoft.com/app/orderForms/Update-Credit-Card

I'll reach out again in a couple of days if I don't hear back from you as we need to get this sorted asap.

Thanks

TERMS & CONDITIONS:

WWW: https://www.wildlywealthy.com/terms-and-conditions/

ISCA: https://lp.inspiredspiritcoaching.com/terms-conditions

MMB: https://www.millionairemindsetbreakthrough.com/mmb-tc

Action Step 2 (DAY 3): Reply to Email

Hi NAME,

As you know your account is still overdue. Unfortanley if we don't hear from before Monday the 25th of March 2019 to arrange an alternative payment your account will be handed over to our accounts department who will take further action with collections.

Please contact our office to arrange a payment plan that you can make to start to pay off your program.

Also, please take a moment to re-read the T&C you agreed to when you first joined - https://lp.inspiredspiritcoaching.com/terms-conditions

Thanks,

Action Step 2 (DAY 3): Contact Via Facebook

Hi NAME

By the way your account is now overdue, please check your emails ASAP as we have sent you some information.

Action Step 4 (DAY 5): Contact Via Phone Call

Sandy write phone script for day 5

Action Step 5 (DAY 12): Contact Send final Email

[Date]

[Name] [Address]

Dear

OVERDUE ACCOUNTS NOTICE

Re: Invoice Number 00000 - $000.00

We refer to our statement that was forwarded last month. We note with disappointment that we have yet to receive payment of your account.

Unless the above amount is received in full at this office within seven (7) days of the date of this notice we will be left with no alternative but to place collection of this debt with our Debt Collection agency, EC Credit Control (Aust) Pty Ltd.

Under our terms and conditions of trade this will mean that you will incur additional collection costs over and above your original debt, and that we may take whatever action we deem necessary to recover this debt. It will also impact your credit score and you will have trouble getting any loans in the future.

We trust that this will not be necessary.

Of course we don't want that to happen, so lets work something out that suits us both.

If you have already forwarded payment, please disregard this letter.

Yours sincerely

Action Step 6 (DAY 19): Process EC Credit Control Application

Follow the EC Credit Control Process - BELOW

When a Client Comes Back with Excuse About Payments

Hi ___________________,

So sorry to hear about your health complications, we hope that everything is looking better for you now.

To remind you, you agreed (twice) to the terms and conditions of joining the ISCA http://www.inspiredspiritcoachingacademy.com/terms-conditions/ NEW LINK

and you are not able to defer your payments even if you decide you cannot continue your training.

If you would like we can put you on a lower payment plan, however, payments need to continue or

our Accounts Department will send your account to our Collection Agency and the entire amount

will be due and payable at once with additional collection fees.

Also, understand that with just one client a month you could pay for your tuition and with 2 clients

a month you would be bringing in an income, so it seems a shame to not continue so you can

begin to create an income as a coach.

Please advise us how much you can pay each month - a minimum of $100 is required to ensure

your account does not go to collections, also advise us within 5 working days so we can

let our accounts department know you are sticking to your commitment.

Thanks so much and let us know if you have any questions.

BELOW TO EDIT

How to turn an account over to collections:

1: final email to the client notifying them of bad debt collections (LINK TO SAMPLE)

2: Send the relevant details (contract, amount, personal info) to the collection agency (collection agency will likely have information they need completed) SAMPLE HERE

3: Zero out the balance in Infusionsoft as “Bad debt” to show $0 Balance (EXPLANATION HOW TO DO THAT HERE) WHY ARE WE MAKING THIS A $) BALANCE IF IT IS BEING HANDED OVER TO COLLECTIONS. SHOULDNT IT STAY AS JUST AN OUTSTANDING ACCOUNT UNTIL THERE IS NO WAY IT IS BEING COLLECTED AND THEN IT BECOMES A BAD DEBT?

4. Make a note in clients record (LINK TO HOW TO DO THIS HERE)

4: Add client to “black list” of non-paying clients – perhaps a “do not market/sell to” tag (Sandy: What tag would you like created?)

5: Notify the bookkeeper of amounts considered bad debt and uncollectable. (SAMPLE EMAIL HERE)

6: If client was a referral, note in the affiliate ledger why affiliate payment will not be made in accordance with Affiliate policies on pay in full clients. (SAMPLE EMAIL HERE)

How to Book Outstanding Debts with EC Credit Control

Account Number 32133

To make use of our online services, which can be found at www.eccreditcontrol.com.au website. Here you can load vouchers online and obtain updates on the progress of your vouchers.

When loading a debt we need copies of invoices & signed credit application.

Also please see attached blank voucher and client manual for your use if needed.

To gain access to these online services you will need to use your client number and password. Your client number is 28460KM or use the account number 32133 and your password is ADMIn2019!!.

To load a voucher

Go to www.eccreditcontrol.com.au

• Click on client login

• Enter your client number

• Enter your password

• Then login

• Select a tab (load a debt, view all vouchers etc)

• Tick the box that you have read & understood our Terms & Conditions of Trade

• Submit

• Enter voucher number and all other details pertaining to the debtor

• Then press submit

You should then receive a confirmation saying,

Thank You – we have received your voucher number (00000) and it has been forwarded to our investigation team. Within 2 working days the debt details will be loaded into our collection system and you will be able to track the progress online. You will then receive an email advising you of the collector responsible for this collection and confirming that the first demand has been served. If this email is not forthcoming, please contact me via return email or phone.

Need more information??

Contact - Marissa Woods (Customer Services Representative)

Email: Marissa.Woods@eccreditcontrol.com

Phone: 1300 361 070