Intelligex Logo
Intelligex Logo
Get A Consultation

Finance & Accounting

Bank Reconciliation with Excel Power Query and Power Automate

23 July 2026|

A finance team replaced spreadsheet-by-spreadsheet transaction matching with standardized Excel imports, deterministic Power Query matching, controlled fuzzy suggestions, exception review, and Power Automate approvals. The resulting process retained QuickBooks Online while adding clearer ownership, repeatable controls, and durable reconciliation evidence.

Three-Way Invoice Matching with Microsoft 365

23 July 2026|

A fictional industrial distributor replaced manual invoice comparisons with a controlled three-way matching workflow. Microsoft Forms captures invoices and receipts, SharePoint holds the records and evidence, Power Automate applies matching rules, and Microsoft Teams coordinates exceptions and approvals.

Planning Contract Renewals with SharePoint and Power Automate

22 July 2026|

A facilities services firm needed to stop vendor agreements from renewing without review. The implemented workflow combines Microsoft Forms, SharePoint, Power Automate, and DocuSign to schedule reviews, assign owners, document decisions, obtain signatures, and archive executed terms.

Validating Procurement Savings with Finance in Google Workspace

22 July 2026|

A fictional industrial distributor replaces disconnected savings spreadsheets with controlled submissions, evidence folders, finance approvals, reminders, and transparent realized-savings calculations built with Google Forms, Sheets, Drive, and Apps Script.

Automating Vendor Onboarding with Airtable, Forms, and Make

21 July 2026|

A growing facilities services provider replaced email-based vendor onboarding with structured intake, document collection, approval tasks, reminders, and completion evidence across Google Forms, Airtable, Make, and Gmail. The resulting workflow gave Procurement, Finance, Legal, and IT one consistent process while retaining human control over sensitive decisions.

Purchase Requests with Budget, Security, and Legal Review

21 July 2026|

An 85-person consulting firm replaced incomplete emailed purchase requests with structured intake, controlled records, conditional approvals, document folders, reminders, and status reporting across Google Workspace. The implementation preserved human authority over spending, security, legal, and procurement decisions.

Automating Customer Credit Limits and Review Dates

21 July 2026|

A fictional equipment distributor replaced email-based credit approvals with an Airtable workflow connected to Xero, Zapier, and Google Drive. The implementation centralizes applications, documents, approval evidence, exposure exceptions, expiry dates, review reminders, and operational reporting while leaving every credit decision with authorized employees.

Transparent Sales Commission Calculations and Approvals

20 July 2026|

A technical services company replaced manual commission reconciliation with a version-controlled calculator connecting Salesforce, Google Sheets, Make, Slack, and Google Drive. The implementation applies payment-based tiers, split credit, adjustments, approvals, exception handling, and audit records while keeping payout decisions under human control.

Connecting Project Milestones to QuickBooks Billing

20 July 2026|

A fictional equipment manufacturer connects milestone submissions, approval decisions, QuickBooks Online invoices, payment updates, disputes, and reminders. Google Sheets provides the operational register, n8n coordinates the workflow, Google Drive stores evidence, and Gmail delivers approval notices and invoice follow-ups.

Tracking Software Renewals with Airtable, Xero, and Zapier

20 July 2026|

An engineering consultancy consolidated scattered subscription records into an Airtable renewal register. Xero transactions and Google Drive contracts feed the register through Zapier, giving finance, procurement, and IT clear ownership, cancellation deadlines, usage reviews, exception alerts, and an auditable decision process.

Go to Top