Drop in any general ledger PDF — QuickBooks, NetSuite, Sage Intacct, Xero, Microsoft Dynamics, or a printed PDF from a legacy ERP — and get a clean Excel file with account, date, memo, debit, credit, and running balance preserved. Multi-account GLs come back as one continuous sheet, account-tagged.
Auditors request general-ledger detail by account for the audit period. ERPs print to PDF cleanly but Excel exports break account hierarchy, lose subtotals, or come back as one giant text dump. Controllers reconciling between two systems (acquired company runs Sage, parent runs NetSuite) have one side of the comparison locked in PDF. Tax preparers rebuilding books from a client-printed GL trial face the same wall.
Generic PDF tools either flatten everything into one column or split account headers from the transactions below them. The structure that makes a GL useful — account hierarchy, opening / period activity / closing, debit-credit pairing — is exactly what generic tools lose.
PDFExcel reads GL detail by account, preserving hierarchy. Account number + name tag every transaction row. Date, journal entry number, memo, debit, credit, and running balance all extract as separate columns. Opening balance, period activity, and closing balance show up as labeled rows so the math checks. Multi-account GLs come back as one Excel sheet with an Account column rather than 100 separate tabs.
Drop the result into your audit workpaper, reconciliation spreadsheet, or analytical-procedure pivot. Pair with trial-balance extraction for cross-checking ledger detail against the balance summary. Pair with balance sheet and income statement extraction for full-suite financial-document reconstruction.
Trained on QuickBooks Online + Desktop, NetSuite, Sage Intacct, Sage 50, Xero, Microsoft Dynamics 365, Oracle Financials, and SAP GL exports. Account hierarchy and debit-credit pairing preserved — the math still ties on the Excel side.
Most GL reconciliation work happens in Excel. The bottleneck is getting the GL out of PDF without breaking account structure.
Account-tagged transaction-level detail with running balance preserved. Pivot by account for sub-ledger views; filter by date for period analysis; reconcile against trial balance.
| # | Account | Date | JE # | Memo | Debit | Credit | Balance |
|---|---|---|---|---|---|---|---|
| 1 | 1010 Cash — Operating | 02/01/2025 | OB | Opening Balance | $182,420.40 | ||
| 2 | 1010 Cash — Operating | 02/03/2025 | BR-1042 | Stripe payout | $8,420.00 | $190,840.40 | |
| 3 | 1010 Cash — Operating | 02/05/2025 | JE-2418 | Office lease — Feb | $3,200.00 | $187,640.40 | |
| 4 | 6010 Rent Expense | 02/05/2025 | JE-2418 | Office lease — Feb | $3,200.00 | $3,200.00 | |
| 5 | 1010 Cash — Operating | 02/15/2025 | BR-1058 | AWS infrastructure | $1,247.30 | $186,393.10 |
Audit associates pulling ledger detail for testing, controllers reconciling acquired-company GLs against parent ERP, bookkeepers rebuilding books from a client-printed GL trial.
Client provides GL detail as PDF (ERP locked-down to clients). Pull as Excel via PDFExcel, run analytical procedures, identify journal-entry outliers for testing in 1 hour vs the 4-hour manual rebuild.
Acquired company runs Sage; parent runs NetSuite. Pull acquired GL into Excel; map account hierarchy to parent COA; drive integration kickoff data.
Client lost QuickBooks file; only has printed GL. PDFExcel pulls GL into Excel; rebuild journal entries; restore books.
Yes. Account number + name tags every row. Multi-account GLs come back as one sheet with the Account column rather than separate tabs — pivot to sub-ledger view in one click.
QuickBooks (Online + Desktop), NetSuite, Sage Intacct, Sage 50, Xero, Microsoft Dynamics 365, Oracle Financials, SAP, and most legacy ERP exports. The model adapts to each ERP's specific layout (sub-totals position, opening-balance row format, account-header style).
Yes — opening balance + period activity (sum of debits − sum of credits, or vice versa per account type) = closing balance. We preserve all three rows; the SUM checks on the Excel side.
10 documents per month, free, forever. A typical audit pull is 1-3 GL PDFs (one per major account or one full-period GL) — fits the free tier for many engagements.
Yes. Drop 12 monthly GL PDFs as a ZIP, get back one Excel with all months — date-tagged so the period column drives time-series analysis. See batch processing for the broader workflow.