ENTERING FREIGHT DETAILS - ALAN CAMBEY

ENTERING FREIGHT DETAILS - ALAN CAMBEY


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

CLICK TO VIEW TRAINING VIDEO FOR ALAN CAMBY

=================================================================================
Instructions for entering Freight details to freight Master file.

--------------------------------------------------------------------------------------
How to record Details
Open Google docs freight master file and create a new tab ,name the tab with the cariers name and invoice number

COLUMNS FOR ALAN CAMBY GOOGLE DOCS
1.Column A - Record Freight company details including               -
Freight Company Name,invoice number from carrier , (Note:this only needs to be recorded on the first line of each new invoice )

2.Column B - Invoice or RMA number


3.Column C -Cost
 
NOTE ONLY ENTER LINES INTO GOOGLE DOCS WHER WE ARE BEING CHARGED ,DONT ENTER AT ALL WHERE OUR CHARGE IS ZERO 
-----------------------------------------------------------------------------------

Entering Freight Details – Allan Camby

 - Freight invoices are located in Zendesk under category A/P FREIGHT/TOWING 

          - click the ticket to open download the invoice attached from the ticket, just click the attachment and it will automatically download


 - open connotes from Dropbox - A A NEW ACCOUNTS 2014 -FREIGHT CONNOTES COPIES AND TOLL MANIFEST folder


 - Open Freight Masterfile from Google Docs (click the link above)


-          Add a new Sheet to the masterfile

-          Rename sheet put name of freight and the invoice number

-          Record the details:

-          Column A –  FREIGHT NAME AND INVOICE NUMBER

-          Column B – REFERENCE NUMBER­( from con notes)

-          Column C  – AMOUNT

-          Column D – NOTES

-          We don’t need include the reference number with no given amount on invoice

- after entering the following details on masterfile compare the total amounts from the invoice to masterfile if match.

- step 1 is done

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

At stage 1 of process ,leave Invoice in freight Bills to Pay category at this stage,we don't remove until stage 2 done  

FAQ

What if there is more than one invoice/con note used by freight company per charge on freight invoice?
If there is more than one invoice/con note used for the one charge add lines to the freight master recording the other invoices/connotes used for this charge. In the notes section record - sub charges.

What if the freight invoice is for re-delivery charge?
If the charge is for re-delivery - column B record con note number, column C record amount charged and in notes - record in the re-delivery original invoice number - this can be found on previous invoices from freight company

What if the freight charge lists RMA?
If the freight invoice lists RMA  - Column B record con note number, column C amount charged, NOTES - record RMA number if listed or any details listed n description on freight invoice.

What if the freight charge is for a "buy in"?
If the freight invoice advises a buy in. Column B record con note number, column C amount charged, NOTES - record description or any reference numbers listed on freight invoice.

What if there is no charge for the delivery from carrier?
Fill in the rest of the details and mark this as no charge in the charge column

Which amount do i record GST exclusive or Inclusive?
When recording amount us the total amount charged to JJAutoparts  GST Inclusive.

Where do i find the original invoice number for any re- delivery charges?
You can locate the original invoice number by searching the name in S11 Masterfile Column F.

What if the amount on the invoice is different from the amount on the runsheet?
Follow the amount on the runsheet and attach it in Xero together with the invoice.