Analysis 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>General Ledger Analysis>

 

Standard General Ledger

This report prints the general ledger. It contains opening balance and complete detail for any report range and account codes selected. It prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. And since the general ledger is basic to your accounting records and is a must for auditors, you will want to print an archive copy each month after all adjustments are entered and posted of either the Standard General Ledger or the Expanded General Ledger (depending on the presentation style preferred).

Expanded General Ledger

This report prints your general ledger. It contains opening balance and complete detail for any report range selected and for all account codes selected. It displays each account segment in its own column. In addition, it allows you to select transaction information columns (such as Transaction Source or Transaction Description) that are not available on the Standard General Ledger. And since the general ledger is basic to your accounting records and is a must for auditors, you will want to print an archive copy each month after all adjustments are entered and posted of either the Standard General Ledger or the Expanded General Ledger (depending on the presentation style preferred). This report also contains additional items, columns, and filters if any user defined fields were created.

Normal Trial Balance

This report prints a trial balance. It prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool. The report contains the Drill Down feature, which allows you to view report data from the report balances level down to the individual debits and credits that make up the balance.

Comparative Trial Balance

This report prints a trial balance with comparative information representing the beginning year balance, beginning report period balance, and the current balance. It prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool. Additional items and filters are available if any user defined fields were created

Working Trial Balance

This report prints a trial balance with four additional columns available for writing in manual adjustments. It prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool. You can also print trial balances that show comparative amounts with differences for review purposes.

Reports>Accounts Payble>

 

Summary A/P Ledger

This Accounts Payable report lists invoices including the amount due. This is a summary style ledger that contains data from the detail ledgers and summarizes all entries for an A/P invoice, credit, or check. The detail entry amounts for an invoice are netted together creating a summary amount due. It assists in reconciling accounts payable balances. It is also useful for audit purposes or for researching vendor payment questions. And contains the Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports.

Detail A/P Ledger

This Accounts Payable report lists invoices including the amount due. This is a detail style ledger that can print data in detail or summary. When the Summarize Amount option is selected on the Options tab, the detail entry amounts for an invoice are netted together creating a summary amount due. However, when this option is not selected, the system prints each individual record for an invoice in detail. It assists you in reconciling accounts payable balances. It is also useful for audit purposes or for researching vendor payment questions. And prints an individual record for each invoice.

Aged Payables

This Accounts Payable report lists invoices using a time factor. The report separates the invoices into four sections of time. It can be used to review the status of current Accounts Payable balances. You can quickly view which invoices are past due according to the criteria you establish on the Options tab of this report. This report is a summary style ledger that contains: Data from the detail ledgers and summarizes all entries for an A/P invoice, credit, or check. The detail entry amounts for an invoice are netted together creating a summary amount due. Additional items, columns, and filters are available if any user defined fields were created. And the Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports.

Invoices Selected for Payment

This Accounts Payable report lists invoices that have been selected for payment (Activities>Accounts Payable>Select A/P Invoices to Pay). You can print the discount date and amount available for each invoice. Then, you can review the selections for accuracy before printing checks. The report assists you in deciding whether you selected the appropriate invoices for payment to the vendors. Additionally, it helps to determine the amount of cash necessary to cover the invoices to be paid. After you print a check for an invoice, that invoice does not appear on this report.

Vendor Activity

This Accounts Payable report prints all transactions related to payments to a Vendor ID, including the GL distribution. You can view check information along with the General Ledger coding. This report contains: Additional items, columns, and filters are available if any user defined fields were created. And the Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas.

Reports>Accounts Receivable>

 

Calculated Invoices/Finance Charges

This Accounts Receivable Billing report shows the information that was calculated on a Bill (Invoice) but has not yet been processed further, for regular (non finance charge) charges, the report shows are all charges calculated but not yet printed in an Invoice, and for Finance Charges, the report shows all charges calculated but not yet transferred to history. This report is comprised of the Invoice number, Date, Customer ID, comments regarding the Charges, and all of the detailed Charge information

Charge Register

This Accounts Receivable Billing report shows detail charge information for invoices that have been printed. This data was created using Activities>Accounts Receivable>Calculate Invoices/Finance Charges and Print/Email Calculated Invoices. This report also shows if an invoice has been voided through the Void Invoices form. Additional items, columns, and filters are available if any user defined fields were created.

Sales Order Register

This Sales Order Entry report show summary and detailed information about calculated and Historical invoices, as well as, Sales Orders Writing: Enter Orders, Cancel Orders, Customer Returns; and Order Fulfillment: Sales Order Fulfillment.

Summary A/R Ledger

This Accounts Receivable Reporting report lists invoices including the amount due. This is a summary style ledger that contains data from the detail ledgers and summarizes all entries for an A/R invoice, credit, or receipt. The detail entry amounts for an invoice are netted together creating a summary amount due. It assists in reconciling Accounts Receivable balances. It is also useful for audit purposes or for researching customer payment questions and summarizes all entries within an invoice.

Detail A/R Ledger

This Accounts Receivable Reporting report lists invoices including the amount due. This is a detail style ledger that can print data in detail or summary. When the Summarize Amount option is selected on the Options tab, the detail entry amounts for an invoice are netted together creating a summary amount due. However, when this option is not selected, the system prints each individual record for an invoice in detail. It assists in reconciling Accounts Receivable balances. It is also useful for audit purposes or for researching customer payment questions. And prints an individual record for each invoice.

Aged Receivables

This Accounts Receivable Reporting report lists invoices using a time factor. The report separates the invoices into four sections of time. It can be used to review the status of current Accounts Receivable balances. Quickly view which invoices are past due according to the criteria that is established. This is a summary style ledger that contains: Data from the detail ledgers and summarizes all entries for an A/R invoice, credit, or receipt. The detail entry amounts for an invoice are netted together creating a summary amount due. Additional items, columns, and filters if any user defined fields were created.

Customer Activity

This Accounts Receivable Reporting report prints all revenues, cash receipts, and charges related to a customer. This report contains: Additional items, columns, and filters are available if any user defined fields were created. And the Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas.

Reports>Allocations Analysis>

 

Pre-Allocation Standard General Ledger

This Allocation Management report prints all posted transactions and any unposted allocation transactions. This allows allocations to be reviewed, which were created using Activities>Process Allocations, before they are posted (Activities>Manage Sessions>Post Transactions). This report: Contains opening balance and complete detail for any report range selected and for all account codes selected; Prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected; Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA); and Displays currency fields with the formatting of the organization's functional currency.

Pre-Allocation Expanded General Ledger

This Allocation Management report prints all posted transactions and any unposted allocation transactions. This allows allocations to be reviewed, which were created using Activities>Process Allocations, before they are posted (Activities>Manage Sessions>Post Transactions). This report: Contains opening balance and complete detail for any report range selected and for all account codes selected; Displays each account segment in its own column. In addition, it allows you to select transaction information columns (such as Transaction Source and Transaction Description) that are not available on the Standard General Ledger; Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA); and Displays currency fields with the formatting of the organization's functional currency.

Pre-Allocation Normal Trial Balance

This Allocation Management report prints unposted pre-allocation transactions. (Pre-allocation transactions were set up using Activities>Process Allocations.) Run this report before posting transactions using Activities>Manage Sessions>Post Transactions. This report: Prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool; Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA); and Displays currency fields with the formatting of the organization's functional currency. The report contains the Drill Down feature, which allows you to view report data from the report balances level down to the individual debits and credits that make up the balance.

Pre-Allocation Comparative Trial Balance

This Allocation Management report prints a trial balance with comparative information representing the beginning year balance, beginning report period balance, and the current balance along with variance information. (Pre-allocation transactions were set up using Activities>Process Allocations.) Run this report before posting transactions using Activities>Manage Sessions>Post Transactions. This report: Prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool; Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA); and Displays currency fields with the formatting of the organization's functional currency.

Pre-Allocation Working Trial Balance

This Allocation Management report prints a trial balance with four additional columns available for writing in manual adjustments. (Pre-allocation transactions were set up using Activities>Process Allocations.) Run this report before posting transactions using Activities>Manage Sessions>Post Transactions. This report: Prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool; Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA); Displays currency fields with the formatting of the organization's functional currency.

Pre-Allocation Statement of Revenues and Expenditures

This Allocation Management report views a standard statement of revenues and expenditures. You can print balance information for posted transactions and any unposted allocations for any account combination desired. This allows allocations to be reviewed, which were created using Activities>Process Allocations, before they are posted (Activities>Manage Sessions>Post Transactions). This report: Contains additional items and filters if any user defined fields were created and does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA). Important Certain requirements must be followed for the Financial Statement Format to ensure that the Fund Balance/Net Assets section totals correctly.

Pre-Allocation Statement of Cash Flows

This Allocation Management report produces a statement of cash flows. The purpose of a statement of cash flows is to provide relevant information about the cash receipts and cash disbursements during a period and whether they stem from operating, investing, or financing activities. You can print the balance information for posted transactions and any unposted allocations for any account combination desired. Sessions with a status of Batch-to-Suspend are not included in this report. However, it does contain any unposted transactions for allocation sessions (JVA). To use this report, the Statement of Cash Flows must first be set up using Reports>Financial Statements>Create Statement Formats. This format is where you will design the statement format to follow, either the direct or indirect method of reporting cash flows.

Reports>Encumbrances>

 

Summary Encumbrance Ledger

This Encumbrances report lists encumbrances, through the report date range. This is a summary style ledger obtaining its information from the detail ledgers and summarizing all entries for an encumbrance which has an effective date prior to or within the report date range. The detail entry amounts for an encumbrance are netted together creating a summary amount. It assists in reconciling Encumbrance balances and contains liquidations made through Transactions>Accounts Payable>Enter A/P Invoices.

Detail Encumbrance Ledger

This Encumbrances report prints the amount of encumbrances through the report date range. This is a detail style ledger that can print data in detail or in summary. When the "Summarize Amounts" option is selected on the Options tab, the detail entry amounts for an encumbrance are netted together creating a summary amount due. However, when this option is not selected, the system prints each individual record for an encumbrance. It assists in reconciling encumbrance balances; is useful for audit purposes or for researching encumbrance question; and contains liquidations made through Transactions>Accounts Payable>Enter A/P Invoices.

Aged Encumbrances

This Encumbrances report lists encumbrances using a time factor. The report separates the encumbrances into four sections of time. These sections of time enable you to see how an encumbrance date is compared to an aging date entered on the Options tab. This summary style ledger contains: Data from the detail ledgers and summarizes all entries for an encumbrance. The detail entry amounts for an encumbrance are netted together creating a summary amount due. An encumbrance may net to zero if there are detail entries within the report date range that net to zero; and Liquidations made through Transactions>Accounts Payable>Enter A/P Invoices.

Encumbrance Budget Report

This Encumbrances report print data comparing current year or period budgeted revenues and expenses with current year or period actual revenues and expenses and/or current year or period encumbrances. The budget columns are calculated based on the Budget Version selected on the Options tab. This report contains: Any liquidations entered using Transactions>Accounts Payable>Enter A/P Invoices, appear in the "Actual" columns; Additional items, columns, and filters if any user defined fields were created; and The Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas.

Reports>Fixed Assets>

 

Asset Transfer Register

This Fixed Assets report lists transferred depreciation, adjustments, and disposals. You can also view the segment coding of the transferred entries. The Asset Transfer Register is comprised of depreciation/disposal transactions that have been transferred to the General Ledger.

Depreciation Calculation

This Fixed Assets report prints the untransferred calculated, adjusted, and disposed depreciation. The information contained in this report is derived from the calculations and adjustments made using Activities>Fixed Assets>Calculate Depreciation, Review/Adjust Depreciation, and Enter Disposals.

Asset Disposals

This Fixed Assets report prints the disposal of assets. This information was entered using Activities>Fixed Assets>Enter Disposals.

Pre-Transfer Depreciation/Disposal Register

This Fixed Assets report prints the transaction entries that will be generated prior to transferring to Accounting. It is important to review this report prior to transfer since assets that have been transferred post immediately to the ledgers.

Summary Asset Ledger

This Fixed Assets report prints summary information for all assets which can include depreciation and disposal activities on any given date range. This report allows you to view information by asset for a specified period.

Reports>Bank Reconciliation>

 

Combined Register

This Bank Reconciliation report lists checks/vouchers and deposits from the General Ledger cash type accounts; lists other cash items; and lists suspense items entered on the Activities>Reconcile Cash Accounts - Suspense Items Tab. Reconcile the cash accounts and review the monthly or annual check/voucher register with this report. These items were entered and posted using either Transactions>Enter Cash Disbursements, Enter Journal Vouchers, Transactions>Accounts Payable>Enter A/P Invoices, Enter A/P Credits, Enter Manual A/P Checks, Transactions>Accounts Receivable>Enter A/R Invoices, Enter Cash Receipts, Enter A/R Receipts, Enter A/R Credits, Activities>Check Writing>Write Checks, Pay Selected A/P Invoices, Receipt Writing, or Void Checks/Vouchers/Invoices. Additionally, this report includes any Payroll Checks/Vouchers entered in the Payroll module and then transferred to Accounting.

Checks/Vouchers

This Bank Reconciliation report lists checks/vouchers from the General Ledger cash type accounts to reconcile the cash accounts and review the monthly or annual check/voucher register. The checks/vouchers listed were entered and posted using either Transactions>Enter Cash Disbursements, Transactions>Accounts Payable>Enter Manual A/P Checks, Activities>Check Writing>Write Checks or Void Checks/Vouchers/Invoices, or Activities>Accounts Payable>Pay Selected A/P Invoices. Additionally, this report includes any Payroll Checks/Vouchers entered in the Payroll module and then transferred to Accounting.

Deposits

This Bank Reconciliation report lists deposits from the General Ledger cash type accounts to reconcile the cash accounts and review the monthly or annual deposit register. The deposits listed were entered and posted using Transactions>Enter Cash Receipts, Transactions>Accounts Receivable>Enter A/R Receipts, or Activities>Receipt Writing.

Other Cash Items

This Bank Reconciliation report lists other cash items. These are items that were entered and posted affecting cash that were not checks/vouchers or receipts. Other cash items might include entries, such as a bank service charge that was entered as a Journal Voucher. The items listed were entered and posted using Transactions>Enter Journal Vouchers, Transactions>Accounts Payable>Enter A/P Invoices, Enter A/P Credits, Transactions>Accounts Receivable>Enter A/R Invoices, or Enter A/R Credits.

Suspense Items

This Bank Reconciliation report lists current suspense item information that appears on the Activities>Reconcile Cash Accounts>Suspense Items tab. Suspense items are reconciling items that are not entered as general ledger transactions (for example, a bank error).

Reports>Budget>

 

Detail Budget/Actual Transactions

This Budget report reviews the effect that actual, budget, and encumbrance transactions have on available budget during a specific period. It includes Budget, Actual, Encumbrance, and Available Budget numeric columns for reporting your data. The budget amounts are based on the Budget Version selected on the Options tab. Currency fields follow the formatting of the organization's functional currency.

Summary Budget Comparison

This Budget report generates any account type or account code combination, to print data comparing current year or period budgeted revenues and expenses with current year or period actual revenues and expenses. Budget data was entered when the budget worksheet was set up using Activities>Budget Worksheet or Transactions>Enter Budget. This report contains: Additional columns if number type user defined fields were created and the Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas.

Budget Worksheet

This Budget report to view or print the budget worksheet as it's being created or after its creation. You can view the budget worksheet with reporting periods in columnar format across the page as monthly, quarterly, or yearly as defined on the Options tab. This report: Consists of account, group account, and period column information; as well as a total of all the Period columns; Reflects all of the information on the Budget Worksheet, Budget Revisions Worksheet, or units based Budget Worksheet, including the comparative columns and the total columns; and Contains additional columns if number type user defined fields were created.

Reports>Purchase Orders>

 

Purchase Order Register

This Purchase Order report prints purchase order information, which was created using Activities>Purchase Orders>Create/Modify Purchase Orders. It contains: Additional items, columns, and filters if any user defined fields were created and 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.

Purchase Order Tracking

This Purchase Order report prints purchase order information, which was created using Activities>Purchase Orders>Create/Modify Purchase Orders. You can track information through the: Process Receipts, Adjust Receipts, Cancel Items, Enter Cash Disbursements, Enter A/P Invoices, Write Checks, and Enter Encumbrance liquidations. Additional items, columns, and filters are available if any user defined fields were created.

Purchase Order Vouchers

This Electronic Requisitions report lists requested items from multiple requisitions that have received final approval and are now ready to add to a purchase order.

Electronic Requisitions>Reports>

 

Requisition Register

This Electronic Requisitions report lists all requisition. includes requisitions of every status.) It contains requisition detail, transaction line entries if applicable, and requisition document information. the requisitions that display in this report are based on the current User ID. You may only be able to view requisitions that you created, depending on your user type.

Requisition History

This Electronic Requisitions report summarizes a requisition's history that was created and/or approved using Activities>Create/Approve Requisitions. You can easily keep track of changes made to a requisition from the time the requisition was created until it was added to a purchase order.

Budget and Encumbrance Balance Analysis

This Electronic Requisitions report checks the budget and encumbered balances for all requisitions according to specific account codes (transaction information). This report supplements the Check Budget and Encumbrance Balances process, so you can verify the transaction lines being affected for the requisition, or it can also be used to review all requisition activity relative to your budget.