Financial Documents
Heartland Merchant Statement to Excel: Extraction Guide
Extract Heartland merchant statements from InfoCentral into Excel. The Fee Summary anatomy, the spreadsheet schema for fee audit, and multi-month rollup.
Earlier articles from the Invoice Data Extraction blog.
Financial Documents
Extract Heartland merchant statements from InfoCentral into Excel. The Fee Summary anatomy, the spreadsheet schema for fee audit, and multi-month rollup.
Tax & Compliance
Learn which ARMS tariff fits a Maltese rental property, how to read the service type on the bill, and which Form H, F2, A, or R fixes errors.
Tax & Compliance
Malta VAT on landlord utility recharges to tenants: 5% on electricity, exempt on water, 18% on admin fees, or out-of-scope as a disbursement.
AP Automation
Anglo-Canadian AP guide to processing Quebec French supplier invoices: French field map, TPS/TVQ, place-of-supply rules, QST verification, QBO/Sage.
Industry Guides
Verify a UK plant-hire invoice under CPA Model Conditions: on-hire/off-hire dates, idle time, dilapidation, and plant-only vs plant-with-operator DRC.
Software Integrations
Ramp Bill Pay imports POs for matching from NetSuite, Sage Intacct, QuickBooks Online and Business Central. What it needs and how to match POs from other ERPs.
Industry Guides
Match the HICAPS daily settlement report to the bank deposit and PMS claims — multi-merchant splits, patient gap arithmetic, and Xero/MYOB posting for clinics.
AP Automation
Reconcile Malta ARMS bills across property entities with an Excel close workflow for owner coding, monthly accruals, tariff checks, and tenant recharges.
Industry Guides
Match Medicare and DVA payment reports to bank deposits, PMS claims, and Xero or MYOB postings, with exception queues for Australian allied-health clinics.
Industry Guides
Match WorkCover and CTP payment notices to allied-health invoices, catch short-paid claim lines, reconcile bulk EFTs, and post revenue in Xero or MYOB.
Invoice Data Extraction
Compare five invoice capture tools for small business by current pricing, setup, exports, line items, and best fit for lumpy volume or growth.
Industry Guides
Split a consolidated Sysco invoice into per-location GL postings across QuickBooks Online, Restaurant365, MarginEdge, Sage Intacct, and NetSuite.
Industry Guides
Construction AP guide to splitting one supplier invoice across multiple jobs — pick a split basis, keep job-cost fields on each line, protect reports.
AP Automation
See which supplier-invoice fields to capture for bookkeeping and AP, from header totals and line items to tax, matching, controls, and audit-trace fields.
Tax & Compliance
Compile a year of subcontractor invoices into a CRA-compliant T5018 listing. Covers the $500 threshold, the gross-inclusive box 22 rule, and filing options.
Tax & Compliance
Convert Telstra, Optus, TPG, or Vodafone Business bill PDFs to Excel - one row per service - so AU sole traders apply ATO work-use apportionment per line.
Industry Guides
How freight forwarders match carrier invoices to bookings and shipment evidence — the document trio, surcharge tolerances, and exception design.
Financial Documents
Guide to timely 401(k) contribution remittance: which dates auditors compare, how to set your earliest segregable date, and how to correct late deposits.
Financial Documents
Extract timesheet data from PDFs, scans, and handwritten time cards to Excel. Field maps for payroll prep, contractor billing, and project costing.
Industry Guides
Track UK subcontractor retention release across projects: per-package ledger, PC and defects-liability triggers, and the 2025 statutory disclosure.
Industry Guides
Build a property-management invoice tracker that follows vendor bills from receipt to approval, property allocation, payment, and owner reporting.
Industry Guides
England, Wales and Scotland QS workflow for assessing a subcontractor AfP: measurement, retention, CIS deductions, and issuing a defensible Pay Less Notice.
Tax & Compliance
Convert a year of Australian supplier invoices into the IAWO asset register your tax agent or accounting software needs, with line-level evidence ready.
Financial Documents
Convert BP Plus, Caltex StarCard, Shell Card, and Motorpass statements into one per-transaction spreadsheet with vendor-of-card, GST, and FTC review rows.