Cosmovex/tools

Convert a services invoice with hours and rate columns to Excel

Hours and rate invoice with Invoice to Spreadsheet

This page opens with a fictional services invoice whose columns are Hours, Rate and Amount instead of Qty and Unit price. Drop your own PDF to get one row per task, with hours in the Qty column and the rate in Unit price.

  1. Tap Choose a PDF and pick the services invoice as a text PDF.
  2. Check that Hours landed in the Qty column and Rate in Unit price.
  3. Read the amounts: hours times rate should equal each amount, and any line where it does not is flagged.
  4. Check the totals line under the invoice card.
  5. Download Excel for your timesheet or client records.
freelance invoice pdf to excel hourly invoice to excelhours and rate invoice pdfservices invoice to spreadsheetcontractor invoice to excel
Open Invoice to Spreadsheet Free to start · no account

What to know

Services invoices name their columns differently: Hours or Hrs instead of Quantity, Rate instead of Unit price. The tool recognises those titles, so a line such as Website design, 12.5 hours at 80.00, becomes a row with 12.5 in Qty, 80 in Unit price and 1,000.00 in Amount. Fractions of an hour are kept exactly as printed.

Because the arithmetic is checked, a typo shows up: a row where hours times rate does not match the amount is flagged with the reason. Discounts or tax included in an amount can legitimately break that, so the flag is a prompt to look, not an error. It adds up the lines and compares them with the subtotal, then compares subtotal plus tax with the total; a mismatch is shown to you and nothing is changed.

Free reads one invoice at a time, the first 3 pages, up to 15 line items per export and 3 exports a day, which is enough to try the tool on a real invoice. Pro merges many invoices into one sheet, reads up to 30 pages per invoice and removes the line and export limits.

Updated · Cosmovex

Questions

Does it recognise Hours, Days or Units as quantity?

Hours, Hrs, Units, Qty, Quantity and Pcs are recognised as the quantity column. Rate, Price, Unit cost and Unit price are recognised as the unit price. A column with an unusual title may need the text edited in the sheet.

Are fractions of an hour kept?

Yes. 12.5 stays 12.5. Quantities are read as numbers, not rounded.

What if my invoice has no Hours column?

A table with a Description and an Amount column is enough. Quantity and unit price are filled in only when the invoice has them.

Is my invoice uploaded?

No. It is read in your browser tab and only anonymous usage counts are sent.

The free plan covers everything on this page. Invoice to Spreadsheet Pro ($9/mo, billed monthly) is described on the Invoice to Spreadsheet page.