In this release, Expedient will allow users to set up EDI interfacing by themselves to load the eCommerce manifest file into Expedient by email or SFTP. Users are allowed to select any Load manifest Line air/sea load template to set up EDI Configuration. Location: Forwarding -> eCommerce -> Import -> Load Manifest Lines (Air) Forwarding […]
Accounting
Accounting
Release 27/09/23 – Spot Quotes – Auto-Rating
In this release, we have enhanced the Spot Quote screen’s capabilities to now allow auto-rating. (Spot Quote screen location: Rates -> Spot Quote) Auto-Rating will work the same way the Job Registration screens currently do, matching against the criteria entered in the Customer Rates, Company Tariff and Cost Tariff screens. Ao Auto-Rate against a Spot […]
Release 30/08/23 – Foreign Contra screen – Bank Fees
In this release, we have enhanced the Foreign Contra screen to now allow the easy adding of Bank Fees. The Foreign Contra screen has a new button in the toolbar called ‘Bank Fees’. Selecting this button will allow users to include a bank fee in their Payment/Receipt, by automatically creating a GL Creditors Invoice using […]
Release 30/08/23 – Foreign Contra Cosmetic Updates
In this release, the Foreign Contra screen has had some cosmetics changes to help make this screen clearer and easier to use. Firstly, some fields names have been changed to reflect the type of transaction: Receiving or Paying Out. If the transaction is a Receipt: Bank Details will become ‘Receiving Bank Details’ Bank Amount will […]
Release 02/08/2023 – Creditor Payments – Bank Fees
In this release, we have enhanced the Creditor Payments screen to now allow the easy adding of Bank Fees. Selecting the new ‘Bank Fees’ button in the toolbar will allow users to include a bank fee in their Creditor Payment, by automatically creating a GL Creditors Invoice using the details applied in the new Bank […]
Release 06/07/23 – Payment and Receipt Reversals
In this release, we are introducing a new reversal process for Payments and Receipts. This update aims to reduce the manual work currently required to reverse transactions while also enhancing the useful information available in these screens. The reversal button will be available in the following screens: Payments Enquiry (Finance -> Banking -> Enquiry -> […]
Release 15/02/23 – Spot Quotes – Charges Order Customizable
In this release, we have updated the Spot Quotes’ (Rates->Spot Quote) charges tab, to allow users to customize the order of their charges. They can do this through the 2 new buttons ‘Move Up <CTRL-Up>’ and ‘Move Down <CTRL-Down>’ . In UPDATE mode, users can see the ‘Move Up <CTRL-Up>’ and ‘Move Down <CTRL-Down>’ buttons […]
Release 15/02/23 – Spot Quotes – Update Quote Printing Options
In this release, we have update the Spot Quote screen’s (Rates -> Spot Quote) functionality to allow users to print the quote in new formats with new additions. Users can access these Printing Options by selecting either the ‘Print Draft Quote’ button or ‘Print Final Quote’ button at the top of the Spot Quote screen. […]
Sub Revenue Codes
This screen allows the addition, update and viewing of Sub Revenue Codes. Use the Maintain Sub Revenue Codes button in the toolbar of the General Ledger > Chart of Accounts screen. Please Note: Once you have added a code to the Chart of Accounts Screen, users will need to add a corresponding Alpha Code in […]
Chart of Accounts
This screen holds the Chart of Accounts Masterfile. The screen is found in General Ledger > Chart of Accounts. The Account Codes are numerical. The structure and headings of accounts should assist in consistent posting of transactions. Each nominal ledger account is unique to allow its ledger to be located. The list is typically arranged […]
Check for all Postings
This function gives the user a snapshot of any postings that have not been performed across the system. This option is found in General Ledger > Check for all Postings
Post General Ledger – All Months
This function is used for reporting purposes only. It updates all of the data to be current and up to date for the viewing of: Debtors Aged Trial Balance Creditors Aged Trial Balance General Ledger Aged Trial Balance Profit and Loss Balance Sheet Bank reconciliation This option is found in General Ledger > Post Gen. Ledger all […]
Accounting Periods
Accounting Periods are used to ‘close off’ financial transactions to gain a picture of the overall financial status of the company at the end of any given period. Accounting Periods are utilised in the following areas of the system: Bank Reconciliation Profit Reporting / End of Period Reports User warning when entering invoices in a […]
Print IATA Reconciliation
This report allows users to reconcile the IATA related job costs in Expedient with what IATA CASS is billing you. This option is found in Creditors > Reports > Print IATA Reconciliation
ATB – Detailed Report
This report outlines a list of creditors accounts with aged balances for a specific period, which is nominated by the user, using the below parameters. This report is found in Creditors > Reports > ATB Detailed New Page Per Creditor? If YES – 1 Creditor will be displayed per page. If NO – The report […]
Load CASS IATA File
Loading the CASS IATA file allows users to reconcile the costs. This screen is found in Creditors > Load CASS IATA File
Modifying Creditors Invoices
This is a search screen allowing you to find invoices by any fields in the screen. Once found click Update and make the required change to the invoice on the screen. The Invoice Number, Due Date and Invoice Date can be amended. This screen is found in Creditors > Modify Creditors Invoice
Posting Creditors Add On / Write Off
This process posts the information to the General Ledger and the data in this screen will be cleared. This is found in Creditors > Post Add On / Write Offs
Create a Creditor Add On/Write Off
An Add On is where you have overpaid by a small amount and you wish to balance the general ledger. A Write off is where you have short paid by a small amount and you wish to balance the general ledger. This option is found in Creditors > Creditor Add On / Write Offs Creating […]
Posting General Ledger Invoices
This process posts the invoice information to the General Ledger and the data in this screen will be cleared. This option is found in Creditors > Post G/L Creditor Invoices
General Ledger Creditor Invoices
When you have money to pay out that is not job related, i.e. stationary, you can input the Creditors Invoice which goes directly into the General Ledger bypassing the Job Creditors process. Find this screen in Creditors > G/L Creditor Invoices By clicking the ADD button or typing A will place the cursor in the input […]
Posting Job Creditor Invoices
This process posts the Creditor’s Invoice information to the General Ledger and the data in this screen will be cleared. The option to Post is found in Creditors > Post Job Creditor Invoices To view this invoice after it has been posted, go to Enquiry Only > Creditor Invoices
Creating a Job Creditors Invoice
In order to process payments you firstly need to create a Creditor’s Invoice. This is done in the Creditors > Job Creditors Invoices screen This screen is designed to display all of the current Creditors Invoices that have yet to be posted to the General Ledger. By clicking the Add button or typing A will place the […]
Cash Payment Process
The below diagram highlights all of the possible scenarios of processing payments and the various processes in Expedient that take place to do so. Note: The red Text boxes are Expedient Menu items that you need to use to perform the various functions. Cash Payment Scenarios 1. Receive Invoice, hardcopy or electronically from Creditor to […]
Creditors Overview
Debtors
Q: Customer has paid invoice twice, and a refund is required A: Step 1 Go To Debtors > Add-on / Write-Offs Enter Date and Client Code Leave Invoice No Blank In the Detail Lines Section enter the GL code for Contra/Suspense Account Department = 000 Enter amount as a MINUS that you wish to remit […]
Batch Send EOM Statements
The option allows you to send Statements to Debtors in a single batched process. This option is found in End of Month Reports > Batch Send EOM Statements. This option will appear where your site has the Batch Send functionality. Before emailing the statements run the Debtors Aged Trial Balance Summary Report from this screen […]
End of Month Statements
The option in End of Period Reports > Print Statements is used when you wish to run statements for customers as at the end of a particular month. In order to perform this, users must first run the End of Period Reports > Prepare Debtors, which prepares the statement amounts for each Debtor. Information in the […]
Statements (as at today)
This Statement option prints clients’ statements and the amount they owe as at the date of printing. The Statements (as at today) options is available with the Debtors folder. The below report selection criteria only allows users to enter: Trading AS (this will not be displayed if no Trading As is set up) Branch Code […]
Reinstate Cash Receipts
This function is used when a user has paid off an incorrect invoice in FULL or the customer has paid an invoice twice. Use this function in conjunction with the Banking > Cash Receipts – Debtors. The Reinstate Cash Receipts option is found in the Debtors folder. The screen prompts the user immediately for the […]
Posting Add On / Write Offs
This process posts the information to the General Ledger and the data in this screen will be cleared. This is option is found in the Debtors Menu.
Create a Debtor Add On/Write Off
An Add On is where a client has overpaid by a small amount and you wish to balance the general ledger. A Write off is where a customer has short paid by a small amount and you wish to stop sending them statements for the small amount and wish to balance the general ledger. A write-off […]
Posting Manual Invoices
This process posts the invoice information to the General Ledger and the data in the Manual Invoice screen will be cleared. This option is found in the Debtors folder
Manual Invoices
Expedient allows you to create invoices that are non-job related such as stationary, receiving rent from other tenants etc The Manual Invoice screen is found in the Debtors folder. By clicking the ADD button or typing A will place the cursor in the input screen in Add Mode. Field Name Description Validation Default Header […]
Posting Job Invoices
This process posts the invoice information to the General Ledger and the data in the Job Invoice screen will be cleared. This is found in Debtors > Post Invoices. To view this invoice after it has been posted, go to Enquiry Only >Debtors Invoices
Duty Breakdown
The Duty Breakdown will be shown on the Debtors Invoice under the following conditions: If System Option INVDUTYBRKDN is turned on If the Duty Charge Code has been entered on the Debtors Invoice The Duty Breakdown will include the following; Total Duty Total GST Other Charges Total Wet Total Dumping Duty Countervailing Duty Total Luxury […]
Auto-populate Duty Amount
If the EFT Receipt has not been received from Customs and the Duty Charge Code is entered in the Debtors Invoice, then the Total Amount will auto-populate based on the following conditions: Entry Status = CLEAR, ATD FINALISED or FINALISED EDI Status is not W (Withdrawn) or P (Prelodge) Owner EFT = NO If the […]
Send Debtor Invoices by EDI
Invoices can be sent to the Debtor as a CSV file which can be uploaded into the Debtor’s systems. Set the Debtor to receive invoices by EDI in the Customer Masterfile Debtor tab. The toolbar button Send EDI Invoice will then appear. Select this button to generate the CSV file and email to selected email […]
Printing Options
Print Invoice Attachment This is set within the Debtors Tab in the Customer Masterfile. This allows invoices to be printed with an attachment page if the number of Containers Numbers or Order Numbers cannot fit on the Invoice Print. The limit is 9 Containers / Orders. If the System Option POSTINVONPRT is turned on, then […]
Print a Debtors Invoice
Once you are ready to save the invoice, you can do so by Clicking OK or Pressing Enter. You can print the invoice via the Print toolbar button Sample Invoice print OPlease note: Once you have printed the Invoice you cannot update or delete the Invoice. If you wish to make a change or […]
All-In Charges
Invoices can be set to print an all-inclusive charge on Export Invoices. For example, a debtor can receive an invoice for an export job where all the individual charge lines are summed and displayed against a single freight charge. All-In Charges Set Up Update the Client Masterfile, Debtor tab. Set the Export All-In Charges (non […]
Creating a Job Invoice
The purpose of creating Job Invoices is to bill your client’s money for which you have supplied services to them. Some of these items will be that of passing on a direct cost like Customs Duty or direct profit such as Agency and Attendance. You can create an invoice for the Job from the Job […]
Accounting – Overview
Add IATA Costs
The Job/Consol Creditors screen can be used for any creditor that you owe money for. When accessed from the Options menu in the Air Export Consol Registration screen and the creditor is CASS IATA the Freight for the Consol will be apportioned to all the House Bills on the Master based on weight. To view the breakdown per […]
Prepare Customs EFT Payment
Once the Data is loaded from the Load EFT File menu option, it is possible to automatically add this data into the Disbursement Cheques screen in the Banking Module. To perform this, you need to ensure the following 2 items are in place: Set up the relevant Duty and DAFF General Ledger Codes. In Main […]
Job Financials
The Job Financial Screen, available from the Job Financials menu, Charges menu in Job Registration screens, allows users to view all financial transactions of a job. The screen displays Billing Information, Creditors Invoices, Direct Cheques, and Journal (Profit) information. Once you have selected a Job you will be presented with the following screen. See below: […]
Debtors Invoice EDI
Invoices can be sent to the Debtor as a CSV file which can be uploaded into the Debtor’s system. Set the Debtor to receive invoices by EDI in the Administration > Customer Masterfile Debtor tab. The toolbar button will then appear in the Debtors > Invoice screen and from the Job Invoice screen as a […]
Creditors Invoice EDI
Creditor Invoices that have been received and loaded by EDI can be viewed, updated and posted from the Creditors > EDI Creditors > EDI Creditors Invoice screen available within the EDI Creditors Invoice menu Data is loaded from the invoice file into the EDI Creditors Invoice screen following the instructions in the Administration > Customer […]
Creditors Invoice EDI Setup
To set up Creditors Invoice EDI the Creditor Invoice EDI module must be active. Contact Expedient Software to arrange this. Once the module is available update the Administration > Customer Masterfile for the Creditor you want to receive Invoice EDI from. Set “Receive Creditor Invoice EDI?” to Yes. The screen will then display the set […]
Creditors Statement EDI
Expedient provides the ability to load a CSV of a Creditors Statement and perform a comparison of the Statement details against Invoices for the Creditor stored in Expedient. The option is available in Creditors > EDI Creditors – EDI Creditors Statement. Please contact Expedient by raising a Support Ticket if you cannot see this menu […]