Additional articles from the Invoice Data Extraction blog, organized into crawlable archive pages.
Come trasformare in Excel un lotto di fatture elettroniche XML: campi FatturaPA, righe articolo, riepiloghi IVA e metodi per studi.
Extract Airbnb and VRBO earnings summaries and 1099-Ks into Schedule E or C rows using the 7-day rule, classification, and host-side expense capture.
Extract ALTA Settlement Statements, HUD-1s, and Closing Disclosures into Excel rows for basis, prorations, credits, fees, and accounting import.
Extract Australian fuel invoices and receipts into BAS label 7D workpapers with rate-period splits, use categories, source references, and review checks.
Capture Australian meal entertainment receipts for FBT, compare 50/50, actual, and 12-week methods, and build defensible year-end workpapers.
Build a per-property Schedule E worksheet from rental receipts, invoices, Form 1098s, tax bills, and owner statements with review-ready source detail.
Guia prático para transformar recibos de vencimento em dados de apoio à DMR, com colunas, validações IRS/Segurança Social e reconciliação.
Fluxo para contabilistas: extrair campos dos recibos verdes de prestadores, aplicar a tabela de retenção IRS e alimentar DMR, guia e Modelo 10.
Guia pt-PT para transformar SAF-T-PT de Faturação em Excel com cabeçalho, linhas e resumo de IVA, pronto para análise e declaração periódica.
Guia para contabilistas processarem faturas de subcontratados com autoliquidação do IVA na construção, da triagem aos campos do Modelo P.
Turn a monthly BP Plus, StarCard, Shell Card, or WEX Motorpass statement into a per-vehicle, rate-period-split FTC spreadsheet for your BAS 7D claim.
Prepare Form 8027 from POS, payroll, and cash-tip records. Map each line, reconcile tips, test the 8% threshold, and document allocated tips.
Convert Hong Kong MPF statements, pay-records, and ABS PDFs to Excel for payroll reconciliation, eMPF cleanup, and audit support.
Extract CLP, HK Electric, Towngas, WSD, and HKT bills into Excel for Hong Kong SME bookkeeping, site tracking, and accounting import.
Track rehab receipts, closing statements, and holding costs by property so house flippers can build Schedule C inventory and COGS workpapers.
Convert HSBC Hong Kong statements to Excel or CSV: multi-currency Business Integrated Account PDFs, bilingual fields, and the Xero-feed-vs-extraction call.
Prepare landlord 1099-NEC rows from contractor invoices, W-9s, and payment records with thresholds, card exclusions, missing-data flags, and source references.
AP workflow for matching HVAC supplier invoices to purchase orders and delivery records — partial deliveries, part numbers, freight, and Canadian GST/HST.
Match steel mill invoices to goods received at line level, catching grade, weight, partial shipment, freight, and surcharge variances before payment.
When one invoice spans several PDF pages, extraction often breaks it into fragments. Learn the failure modes and what real multi-page invoice support must do.
Convert NAB bank statements to Excel or CSV. Covers NAB Internet Banking vs NAB Connect exports, PDF extraction, and Xero, MYOB, and QuickBooks import.
Use this employer-side 401(k) audit package checklist to gather plan documents, payroll support, census files, and reconciliations. Avoid follow-up requests.
Guide for airline finance teams to verify landing, parking, passenger, and terminal charges against flight records, tariff logic, and credits before payment.
Guide for promoters and agencies reconciling artist-fee invoices to contracts before payment. Check payee, deposits, deductions, withholding, support costs.