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. 

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

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.