Transaction Reports

The following is a list of reports available for MIP, along with a brief description of each report. Click each report to view more detailed information.

Report Name

Description

Reports>

 

Check/Voucher Register

This report lists posted checks and/or vouchers. This report: Assists in reconciling your bank accounts and may be required at year-end by auditors; Contains the Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports; and Contains additional items, columns, and filters if any user defined fields were created.

Reports>Journals>

 

Cash Journal

This report prints the posted detail information for cash type general ledger accounts. This report: Includes any cash type transaction that occurred during the date range you specify; Provides an audit trail of your receipts, disbursements, and adjustments to help you control cash flow; and Contains additional items, columns, and filters if any user defined fields were created.

Revenue Journal

This report prints the posted detail information for revenue type general ledger accounts. You can view and reconcile revenues received by your organization according to the entry sourceGeneral Ledger receipts, receipts on Accounts Receivable, or Adjustments. Additional items, columns, and filters are available if any user defined fields were created.

Expenditure Journal

This report prints the posted detail information for expenditure type general ledger accounts. You can view and reconcile expenses received by your organization according to the entry sourceGeneral Ledger expenses, disbursements for Accounts Payable, or Adjustments. Additional items, columns, and filters are available if any user defined fields were created.

Reports>Transaction Reports>

 

Unposted General Ledger Transactions

This report prints accounting entries that have been entered, but not yet posted. It is a good idea to print and review unposted entries for accuracy prior to posting. Additional items, columns, and filters are available if any user defined fields were created.

Posted General Ledger Transactions

This report prints accounting entries that have been posted. This report: Provides an audit trail for internal use and for auditors; Contains additional items, columns, and filters if any user defined fields were created; and Contains the Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up with custom formulas.

Unposted Budget Transactions

This report reviews budget entries that have been transferred from the budget worksheet, but have not yet been posted (Activities>Manage Sessions>Post Transactions). It is a good idea to print and review unposted budget transactions for accuracy prior to posting. It use the Budget Version column to differentiate between Budget Versions; Additional columns are available for user defined fields with a Transaction Line type, Field type of number, and a Transaction Source of BD (Organization>Set Up User Defined Fields). User defined fields with a field type of Currency follow the formatting of the organization's functional currency; and Currency columns follow the formatting of the organization's functional currency.

Posted Budget Transactions

This report reviews budget entries that have been transferred from the budget worksheet and have been posted. This provides an audit trail for internal use and for auditors. It use the Budget Version column to differentiate between Budget Versions. Budget Versions were created using Organization>Set Up Modules>Budget>Budget Versions and selected in the Budget Worksheet wizard using Activities>Budget Worksheet; Additional columns are available for user defined fields with are a Transaction Line type, Field type of number, and a Transaction Source of BD (Organization>Set Up User Defined Fields). User defined fields with a field type of Currency follow the formatting of the organization's functional currency; and Currency columns follow the formatting of the organization's functional currency.

Unposted Encumbrance Transactions

This Encumbrances report prints encumbrance entries that have not yet posted. It is a good idea to print and review unposted entries for accuracy before posting them. This report contains: Additional items, columns, and filters if any user defined fields were created; Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No in the Items by Page group box on the Content tab; and User defined fields with a field type of Currency follow the formatting of the organization's functional currency.

Posted Encumbrance Transactions

This Encumbrances report prints posted encumbrance entries. It provides an audit trail for internal use and for auditors. This report contains: Additional items, columns, and filters if any user defined fields were created; Only user defined fields with a field type of String, Editable Drop-Down List, Non-Editable Drop-Down List, Date, or Yes/No in the Items by Page group box on the Content tab; and User defined fields with a field type of Currency follow the formatting of the organization's functional currency.

Memorize/Recurring Transactions

This report prints the transactions memorized on any of the transaction entry forms (using Memorize Document or Memorize/Recurring Document ). The report is used to review transactions before they are posted.