May type in your own number or create a number by hitting F2.

1- Name : 

Name of the client.

2-Address 1 :

Address of the client.

3-Address 2 :

Use if you need more room for the address than the first line.

4-City,Country:

Put the City, Province, and country all separated by commas. For example, you would put “Brampton, ON, CA”. The commas are important.

5-Postal Code :

Postal code of the client.

6-Telephone # :

When entering phone numbers, do not use any (, ), - ; just type in numbers. The system will then automatically format.

7-Fax # :

When entering phone numbers, do not use any (, ), - ; just type in numbers. The system will then automatically format. NOTE: CFIA clients require a fax number.

8-Sales Rep. :

This is the Sales Rep who would get a commission on the client, the main rep for the client.

9-Contact Name:

Contact name of the client.

10-IMPRT#/SBRN :

Business number of the client with their RM extension.

11-P/A Number :

Power of attorney number. Use this if you number power of attorneys you receive from clients. Optional field.

12-EICB Number :

Export Import Control Board number. This is generally not used. When used, it is a permit number given to the importer. Optional field.

13-Act Security:

This is the importer’s account security number. Most of the time this would be left blank. If you put in an account security number for the client here, it says the shipment will be cleared under the client’s account security number. This is not the same as the direct security option in which shipment are cleared under the broker’s ASEC but the client pays duty and taxes directly. This is an optional field.

14-Alpha Seq:

This is a search identifier field. For example, if you have several “Loblaw” clients, you can put in “Loblaw” in this field to make it easier to search for Loblaw clients.

15-Lang Code :

0 for English; 1 for French

16-Bill To Acct:

This is used for third party billing. You would only use this field if you are billing another client, then you would have to put in the client number of who you are doing the third party billing to. The third party billing client must also be set up in Candata.

17-Temp Account:

This is for a temporary one off or one time use account. Most of the time this would not be used. The difference between a temp account and a regular account is that temp accounts can be purged but regular accounts cannot be purged. However, regular accounts can have their status changed to inactive. Enter T for temporary account or leave blank for regular account.

18-B3 Type :

IBS – Importer broker security. This is for clients who are on the direct security option and pay all of their duty and GST directly. Broker is not responsible for any defaults of the importer of duty or GST.

G – GST Direct. This is for clients who are on the GST direct option and pay only their GST directly. Broker is not responsible for a default of the client of GST. However, broker is responsible for a default of the importer of duty when the client is on this option.

IBS is a good option for clients who pay duty whereas GST direct may be a good option for clients who import almost all duty free goods since those clients would not want to spend money on obtaining a surety bond. The GST direct option does not require clients to obtain a surety bond.

E – Emulated IBS. This is where the client signs the GST agreement but the client pays the broker and the broker pays the GST. This option is not used very often.

N- Non reported GST direct. This is similar to emulated IBS and is not used very often.

19-Ship To Acct:

This is you are always shipping to the same address and it is different than what is listed in the client profile address above. This is not used very often because you can only have on Ship To Account number in this field. It is most often used blank. If a client has one main billing address but several consignee ship to locations, a way you could handle that is by having each ship to location set up in Canada as an individual client but set up one bill to address for the billing location. Again, most of the time this field would be left blank.

21-G.S.T. # :

Normally, the system will pull this information from field 10 IMPRT#/SBRN. The system does not put an “RT” in this field. NRI clients may not have an RT account. Most of the time, you would leave this blank or just use what is defaulted by the system.

22-Curr. Code :

This is the currency code for what you bill the customer.

The system here will also ask you for an AR Account Number, which are set up in another table.

23-Acct Status :

A – Active

I – Inactive

H – Hold

W – Credit Watch

24-Rater Code :

This is who the rater would be for the client. A rater code table is set up in another area of Candata. This field can also be left blank.

25-Recap Entry :

Y – system will consolidate all invoice lines with the same HS code into one B3 line

N – all invoice lines will be reported as separate lines on the B3 even if they all have the same HS code

26-Provincial Tax :

N – for commercial goods

Y – normally only for casual goods

If a client has both commercial and casual goods, then two different client account numbers have to be set up.

27-Consignee Required

Y – user must type in a consignee for the entry

N – consignee defaults to the importer

You would use Y if you want the rater to always verify the consignee. CFIA requires a Canadian consignee and is a situation where you may want to use Y. If the consignee is always the same as the client though, you would most likely use N.

--------------------------------------------------------------------------------------------

At the bottom of this screen:

F1 – Notes – this is where you put in notes for the client on how to handle the account

F2 – Documents – this is where you can attach documents to the client’s profile

F7 – Contacts – this is where you can enter contacts for the client. This is also the spot where you can set up things to go automatically to the client, such as to specified e-mail addresses.

1.Brok. Schedule:

Enter Brokerage schedule code from the Brokerage schedule code table. The brokerage schedule code table is set up separately from this screen and must be set up prior to entering a code here.

2.Line Chg Ind :

This is where you specify how many lines of a B3 entry are included in the regular brokerage rate before additional line charges apply. You enter a number here for the number of lines included in the regular brokerage rate or “N” if no additional line charges apply. With the “N” option, there will never be additional B3 line charges no matter how large the B3 entry.

3.Flat Rate Code:

Enter the flat rate code here. This is set up in another table and must be set up before entering the code here. If you are not using flat rates, then a “N” is entered.

4.LVS Flat Amt :

Enter the flat rate code for LVS here. This is set up in another table and must be set up before entering the code here. If a “0” is entered in this field, then flat rates for LVS do not apply.

5.Max Brok. Amt :

This is the maximum amount you would charge for brokerage. This could be used if you are charging for additional B3 lines but want to put a cap on the total brokerage you charge the client.

6.% Brok. Disc. :

This is a percentage discount off of the brokerage fee. For example, it would show the client standard brokerage charge and the client receiving a percentage discount. Probably would not use. #7 through #13 deal with disbursements:

7.Disb Code Frt%:

Enter the disbursement % code for freight. Here, you are charging a percentage of the amount disbursed. This is done from a separate disbursement schedule table that must be set up before entering a charge here.

8.Disb Code Frt$:

Enter the disbursement amount dollar amount code for freight. Here, you are charging a flat amount for the disbursement regardless of the amount of money disbursed. This is done from a separate disbursement schedule table that must be set up before entering a charge here.

9.Disb Code % :

Enter the disbursement % code for disbursements besides freight. Here, you are charging a percentage of the amount disbursed. This is done from a separate disbursement schedule table that must be set up before entering a charge here.

10.Disb Code $ :

Enter the disbursement dollar amount code for disbursements besides freight. Here, you are charging a flat amount for the disbursement regardless of the amount of money disbursed. This is done from a separate disbursement schedule table that must be set up before entering a charge here.

11.Max Disb Amt :

This is the maximum amount of money you would disburse on the behalf of a client.

12.Disb. Chg Ind :

This gives you the option to charge disbursements based on duties and taxes, based on freight amount, or based on duties and taxes and freight. Most brokers are not using this option.

13.Disb Flat Amt :

This allows you to set up a flat dollar amount for each disbursement made. The set dollar amount applies regardless how large the dollar disbursement.

14.Payment Terms :

Enter the terms of payment code. This is done in another table which must be set up before entering the code here.

15.Salesman # :

This is where you set up sales person commission schedules. A table listing sales people must be set up before setting up the sales person commission schedule. When you go to this field, the following screen comes up.

16.Deferred Bill :

This is how billing is sent to the client. A “Y” in this field is used for summary or statement billing. If an “N” is used in this field, one individual bill is sent to the client per shipment or entry. Basically, a “Y” in this field defers the billing to a future time instead of doing the billing immediately.

17.A/R G/L # :

This is the G/L number for Accounts Receivable. The system will carry over what is set up in field 22 Curr. Code field on the initial Client Information Screen. Choosing this number is done after you enter the currency on initial Client Information Screen in field 22. The G/L numbers are set up in the General Ledger Control Maintenance table.

18.Show Pay Chg :

“Y” – shows disbursement and brokerage charges separately

“N” – shows disbursement and brokerage charges together (combines them into one amount)

19.Print Stmt :

Used to automate printing of the Accounts Receivable Aging Statement. If you use this option, then aging statements would be set up to print in specified time periods. This would happen if you use the “Y” option. If you use the “N” option, then Aging Statements would not be automatically printed. Most brokers use the “N” option here.

20.Age Stmt :

This is used to “age” statements. Y is used for aging and N is used if you do not want statements aged. Most brokers would use “Y” here.

21.Interest Chg:

Here you enter the interest charge code from another table. The interest charge code table must be set up before entering a code here.

22.Stmt Msg :

This is wording that would go on every invoice you sent to the client, such as “Thank you for your business.”

23.Intrans.Bal :

This is the average balance outstanding the customer would have over a one year period.

24.Credit Code :

Here you enter the credit limit code. The credit limit codes are built in another table. The credit limit code table must be set up before entering a code here.

25.Deposit Amt :

This is used when a client gives money to the broker in advance. It is not a good idea to use this option and most brokers would not use.

26.CR Deposit :

This is what you took away from the Deposit Amount in #25 above (i.e. to pay a charge related to the client. It is not a good idea to use this option and most brokers would not use.

27.Credit Bal :

This is the amount of credit the client has left right now before they exceed their credit limit. (Or what the client has outstanding right now?)

28.Age Code :

Here you enter the aging code. This is set up in an aging code table. The aging code table must be set up before entering a code here.

29.Set Doc Fee :

This is a fee you would set up for handling certain types of documents, such as special permits or having to handle documents manually. You cannot specify the type of doc fee here. Most brokers would not use this. Instead of using this field, you would likely use the F5 Doc Chg option at the bottom of the screen.

30.Disb Fee<500:

This allows you to set up a disbursement fee amount for disbursements under $500. Most brokers would not use and instead would use #7-13 above.

31.GST/HST Ex :

You cannot charge GST/HST on your services to non-resident importers that are not registered with an RT account. For companies with an RT account, you are required to bill GST/HST. In this field, you only put a “Y” for a non-resident importer that does not have an RT account on file. Otherwise, you would put a “N” in this field and would charge the client GST/HST on your services.

32.PST Exempt :

The PST normally only applies to casual goods importations. For commercial goods importations, you would be exempt from the PST. For importers who are importing commercial goods, put a “Y” in this field. For importers who are importing casual goods, put a “N” in this field. These are normally the circumstances regarding this field.

33.# Inv Copies:

Number of copies here defaults to “0”. This means that only one copy of the invoice gets printed or sent to the customer. Normally, you would use a “0” here.

34.Stmt Actvity:

Lineage Fee-

Enter Y if you want the statement to print all activity. Enter N if you want the statement to print only open items.

35.Auto Billing:

There are 3 options here:

Never

Release – ACROSS Release

B3 – B3 Acceptance

With the Release – ACROSS Release option, the system automatically bills the customer as soon as the shipment is released in ACROSS.

With the B3 – B3 Acceptance option, the system automatically bills the customer as soon as the B3 is accepted on the shipment.

The risk of using this option is that the system bills the customer before the entry is audited and there is a higher risk the customer could be billed an incorrect amount for duty and taxes.

Most of the time, probably would want to use the “Never” option.

36.Att'n :

This is a text field to put in the person who you want invoices to go to.

37.Remarks:

This is a text field to enter remarks that you want to put on every invoice that goes out to the client.

<Enter> Accept

This will save your client billing information.

<F2> O.Sched

This brings up “Additional Brokerage Details” such as additional charges for an OGD entry or additional charges after a certain number of B3 entry lines. You also enter charge codes on this screen. It looks like this below.