Blog

A Client’s Folder of Invoices Into One Spreadsheet

Published 18 November 2026. Where other products are mentioned we describe the kind of product and its pricing model, not figures, which change.

A client sends a folder: a year of supplier invoices, or every sales invoice they raised, as PDFs. You need it as one table you can total, check and hand back. This is how to get there without typing, and what to watch for when the folder is sales invoices and not purchases.

First, which way round are the invoices?

A folder of purchase invoices has many suppliers and one customer: your client. A folder of the client’s own sales invoices is the other way round. Every row has the same supplier, and the column that tells them apart is who each invoice was billed to.

That matters for the spreadsheet. Invoices to Spreadsheets records the customer on every invoice as well as the supplier, and the Customer column is in every Excel export. In the on-screen table it is hidden to begin with, because on purchase invoices it repeats; switch it on from Columns when the batch is sales invoices.

Upload the whole folder at once

Create a project for the client or the period and drop the folder in. Documents process independently, so one bad scan does not hold up the rest, and you can open the first rows while the others finish. A PDF holding several invoices is split into one row each.

Invoices billed by the hour or the day

Service businesses often print a quantity of 1, a day rate, and an amount worked out from the hours in the description. Quantity times rate will not equal the amount, and that is not an error. What matters is that the line amounts add up to the invoice net, and those invoices are treated as correct when they do.

Check the exceptions, then a sample

What to hand back

Export to Excel: one sheet with a row per invoice, one with a row per line item. Totals by customer or supplier, by month and by VAT rate are then a pivot table away, and the client can see every figure traced to a page.

Size of the job

The trial covers 50 documents over seven days with no card, which is enough to prove it on a real client folder. Beyond that, plans are monthly with a document allowance, so a one-off backlog does not need a year’s commitment.

Can it handle a client’s sales invoices as well as purchase invoices?

Yes. Each invoice records both the supplier and the customer it is billed to. For a batch of one business’s sales invoices, the Customer column tells the rows apart and is included in the Excel export.

How do I get a block of invoices into an Excel spreadsheet?

Upload the whole folder as one batch. Each invoice becomes a row in the same table, with its line items on a second sheet, and the table exports as one Excel or CSV file.

Why would quantity times unit price not equal the line amount?

Commonly because the unit price is a day or shift rate and the amount is worked out from hours stated in the description. If the line amounts add up to the invoice net, the amounts are correct as printed.

Can I keep each client separate?

Yes. Use one project per client or per period. Each project is its own table and its own export.

Start my free trial

7 days · 50 documents · No card needed

Try it on one invoice, no account needed · The full 14-tool comparison table · More guides · What Invoices to Spreadsheets is · Invoice to Excel