Discover the Ideal Freight Invoice Format in Excel for Shipping

Freight invoice format in excel for Shipping

all right welcome back everybody to the last video in the in the paperwork series here for paperwork for transport series um we're gonna cover invoices in this video we've already covered raycons and bills of lading in this one we're going to cover the invoice if you do have to invoice customers a lot of times at cars you're not going to use factoring because a lot of companies don't factor they won't factor they refuse to actually and you'll be getting a lot of company checks you'll be getting a lot of cods you'll be getting a lot of ach payments so what you're going to want to do with some of these is invoice people and invoices don't have to be crazy there's no like extreme template there's just there's just a few things that you want to have on here mine is super minimal um i've got the logo on here i've got my contact info on here i've got invoice listed on here and really that i mean this this big stuff right here is just it it helps us more than them honestly with paperwork you're going to want to put on here who it's billed to you're going to put their name their address the date of issue which basically starts the timer there um and then you're going to want to have the invoice number now how you do your invoices is on you that's fine i do it really really easy uh i use the month the day the last two digits of the year and then the invoice number of that day so this would be the first you know zero one so like today's uh september 7th so it would be uh what zero nine zero seven two one zero one uh that that would be the invoice number for today if i were to have one if i were to have two invoices you know of course the second one would be zero two but it's really that i mean that's that's how i invoice things uh you can invoice stuff however you want to the next part you're going to want to have is a description this is where you're going to put your order id number this is going to basically let them know which load this was you're going to want to make that sync up with the shipment id or the bl number or anything like that that they would have for their paperwork you're going to want to list the commodities that it was whether it be vehicles you're going to list all the vehicles you're going to want to list um you know i'd do at least the last six of the vins on vehicles for freight you're going to want to basically just do a carbon copy of what's on the bol then you're gonna put the rate which is what you're owed now it's gonna be for each one of these uh you could you could tally up multiple uh order ids on this but you're gonna have a rate on here of what they owed you you're gonna have a total which if it was more than one it would be you know the sum of all that and then the amount due which would once again typically be the total of that unless they paid you others or unless you've had extra things added like you know detention or anything like that and that's really it you're usually going to fire that off to an ap address for whatever you typically whenever you see the email address that you send these to it's going to be ap whatever dot com ap core stands for accounts uh payable so whenever you're looking for who you need to send this to a lot of times just go ahead and try to catch that ap address in in the the mess of all the paperwork that you'll have typically for loads like these um but if not you could uh you could just go ahead and send it to or call the broker that you handled with and ask them who you need to send it to um it's really easy to find out where to send invoices i would send the invoice and the bill of lading and the recon i would just fire all three of these pieces of paper to whoever it needs to go to and um in the email whenever i send an email i always always at the very beginning put please confirm receipt that's to let me know that they did see it someone has seen this and and they're going to start the processing because a lot of these will have it's in your your agreement uh how how long they have to pay you a lot will be like 15 days to pay 30 days to pay once they confirm receipt for processing uh that's that's when the the the clock starts and and we've had to call several times through several different brokerages and and shippers uh to kind of remind them that they need to pay us you're gonna have to chase money okay that that is one good thing about factoring uh three percent or four you know two and a half whatever you get with your factoring company for the guys that do factor what three thousand dollars a year on a hundred thousand dollars of revenue that's not much to have them do all this leg work the chasing payments the trying to remind people finding things from you know a month ago that you've already sent in that they say they lost and all the units it's it's a big run around i mean you always essentially end up getting paid but some of it i mean there's been several that has taken you know 90 to more than three months on a couple of occasions to get your money but that's why it's good to file i always when i come home put all this together shoot my bols out to the people that need proof send my invoices of people need invoice and i put all that that i don't have money in hand for in an outstanding folder and we check that about once a week and the ones that have met or exceeded their ach time frame we start making phone calls then we start shooting emails we say you know we have to get a hold of somebody you've got to chase your money every once in a while but it's all part of it and uh that's how you get paid guys so you need there we go over the raycon the bill of lading and the invoice if you haven't seen the bill of lading or the raycon videos i'll post those up here and uh that's it if there's anything else that you guys want to see pertaining to paperwork that doesn't involve raycon's bols or invoices let me know in the comments what what you want to see and uh i'll try to kind of go over that i know that there's a lot involved in this with the back office stuff that a lot of people want to jump into this have never experienced so paperwork is very important okay not not just for getting paid but also compliance uh following regs and all that staying legal let me know what you want to see guys i hope you all enjoyed this little video series like i said i'll post the other two uh videos that pertain to this one and uh we'll see you guys next time [Music] [Music] you