AMS360 Reports List

The following charts lists the standard reports available in AMS360 with information on why you might use the report. Also, some reports are available as a Quick Report from a particular center. Quick reports are a shortened version of the standard report that includes information for a single customer, employee, bank, etc. For more information or to see a sample of the standard report, click the report name link.

Report Name	Description - Why Use It?	Quick Report Center	Where Does Report Data Come From?
1099	This report provides you with a quick means of accessing a list of 1099 items to be included on a Form 1099 to the IRS.	Broker Employee Vendor	Cash Receipts, Checks or Journal Entries posted to a Broker, Employee or Vendor who is set up as 1099.
Account Current	Use this report to manage and report your company payables. You can use this report for both account current or statement basis companies.	Company	Agency bill invoices through a specific date, which have not been fully paid to the company. You choose the items that appear on this report by the selections you make on the Pay Account Current process.
Activity	Use this report as your agency Errors & Omissions to track actions performed by your agency personnel. Activities are historical records of actions performed throughout AMS360. Once entered they cannot be changed or deleted.	Bank Broker Customer Employee Vendor	Activities logged for your Customers and their policies, as well as for each Bank, Broker, Company, Employee, or Vendor (depending upon your security settings).
Authentication Information	This report shows the login activity over selected periods to your agency.	N/A	Employee logins.
Balance Sheet	This report shows you the financial position of your agency on a specific date. It includes the agency's assets, less liabilities, which result in owner's equity.	N/A	The General Ledger balance of all 10000000, 20000000, and 30000000 accounts in your Chart of Accounts.
Bank Deposit	This shows you all receipt transactions (cash, check, credit, and debit card) included in a single deposit to the bank. Print to include with your deposit to the bank. The report lists each item in the deposit.	Bank	Receipts (cash, check, credit, debit card, and EFT) posted in a single deposit for a bank.
Bank List	Use to print a list of banks setup for your agency. This report is a reference list for the agency management staff.	Bank	Banks setup in your agency via the Bank Center.
Bank Reconciliation	Use this report as a record of items reconciled against a specific bank statement.	Bank	Checks, journal entries, and receipts marked as reconciled on a particular bank statement through the Bank Reconciliation process.
Billing Register	This report includes billings posted for a selected date range. Use it for verifying the accuracy of posted billing transactions for single or multiple users.	N/A	Items on this report are focused on instances where a user pressed 'Post' or 'OK' on a billing transaction. Items reported include the following: Posted agency bill invoices Posted direct bill invoices entered via Customer Center billing Installments (optional) Invoice Corrections (including commission corrections for employees on the original invoice) Items not reported are as follows: Direct bill items entered via the Direct Bill Statement. These are reported on the Direct Bill Commission Statement Report. Employees added in 'Change Personnel' even if that employee received commission. Employees changed using Global Change.
Binder Log	Use this report to track the status of binders. The report includes a list of binder recipients as well as information on whether the binder is active, expired, or replaced.	N/A	Binders created for customer's policies via eForms Manager.
Broker Aged Accounts Receivable	Use this report as a collection tool for broker policies. It shows the amounts due your agency from your brokers, by age of the invoice.	Broker	Unpaid Agency bill invoices for Brokers' Customers.
Broker Business Summary	This report provides a summary of agency commission from broker business. The report includes all broker commission activity, regardless of whether the broker is net or gross.	Broker	Posted billing activity. (Customer Center suspended billings and unposted Direct Bill Statement activity are not reported.)
Broker Commission Setup	This report provides a list of commissions by broker as defined in setup. Use to review how brokers are set up in your agency.	Broker	Broker information set up in the Broker Center. Options for the report include the following: All Brokers (with or without Commission Setup) Only Brokers with Commission Setup Only Brokers without Commission Setup
Broker List	This report provides a list of brokers and their basic employment data, if entered. Use this report as a reference list for the agency staff, or print it once a year, and verify the broker's data on file with your agency.	Broker	Brokers set up in the Broker Center.
Broker Receivable Activity	This reports shows you all financial activity for a Broker based on a selected date range.	Broker	Invoices, receipts, disbursements, and journal entries posted for the Broker's customers. To appear on the report an item must have an unpaid balance or have had activity within the date range selected.
Broker Statement	Print this report to send to the broker as a recap of the month's activity and show unpaid items.	Broker	Invoices, receipts, disbursements, and journal entries posted for the Broker's customers. To appear on the report an item must have an unpaid balance or have had activity within the date ranged selected.
Budget	This report allows you to review budget data entry and provides hard copy reports for budget comparison and analysis	N/A	Budget figures entered in the Financial Center.
Business Unit Setup	Use to review business units set up for your agency.	N/A	Division, Department, Group, and Branch setups entered in Agency Setup.
Cancellation	This report helps you identify carrier trends (companies non-renewing specific types of policies) or problem clientele (slow pay). The report gives you a quick review of how business was lost.	N/A	Policies that have the following transactions for the date ranged selected: Cancellation request (XLN) Cancellation confirmation (XLC)
Cash Disbursement Journal	Use to see a general ledger view of posted checks in date order by bank.	Bank	Posted checks from each bank.
Cash Receipt Journal	Use to see a general ledger view of posted receipts in date order by bank.	Bank	Posted cash receipts from each bank.
Certificate Holder	This report is a listing of all individuals and companies (names and addresses), for whom certificates were created. You can run this report at renewal and send to your insured for review. Your insured can then indicate any changes or additions needed for the renewal term.	Customer	Certificates and holders entered via eForms Manager.
Chart of Accounts	This report is a list of the active GL account numbers in AMS360. Print this report to have a reference copy of all account names and numbers. You can also preview the report on screen to lookup account numbers.	N/A	Chart of Accounts setup
Check Register	This report is a detailed list of checks and EFT's issued for a particular bank. Use the register for a listing of cash outflows by the day, week, or month	Bank	Posted checks and EFT's for each bank by date.
Checks	Use this report to print checks on pre-printed check stock. Checks are unique from other reports in AMS360 because the check must have magnetic ink micro coding for the bank scanners to identify the check. The micro coding on the check also contains the check number that is preprinted on the check.	Bank	Posted checks for each bank
Checks to Print/Review	This report displays posted checks that need to be printed as well as recurring checks available for review and posting, by bank account.	Bank	Posted checks not yet printed as well as recurring checks that are due for the selected day.
Claims Management	This report allows you to review loss history and loss ratios. The information can help you plan for future business decisions, such as loss control, risk management, or carrier/risk replacement. In addition, you can run a loss history schedule for a customer to submit with applications.	Customer	Claim information entered via Claims data entry as well as loss history entered in Customer Information.
Commission Payable Statement	Use this report to manage and report commission amounts due your employees and/or brokers. Only commissions posted to the General Ledger appear on this report; memo commissions are not included.	Broker Employee	Posted agency bill and direct bill transactions with broker or employee commission that creates a payable on the General Ledger.
Company Accounts Payable	Use this report to review what you owe the company.	Company	All invoices with an unpaid company payable balance.
Company Commission Setup	This report provides a list of commissions by company as defined in setup.	Company	Commissions entered in Company Setup.
Company List	This is a reference list of your Parent companies and their associated Writing companies.	Company	The following types of companies entered in Company Center: Brokerage Fee Finance Insurance companies you have setup.
Customer Aged Accounts Receivable	This report is used as a collection tool. It includes the amounts due your agency from your customers, by age of the invoice.	Customer	Agency bill invoices with open balances.
Customer List	This gives you a list of customers including many different criteria (e.g., customer type, status, representative, executive, business unit).	N/A	The following types of customers entered in Customer Center: Customer Information Active Inactive Customer Prospect Suspect Agency Broker
Customer Receivable Activity	This report shows all financial activity for a customer based on the date range selected.	Customer	Invoices, receipts, disbursements, and journal entries posted for the customer. To appear on the report an item must have an unpaid balance or have had activity within the date ranged selected.
Customer Statements	Summarizes all transactions from the customer receivable account This provides your customer the opportunity to reconcile their records with yours, and verify the amount still due your agency from the customer	Customer	Invoice postings which can include: Invoices with unpaid or non-zero balances for the selected date range. These items can include the following: Zero balance invoices Credit balance invoices Advanced payments on behalf of customer To appear on the report an item must have an unpaid balance or have had activity within the date ranged selected.
Daily Process	This report shows you the batch accounting tasks (invoices, recurring checks, recurring journal entries) associated with the Daily Process and the results of each.	Financial	Items that occurred during the daily process including the following: Future invoice/installment transactions posted during the daily process. These are items previously entered that are now within the number of days to bill in advance range Recurring checks with interval dates within the daily process period. Recurring journal entries with interval dates within the daily process period.
Deposit Slip	This report lists receipt transactions (cash, check, credit card and debit card) to accompany your deposit to the bank.	Bank	Posted receipt transactions included in a posted bank deposit.
Direct Bill Entry Statement	This displays the transactions entered on the selected Direct Bill Entry Statement(s).	Company	Based on your selection, information pulls from statements by company for the following: All In Progress Ready to Post Posted
Direct Bill Statement	The Direct Bill Statement Report assists you with reviewing and managing your direct bill business by providing a listing of direct bill entries recorded on AMS360.	Company	The following types of direct bill transactions flagged as Customer Center or Direct Bill Statement in the How Billed field of Transaction Premiums. Only items flagged as Customer Center must be billed to appear on the report.
Doc360 Management	Use the this report to monitor the size of files imported into your agency's database. You can also use the report to gather information about the amount of time lapsed between the point when a document is imported and when that document is processed in the system	N/A	The source information comes from Activity Attachments through Frontend, On Demand or Backend scanning.
Download Detail	Use to see the transactions in the download file that have been assigned to a customer and loaded into your database. If the transaction or some portion of it was not loaded, a message appears telling you why.	N/A	The name of the download company The name of the customer Policy number Policy term Line of business The policy effective date and Type of transaction downloaded. All items from a specific message or group file that are matched with a customer and run through process transactions to load into your AMS360 database.
Download Direct Bill Statement	This report lists all direct bill company statement transactions for a specific downloaded statement. Use to see the detail for your commission payment from the company.	Company	All transactions in the electronic direct bill statement that you have marked as accepted and processed into your AMS360 database.
Download Electronic Mail	This report is a listing of electronic mail messages from the company. Companies can send a list of policies that were downloaded and/or additional information they want you to know.	N/A	Carriers who have the capability of downloading email messages to AMS360.
Download Session Log	This reports on the success or failure of the download communication and file storage process, known as store transactions.	N/A	The information is a by-product download pickup, store, and process transactions.
Earned Premium	This report provides earned premium for policies in-force during the selected report date range. Both billed and unbilled policies are evaluated for reporting.	N/A	Earned premium is calculated by dividing the numbers of days elapsed for the policy transaction by the total number of days the transaction is in effect (the transaction term) and then multiplying the result by the total of entries in the Premium or Amount fields in the Transaction Premiums / Billing section of the policy form. Earned premium = (# days elapsed/total # days the transaction in effect) X (premium or amount fields in transaction premiums billing section of the policy)
Employee Commission Setup	This report provides the commission schedule for your employees.	Employee	Employee Setup
Employee List	This is a list of employees and their basic employment data. It is used by your Human Resource department or individuals in the agency with the same security rights as Human Resources.	Employee	Employee information entered in the Employee Center.
Evidence of Property Insurance	This report lists Additional Interests that have been issued evidence of property insurance forms. You can use this report as part of the renewal process.	N/A	Evidence of Property Insurance issued via eForms Manager to additional interests for the dates specified.
Expiration/Renewal	Use the Expiration/Renewal report to work your renewals to see a list of expiring, non-renewed policies for a selected date range.	N/A	This report uses the policy expiration date and the transaction from basic policy. Options for running the report include the following: Include all policies (renewed, rewritten and expired) based on the dates specified. Include only those policies that have not been renewed, rewritten or cancelled, based on the dates specified.
Finance Company Receivable Activity	Reports all financial activity for Finance Companies based on selected date range.	Company (Finance)	Data is pulled from premium financed policy transactions where the invoice is unpaid (non-zero balance) for the selected data range. Information used to create the report comes from the following areas: Finance Company Customer Information Policy Information Posted Invoices with premium financing Cash Receipts, Disbursements, and journal entries
Future Invoices	This report provides a means of projecting income from billed (customer center) policy transactions that have posted to receivables, but not income or not yet posted to the general ledger. You can use this report to determine agency income from advanced and future installments to comply with new GAAP (Generally accepted accounting principles) standards implemented in 2018. Click here to see the How To topic.	N/A	Posted and suspended invoices not yet assigned an invoice number based on the "Number of Days to Bill in Advance" as set up in agency setup.
General Journal	All posted journal entry transactions for a specific date range. appear on this report.	N/A	All posted journal entries for all or a specific general ledger number with subledgers, if applicable.
General Ledger	This is a list of general ledger transaction detail and account balances for a selected date range. It is used to audit posting activity for a particular account or to provide detail in support of your agency's financial statements.	N/A	Information on this report comes from financial activities performed throughout AMS360. including: Billing, including corrections Cash Receipts Cash Disbursements Journal Entries
Global Change for Personnel	This report provides information about the number of items processed or unable to be processed, and a detailed list of Processed Records and/or Exceptions for global personnel changes.	N/A	Processed records and/or exceptions of the changes requested are pulled based on the run date and the specific employee changes requested.
Income and Expense Statement	This reports your agency's income and expenses for selected time periods and indicates either a net profit or loss.	N/A	Information on this report comes from financial activities performed throughout AMS360. including: Billing, including corrections Cash Receipts Cash Disbursements Journal Entries
Invoice	Use to print invoices to send to your customers. Report selections include unprinted or previously printed invoices. You can also print a specific invoice or a range of invoices.	Customer Financial	Unprinted or previously printed invoices. Billings posted via customer center billing. Cash receipts, cash disbursements, and journal entries applied against an invoice also appear.
Merger, Acquisition & Conversion	Use this report to assist you if you are an existing AMS 360 agency who is acquiring or merging with an AfW or AMS360 agency. The report provides data for entering beginning general ledger and customer account balances as of the merger date.	N/A	Information sources include Agency billed invoices, Direct bill invoices entered via the Customer Center, and items entered via the Direct bill statement.
Notes	This report provides a list of notes, with details, entered for an employee, customer, policy, claim, bank, broker, company, or vendor. Notes may also include information about data migrated to AMS360 that did not correspond to an existing field within the product.	User Customer Bank Broker Company Employee Vendor	Notes entered for a specific employee; customer, policy, claim, bank, broker, company, vendor. Notes entered or migrated based on the selected criteria.
Open Invoices by Company	This report provides information about open invoices (that still have a customer receivable balance) for the selected company. Use this report as a collection tool as well as a to evaluate when to notify your customer that a policy will be canceled for non-payment.	Company	Net premium not yet paid to the company by customer and policy. Information sources include agency billed invoices, cash receipts, cash disbursements, and journal entries made for an invoice.
Open Vendor Invoices	Use as a cash management tool. This report provides information about vendor invoices with unpaid balances as of the report date.	Financial Vendor	Invoices entered in the Vendor Center.
Payment Receipt	Used primarily as a receipt for cash received from your insured. The payment receipt can be printed as part of the cash receipt process.	N/A	Customer Cash Receipts.
Policy Book of Business	This report provides details about the in-force book of business for your agency business units, companies, employees, brokers, and lines of business.	N/A	The source for this report is the Premium column of the Transaction Premiums section and the Amount column for the Transaction Fees, Taxes, Finance, & Down Payments section of the policy data entry form. For more detailed information see the Policy Book of Business Report topic.
Premium Advanced	This report assists you in identifying agency billed invoices that you have paid the net premium to the company, but which still have an unpaid balance from the insured.	Customer	Invoice and general ledger transaction detail at the customer and policy level. Outstanding invoice balance versus amount paid to carrier. Amounts from invoicing, cash receipts and cash disbursements for company payables are used to calculate the figures on this report.
Producer/Broker	This report details the following information: Billings posted in the Customer Center or the Direct Bill commission statement for the selected date range by producer or broker, How much commission payable for the producer/broker posted to the general ledger and how much posted as a memo commission. A summary section showing totals for new premium/non premium; agency commission and producer/broker commission with averages and a break out by transaction	Broker Employee	Agency bill invoices and direct bill commission statement transactions with producer or broker commissions included. The Producer/Broker report includes commission for memo and regular (commissioned) personnel.
Production Analysis	This report is used for multiple applications: Evaluate performance for companies, employees and customers. Gather statistics on the number of customers, invoices (work load) and volume by: Line of Business, Company, and Transaction. Establish goals using the comparison format. New Business Reporting. Retention Reporting.	N/A	Information sources for this report include agency bill and direct bill customer center invoices, direct bill entry, and direct bill statement transactions.
Receipt List	Print as a reference of receipts printed from AMS360. It can be helpful to have this information as evidence that a payment receipt was printed.	N/A	Printed invoice receipts from the Cash Receipts data entry form.
Receipts to Deposit	Review this report to see the receipts that have been entered in AMS360, but not yet included in a bank deposit.	Bank	The information source for this report are: Posted receipts not included in a deposit. Receipts on an open, but not yet posted deposit.
Recurring Checks	This report lists all Recurring Checks, active and expired in AMS360. Review this information to identify expired recurring checks that need to reactivated.	N/A	Recurring checks set up in each bank account.
Recurring Journal Entries	This report lists active and expired recurring journal entries that have been entered into AMS360. This information is helpful if you need to reactivate an expired journal entry.	N/A	Recurring journal entries set up via the Financial Center.
Revenue Recognition - Employee Benefits	This report helps you keep track of recognized revenue as it’s earned through the transfer of promised goods or services to customers.	N/A	The Information source for this report include the following: Bill Method Type of Business Lines of Business Business Unit
Revenue Recognition - P&C	The P&C revenue recognition report is now tailored to agency bill use cases where all revenue is considered 100% binding revenue, recognized when the policy becomes effective.	N/A	The Information source for this report include the following: Agency fees
Sales Journal	This is a general ledger view of posted sales (billing) transactions.	N/A	Information sources for this report include the following: Agency Bill Invoices Direct Bill Invoices Broker Commission Credit Commission Entry Invoices Commission Statement Invoices
Scheduled Report History	Use this report to see a snapshot of scheduled reports sent and to whom they were sent plus additional information. The information that appears on this report is limited by the user's security authorization.	N/A	The information source for this report is the Scheduled Reports feature of AMS360. Only reports generated using this feature are reported.
Scheduled Report Management	This report provides a way to manage your agency's Scheduled Reports. Use this report as a summary of reports currently set up for your agency and the details of the selections for each report.	N/A	The information source for this report is the Scheduled Reports feature of AMS360. Only reports generated using this feature are reported.
Scheduled Report Recipients	This report allows you to quickly identify the scheduled reports you are receiving and those reports for which you are the Primary or Backup Approver.	N/A	The information source for this report is the Scheduled Reports feature of AMS360. Only recipients attached to these reports are available for reporting.
Security Setup Report	This report returns information about your agency's system security setups	N/A	Security Group report lists all tasks on the Secured Item List. The report indicates the selected Employee Security Group's assigned level of access for each secured item. Bank Security report lists system information about the selected bank(s) as entered in Bank Setup, and optionally lists employee names authorized to use the bank. Employee Security report lists the following security information about the selected employee(s): Employee Security Group(s)assigned in Security Group Setup, authorized Banks in Bank Setup, and Business Units assigned in Employee Setup. Business Unit Security report lists the names of employees assigned to selected Business Units. Optionally, it includes Security Group assignment information for each employee on the list.
Service Agreement Report	You will have the ability to create a Service Agreement which may be associated with one or many policies, have service personnel commissions and multi-entity billing capability. In addition, you can invoice customers for consulting and other service fees.	N/A	Information for this report comes from the following areas of AMS360: Service Type Type of Business Transaction Business Unit Audit Date
Statement of Premium Trust	This report assists you in determining the amount of money to move between the trust and operating bank accounts.	N/A	Information for this report comes from the following areas of AMS360: Invoices Cash Disbursements against the invoices Cash Receipts for the invoices Late charges applied Monies received or paid by the agency Monies paid or received from the company Agency commission taken Agency fees taken Late charges taken Paid or received from the fee company
Submission Tracking	Use this report to see the progress of your submissions to carriers.	N/A	Activity and Suspense actions related to submissions.
Subsidiary Aged Ledger	This report provides an aged itemized list of specific AMS360 system accounts by subledger.	N/A	Information sources for this report can include the following based on your reporting criteria: Invoices Cash Receipts Cash Disbursements Journal Entries Total general ledger balance by customer, policy and, invoice number along withagingcategoriesbased on what you set up in Accounting Options in Agency Setup.
Subsidiary Ledger	This report provides an itemized list of entries for certain AMS360 system accounts by subledger.	N/A	Information sources for this report can include the following based on your reporting criteria: Invoices Cash Receipts Cash Disbursements Journal Entries Total general ledger balance by customer, policy and, invoice number
Summary of Insurance	This report allows you to create a summary of an insured's personal or commercial policies and/or submissions.	Customer	All or current in force policies and/or submissions for an insured.
Suspense	Use this report to view suspense items created by employees as personal reminders, center related suspense, or as follow up for customers.	Bank Broker Company customer Employee User Vendor	Suspense items created throughout AMS360, based on your reporting selections.
Transaction	This report gives you the tool to review transactions for specific policies, or to see a list of policies with a specific transaction.	N/A	The information for the report comes from the transaction entered in Basic Policy.
Trial Balance	This report is used to verify total debits equal total credits in the accounting system (accounts are "In Balance"). It can also be used to help detect errors in the financial system and as a review prior to running the Balance Sheet and Income and Expense Reports.	N/A	The information on the report is a total of general ledger transactions for each general ledger account on the Balance Sheet. Accounts with zero balances for the date range selected do not appear on the report.
Unbilled Policies	This report identifies Customer Center policy premium and non premium transactions not yet billed via the Customer Center.	N/A	Policy transactions that have premium entered in the transaction premium section of the policy, but have not been billed.
Unreplaced Binders	Use this report to identify policies billed using binder that have not been replaced.	N/A	Binder billings for the following: Binder New Business Binder Endorsement Binder Renewal
User Login	Use this report to show which employees should have their user login removed.	N/A	Users who have logged in for a selected period of time.
Vendor Invoice Payments	Use this report to review invoice payments to vendors	Financial Vendor	Posted payments (checks or EFT) to a vendor using the Vendor Payables feature in AMS360.
Vendor List	This report gives you a list of vendors entered in the Vendor Center.	Vendor	Vendors entered via the Vendor Center.
X-Date	This is a listing of expiration dates for policies you currently do not have for your customer. Use the report: Contact prospective customers. As a criteria in Target Lists so you can include these suspects/prospects in a campaign. Create a list of expiration dates by customer, or groups of customers, for special mailings.	N/A	This report includes only X-date information entered in Customer Information.