Skip to main content

O365: Bulk Invoicing from Office 365

O365: Bulk Invoicing from Office 365

See also - Blogs on Library, List, Linking, Teams, Invoicing and Workflow

Note - requires compatible client versions of Word and Excel

Earlier posts have covered List and Library creation and producing high quality single invoices from Office 365 and SharePoint.

In this post I'll demonstrate how to push bulk invoicing from the Office 365 platform.



Create the List

First you will need to create the SharePoint List.


Be sure to include fields for Invoice number, date, each address field, quantities and price. Remember that most countries have minimum legal requirements regarding what needs to be shown on an invoice.

Build the Content

Add content to the list as required. This can be done as orders are fulfilled or work completed and may be part of a broader process that includes works order processing and stock control.

Once there is data in the list you can export it. Select 'Export to Excel' in the top menu of the list

This will create a query on the local computer which may be opened with Excel. Save the Excel spreadsheet to a convenient place on the local machine, or in a cloud location. Remember to give the file a name that you can use each time to perform the download. The content of the SharePoint list will change with each financial period and the new Excel download will reflect those changes, so you will need to overwrite the previous period result.

Create the Invoice Template

Note -  You only have to do this bit once

Create this using the client based version of Word to include any company branding, logos, contact detail and company registration numbers
 
Once you have the format of the invoice completed click 'Mailings' in the top menu and then click the drop menu under 'Start mail Merge'. Select 'Step By Step mail Merge Wizard'.

From the wizard panel on the right select to create letters
Select to use the current document and on the next page select to use an existing list. Locate the Excel download you created in the previous step.

Insert an address block under the 'To' heading in the template and select to map fields. Add other fields such as Invoice Number, Invoice Date, etc to the template.

The next step allows you to review the work so far by clicking through the records you will see each record detail allocated to the template.

Don't forget to save your work.

The invoices can be printed individually or streamed to the printer in bulk. You can also print to PDF if you use a mailing agency or wish to sent invoices as PDF attachments to emails.

Use it again and again

Your SharePoint list is now configured and the export to excel will always produce a query in the same format. Save this to the same name as the previous export, overwriting the last period and the Word Invoice template will always find the fields in the same place.



We can show you how, or we can do it for you.





Labels:

Comments

Post a Comment

Popular posts from this blog

The Wind Power Alternative

Could wind power be a viable alternative to conventional methods of power generation? The UK Prime Minister, Tony Blair has recently said - "We are not going to be able to make up through wind farms all the deficit on nuclear power," Yet, if looked at from a slightly different perspective, wind power may already be a viable alternative - the link below is a web page where you can buy your own domestic wind turbine. http://www.diy.com/diy/jsp/bq/nav/nav.jsp?action=detail&fh_secondid=9414908&fh_location=%2f%2fcatalog01%2fen_GB&fh_search=wind+power&fh_eds=%c3%9f&fh_refview=search&ts=1180379362679&isSearch=true It produces around 1Kw at moderate wind speeds and costs around 1500GBP. Okay, so it’s not cost effective, but it is a step along the road. The manufacturer and retailer must believe they have a market. If they have, the unit cost will fall as sales rise. Once competition gets hold, the performance of equipment from alternative suppliers will i...
Post a Comment
Read more

O365: SharePoint Searching in Office 365 and Teams

 O365: SharePoint Searching in Office 365 and Teams See also -  Other Office 365 Posts Earlier posts have discussed the huge advantages of centralising documents, files and communications in SharePoint and Office 365. One of the strongest functions in Office 365 is the ability to search all content so that locating data is easy. However, the search tools in Office 365 are not always obvious. Teams Search Teams is becoming really popular, not least due to the fact that it makes SharePoint very easy to deploy, use and control. At the top of each Teams General Tab is a search box This is multi function. Type / into the box and you will see a list of commands that will perform all sorts of Teams functions    The /Files option will return files you have recently accessed. Great, if the file or document you are looking for is actually in the recent file list. What if the information you require is in an older file, or in a different location? Location Search Also in Teams ...
Post a Comment
Read more

New Inventions

A question asked on a business forum recently set me thinking. The question was – Your thoughts on the best invention of the last ten years? Try as I might I can’t come up with any single thing that fits the bill. Many other people suggested Broadband, Mobile telephone developments and improvements in the personal computer, some even suggested that search engines were of the highest order of importance. The problem is that none of these were invented in the last ten years. Probably the biggest single step has been the availability of Broadband access, but while the services to provide this are new, the technology certainly isn’t. DSL (as in ADSL) has been around since nineteen forty-eight. Up until around ten years ago it was just too expensive to deploy on a large scale basis. At that point in time a major step was made in the advancement of Very-large-scale integration (VLSI). This is another technology that has been around for a considerable period of time, but the late nineties saw...
Post a Comment
Read more