Streamline Your Purchases with Our Apple Invoice Template for Procurement

Apple invoice template for Procurement

hello and welcome to the tutorial for my professional dynamic invoicing system for Apple numbers if you'd like to follow along follow the link below to the download page to get started the template is open-source and completely free the system features full product and customer databases a fully customizable and dynamic invoice and automatically generated receipts and packing slips provided with the template is a user guide with full-color screenshots and a sales record spreadsheet to log your sales for general bookkeeping and tax purposes when you follow that link you can go to the download page and click the icon to download the system once it is finished downloading you can unpack the zip file and you'll have three files here you'll have a sales record a readme file which I would start with first and your invoice system template this is where you will start each time you want to create a new invoice let's start by opening the invoice the first thing you'll see is your product list this is where you should start and enter all the information for all the products or services that you sell first create a name for them and then you can input a code this code is how we were going to reference your products and services on your invoice so make it short and something that's easy to remember or easy to type you can always copy and paste these to choose a product type or a service type I have a pulldown list which you can customize for our categories provide a brief description and then enter your cost your price and profit margin and allowable discount will automatically be generated based off these two numbers you can add any notes and you can also keep track of inventory here next is the customer database you'll want to put in your information for all of your customers and most importantly create a unique customer ID for each person this is how you'll enter their information onto the invoice you can just think up a number or use some combination of their name and a number if you'd like or you can come to the data generators page and check this button to get a newly generated random number you can then copy this come back into here and you can paste it in by pasting values this will ensure that no formulas are pasted into this cell so it won't change each time you open it on the data generators page you also have a place where you can change your tax rate that will be applied on your invoice if you choose to tax you have $1 2% and percent $2 discount converter for calculating discounts and in this table you can see a detailed breakdown on your profit by line and by total moving on to the invoice you can see that it's a very clean and professional look the first place you'll start is with your customer ID let's go ahead and delete this and see what happens as you can see the data is all linked to the ID so when you delete the ID the data disappears when you create a new invoice all you have to do is find your customer get their ID copy it and simply paste it into the ID field and all of their information will automatically be populated you can put your information over on the right side and save it so that it's automatically there when you load it entering items works in the same way as entering customers all you have to do is enter the items code a quantity and any applicant and it will automatically fill in the rest for you so go to your product page let's say we want to sell to small widgets and one medium widget and their codes are 1000 and 1100 respectively we're going to enter those in and then add our quantities and our discount and let's say I want to apply a 15% discount to this line only I'll enter it in there the amounts in the extended price will reflect this discount let's say I don't want to apply sales tax so I'm going to uncheck this box and you'll see that the tax field is now zero if I decided I wanted to apply sales tax I will simply check the box this field shows your total due and this field will show when it's due its default set to two weeks after the date of your invoice which is automatically generated here you can right click on this and say update now if it's not already the right time add any comments you wish in here and thank your customer now you'll notice we have a receipt and a packing slip here by this point in the invoicing process these will already be fully generated with the appropriate information you can now apply any payments that you may have received and you can also update any tracking numbers internal reference numbers or any purchase order numbers as well as the shipping charge I have it setup right now where you can add shipping by typing in ship and this is just a generic shipping code to charge your customer you can use this if you wish or you can change it but as you can see it's very simple it's minimal data entry once you've finished the invoice you automatically get a receipt and a packing slip to ship your products with I hope that this template can prove useful to you in your business if you like my template please consider making a small donation by clicking on the Pay Pal donate button on my webpage to help me continue to offer free products like this one thanks for watching