Transform Excel & CSV Invoices into Compliant JSON in Seconds
Empower your business with automated spreadsheet transformation. Register your business, upload billing sheets, validate 12% VAT and customer TINs, and generate standardized BIR E-Invoice JSON formatted for tax compliance and API integration.
Live Interactive Transformation Playground
Toggle sample datasets to test real-time spreadsheet parsing and BIR-standard JSON generation.
| Inv # | Customer | Description | Gross | Tax Type |
|---|---|---|---|---|
| INV-2026-00101 | Apex Retail Holdings Inc. | Industrial Storage Racks | ₱75,000 | VATABLE |
| INV-2026-00101 | Apex Retail Holdings Inc. | Forklift Assembly Service | ₱25,000 | VATABLE |
| INV-2026-00102 | Pacific Ocean Freight Ltd. | Zero-Rated Inter-Island Charter | ₱84,000 | ZERO_RATED |
| INV-2026-00103 | St. Luke Healthcare Center | Medical Grade Pallet Trays | ₱35,000 | EXEMPT |
{
"schemaVersion": "2.1-BIR-EINV",
"documentHeader": {
"documentType": "SALES_INVOICE",
"invoiceNumber": "INV-2026-00101",
"issueDate": "2026-03-24",
"currency": "PHP",
"generationTimestamp": "2026-03-24T08:30:00.000Z",
"batchId": "BATCH-INV202600101"
},
"sellerInformation": {
"registeredName": "Metro Trading & Logistics Solutions Corp.",
"tradeName": "Metro Solutions PH",
"tin": "009-845-212-00000",
"branchCode": "00000",
"registeredAddress": "123 Commerce Avenue, Makati City, Metro Manila, Philippines",
"taxStatus": "VAT_REGISTERED",
"lineOfBusiness": "Wholesale & Freight Logistics"
},
"buyerInformation": {
"buyerName": "Apex Retail Holdings Inc.",
"buyerTin": "008-112-990-00000",
"buyerAddress": "Makati City Metro Manila"
},
"lineItems": [
{
"itemNumber": 1,
"description": "Industrial Storage Racks",
"quantity": 5,
"unitPrice": 15000,
"grossAmount": 75000,
"taxClassification": "V",
"vatAmount": 8035.71,
"netSales": 66964.29
},
{
"itemNumber": 2,
"description": "Forklift Assembly Service",
"quantity": 1,
"unitPrice": 25000,
"grossAmount": 25000,
"taxClassification": "V",
"vatAmount": 2678.57,
"netSales": 22321.43
}
],
"financialSummary": {
"totalVatableSales": 89285.72,
"totalVatAmount": 10714.28,
"totalZeroRatedSales": 0,
"totalExemptSales": 0,
"totalGrossSales": 100000,
"totalWithholdingTax": 1116.07,
"totalNetPayable": 98883.93
},
"auditCompliance": {
"tinVerificationChecksum": false,
"vatMathValid": true,
"validationStatus": "PASSED",
"engineVersion": "BIR-JSON-Engine-v2.1",
"digitalSignature": "SHA256-INV202600101-VERIFIED"
}
}Streamlined 3-Step Architecture
From Raw Spreadsheets to Validated Tax JSON
Register Your Business Profile
Provide your Registered Business Name, BIR TIN, 5-digit Branch Code, and Line of Business. Your account is provisioned with a secure, isolated panel.
Upload Excel or CSV Invoices
Drag and drop your spreadsheet exports from SAP, QuickBooks, Odoo, or manual Excel templates. Our engine auto-identifies columns and extracts line items.
Audit & Export JSON Package
Review mathematical reconciliations, inspect VAT breakdowns, and download single or bulk ZIP packages formatted to official BIR schema specifications.
BIR E-Invoice Features
Engineered for Accounting Precision & Compliance
Automated 12% VAT Breakdown
Deconstructs gross sales into net taxable amounts and output VAT with centavo-level rounding guarantees. Supports zero-rated and exempt line items.
TIN & Branch Code Validation
Verifies buyer and seller Tax Identification Numbers against standard 9 or 12 digit formatting rules, preventing rejected e-filing submissions.
Multi-Tenant PostgreSQL Architecture
Containerized PostgreSQL database ensures strict tenant isolation. Each registered business maintains its own conversion history and audit logs.
Batch Spreadsheet Processing
Upload workbooks containing thousands of invoice line items. The transformation engine clusters items by invoice number and computes batch summaries.
Standard JSON Schema Export
Generates validated, structured JSON payloads with seller metadata, customer information, detailed item matrices, and digital checksums.
Compliance Ready & CAS Compatible
Pre-formatted for Computerized Accounting System (CAS) audits and electronic tax records storage, saving weeks of manual conversion effort.
Ready to transform your business invoicing pipeline?
Register your business account now to get immediate access to your dedicated conversion panel, batch upload tools, and tax compliance history.