Reconcile Registrations to QuickBooks

After each weekend, it is important to reconcile the final headcount in Registrations to the headcount recorded in QuickBooks.  Repeat the steps below for all four Registration “events” (Men’s Team, Women’s Team, Men’s Candidates, Women’s Candidates):

Steps:

1. Planning Center Registrations final reports:  ask IT to provide or follow these steps if you have permissions:
   1. Download the reports
      1. Open each Registration Event (if archived, tap the “All Categories” then select “Archived”)
      2. Click the “Actions” button on the right side of the page, then “.csv” under the Export options
      3. Save the files for editing & comparison
      4. There should be 4 files (2 team, 2 candidates)
   2. Open each report and remove unnecessary columns.  Keep:
      1. Team files:
         1. First name
         2. Last name
         3. Selection (this is team member vs SD)
         4. Registration Amount Paid
      2. Candidate files:
         1. First Name
         2. Last name
         3. Registration Amount Paid
         4. What is the name of your sponsor?
   3. Sort name files by last name
2. In QuickBooks, run the custom report “Candidate Fees #xx” and “Team Fees #xx”
   1. Create a copy using the prior weekend if needed
      1. Edit the filters
      2. Edit the title
      3. Save customization in the same folder, share with all
   2. Export the list to Excel if desired for easy comparison to the Registration reports
3. Compare and make corrections to QuickBooks as necessary to match the Registration reports.