Page Comparison

The report that you download will be a .csv file.  It will include the following columns:

• Distribution date: the date that the money was scheduled to be released by the bank.  Actual deposit date may vary depending on your own bank but generally are within a day or two of this distribution date.
• Distribution batch: the internal batch number that AIA uses to track our distributions and which receipts are in those distributions. Most chapters don't use this for any business purpose.
• Contact: the member that the receipt is associated with
• Member number: the members AIA number
• Activation: the date that the membership is activated on. This is the easiest way to tell if this is a current year renewal or a next year renewal. Next year renewals will have a 1/1/XXXX dates, current year renewals will be mid-year of the current year dates.
• Item: the membership type that was purchased. Remember that emeritus is not a membership type but a status, however, if an additional emeritus only product was purchased (like a magazine subscription) that will appear in this column.
• Receipt type: Either a payment or a refund
• Subscription type: Tells you if this was a payment-in-full or part of an installment plan
• Price rule: Explains any special pricing that the customer received (ex: newly licensed, new grad, etc.), DEFAULT means they paid full price.
• Sale price: the amount charged for the item  (!!! note that payments and refunds are both postive amounts !!!)

Fonteva records the amount of a receipt as a positive number–both payments and refunds. 

NOTE: If you do not want to use the calendar to enter in dates on the "Date From" and "Date To" fields, you must click out of the "Date To" field before selecting Download Report. If you do not, the file will display ALL results from the "Date From" date entered. 

Check out Using a pivot table on your ACH report

Fonteva records the amount of a receipt as a positive number–both payments and refunds. 

Make sure you adjust any refund receipts to negative amounts if you are going to be using SUM formulas in your analysis.