Reports
Reports are documents that
The types of reports included in the module are,
Jobs Report
Job Report furnishes the report which portrays the job related activities.
Reports are given based on the filters applied,
- Date
- Status { Pending / Cancel / Complete }
- Activity
- Services
- Customers
- Jobs
- Invoice Status
Center part of the page displays the Total Number of Jobs, Pending Jobs, Completed Jobs, Cancelled Jobs based on the filters applied.
It manifests the details related to jobs such as Customer, Build { Final Invoice }, UnBuild {Approved Cost Sheet not converted into Final Invoice }, Latest Status according to Job Status, Containers if have any along with the quantity, Date of Creation.
The Filtered data can be printed out using the Print button given next to Search Button. This prints the whole page of data.
The Video inserted below explains you the working of " Job Report " to have a better understanding
Invoice Report
Invoice Report and Sales Report are homogenous and Interchangeable.
Invoice Report furnishes the Sum of Each Invoice along with its Job , Income and Commission percentage given/allotted to Salesman.
Refer Sales --> Sales Report for the detailed functioning of the segment.
The Video inserted below explains you the working of " Invoice Report " to have a better understanding
Operation report
Operation reports typically refer to documents or summaries that provide detailed information about the activities, performance, and outcomes of specific operations
Operations reports are classified into:
Daily Report
Subsegments of Daily report are as follows.
Daily Report has the list of jobs under the import and export section on a daily basis.
Report has AWB / Bill of Lading , Vessel Number and Container details along with the respective jobs.
Based on the Activity Code { import / export }, ETD, ETA selected during the job creation, jobs are segregated under three different sections namely Book, Intransit and Arrived .
Based on the Activity Code Selected the jobs are segregated among import and export sections.
- Import / Export :
-
Import / Export has different sections in the same page based on the number of days between ETA and ETD.
E.g If there are multiple jobs with 10 - 20 days , 20 - 40 days and more than 60 days as their time period, then the jobs are grouped based on the time period in both import and export sections.
The Types of Services involved in a particular job are indicted along with the JobNo.
- Intransit
-
Intransit has a list of jobs which is in motion. Based on the ETD/ETA given, the jobs are moved to the Intransit section which includes both Import and Export.
Import and Export Status is segregated based on the activity code selected.
- Arrived
- Arrived has a list of imported and exported Jobs based on ATA/ATD
This has two segments based on the job which is completed or not completed yet.
- Not Completed
- Complete
Status Report
Status Report furnishes the status of the consignmens along with the posting date of the respective job.
It shows the activity code, Last Status of the consignment updated, ETD and ETA of the selected job / Customer.
The List of jobs are fetched based on the filters applied.Filters Include,
- Date Filter
- Type of Activity
- Status of the Job
- Customers
- Jobs
Click Search once the filters are applied. The Selected List can be Print with the Feature Available next to Search.
Actions Performed
Right Clicking on the Column provides the below,
Status : An Email can be sent to the customer regarding the current status by choosing the parameters like Service Type, Posting Date, Status Category and Default Content (which needs to be conveyed).
Edit
The Video inserted below explains you the working of " Status Report " to have a better understanding
Clearance Report
Clearance Report furnishes the data related to Custom Clearance. This gives the Date of Clearance, Bayan No, Bayan Date, Deliver Order No and Date in respect to the job and customer.
The list is specified based on the following filters,
- From and To Date
- Type of Activity
- Status of the Job
Click Search to apply the filters selected over the Jobs / Customers.
The Video inserted below explains you the working of " Clearance Report " to have a better understanding
Freight Report
Subsegments of Freight report are as follows.
- Package Report
- Container Report
- Terminal Report
- Pullout Report
- Port in Report
- Location In Port report
Package Report
Package Reportprovides you the review of the packages associated with the Jobs.
Report Serves the details such as Job No, Customer, Activity Code, Type and Quantity, Total weight and Remarks etc
Use the following filters to fetch the required data,
- Periods
- Date Filter
- Customers
- Status of Job
- Job
- Activity Code
Click Search to Proceed.
Container Report
Container Report provides you the review of the containers associated with the Jobs.
Report Serves the details such as Container No, Terminal, Size and Type of the Container, type of Shipment (Dangerous / Non Dangerous), Volume , Tare weight and Remarks.
Use the following filters to fetch the required data,
- Date Filter
- Terminal
- Status of Job
- Container Size and Container Type.
Click Search to Proceed.
The Video inserted below explains you the working of " Container Report " to have a better understanding
Terminal Report
Terminal Report Serves the attributes of the Terminal section wherein the details of Consignment arrival can be viewed.
Report Provides details such as Consignee, Estimated Time of Consignment Arrival, Delivery Date (Actual) in respect to the Job.
Available Filters to Sort data are,
- Date Filter
- Type of Activity
- Type
- Status of the Job.
Click Search to Proceed.
The Video inserted below explains you the working of " Terminal Report " to have a better understanding
Pullout Report
Pull out Report shows the following data based on the filter selected,
- Terminal
- Container Size
- Container Type
- Add Periods
- Date Filter
- Customers
- Job
- Status
Select Search to Proceed.
Report displays the particulars of a container such as Container No, Job, Terminal, Customer , Size , Type , Seal No, Weight, Tare Weight and VGM based on the terminal and container features selected.
Port in Report
Port in Report shows the following data based on the filter selected,
- Periods
- Date Filter
- Customers
- Job
- Status
Report displays detailed information about shipments arriving at port.
Location in port Report
This Report provides you the review of the Location in port associated with the Jobs.
Report Serves the details such as Customer, Job, bayan no, commodity, location in port, Job status and ETA.
Use the following filters to fetch the required data,
- Periods
- Date Filter
- Customers
- Job
- Status
- Type
Click Search to Proceed.
Operation Reports
Subsegments of Operation Reports are as follows.
Description Report
Description Report exhibits the list of data based on the description selected.
Also, based on the Type { Normal / Cost Sheet } Selected multiple sections of data can be displayed.
Normal Type
Normal Type has SI(Supplier Invoice), PV (Payment Voucher), TC(Terminal Cost), MR (Material Request), TA(Truck Allocation), CD(Container Deposit) , Total Sales and Income in regards to the description Selected.
Clicking on the column gives you the list of invoices involved to that particular description and the same can be taken a print out / Simply Viewed
Cost Sheet
Cost Sheet section displays the Income earned vs Cost Sales and Net Sales.
Clicking upon the column displays the list of Cost Sheets that the selected Description holds. The invoice can be viewed and Print out can be taken from the feature given along with each cost sheet.
Dispatch Report
Dispatch Report furnishes the invoices that are being dispatched along with the medium of dispatch.
It Provides attributes such as Customer , the medium of Invoice Dispatch , Employee who is carrying the Invoice (if the Medium/ Mode is Direct , Number of Invoices, Job Posting date and the one who creates the Job.
Filters Available to Segregate data are,
- Date Filter
- Customer
- Method of Dispatch
- Invoice Carried By
Select Search to proceed.
Actions Performed
Double Clicking on the row no exhibits the dispatched invoice associated with it in a pop up window.
Invoice Details displayed in the pop up window are Job Number , Currency, Customer , Amount along with Tax.
The Invoice can be printed with the help of Print Button Available along with the basic invoice details.
Advanced Features : (Common to All Reports)
Non Numerical Data can be sorted in alphabetical order and Numerical data can be sorted in ascending order.
Press the Double Directed Arrow available next to every column to sort the data displayed.
Actions Button available next to search has options like Print, Export as Excel, Download PDF, Send Email.
The Video inserted below explains you the working of " Dispatch Report " to have a better understanding
Job balance report
AJob Balance Report typically refers to a document or record that presents information about the supplier invoice and final invoice, showcasing the difference between the two for clear understanding.
It Provides attributes such as Customer , the medium of Invoice Dispatch , Employee who is carrying the Invoice (if the Medium/ Mode is Direct , Number of Invoices, Job Posting date and the one who creates the Job.
Use the following filters to fetch the required data,
- Periods
- Date Filter
- POL & POD
- Activity Code
- Voucher Date Filter
- Job
Click Search to proceed.
Job income report
A Job Income Report typically refers to a document or feature that provides a detailed overview of the income generated from specific jobs or shipments handled by the freight forwarding company.
Use the following filters to fetch the required data,
- Periods
- Date Filter
- Voucher Date Filter
- Status
- Customers
- Job
Click Search to proceed.
Finance Reports
A finance reportin freight forwarding software typically refers to a document or feature that provides comprehensive financial insights and analysis related to the operations of a freight forwarding company.
Finance reports are classified into:
Accounts
Subsegments of Accounts are as follows.
- Ledger Account Balance
- Banking
- DayBook
- General Ledger
Ledger Account Balance
Summary of all the accounts with an opening balance, transactions and closing balance.
Use the following filters to fetch the required data,
- Periods
- Date Filter
- Account No
Banking
A graphical representation of all listed bank and cash with their balance.
Use the following filters to fetch the required data,
- Periods
- Date Filter
DayBook
Day book typically refers to a daily transaction log or journal that records all financial transactions and activities within the freight forwarding operation for a specific day.
Cash book, Daybook and Ledger can be exported from here.
Business
Subsegments of Business are as follows.
- Balance sheet
- Financial income statement
- Operational Income statement
- Trial Balance
- Trial Balance detailed
Balance sheet
The balance sheet is a financial statement that summarises the company's financial position for a specified period. It presents a summary of the balances in all the accounts in a company's accounting system categorised into assets, liabilities, and equity.
Use the following filters to fetch the required data,
- Periods
- Date Filter
- Type
- Select Branch
Financial income statement
The report displays the Sales,Cost of Sales,Operating Income,Operating Expense,Other Income,Financial Revenue,Non Operating Expense and Financial Expense for the selected period.
Operational Income statement
The report displays the Sales,Cost of Sales,Operating Income,Operating Expense,Other Income,Financial Revenue,Non Operating Expense and Financial Expense for the selected period.
When Book Income is allocated to a specific job, you can view the transactions associated with that particular job within this section.
Trial Balance
A trial balance report is a financial statement that summarizes the balances of all accounts in a company's accounting system. It lists the total debit and credit entries for each account, providing a quick overview of the company's financial position.
Use the following filters to fetch the required data,
- Periods
- To Date
- Select Branch
Trial Balance detailed
Trial balance detailed typically refers to a detailed summary of all the accounts in the company's general ledger and their respective balances
Use the following filters to fetch the required data,
- Periods
- From Date
- To Date
- Select Branch
Opening Balance, Period Transactions, Closing Balance will be displayed for the selected date filter.
Tax Report
Tax Report furnishes the report which portrays the tax related activities.
Reports are given based on the filters applied,
- Periods
- Date Filter
- Type
- Supplier
- Status
Center part of the page displays the Total invoices, Total vouchers, Total amount, Total tax and specific types of taxes chosen, all contingent on the applied filters.
Receivables Report
Subsegments of Receivables are as follows.
- Customer Balance
- Customer Balance Summary
- Ageing Report
- Ageing Detailed Report
- Statements
- Movements
Customer Balance
Customer balance report includes the complete list of customers along with the invoices issued, funds received, and current balance.
Use the following filters to fetch the required data,
- Customer
- Periods
- Date Filter
Customer, Invoice Balance, Available Balance, Closing Balance will be displayed for the selected date filter.
Customer Balance Summary
This report will display the current balance of each customer along with transaction details.
Use the following filters to fetch the required data,
- Customer
- Periods
- Date Filter
Customer, Net Credit, Net Debit will be displayed for the selected date filter.
Aging Report
Aging report holds the details of invoices that are unpaid, it could have exceeded the due date or have time to pay the due.
The details are listed based on the report selected,
- Report Date
- It Specifies the period till when the report needs to be fetched.
- Interval
- Based On Invoice Date: Report will be based on Invoice Date
- Due Date: Report will be based on Due Date
Interval Field Concludes the number of sections/intervals to be fetched in terms of 30 days
Possibilities of Selection
- Possibility 1
- Customer --> Select All Customers , then you will get a detailed report of each and every customer as a list.
- Possibility 2
- Customer --> Select Particular Customer then you will get a detailed report with respect to the selected customer.
NOTE: Click on Invoice count to view the details of pending invoices in respect to the customers (period wise).
Click on the Invoice amount, to navigate to the Ageing Details.
Ageing Detailed Report
In the Ageing Details tab, you can view the detailed information of the Ageing Report.
Use the following filters to fetch the required data,
- Customer
- Periods
- Date Filter
Invoice Date: Report will be based on Invoice Date
Due Date: Report will be based on Due Date
Customer Statement
Customer Statement Provides you the list of financial transactions happened. Multiple filters are available to fine tune your data.
Firstly you need to select the customer whose data are to be reviewed or analysed.
Secondly you need to choose either filter through date or Currency. After applying the filters Select the type of statement you wish to observe.
- Balance Statement
- Ledger Statement
- Advance Transactions
- Balance Statement
- Statement has list of Unpaid Entries respective to the customer
- Advance Transactions
- List of Paid entries can be observed here.
- Ledger Statement
- Ledger furnishes all paid and unpaid entries in respect with the customer selected.
- Credit / Debit : Enable / Disable the option to include this as one of the columns in the statement
NOTE: If you do not match your Invoice while creating Voucher, the data will be reflected in both Statement and Ledger.
Default Columns displayed in the statements are Voucher type, Voucher No, Invoice / Ref No, Client Reference, Cheque No, Job No, Voucher Date, Currency , Amount, Local Amount, Open Amount , Balance.
If you want additional columns to be displayed on the statement, do the following steps.
Select Actions Button and click on Customize column and select the required columns to be displayed which will get automatically reflected while printing the document.
If a customer has invoices in two different currencies, like SAR and USD, you can choose either SAR or USD from the Currency Exchange Rate dropdown, and the statement will be displayed in the selected currency.
If a customer has invoices in more than two different currencies, such as SAR, USD, and EURO, you can take statement only in SAR.
If foreign currency is selected from the currency exchange rate dropdown,Summary will not be available
Advanced Options
BridgeLCS has given you certain features which ease your work and save your time.In the Actions section you have choices for Print,Download pdf and Send mail.
Apart from the print option available separately , you can double click on the voucher number to get a document to be printed.
Search can be done from any of the fields available. Search is not restricted to a single search column.
Payables
Subsegments of Payables are as follows.
- Supplier Balance
- Supplier Balance Summary
- Ageing Report
- Ageing Detailed Report
- Statements
- Movements
Supplier Balance
Supplier balance report includes the complete list of supplier along with the invoices issued, funds paid, and current balance.
Use the following filters to fetch the required data,
- Supplier
- Periods
- Date Filter
Supplier, Bill Balance, Advance payment, Closing Balance will be displayed for the selected date filter.
Supplier Balance Summary
This report will display the current balance of each supplier along with transaction details.
Use the following filters to fetch the required data,
- Supplier
- Periods
- Date Filter
Supplier, Net Credit, Net Debit will be displayed for the selected date filter.
Ageing Report
Aging report holds the details of invoices that are unpaid, it could have exceeded the due date or have time to pay the due.
The details are listed based on the report selected,
- Report Date
- Aging report holds the details of invoices that are unpaid, it could have exceeded the due date or have time to pay the due.
- The details are listed based on the report selected,
- Report Date
- It Specifies the period till when the report needs to be fetched.
- Interval
- Number of Sections based on a period of 30 days will be decided by Interval.
- Based On Invoice Date
- Report will be based on Invoice Date
- Based On Due Date
- Report will be based on Due Date
Possibilities of Selection
- Possibility 1
- Supplier --> Select “All Suppliers” , then you will get a detailed report of each and every supplier as a list.
- Possibility 2
- Supplier --> Select Particular Supplier,then you will get a detailed report with respect to the selected supplier.
NOTE: Click on Invoice count to view the details of invoices in respect to the suppliers (period wise) . Click on the Invoice amount, to navigate to the Ageing Details.
Ageing Detailed Report
In the Ageing Details tab, you can view the detailed information of the Ageing Report.
Use the following filters to fetch the required data,
- Supplier
- Periods
- Date Filter
Invoice Date: Report will be based on Invoice Date
Due Date: Report will be based on Due Date
Statements
Supplier Statement Provides you the list of financial transactions happened. Multiple filters are available to fine tune your data.
Firstly you need to select the Supplier whose data are to be reviewed or analysed.
Secondly you need to choose either filter through date or Currency. After applying the filters Select the type of statement you wish to observe.
This falls under three categories :
- Balance Statement
- Advance Transactions
- Ledger Statement
- Balance Statement :
- Statement has list of Unpaid Entries respective to the Supplier.
- Advance Transactions :
- List of Paid entries can be observed here.
- Ledger Statement :
- Ledger furnishes all paid and unpaid entries in respect with the Supplier selected.
- Credit / Debit :
- Enable / Disable the option to include this as one of the columns in the statement .
NOTE: If you do not match your Invoice while creating Voucher, the data will be reflected in both Balance Statement and Advance Transactions.
Default Columns displayed in the statements are Voucher type, Voucher No, Invoice / Ref No, Client Reference, Cheque No, Job No, Voucher Date, Currency , Amount, Local Amount, Open Amount , Balance.
Ageing Detailed Report
Bridge LCS has given you certain features which ease your work and save your time. You can directly send email to your suppliers with ONE CLICK.
Within the Actions category, you can opt for Print, Generate a PDF and Send Email.
Moreover, within the Export As feature, you have the option to copy and export the data in both CSV and Excel formats
Smooth way to create Memo is double click on the Reference Number, a pop up window will appear wherein you can create notes and set a reminder.
Effortless way provided to upload document. Double click on the invoice number to get a document to be printed.
double click on the voucher number to get a document to be printed.
Search can be done from any of the fields available. Search is not restricted to a single search column.
Employee
Subsegments of Employee are as follows.
- Ledger
- Statement
Ledger
This report include the comprehensive list of employees, detailing their paid salaries, outstanding loans, and current balances.
Use the following filters to fetch the required data,
- Employee
- Periods
- Date Filter
Employee, Payable salary, Loan Advance, Closing Balance will be displayed for the selected date filter.
Statement
This falls under three categories :
- Loan
- Ledger Statement
- Loan
- Loan has a set of employees who have got Advance Salary / loan in prior which can be deducted from their monthly salary.
- Ledger Statement
- Statement has a list of employees whose salary / loan is yet to be paid.
Credit / Debit : Enable / Disable the option to include this as one of the columns in the statement
Use the following filters to fetch the required data,
- Employee
- Periods
- Date Filter
Partner
Overall statement of the customer who is also a supplier or supplier who is also customer. This falls under three categories :
- Balance Statement
- Advance Transactions
- Ledger Statement
- Balance Statement :
- Statement has list of Unpaid Entries respective to the Partner.
- Advance Transactions :
- List of Paid entries can be observed here.
- Ledger Statement :
- Ledger furnishes all paid and unpaid entries.
- Credit / Debit :
- Enable / Disable the option to include this as one of the columns in the statement .
