Collaborate on Open Office Invoice Template for Organizations with Ease Using airSlate SignNow

Open office invoice template for organizations

hi everyone this is just a quick tutorial to show you how to set up and the really easy invoicing template I'm using the free version in libreoffice but it's an XSLT file and the instructions will work whether you're using Excel or OpenOffice and it makes no difference whether you're using a free version of this template or paid-for version okay so first of all I've downloaded the file and it's here on my desktop you can put it into your templates folder for your application whether that's Excel or whatever or you can just put it in a folder and then to create a new version of the template you just double click the file so that's what I'm going to do I'm just going to double click it and now you can see it's opened a new version a copy of that template file it's called it untitled one and I'm using the Libre Office so I'm just going to save that I'll pop it on my desktop as well here's one I made earlier definite demo invoice so I'll just replace that okay so the first window you should see is start here if it hasn't opened there then navigate to that by clicking on the tab at the bottom that says start here this is where you can put in information relating to your company so we just go through this one by one and enter all your company details I'll do this as if I was doing it for myself so this is like my customers see the website address the registration number let's pretend that's my surrett number the reporting is that's fine 2019 so company address you could change that I'll just pretend it's ok so that's my address payment terms I'm just going to change that to 30 days you can customize this as well okay check the telephone number I'll add my email address and this invoice number prefix we'll just add another zero so this will make sense later on when we're looking at the individual invoice pages so as you can see that's all of the little fields in this page filled out you can't click anywhere or you're not allowed to enter information so only the boxes where you're required to fill something out are available to you okay and with all of that done you're ready to start putting in some invoices so we'll click on the invoices tab here we've got just a table it's got an invoice number we've got 30 invoices in the sheet so that number shows one through to 30 on the left-hand side and then these are the columns few to fill out so we've got invoice date client name description unit price number of units a total which is automatic comments which are for you and a date paid so let's pretend we're making an invoice and let's make one it's the 8th of April so we put that in our client is J blocks today we're bidding for work in March and we recharged 25 euros an hour 30 euros an hour and we did 4 hours of work so you can see it's taken the unit amount and the number of units and it's given a total of 120 now I can add some comments this is just for myself so and then we'll leave that blank because at this stage we haven't had an invoice paid so now that's all put in we can click this button we have to hold ctrl and click press click and it takes us to the first invoice you can see it says invoice again you can't click there it has the company name from the front page the address the invoice number which is a combination of the prefix that we set on the first page and the invoice number here the one the invoice date which is coming from the table we just put that information in okay here we've got the customer name and other information from the invoice sheet the description work in March the rate 30 a quantity 4 and the total 120 the payment terms within 30 days and then this box you can enter notes so everything else on this form is locked but here you can put there you go so there's a comment from you for me in this case and that's how invoice done so now if we click the file and print let's preview first so we'll print preview and see you can see it's laid out it doesn't have some of the other it doesn't show that button the top bright yellow box it just shows you the invoice so now if we close the preview click file and print it brings up your printer dialog and it will print or you just saw so you can make a PDF or a hard copy on your printer or whatever you want to do I'll just cancel that for now because I don't want to do that so now if we go to totals you'll see here that we have a sent invoice so we've created an invoice it was sent in April in April we have a sent invoice 120 euros you can see we haven't received anything yet which means we rode 120 euros ok if we want to get back to the invoice list we can click on the tab at the bottom here where it says invoices or we can control and press this little link there and that takes you back to the page the summer the invoice page so here we are back at number one let's say Joe Bloggs has paid so I'll say let me put a date so now it's the 9th of April and Joe's already paid so if we want to go back to summary we can click on the totals tab here or we can control and click on the box and that will take us to the summary page and so here again we can see now we sent invoices 420 we've received payments over 120 so we're actually not add anything if I go and change it now then in here let's say it's not paid until May ok we do that you can actually now see the payments has moved to May so in April we have a total we send 120 we receive nothing but in May so far we haven't sent any more dismay but we have a payment so that's quite handy because it gives you a quick overview of your your invoices and who's paid what and that's all there is to it so as I said there are 30 sheets in this free version and I'm working on a paid full version which will include more invoice sheets and some more customizations that will be of benefit to you and your customers so email if you have any questions or comment on the blog post and I will get back to you thank you