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.
In This Article
- Account Statement
Account Statement with Parameters
AR Cash Daily Distribution Summary
AR Cash Distribution Detail
AR Cash Transactions
Batch Distribution Summary
Credit Card Authorization Audit
Credit Car Post Authorization
Deferred Income Analysis Spread
Deferred Income Audit Trail
Deferred Income Detail
Deferred Income Matrix Summary
General Ledger Journal Daily Summary
General Ledger Journal Detail
General Ledger Journal Monthly Summary
Invoice Detail
PayPal Reconciliation
Trial Balance
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 Distribution Summary
Cash distribution transaction summary, by GL.
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.
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 Daily Summary
Daily transaction summary by GL account.
General Ledger Journal Detail
General Ledger transaction detail, sorted by account.
General Ledger Journal Monthly Summary
Monthly transaction summary by GL 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.
