Microsoft 365 & Cloud Integration

How to Route Scanned Invoices Automatically into Microsoft 365 and SharePoint

A Comprehensive Technical Architecture Guide for IT Heads and Finance Directors: Automating Accounts Payable, VAT Extraction, and SARS-Compliant Archiving.

By David Stone, Senior Records & Compliance Analyst • Updated: October 2026 • 13 min read

In South African commercial enterprises that have invested heavily in Microsoft 365 licensing, a persistent operational contradiction frustrates leadership: while general business communication and collaboration live seamlessly in Teams, Outlook, and SharePoint, the Accounts Payable (AP) invoice workflow remains mired in manual clerical friction.

Invoices arrive across multiple disconnected channels: paper slips delivered with physical goods receiving notes, supplier invoice PDFs emailed to general accounting inboxes, and WhatsApp photos from remote technicians. Accounts payable clerks spend hours downloading attachments, manually typing invoice numbers and 10-digit South African VAT registration numbers into accounting ERPs (Sage Evolution, SAP Business One, Xero, or Microsoft Dynamics), and dragging files into SharePoint folders with inconsistent, unsearchable naming conventions. In this technical architectural guide, we demonstrate how to connect modern AI document capture pipelines directly into Microsoft 365 and SharePoint, establishing an automated, audit-proof accounts payable workflow.

Core Integration Capabilities Dissected
  • Automated Multi-Channel Ingestion: Ingesting physical paper scans, network MFP feeds, and emailed PDF attachments into a unified queue.
  • South African VAT Act Section 20 Compliance: Auto-extracting 10-digit VAT numbers, sequential invoice numbers, and 15% VAT breakdowns.
  • Microsoft Graph API & Power Automate: Pushing metadata-tagged PDF/A files directly into SharePoint document libraries and Teams approval cards.
  • ECT Act Section 14 & 15 Evidentiary Standard: Generating tamper-proof digital originals admissible in tax audits and court litigation.
  • SARS 5-Year WORM Archiving: Resolving SharePoint's native overwrite vulnerability through certified sovereign vaults.

1. The Operational Pitfalls of Manual SharePoint Ingestion

When businesses attempt to use SharePoint as a document repository without an automated extraction and routing pipeline, three systemic failures inevitably emerge:

Inconsistent Taxonomy & Lost Files

Different staff members use different folder paths and file naming syntaxes (e.g., Inv_ABC_May.pdf vs 12345.pdf). Documents get dropped into incorrect subfolders, and without custom SharePoint metadata tags, searching for historical invoices during year-end audits becomes nearly impossible.

Manual Typing Errors & VAT Clawbacks

Clerks typing 10-digit South African VAT numbers and line item totals into ERPs produce typographical error rates between 3% and 7%. When SARS conducts input VAT reconciliations, mistyped invoice numbers or missing supplier VAT registrations result in input VAT disallowances and severe understatement penalties.

2. The 4-Layer Technical Architecture: Paperop to Microsoft 365

An enterprise-grade document routing pipeline transforms incoming physical paper and digital files into structured business records across four discrete layers:

Layer 1: Document Ingestion & Image Enhancement

Whether physical paper is scanned on an office multi-function printer (MFP), captured via a dedicated desktop feeder, or processed in bulk at Paperop's scanning bureau, the ingestion engine applies automated computer vision enhancements: deskewing tilted pages, background descreening, binarization, blank-page deletion, and multi-page document separation using dynamic barcode patch sheets.

Layer 2: AI-Powered Intelligent Document Processing (IDP)

Unlike primitive OCR that merely reads raw text characters, Paperop's IDP models structurally recognize South African tax invoice formats. The engine locates and validates:

  • Supplier Identity: Company legal name, trade name, physical address, and 10-digit VAT registration number.
  • Customer / Recipient Verification: Confirming your enterprise legal entity name and matching VAT registration number to satisfy Section 20(4) of the VAT Act.
  • Financial Figures: Net total, line items, 15% standard-rate VAT calculation, zero-rated exemptions, and final gross amount due.
  • Temporal Fields: Tax invoice date, payment due date, and purchase order (PO) reference numbers.
Layer 3: Schema Normalization & ERP Synchronization

Extracted fields are validated against internal business rules (e.g., verifying that line items sum exactly to the invoice subtotal, and that the calculated 15% VAT matches the stated VAT). The data is serialized into structured JSON and XML payloads, ready for API injection into accounting ERPs.

Layer 4: Microsoft Graph API & SharePoint Document Library Routing

Using secure Microsoft Graph API endpoints authenticated via OAuth 2.0 with least-privilege enterprise application permissions, Paperop creates an archivable, searchable PDF/A-1b document directly within your SharePoint document library (e.g., https://yourcompany.sharepoint.com/sites/Finance/Invoices/2026/08/SupplierName). Crucially, the custom SharePoint columns (Supplier, Invoice Number, Invoice Date, Total ZAR, Approval Status) are populated simultaneously.

3. The Power Automate Workflow: 1-Click Teams Approvals

Once the metadata-tagged invoice arrives in SharePoint, it can instantly trigger a native Microsoft Power Automate cloud flow to orchestrate approval hierarchies without sending heavy email attachments:

Step 1: Automated Trigger

When a new invoice document is created in the SharePoint library, Power Automate evaluates the extracted gross amount and cost centre code.

Step 2: Teams Adaptive Card

An interactive Microsoft Teams adaptive card is posted to the responsible departmental budget holder, displaying supplier name, PO number, total ZAR, and a direct link to the certified PDF.

Step 3: ERP Ledger Posting

Upon manager approval, the flow updates the SharePoint status column to 'Approved' and triggers an ERP webhook to generate the accounts payable voucher automatically.

4. The SARS Compliance Gap: Why SharePoint Alone Needs WORM Protection

While Microsoft SharePoint is an outstanding platform for active document collaboration, workflow routing, and internal sharing, IT and finance directors must be aware of a critical legal limitation: SharePoint is not an immutable WORM (Write Once, Read Many) archive by default.

The Statutory Requirements for Tax Invoices:

  • Tax Administration Act No. 28 of 2011 (Sections 29 & 30): Mandates that records, books of account, and tax invoices must be retained in an accessible, unaltered electronic form for at least five (5) years from the date of return submission.
  • Electronic Communications and Transactions Act No. 25 of 2002 (ECT Act Section 14): Requires reliable assurance as to the integrity of the information from the time it was generated to its final form.

In standard SharePoint libraries, any user with edit or site-owner permissions can check out, overwrite, rename, or permanently delete an invoice. During a SARS tax audit, an auditor can challenge the evidentiary validity of an invoice if the system cannot prove cryptographically that the PDF has remained completely unaltered since receipt.

To resolve this, leading enterprises adopt a hybrid compliance model: Microsoft 365 and SharePoint are utilized for day-to-day workflow, collaboration, and departmental approval, while an identical, cryptographically hashed SHA-256 copy is mirrored into Paperop's secure sovereign cloud vault, where WORM retention locks guarantee complete legal immutability and instant 1-click audit dossier export.

5. Comparative Workflow Matrix: Manual AP vs. Automated SharePoint Ingestion

Workflow Stage Traditional Manual Scan-and-Upload Paperop Automated M365 Pipeline
Invoice Ingestion & Prep Paper scanned to personal email; digital PDFs saved to local desktops. Multi-channel automated ingestion; instant image clean-up and barcode page splitting.
VAT & Data Extraction Manual typing of 10-digit VAT, dates, and amounts into ERP and spreadsheets. Zero manual typing: AI extracts VAT, line items, and totals with 99.8% precision.
SharePoint Tagging & Filing Inconsistent manual folder placement; generic unindexed file names. Automated Graph API injection: custom columns populated, auto-filed by supplier/date.
Approval Routing Forwarding PDF email chains; invoices lost in manager inboxes. Automated Power Automate flow with 1-click adaptive approval cards in Microsoft Teams.
SARS 5-Year Audit Trail Files can be overwritten or edited; weak chain-of-custody logs. ECT Act certified WORM storage with cryptographic SHA-256 tamper logs.
Average Processing Cycle 5 to 12 working days per invoice from receipt to approval. Under 4 hours: real-time ingestion, extraction, and approval notification.

6. Step-by-Step Implementation Blueprint

Deploying automated invoice routing into your Microsoft 365 environment does not require disruptive overhaul. Follow this structured 4-step deployment methodology:

  1. Step 1: SharePoint Document Library Schema Setup: Create a dedicated document library in your Finance SharePoint site. Define managed metadata columns: SupplierName (Text), InvoiceNumber (Text), InvoiceDate (Date), VATNumber (Text), GrossAmountZAR (Currency), and ApprovalStatus (Choice).
  2. Step 2: Microsoft Graph API Authentication: Register an enterprise application in Microsoft Entra ID (formerly Azure AD). Grant application permissions for Files.ReadWrite.All and Sites.Selected, securing credentials with secret key rotation.
  3. Step 3: Paperop Capture Pipeline Configuration: Configure Paperop's extraction engine to map extracted South African tax fields to your custom SharePoint columns. Enable webhook notification triggers for Power Automate.
  4. Step 4: Power Automate & Teams Flow Activation: Build a cloud flow triggered by new document creation in the library. Configure conditional logic routing invoices based on department or expenditure threshold to departmental Microsoft Teams channels.

Frequently Asked Questions (FAQ)

Intelligent Document Processing (IDP) utilizes computer vision and transformer language models to locate, extract, and normalize key tax fields required under Section 20 of the South African VAT Act No. 89 of 1991. The AI extracts the 10-digit supplier and recipient VAT numbers, invoice date, sequential invoice number, line items, 15% VAT breakdown, and total due, formatting the output into structured JSON payloads for downstream ERP integration.

By default, standard SharePoint document libraries allow users with edit permissions to modify, check out, overwrite, or delete documents, which violates the immutability requirements of Section 29 of the Tax Administration Act and Section 14 of the ECT Act. To achieve SARS compliance, organizations must either configure strict Retention Labels with Preservation Hold Policies, or deploy a hybrid architecture where active approvals run through Microsoft 365 while immutable WORM copies are archived in Paperop's sovereign cloud vault.

Following high-speed scanning and AI metadata extraction, Paperop generates a sanitized, searchable PDF/A-1b file. Using secure Microsoft Graph API connectors with OAuth 2.0 authentication, the file is transmitted directly into the designated SharePoint site library, automatically populating custom SharePoint columns (Supplier Name, Invoice Number, Invoice Date, Total ZAR) and triggering automated Power Automate approval flows.

No expensive dedicated server hardware is required. Organizations can utilize existing commercial multi-function network printers (MFPs) configured with dedicated scan-to-FTP/SFTP or cloud endpoints, high-speed desktop document scanners, or outsource heavy historical backfile invoice scanning entirely to Paperop's capture bureau.

Paperop exports searchable PDF/A files along with structured JSON metadata (Supplier, VAT Number, Invoice Date, PO Number, Total) that maps directly into custom SharePoint columns and metadata term stores. Industrial production scanners operate at 300 to 600 DPI optical calibration with automatic deskew, blank-page filtering, and AI visual layout profiling, extracting key metadata with over 97% automated capture accuracy into searchable ISO-standard PDF/A formats.

Yes. When Paperop ingests an invoice into a SharePoint library or Blob container, a Power Automate flow triggers automated approval routing, 3-way matching, and manager notifications. Industrial production scanners operate at 300 to 600 DPI optical calibration with automatic deskew, blank-page filtering, and AI visual layout profiling, extracting key metadata with over 97% automated capture accuracy into searchable ISO-standard PDF/A formats.

Our automated invoice processing engine performs automated multi-point verification matching Supplier VAT Number, Invoice Number, Purchase Order Reference, and Total Gross Amount against historical database records. If a potential duplicate or overlapping invoice submission is detected, the system immediately flags the transaction for manual review, preventing costly double-payments.

Yes, provided the SharePoint repository or Azure storage applies retention policies preventing deletion for a minimum of 5 years, in compliance with Tax Administration Act Section 29. All procedures adhere to strict South African statutory standards, including POPIA Condition 7, the Companies Act 71 of 2008, and the Electronic Communications and Transactions Act, providing enterprise clients with transparent Service Level Agreements and audited operational security.

Paperop utilizes AI visual layout profiling rather than rigid zonal OCR templates. The artificial intelligence engine analyzes the structural anatomy of the document (identifying tabular line items, subtotal blocks, VAT rates, and corporate headers) to accurately extract key-value financial pairs regardless of font, layout variations, or shifting invoice designs.

Our multi-pass digitisation engine combines high-resolution optical character recognition (OCR) for machine-printed text with intelligent character recognition (ICR) for handwritten annotations. The engine captures handwritten supervisor sign-offs and rubber approval stamps while preserving the original high-resolution visual impression for audit verification.

Ready to Connect Scanning to Microsoft 365?

Partner with Paperop to automate invoice ingestion, eliminate clerical data entry, and establish an audit-proof SharePoint document architecture.

Book Microsoft 365 Integration Demo
Integration Services
Related Technical Guides
Custom Power Automate Connectors

Our systems engineers build and test custom Microsoft Graph connectors tailored to your exact SharePoint architecture.

Speak to Systems Integrations
*Errors and Omissions Excepted (E&OE). Content is provided for informational purposes and may be compiled with automated tools. By using this site, you accept our terms and conditions.