1 / 53

Event Reconciliation Step – by – Step Instructions

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

keenan
Download Presentation

Event Reconciliation Step – by – Step Instructions

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

More Related