Accounting reports can provide information about day-to-day transaction summaries, credit card transactions for a specified date range, details about invoices, and even invoice-related tax information.
Some of the Accounting reports have enhanced functionality due to being able to use IQA queries to drive report results. This article provides expanded information for these reports, to enable you to generate the maximum benefit from these reports.
Note: Printing a report using IE11 requires that the browser be in Enterprise Mode. Contact Tech Support for assistance.
Note: It is suggested that you export the report (PDF or Excel) and print then print the report.
The following Accounting reports are available:
Account Statement
This report excludes invoices with zero balances, future dates, and fundraising invoices (i.e. pledges).
Account Statement with Parameters
This report prints Account Statements in bulk with several optional parameters to refine, which invoices are included in the statements.
AR Cash Daily Distribution Summary
Day-by-day transaction summary, by GL.
AR Cash Distribution Detail
End-of-month transaction detail, sorted by account number.
AR Cash Transactions
Daily transaction listing grouped by journal type, showing line-by-line details with subtotals by day and journal type. It is not recommended to run this report for periods of time greater than 6 months.
Batch Distribution Summary
Daily batch transaction summary, which displays a one-line summary of debits and credits for each GL account (or Deferred GL account if populated). Includes totals for each batch and a Grand Total.
Credit Card Authorization Audit
Prints a list of all credit card transactions for the specified date range, sorted by Transaction Number. This report uses the Trans.TRANSACTION_DATE for date and time data.
Credit Card Post Authorization
Prints a list of all credit card transactions that are not in Deferred status, in order to reconcile with the gateway. Grouped by Credit Card Authorization Account and Date Entered. This report uses the Trans.TRANSACTION_DATE for date and time data.
Debit Card Post Authorization
Prints a list of all debit card transactions for the selected date range, grouped by Debit Card Authorization Account Code and then by Date entered. Helps to verify Debit Card Gateway reports and to follow up on transactions that are in Unknown or Declined status.
Debit Card Reconciliation
Prints a list of all debit card transactions for the selected date range, sorted by batch and transaction number. Helps to verify Debit Card Gateway reports and to follow up on transactions such as refunds if needed.
Deferred Income Analysis Spread
Provides a projection of how the current balances in deferred income will be recognized in each future period. Includes 12 months of projections as well as a summary of projections beyond that. To have access to this report, you must be licensed for Deferred Income. Contact ASI for more information.
Deferred Income Audit Trail
Provides an audit trail to simulate the income that was recognized and the deferred income balances that remained for a specific monthly period (any month for which the GL Export has already been run). To have access to this report, you must be licensed for Deferred Income. Contact ASI for more information.
This report simulates the process that iMIS uses to generate the deferral to income transfer entries with one exception. It depicts the income recognition at the individual detail transaction level, as opposed to the matrix summary level that iMIS uses to generate the actual entries. As a result, the reported income amounts will most likely be different from the actual amounts by small rounding differences. Nonetheless, the report should give a close approximation of the actual transfer amounts per month as well as the residual balance at the end.
Deferred Income Detail
Provides a report of transactions to be posted to deferred income. This report should be printed prior to running the GL export. Verify the accuracy of the data and make modifications as needed before running the GL export. Any transactions that have already been exported to the GL display a "Y".To have access to this report, you must be licensed for Deferred Income. Contact ASI for more information.
Deferred Income Matrix Summary
Provides the current status of deferred income grouped by account. Includes the totals that were originally posted to deferred income, how much has been recognized to date, and the amount that remains to be recognized in future months. To have access to this report, you must be licensed for Deferred Income. Contact ASI for more information.
General Ledger Journal Detail
General Ledger transaction detail, sorted by account.
Invoice Detail
Displays invoice details without any special formatting for events, orders, or taxation. Can be filtered by open balance, invoice date, invoice number or reference number, sold to contact, or bill to contact.
PayPal Reconciliation
Lists all PayPal Express Checkout transactions for the specified date range, in order to reconcile with PayPal. The columns provided in the report are Trans #, Batch Number, Trans Date, ID, Company/Name, Gateway Ref, and Amount.
Trial Balance
This report displays balances in aging categories for each contact as of the specified Aging Date, optionally including detail rows for each invoice. Includes several optional parameters to refine which invoices are included.
