Event Reconciliation Step – by – Step Instructions

1. Event Reconciliation Step – by – Step Instructions For U.S. Managing Directors

2. The enclosed instructions are to assist you with the post-event reconciliation process. Please have all necessary documents in hand to assist you in proceeding through each step.FOR ALL OTHER EVENT SERVICES, CONTACT: Jenn Simpson Program Coordinator (972) 620-9995, ext. 1008

3. To begin your event reconciliation, log in to the site, which will take you to the Members Directory (your homepage). STEP 1

4. Click “Manage Events” on your homepage. STEP 2

5. Select “My Events”. STEP 3

6. Click the “Past Events” link to add attendees that have registered the day of the event by check or credit card . STEP 4

7. To add attendees at or after the event, click the “Add Attendees” link. If you do not have additional attendees to add, skip to Step 18. STEP 5

8. If the additional attendees you need to enter are members, click the “find sign-in name” and skip to Step 11. If they are not members, continue to next step. STEP 6

9. For non-members, click the “highlighted option” to register them. STEP 7

10. Enter all pertinent information for the non-member registrant and click “Continue”. STEP 8

11. Enter the appropriate price and click “Update Price.” After the price is updated, select whether the payment was a new credit card or physical check received, and “Click Here to Continue Your Registration”. STEP 9

12. Fill in the appropriate credit card data and click “Update”. Then, move to Step 12. STEP 10

13. Type members last name into the Search Term box. STEP 11

14. Select Member And Press “Continue”. STEP 12

15. Enter correct amount for registration and click “Update Price”. STEP 13

16. Select new credit card, physical check pending or physical check received and “Click Here to Continue Your Registration”. STEP 14

17. Fill in any address information needed and click “Continue”. STEP 15

18. Verify your attendee information and click “Submit Transaction”. STEP 16

19. Click “Continue” to add more attendees OR to begin entering Foundation Donation amounts. STEP 17

20. Click the “Attendees” link. STEP 18

21. Click the “Donation” link for the person who gave the donation. STEP 19

22. Enter the amount of the donation given in the “Amount of Contribution” space, mark the “Payment Type”, and click Continue when you are finished. STEP 20

23. Verify the amount of the contribution and click “Confirm Information Above”. STEP 21

24. When you’ve finished entering Foundation Donation amounts, click the “My Events” link to go back to your events. STEP 22

25. Click your “Menu” link. STEP 23

26. Click your “eWN Menu” link. STEP 24

27. Click “Go to the Toolkit” link. STEP 25

28. Click your “Event Reconciliation” link. A form will open up in an Excel format that you can save anywhere on your computer. STEP 26

29. Please save this form to your computer for easy reference. You will complete all totals in this form before submitting to the corporate office. STEP 27

30. The information to complete the event reconciliation will be found on your events page. STEP 28 Complete the following fields: 1. Your Name Event Location Chapter ID Date of event Event Type Event ID – Accounting dept. will complete for you

31. Open up the “Accounting Report” and Save to your computer. You will need to attach a copy of this as part of your event reconciliation package. STEP 29 You will need to have your Event Reconciliation Form open to complete the next few sections.

32. Place total of all credit cards (cell K11) in the field marked “Total of all Credit Card Charges” under the “Events Payment Received” or “Accounting Report” column as demonstrated in the next slide. STEP 30

33. “Event Payments Received” and “Accounting Report” will always be equal. The amounts should never differ. After credit card charges, continue entering the subtotals of any paper checks as subtotaled on your accounting report. STEP 31

34. The total of all payments from credit cards and checks– as shown in cell K12 – will match the amount of the “total amount collected” on your reconciliation form as shown in the next slide. STEP 32

35. The “total amount collected” will match your accounting report total. Once you have completed your accounting report totals, you are now ready to move on to your club bill and Foundation donations. You will need to enter the amount of the invoice or receipt you received from the club or venue after your event. Fill free to add notes in the notes column, concerning your venue. (Remember to attach a copy when you send it in.) STEP 33

36. Form the Events page, click “Foundation Form” link. STEP 34

37. Total all donations and enter on your reconciliation form under the “Foundation Donation Totals” section, as shown on next slide. STEP 35

38. Fill in Foundation Donations Total. Enter any local Sponsorship Dollars Collected for your event in the next block of the Event Reconciliation Form. Complete “Notes to accounting staff” should you need to report any other pertinent information. (For example: 2 paper checks sent in mail OR awaiting bill from venue) STEP 36

39. For total numbers of paid members, non-members, guests and tables, reference the Membership Status column of your accounting report. STEP 37

40. Once your event reconciliation package is received and processed by the corporate office, you will receive a Statement of Registration Reimbursement as an attachment in your email inbox. It will include the date of your check or deposit. STEP 39

41. Cash and check payments fields will show the totals collected from attendees who paid with cash or a check. STEP 41 The checks are taken out of your gross revenue – shown later in the statement.

42. The credit card section will show the total of all credit card charges for registered attendees. STEP 42

43. The highlighted Subtotal is the total of all the cash, check and credit card payments. STEP 43

44. The number of credit card transactions are the total number of credit card transactions found on the accounting report. STEP 44

45. The 20% Corporate fee is the fee that you pay to the eWN Corporate office. It is calculated by taking the subtotal and multiplying it by 20%. (For example: $395.96 x .20 = $79.19) STEP 45

46. Credit Card Transaction Fees are calculated by multiplying the total number of credit card transactions by 75%. (For example: 9 x .75 = $6.75) STEP 46

47. The 4% Fee on Approved Charges is the fee that the corporate office pays, as a merchant, for processing credit card transactions. It is calculated by multiplying the total of all credit card payments by 4%. (For example: $395.96 x .04 = $15.84) STEP 47

48. The Subtotal is the sum of all combined fees and approved charges. This is the total amount that you pay to the corporate office. STEP 48

49. The Subtotal under the Managing Director’s Reimbursement is the amount of gross revenue earned on the event less all corporate and processing fees. It is calculated by taking the subtotal of the event payments received and subtracting the subtotal of all corporate and processing fees. (For example: $395.96 – $101.78 = $294.18) STEP 49

50. Below the Sub-Total is the Less Event Funds Retained and Less Foundation Funds Retained. These are both the physical checks and cash received for your event and for your Foundation donations. These amounts are deducted from your reimbursement . STEP 50 The Total Due To Managing Director is the amount that will be remitted to you via check or direct deposit.