We have created a new type of XLS report which incorporates both job and financial information. This report is available under management > reports > finance > accounting report scheduling, to users who have purchased the accounting module. If you would like access to this new report please raise a support ticket.
The financial analysis report provides a break down of the jobs and any charges related to these on a month by month basis. Users can choose to group the financial data by ETA/ETD of the job or by the date each transaction is raised (ie. accounting date). The biggest highlight of this new report is the group by criteria. We have provided users with the ability to dissect both their financial and job data by a number of different factors. These include:
- Branch
- Department
- Direction
- Job Class
- Job Type
- Port Pair
- Responsible Person
- Sales Person
Similar to other reporting screens, users have the ability to schedule these financial reports to run on certain days and to specific users.
Through the report selection criteria, users can filter their results by date ranges and groupings as well as specify what they wish to see on the report. The below table summarizes these capabilities.
| Criteria Name | Description |
| Customer Code | Allows users to search by a specific customer. If a customer is entered, the results will be filtered to only show the selected customers data. If left blank, the report will show results for all customers in the system. Click on the zoom button in the customer code field to search for customers. |
| Reporting Date | This allows users to search by either:· ETA· ETD· Accounting Date |
| Date Selection | Allows user to specify what dates are displayed in the report. Users can choose either:· Calendar Year to Date· Financial Year to Date· Date Range
|
| Report By | This field allows users to specify how they wish to view their data. Users can group data by one of the following:· Branch· Department· Direction· Job Class· Job Type
· Port Pair · Responsible Person · Sales Person |
| Include Financial Information | This is a dropdown with the options: Yes and No.If set to yes, Revenue, Cost, Profit and custom liability information is shown within the report.If set to no, no financial data is displayed in the report. |
| Include Job Information | This is a dropdown with the options: Yes and No.If set to yes, Job count data is displayed in the report.If set to no, the report will only show financial data. |
Your report criteria is listed at the top of the report output. Within the output, the first column will list the group by criteria. The second column lists the categories that the data will be sorted by. The below table explains each of these in detail.
| Field Name | Description |
| Accrued Revenue | This represents the summed total amount for all unbilled and unposted debtors’ invoices lines, minus the invoice GST amounts and any Import Duty and GST. |
| Realised Revenue | This represents the summed total amount for all posted debtors’ charge lines, minus the invoice GST amounts and any Import Duty and GST. |
| Total Revenue | This is the summed total of both the accrued and realised revenue. |
| Accrued Cost | The summed total of any expected cost amounts against charge lines within the 2300 to 2800 General Ledger series where there is no paid or journal amount listed on the job financial screen.This column does not display if the expected cost system option is turned off. |
| Realised Cost | This represents the summed total amount of the paid column on the job financial screen. |
| Total Cost | This is the summed total of realised and accrued cost. |
| Accrued Profit | This is the calculated difference between accrued revenue and accrued cost. |
| Realised Profit | This is the calculated difference between realised revenue and accrued cost. |
| Total Profit | This is the summed total of accrued and realised profit. |
| Profit Margin | Total Profit divided by total revenue, represented as a decimal amount. |
| Custom Liabilities | This is the summed total of any import Duty and GST entered. |
|
Job Information |
|
| Job Count | This will list the total number of jobs that match the filter for each month |
| Job Volume (M3) | This will list the total volume listed against jobs that match the filter for each month |
| Job Weight (Kg) | This will list the total weight against jobs that match the filter for each month in Kgs. |
| Job Charge Weight (Kg) | This will list the total charge weight against airfreight jobs that match the filter for each month in Kgs. |
| Job Count: FF Only | This will list the total number of jobs that are freight forwarding only. |
| Job Count: CU Only | This will list the total number of jobs that are customs only. |
| Job Count: FF, CU & TR | This will list the total number of jobs that are freight forwarding, customs and transport |
| Job Count: FF & TR | This will list the total number of jobs that are freight forwarding and transport but not customs. |
| Job Count: CU & FF | This will list the total number of jobs that are freight forwarding and customs but not transport. |
| Job Count: CU & TR | This will list the total number of jobs that are customs and transport but not freight forwarding. |
| Job Count: TR Only | This will list the total number of jobs that are transport only. |
| Job Prepaid Count | This will list the total number of jobs where prepaid/collect dropdown is set to prepaid. |
| Job Collect Count | This will list the total number of jobs where prepaid/collect dropdown is set to collect. |
| No. of Dangerous Goods | This will list the total number of jobs that have been flagged as containing dangerous goods. |
| No. of Refrigerated | This will list the total number of jobs that have been flagged as needing refrigeration |
| No. of 20’s | This is the total number of 20 foot containers that have been listed against jobs. |
| No. of 40’s | This is the total number of 40 foot containers that have been listed against jobs. |
| No. of TEUs | This is the total number of twenty-foot equivalent containers that have been listed against jobs. |
The next couple of columns list the data available for the months selected. The final column on the report is the Totals column. This shows the summed data across the months displayed within the report.
