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

O365: SharePoint List v Spreadsheet - which is best?

O365: SharePoint List v Spreadsheet - which is best? See also - Blogs on  Library ,  List ,  Linking ,  Teams ,   Invoicing ,  Workflow  and  Bulk Invoicing The image shows the same data displayed in different applications. On the left is the information imported into a SharePoint List and on the right is a table representation in Excel What's The Difference? Let's assume you are running Office 365 and you may even have Teams launched. You need to provide your users with access to a table of data, the sort of thing that has traditionally been circulated in spreadsheet format. Only now, you have SharePoint Lists as well.  So, which is the best way to store, maintain and distribute the data? In both apps you can sort and filter the rows and columns, you can add new columns that read original columns and perform arithmetic, mathematical, statistical and text manipulation on the content of the original. In the SharePoint List linking to other lis...
Post a Comment
Read more

The New Computer Age: Infrastructure and the cloud

Most business managers don’t know it but this is very close to the truth. IT teams across the world live in day to day hope that their servers and networks hold together and pray that the disaster recovery schemes will be adequate in the event of catastrophe. IT people are highly professional and, of course, their server networks do deliver. Massive and expensive failure is surprisingly rare, provided that the IT department gets what the IT department needs in terms of budget. But, where budget is restricted, where the IT manager fails to make the business case for upgrade, then performance and security start to become threatened. In addition, a complex IT infrastructure brings with it the penalties of restrictive practise where a department head can’t get the software, services or technology required for a lean department because what is needed will not fit with the current IT infrastructure. So, what’s the answer? Sole Trader - Read more SME - Read more En...
Post a Comment
Read more

Knowledge - The Ultimate Resource

Knowledge – the ultimate resource? I can’t argue with that. As a writer I’m in the business of providing knowledgebase elements. I take my own experience and that of others, I then turn it into some form of written document that may be understood and acted upon by the intended audience. Quote from Wikipedia - Human-readable knowledge bases are designed to allow people to retrieve and use the knowledge they contain, primarily for training purposes. They are commonly used to capture explicit knowledge of an organization, including troubleshooting, articles, white papers, user manuals and others. The primary benefit of such a knowledge base is to provide a means to discover solutions to problems that have known solutions which can be re-applied by others, less experienced in the problem area. · The most important aspect of a knowledge base is the quality of information it contains. The best knowledge bases have carefully written articles that are kept up to date, an excellent information ...
Post a Comment
Read more