Earlier articles from the Invoice Data Extraction blog.
Financial Documents
Convert Australian payslip PDFs into a clean Excel spreadsheet: map the Fair Work fields, super and PAYG, then extract YTD for payroll migration or back-pay.
Invoice Data Extraction
Convert Indian Bills of Entry from PDF to Excel — extract BCD, SWS, IGST, CTH and port code to build your import-IGST ITC register and landed-cost sheet.
Financial Documents
Extract South African municipal, Eskom and City Power bills to Excel — split rates, electricity, water and refuse per property for recharge and disputes.
Financial Documents
Turn South African payslip PDFs into a reconciliation-grade Excel — PAYE, UIF, SDL and ETI as separate columns, one row per employee per pay period.
Tax & Compliance
Build the GSTR-1 Table 12 HSN-wise summary from PDF sales invoices: extract HSN, UQC, quantity, taxable value and tax, then pivot and split B2B/B2C.
Invoice Data Extraction
Can AI invoice extraction do the math? See what it computes, what it can't, and how to get calculated and validated fields into your spreadsheet.
Invoice Data Extraction
Recover net and VAT from gross invoice totals in Excel using the reverse-VAT formula — with mixed rates and a check against the printed VAT figure.
Invoice Data Extraction
Use one reusable AI prompt to categorize a batch of invoices and receipts into your own expense categories, cost centers, and projects in a spreadsheet.
Financial Documents
Check your UK business energy bills for overcharges: unit rates, standing charges, VAT relief, CCL, estimated reads, and kVA capacity charges.
Financial Documents
Convert PDF financial statements — P&L, balance sheet, cash flow — into analysis-ready Excel, with multiple periods and entities in one consistent layout.
Financial Documents
Convert a multi-cardholder corporate card statement to Excel: attribute each transaction to its cardholder and allocate by employee, department, or GL code.
Financial Documents
Convert handwritten cash books and ledgers to clean, balance-verified Excel — preserve running balances and reconcile totals to the book's own figures.
Tax & Compliance
Извлечете контрагент, ЕИК/ДДС номер, дата, данъчна основа и ДДС от получените фактури в Excel за дневника на покупките по ЗДДС — без ръчно въвеждане.
Financial Documents
Turn multi-site energy bills into a consumption-and-cost spreadsheet: one row per meter per billing period with kWh, unit rates, and standing charges.
Invoice Data Extraction
Turn a consolidated fleet leasing invoice into a per-vehicle Excel sheet — split charge types and carry plate, driver and cost centre down each row.
Invoice Data Extraction
Convert handwritten invoices to Excel with AI extraction. How accurate handwriting OCR is, how to prep scans for legibility, and how to verify every figure.
Industry Guides
Extract Indian pharmacy stockist invoices to Excel: one row per line item with batch, expiry as a date, MRP, PTR, HSN and GST for purchase entry.
Industry Guides
Turn multi-currency FF&E and OS&E supplier invoices into a budget-reconciled hotel project cost spreadsheet, with landed cost and committed-vs-actual handled.
Software Integrations
Odoo won't import a PDF bank statement directly. Learn its supported formats (OFX, CAMT.053, CSV), the exact import path, and how to convert a PDF first.
Software Integrations
Import vendor bills into Odoo in bulk from Excel or CSV: the account.move template, External IDs, draft vs posted, and turning PDF bills into a clean file.
Tax & Compliance
Build Ireland's annual RTD from your invoices: classify a year of sales and purchases by VAT rate and resale vs non-resale, then reconcile it to your VAT3s.
AP Automation
Turn order acknowledgements into a PO-keyed spreadsheet and check them line by line against your purchase order — price, quantity, dates, and backorders.
Tax & Compliance
Jak z přijatých PDF faktur dostat data pro oddíl B.2 kontrolního hlášení do Excelu — DIČ, evidenční číslo, DUZP, základ a daň bez ručního přepisování.
Invoice Data Extraction
Total spend across a folder of PDF invoices: extract them into one sheet, then use SUMIFS and PivotTables to total by supplier, category, or date.