Eliminate Manual Data Work with Custom Sheets, Scripts & Reporting
I design and implement automated payment reconciliations, SQL reporting, internal CLI/GUI tools & sites, custom Google Sheets, and Google Cloud infrastructure consultations for SME's.
Software Stack & Tools
Language Stack
Specialized Services That Remove Manual Work
Fixed-scope builds across Google Sheets, Apps Script, SQL reporting, dashboards, GCP and Workspace — each delivered with documentation and 30-day post-delivery support.
Custom Spreadsheets (Google Sheets)
Bespoke Google Sheets built for your team — advanced formulas, clean formats, custom dashboards and data-entry controls that prevent errors before they reach your bottom line.
- ✓Advanced QUERY & FORMULA modeling
- ✓Dynamic inventory & financial statement sheets
- ✓Data validation & access permissions
Apps Script & Payment Reconciliation
Automated multi-channel reconciliation that pulls payouts from Peach Payments, Payfast, Ozow and bank APIs straight into Google Sheets — matched, netted and flagged automatically.
- ✓Automated bank payout vs invoice auto-matching
- ✓Micro-discrepancy & gateway reconciliation
- ✓Scheduled reports & PDF generators
Data Dashboards & Visualisation
Executive reporting dashboards in Data Studio, Sheets or custom web components — live visibility into the metrics you actually make decisions on.
- ✓Live metric tracking
- ✓Cross-source data blending (Sheets + SQL)
- ✓Responsive interactive charts & filter controls
SQL Scripting & Custom Reports
SQL querying, data-warehousing pipelines and reporting scripts for CloudSQL, MySQL and BigQuery — for when your spreadsheet has simply outgrown itself.
- ✓Aggregation & formatting functions
- ✓BigQuery scheduled query automations
GCP Administration & Consultations
GCP infrastructure managed properly — least-privilege IAM, serverless functions, and a bill that never surprises you. Advisory sessions available when you just need direction.
- ✓Cloud Functions & Cloud Run serverless deployments
- ✓IAM security
- ✓GCP cost optimization and solutions
Google Workspace Administration
Google Workspace set up, secured and run properly — security policies, domain routing, group delegation and the whole user lifecycle from onboarding to offboarding.
- ✓Admin SDK Apps Script user onboarding/offboarding
- ✓2FA security enforcement & DKIM/SPF/DMARC routing
- ✓Shared drives permission audits & data loss prevention
Automated Data & Reconciliation Pipeline
Google Sheets Ingestion
Google Sheets API v4
Apps Script Automation
Apps Script Engine
SQL & Data Warehouse
BigQuery / CloudSQL / Sheets
GCP Cloud Infrastructure
Cloud Functions & Triggers
Data Visualisation
Data Studio / Vue Chart
Step 2: Apps Script Automation
Custom Apps Script algorithms match bank payouts against order IDs, flag micro-discrepancies, and resolve currency adjustments automatically.
function reconcilePayments(bankRows, orderRows) {
const matchMap = new Map();
bankRows.forEach(row => {
const match = orderRows.find(o => o.refId === row.refId && Math.abs(o.amount - row.amount) < 0.01);
if (match) matchMap.set(row.id, { status: "RECONCILED", orderId: match.id });
else matchMap.set(row.id, { status: "DISCREPANCY_FLAGGED" });
});
return matchMap;
}Apps Script Payment Reconciliation Engine
Automate multi-gateway reconciliation (Peach, Payfast, Ozow, Bank Statements) directly within Google Sheets or in Scripts and rendered in Data Studio.
| Ref ID | Source Gateway | Order Amount | Bank Settlement | Gateway Fee | Reconciliation Status | Apps Script Resolution |
|---|---|---|---|---|---|---|
| TX-88401 | Peach Payouts | R1450.00 | R1407.95 | R42.05 | UNMATCHED | Pending Apps Script validation... |
| TX-88402 | Payfast | R890.50 | R860.20 | R30.30 | UNMATCHED | Pending Apps Script validation... |
| TX-88403 | Bank CSV | R3200.00 | R3200.00 | R0.00 | UNMATCHED | Pending Apps Script validation... |
| TX-88404 | OZow Payments | R512.00 | R497.14 | R14.86 | UNMATCHED | Pending Apps Script validation... |
Calculate Your Product & Service ROI
See how much time and money custom Apps Script reconciliations, Google Sheets automation, and SQL data pipelines will save your business annually.
Got Questions? Here Are Answers.
Ready to Automate Your Data and Reporting Workflows?
Book a 30-minute discovery consultation. We will audit your current data bottlenecks and outline a step-by-step automation blueprint.