Bookkeeper for a contractor
The invoice PDF shows the total fine, but I need each line item in Excel for job costing. Typing them is killing my week.
Adobe export and online converters — they drop columns or merge cells wrong.
Each line item is its own row with description, qty, and amount.
Links open someone else's site. Read before you click.
Try 1
Posted by Casey
Used Tabula on the PDF table region, exported CSV, cleaned merged cells in Excel with a fixed template.
Link: Tabula
What you still do by hand: You pick the table area on each PDF layout once.
Cost: Free desktop tool.
Try 2
Posted by Morgan
Exported to Excel from Adobe, then ran a short cleanup sheet that splits combined cells into rows.
What you still do by hand: Cleanup sheet is yours to keep; run it after each export.
Cost: Adobe subscription if you use their export.
These examples are seeded so the desk is not empty on day one. When posting opens, your problem can look like this too.