Automated PDF Invoice Extraction to Xero (Make.com)

Eliminate manual data entry by extracting PDF data via Wondershare Document Cloud and AI to Xero via Make.com

Tools: PDFelement → Xero

Platform: Make.com

Short Answer

A fully automated pipeline where saving a PDF to the cloud triggers AI data extraction, creates a draft bill or contact in Xero, and archives the original document for compliance—all monitored by Make.com error handlers.

The Problem

Accounting teams often waste hours manually transcribing data from vendor invoices or signed contracts into Xero. This manual process is prone to human error, resulting in incorrect tax filings or payment delays.

The Outcome

A fully automated pipeline where saving a PDF to the cloud triggers AI data extraction, creates a draft bill or contact in Xero, and archives the original document for compliance—all monitored by Make.com error handlers.

Step-by-Step Guide

1. **Establish the Trigger Source**: Since PDFelement is desktop-based, configure it to save outputs to **Wondershare Document Cloud** or a linked folder (Google Drive/Dropbox). Add the 'Watch Files' module in Make.com for that specific folder. 2. **Connect Wondershare/Cloud API**: In Make.com, click 'Add', search for your cloud storage, and authenticate. Set the 'Limit' to 1 to process bundles one by one during initial setup. 3. **Leverage PDFelement AI/OCR**: Use a 'HTTP Make a Request' module or a dedicated OCR module to send the file to PDFelement’s extraction API. Ensure you request the 'Summary' or 'Markdown' output for structured text. 4. **Parse the Data**: Add a 'JSON Parser' or 'Text Parser' module. Use **Regular Expressions (Regex)** within Make.com to isolate 'Total Amount', 'Invoice Date', and 'Vendor Name' from the AI-generated summary. 5. **Establish Xero Connection**: Add a Xero module ('Create an Invoice'). Click 'Create a connection' and log in via OAuth2. Select the specific Xero Organization. 6. **Check for Existing Contact**: Add a Xero 'Search Contacts' module. Map the 'Vendor Name' from the PDF. This prevents duplicate contact creation. 7. **Implement a Router**: Use a Router to branch the logic. Path A (Contact found): Proceed to Create Bill. Path B (Contact not found): Create Contact FIRST, then Create Bill. 8. **Map Bill Details**: In the 'Create a Purchase/Bill' module, map the extracted date using `formatDate(parsed_date; YYYY-MM-DD)` and the total amount using the `parseNumber()` function to ensure Xero accepts the decimal format. 9. **Attach Original File**: Add the Xero 'Upload a File' module. Source the 'File Content' from the initial trigger module to ensure the PDF is linked to the Bill in Xero. 10. **Add Error Handling**: Right-click the Xero module and select 'Add error handler'. Choose 'Break' to store the execution for manual review if the API fails due to validation errors (e.g., missing account codes).