Information Need

Reports

Connect payments to bank deposits/bank statements

Payment Gateway Reports

Inactive Accounts with balances within a specified timeframe

Custom Report - Account Tab filtering by "enrolled on date" and switching the Inactive switch on

Invoices Report/Current Invoices - If you need Invoice due dates or #s

Accounts paid in full for specific programs/specific classes

Invoices Report/Paid Invoices - If you need Invoice due dates or #s; does not include email addresses

Custom Report - filter columns based on balances and programs/classes

Accounts paid/paid invoices/total payments (paid in full or payment plans); per location/program/class

OR

Payments (income) by charge items

Invoices Report/Paid Invoices - If you need Invoice due dates or #s; does not include email addresses

Custom Report - Filter columns based on payment plan name ("None" if paid in full)

Charge Items Report - Certain charge items (same info as Transactions Report)

Transactions Report - Does not include totals, only includes the 1st 10 classes, and all classes are on one line in export

Transactions Export - does not include email addresses

Accounts due/balances

A/R Aging Report - only by location (not enrollment period, program, or class); only active accounts

Invoices Report/Current Invoices - If you need Invoice due dates or #s; does not include email addresses

Custom Report - Filter by balance column

Transactions Report - Does not include totals, only includes the 1st 10 classes, and all classes are on one line in export

Enrollees and tuition rate

Invoices Report/Future Invoices - Will show payment plan tuition charges

Auto-Pay- who is on auto-pay and who isn’t

Invoices Report/Current Invoices - If the payment method shows, auto-pay is on; will say "Off" if auto-pay is off.

Credits on accounts (credit refunds, etc.)

Discount Items Report - Certain credits (excluding coupon codes; see below)

Coupon codes used

Transactions Report - Coupon Codes show under "Misc Credit." Does not include totals, only includes the 1st 10 classes, and all classes are on one line in the export

Refunds

Transactions Report/Refunds - Can export just refunds. Does not include totals, and all classes are on one line in the export

Discount Items Report - If you have a discount item like "Refund Adjustment"

All transactions within a specified timeframe

Transactions Report - Does not include totals, only includes the 1st 10 classes, and all classes are on one line in export

Transactions Export - Does not include email addresses

Invoices Report - Export current, paid, and future invoices (does not include email addresses)

Prepayments

Prepayment Report - only shows email addresses and balances

Unreconciled Accounts

No Report Available

Workaround: Invoices Report/Current Invoices (not on auto-pay) + Custom Report filter by balance - Compare balances with current invoices)

Failed credit card payments

No Report Available

Admin users receive failed credit card payment emails if the setting is checked in the admin profile