Additional articles from the Invoice Data Extraction blog, organized into crawlable archive pages.
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.
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.
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.
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.
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.
Check your UK business energy bills for overcharges: unit rates, standing charges, VAT relief, CCL, estimated reads, and kVA capacity charges.
Convert PDF financial statements — P&L, balance sheet, cash flow — into analysis-ready Excel, with multiple periods and entities in one consistent layout.
Convert a multi-cardholder corporate card statement to Excel: attribute each transaction to its cardholder and allocate by employee, department, or GL code.
Convert handwritten cash books and ledgers to clean, balance-verified Excel — preserve running balances and reconcile totals to the book's own figures.
Извлечете контрагент, ЕИК/ДДС номер, дата, данъчна основа и ДДС от получените фактури в Excel за дневника на покупките по ЗДДС — без ръчно въвеждане.
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.
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.
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.
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.
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.
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.
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.
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.
Turn order acknowledgements into a PO-keyed spreadsheet and check them line by line against your purchase order — price, quantity, dates, and backorders.
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í.
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.
Write a bank statement extraction prompt for statement fields, transactions, JSON-ready output, and balance checks that avoid current-vs-closing errors.
Learn how bulk invoice scanning turns many PDFs, scans, and images into structured data with batch intake, review, and export-ready output.
Convert Uber, Ola, and other Indian ride receipts into one Excel expense log with date, fare, GST, platform, and source-file fields.