Job Analysis Reports

Job Account Analysis

This s a report that groups income accounts and expense accounts, based on a column definition done by accounting prior to running the report. This is done in this way, since there are so many accounts, the report could not show the amounts per job for every single account. There are different columns in both the income section and the expense section which correspond to the definition.

The report shows the job number, ports, bill of lading numbers and totals for income and expenses

Job Analysis Report

This report shows list or invoices per charge or per account, depending of the selected option. It can be run for one job or you can select many jobs at the same time.. It displays the invoice number, the amount involved and the accounting period. It shows totals per charge\account. This would be a good report to analyze revenue or expenses for a specific job

It has many report options, such as include or exclude un-posted items, include a specific department or run the report for all payable departments

Job salesman analysis

For a specific accounting period, this report shows the operating and net profit based on the total income and total expense by job number. It also shows ports, bill of lading number and client’s name

Brokerage Commission

Outputs brokerage commissions by job, port pair, and B/L. Details reported include forwarder, commissionable charges, grouped by containers and LCL, the percentage used to calculate the commission, and the amount of commission calculated. Also reported is the A/P invoice number, if ISIS is setup to automatically create the invoices upon posting the B/L. This report will display the information based on the freight forwarder commission rules

Agency commission

Outputs agency commissions by job, port pair, and B/L. Details reported include commissionable charges, grouped by prepaid, collect, and total, and the amount of commission calculated. This amount is based on existing rating defaults set up in ISIS. (See Traffic, Rating Defaults section more info). Each Port of Load is subtotaled and the entire job is totaled at the end of the report.

Hold Papers Report

This report is used as a guideline for personnel upon releasing original B/L’s to the customer. The report outputs a list of customers who, for a number of reasons, could be defaulting on previous invoices. Some criteria include reaching or exceeding their credit limit, having open invoices over 45 days old (or other number of days as selected), or having put on hold by accounting personnel. These are guidelines only and will in now way hinder the user from printing and releasing documents to the customer.

Insurance Payable report

This report is used for those ISIS installations that offer insurance to the customers. Based on rating defaults (tariff), the report calculates the amount billed to the customer and the amount payable to the insurance vendor. The report outputs, by B/L, the shipper and consignee, the invoice value, the insurance percentage rate used, the coverage amount, and the amount due. If set up to automatically create payable invoices to the insurance vendor, the report will display the payable invoice number and amount open. Can be used as backup for manually created lump sum payable invoices to the insurance vendor. To run, select the job, port of load (or all ports), and port of discharge (or all ports). Select ‘Y’ to print B/L on report if no insurance, or ‘N’ to exclude it. Select printer.

Summary by charge

This report outputs a list of B/L’s showing the customer, invoice number, and amount billed for the selected charge. It will also show a related payable invoice if one was created. Options exist to show the forwarder, and the TIR or D/R information (number, container number, pieces, etc). To run, select job number, port of load (or all ports), port of discharge (or all ports), port of final destination (or all ports), B/L number (or all B/L’s), and charge name. Select the corresponding options to show forwarder and TIR or D/R information. Define whether you want to include un-posted items.

Line Payable Detail

Report used for those ISIS installations where the company is an agency who automatically creates payables to the line for all B/L charges in relation to the receivable invoices created to the customer. The report outputs a long list of details to include, by B/L, the A/P control number, related A/R number, customer billed to, amount billed, collected, and the balance, un-remitted, check number, and date paid. The report totals by port, by job, and report total. Select line number, or from job and to job, depending on whether excluding zero balance invoices.

Container Revenue by job

This report is the perfect report to analyze revenue per container. The analysis can be made by job number or for a range of dates.

It shows container number, container type, revenue, weight, bill of lading, shipper, and consignee. All this information can be customized by going into view\select field, and select the desired columns. The data is based on job\ports selected. The analysis can be made for a specific company acting as one of the parties (shipper/forwarder/.consignee/notify) in the bill of lading and/or by charge

Container Count

This is a view of containers per job/ports combination or for a specific range of dates. It shows quantity of containers, revenue, weight and its information can be exported to excel.

Revenue Analysis

This report/grid is one of the best analysis tools. Its structure allows analysis by ports, customers, charges, container, job number, equipment type. It shows total revenue, total TEU’s total weight and measurement. This information can be exported to excel