Offering by Unique Attendees

Open the Deductions and Deposits form

Go to the "Offering pp/w/y" tab

Open the Sunday Attendance sheet

Scroll to the week you are entering and scroll to the bottom of the chart where the totals are

Enter the total AM and PM attendees in columns B & C of the Offering pp/w/y sheet

On the attendance sheet, scroll through and count every time a person was at both services, enter this number into Column D

Column E will then populate the number of Unique Attendees

Open PCO Giving

On the left side, click on Donations List

Change the date range to the dates on the Offering pp/w/y sheet and Filter by: Fund ->General

Enter the "donated" number into Column H

Enter the number of donations into Column J

Columns I (General/Unique Attendees) and Column K (Giving/ # of Donations) will populate