How do I record my membership dues for my GL

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 the receipt is associated with on the payment.
• Member number: the member's AIA number.
• Preferred email address: the email address marked by member as Preferred/Primary.
• 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/YYYY date, current year renewals will be mid-year of the current year dates.
• Item: the membership type or supplemental dues purchased.
  • Remember Emeritus is no longer a membership type but a status; however, if an additional Emeritus only product was purchased (like a magazine subscription) this item will appear in the column.
• Receipt number: the number which holds the payment information for a Sales Order.
• Receipt type: Either a payment or a refund.
• Subscription plan: 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.
• Total finance: the amount paid for the item.
  • Note: an enhancement was added in June 2021 to format the Refund amount with a minus "-" sign in front. This will allow users to use the SUM function to calculate total amount deposited to the component's bank account.