David Simpson Apps

How to create invoices in monday.com using the Microsoft 365 SharePoint integration

Learn how to connect monday.com boards to generate automated custom invoices in SharePoint, with calculations and document creation in SharePoint.

Overview of the invoice creation process

We demonstrate a method for generating invoices within SharePoint by integrating data from monday.com. The system uses three connected boards in monday.com to manage contacts, clients, and invoice details.

This functionality (and much more) is available in the Microsoft 365 SharePoint • Automate & Embed app.

Setting up the monday.com boards

The solution uses three interconnected boards:

  1. Contacts board: Contains individual contact details
  2. Clients board: Lists company information
  3. Invoices board: Manages all invoice data

The invoices board connects to both clients and contacts, pulling information such as billing addresses and shipping details using connected board and mirror columns. This is not absolutely necessary, but just shows the power of the automations to support formula, connected board and mirror columns within monday.com.

Each invoice contains sub-items representing line items with:

  • SKU details
  • Unit quantities
  • Pricing information
  • Automated calculations for net total, tax, and gross total

Automated calculations in invoice items

In the example, we use formula columns to automatically calculate:

  • Net total: Units multiplied by unit price (rounded to 2 decimal places).
  • Gross total: Net total plus 20% VAT (in this example it's for a company in the UK, but you can adapt this to the needs of your own local tax laws).
  • Tax amount: Difference between gross and net totals.

These calculations update dynamically when any underlying values are modified.

Creating the word template in SharePoint

The process begins with a Word template stored in SharePoint containing:

  • Placeholder text for dynamic fields
  • A repeatable table row for invoice line items
  • Fields for client and contact information
  • Job numbers and due dates (formatted in American date style in the example, but available for all international formats)

The template is designed to pull data from the connected monday.com boards when generating the final invoice.

If you'd like a starting point for building Word template documents, you can browse our document template gallery, then save the Word document template to your own SharePoint site.

Automating document generation

The system uses monday.com automations to:

  1. Create a dedicated SharePoint folder for each new invoice
  2. Trigger document generation when a status column changes
  3. Populate the Word template with data from monday.com
  4. Save the completed invoice in the appropriate SharePoint folder

The automation workflow:

  • Monitors for status changes to "create invoice"
  • Locates the SharePoint template
  • Generates the document with all connected data
  • Saves the output as a Word file in SharePoint

Additional functionality

The solution can be extended to:

  • Generate PDF versions of invoices
  • Automatically email PDF versions of invoices to clients
  • Maintain all invoice documents (with version control) within SharePoint for record-keeping

The integration between monday.com and SharePoint provides a streamlined process for creating professional invoices while maintaining data consistency across platforms.