# How to cut manual data entry from invoices and pdfs on Mac for accountants in 2026

> Manual data entry from invoices and PDFs eats hours each week. Use Excel's Data from Picture, Preview column copy and a total check to cut it on Mac.

URL: https://www.lazur.app/for/accountants/problems/manual-data-entry-from-invoices-and-pdfs
Updated: 2026-11-08

Manual data entry from invoices and PDFs means retyping each number by hand. On a Mac, you can cut that work with tools you may already have. Excel's Data from Picture, Preview's column copy and a simple total check handle many of the common cases. This page covers what the work costs, why it keeps happening, and fixes you can use without buying anything.

## Quick answer

- Keying invoice data is slow, and the bigger cost is the checking that people skip.
- Excel's Data from Picture reads clean printed tables, but only if you have Microsoft 365.
- Preview's Option-drag column copy pulls tables out of text PDFs, and Preview comes with macOS.
- Power Query's From PDF option may be missing on Mac, so check your Data menu before you plan around it.
- Check totals against the PDF before anything posts, and follow your employer's rules on client data.

## What keying invoice and pdf data into software costs you

- **Hours each week.** Parseur's 2025 survey of 500 US professionals found more than 9 hours a week spent on manual data entry. The group covered operations, finance, administration, IT and customer support. The survey was run with QuestionPro, and the report comes from a vendor. Read it as a warning sign, not a precise measure for accountants.
- **Yearly cost per person.** The same report puts manual data entry at $28,500 per employee each year for American companies. That is an average across all professions, not a figure for accounting teams. Use it to make the case for a fix. Do not quote it as a measured payroll cost for your firm.
- **Payroll cost per hour.** BLS reports a median pay of $83,680 a year, or $40.23 an hour, for accountants and auditors in May 2025. Salary is only part of the cost of a team hour. Still, every hour spent keying is an hour not spent on review, close or client questions.
- **Errors and delays.** 50.4% of respondents said manual entry leads to costly errors, delays or lost opportunities. That is a perception measure, not an error rate. No study in this research measured how often accountants mis-key invoice data.
- **Cost per invoice in AP.** Ardent Partners' 2026 metrics, summarized by Basware, put one invoice at $2.67 for top-performing AP teams. All others pay $12.50, nearly 4.7 times as much. Those top teams also move 55.2% of invoices straight through, against 31.4% for the rest. These are accounts payable teams, so translate the numbers with care.
- **Burnout and people leaving.** An Illinois CPA survey by ICPAS, dated January 2024, drew on 433 employees and 449 employers. In the coverage reviewed here, too many hours or burnout was the second most cited reason for resigning. The article gave no percentages. Repetitive keying is not named as a cause in it.

## Why it happens

1. **Every vendor draws its own invoice.** Each vendor designs its own layout. Totals sit in different corners. Line items spread across one page or three. A tool that learns one layout struggles with the next. So you keep retyping, because the source changes every time.
2. **A PDF is not always a table.** Many PDFs look like tables but store text in separate boxes and drawn lines. A plain paste can merge columns or reorder them. A copy that looks fine on screen can still hide a shifted column. That is why a quick paste is not a full check.
3. **Scans and photos add a reading step.** A scanned invoice is a picture of text. Reading it needs OCR, and OCR can misread a 1 as a 7 or lose a decimal point. Phone photos add skew, glare and shadows. Each of those adds a check you did not plan for.
4. **Mac users have fewer import routes.** Microsoft documents From PDF under Data > Get Data > From File > From PDF. The page mentions a Windows framework and says nothing about Macs. A 2021 Microsoft thread says the option was missing on Excel for Mac. Without a clean import route, copy and paste becomes the default.
5. **Invoices arrive by email and stay there.** Invoices sit as attachments in an inbox. You download each file, open it, rename it and type from it. Nothing links the file to the row in your sheet. The trail of where a number came from is manual too.
6. **No matching step before entry.** Without a matching step, every invoice needs a full read from the top. Someone has to decide whether the amount is right, whether it was ordered and whether it arrived. The Ardent figures show how wide the gap is between teams that accept manual touch and teams that do not.
7. **No template, so each invoice starts blank.** Each month starts with a blank sheet. Column names drift. One month says Amount, the next says Total, and a third says Net. Filters break and totals miss rows. The fix is dull. The cost of skipping it shows up every month.

## How to fix it

- **Ask vendors for a usable copy.** Email each frequent vendor and ask whether they can send invoices as CSV or export them from their portal. Ask once, then note the answer for that vendor. You lose nothing if they say no, and a yes can end a lot of retyping.
- **Use Data from Picture only on clean tables.** If you have Excel for Microsoft 365, capture a clean printed table with ⇧⌃⌘4, then choose Data > Data from Picture > Picture From Clipboard. Crop tight and shoot head-on. Type anything the tool misreads. Skip it when a table is messy or handwritten.
- **Copy text columns with Preview.** Open the PDF in Preview. Choose Tools > Text Selection, hold Option while you drag down one column, then choose Edit > Copy. Paste into Numbers or Excel and check every column. Preview is already on your Mac.
- **Set one template and do not change it.** Build a single sheet with fixed columns: vendor, invoice number, date, net, tax, total, file name and checked. Keep the names and order the same. Save a blank copy and start every month from it, never from last month's file.
- **Check each total with a formula.** Add the line amounts with SUM, for example =SUM(C2:C40), and compare the result with the printed total. A gap means a missed line, a tax mistake or a typo. Fix the gap before the invoice goes into a report.
- **Name files from the invoice.** Rename each PDF with vendor, invoice number and date, in one pattern such as Vendor_InvoiceNumber_Date. Search by name when you need the source later. A clear name also helps a colleague find the file during review.
- **Batch invoices by vendor.** Work through all invoices from one vendor in one sitting. The layout stays fresh in your mind, so changes stand out. Look closely at any change in bank details or tax lines, because a layout shift can hide a real problem.
- **Spot-check a sample with a colleague.** Ask a second person to check a sample of entries, not every single one. Start with the largest totals and the first rows of the batch. Keep a short note of what they found, so you can see which errors repeat.

![Accountant reviewing invoice PDFs on a laptop before manual data entry from invoices and PDFs](https://images.lazur.app/content-images/problem/manual-data-entry-from-invoices-and-pdfs/manual-data-entry-from-invoices-and-pdfs-1-82d446.jpg)

- **$28,500** Average yearly cost of manual data entry per employee in US companies, all professions, vendor-run survey ([source](https://parseur.com/blog/manual-data-entry-report))
- **more than 9** Hours per week respondents said they spent on manual data entry, Parseur 2025 survey of 500 US professionals ([source](https://parseur.com/blog/manual-data-entry-report))
- **55.2%** Invoices the strongest AP teams in the Ardent 2026 study move straight through with no manual touch, versus 31.4% for all others ([source](https://www.basware.com/en/resources/ardent-partners-accounts-payable-metrics-that-matter-in-2026))
- **$2.67** Cost to process one invoice for the strongest AP teams, versus $12.50 for all others, Ardent 2026 data ([source](https://www.basware.com/en/resources/ardent-partners-accounts-payable-metrics-that-matter-in-2026))

## Where the time goes when you key an invoice

Most people think typing is the slow part. Often it is not. The slow part is finding the right value, typing it, and then checking it. One invoice can carry a vendor name, an invoice number, a date, several line items, tax and a total. Each field is a chance to slip.

Think of the job in three passes. First you find each value on the page. Then you type it into a sheet or a system. Last you compare what you typed with the PDF. Busy people skip that last pass. The skipped pass is where the expensive mistakes hide.

## Try Excel's Data from Picture on clean tables

Excel for Microsoft 365 can read a table out of a picture. Microsoft's help page gives the Mac route. Press ⇧⌃⌘4 (Shift, Control, Command and 4) and drag a box around the table. Then go to Data > Data from Picture > Picture From Clipboard.

If the table is already a saved image or a scan file, use Data > Data From Picture > Picture From File instead. The page says to include only the data you want. It says to crop tight and shoot head-on, not at an angle. Those habits give Excel a cleaner image to read.

1. Open the PDF in Preview and zoom until the table fills most of the window.
2. Press ⇧⌃⌘4 and drag a box around only the table.
3. In Excel, choose Data > Data from Picture > Picture From Clipboard.
4. Read what Excel pulled in, row by row, before you keep it.
5. Compare the totals with the PDF before you use the sheet.

> **Check your version first:** Data from Picture is listed for Excel for Microsoft 365. The help page gives no minimum macOS version. An older or perpetual license may not include the feature. Look under the Data menu before you build a workflow around it.

The same page does not mention handwriting. Its language list covers English and several European languages. If your invoices are handwritten, test one first. Expect to type those values by hand.

## Copy a table out of a text PDF in Preview

Many invoices are text PDFs, not pictures. For those, Preview often beats a screenshot. Apple's guide says to choose Tools > Text Selection, drag across the text, then choose Edit > Copy. Preview ships with macOS, so there is nothing to install.

- To copy one column of a table, hold Option while you select it.
- To copy part of a page as an image, use Tools > Rectangular Selection.
- Paste into Numbers or Excel, then check each column before you trust it.

Pasted tables break in predictable ways. Amounts can land in one cell with the currency symbol attached. A long description can wrap onto the next row. Fix those before any formula runs, or the formula will quietly give wrong answers.

| Method | Works best for | What you need | Watch out for |
| --- | --- | --- | --- |
| Data from Picture | Clean printed tables | Excel for Microsoft 365 | Crop tight, shoot head-on |
| Preview text selection | Text PDFs with real columns | Preview, included with macOS | Columns can merge when pasted |
| Typing by hand | Scans, handwriting, odd layouts | Nothing extra | Slow, and typos hide in plain sight |
| Vendor export | Vendors who can send CSV or portal data | A vendor who will send one | Ask first, it is the cleanest route |

_Pick the method by the document, not by habit._

## Power Query and From PDF on a Mac: check before you plan

Power Query is Excel's import tool. Microsoft's import page gives the PDF route as Data > Get Data > From File > From PDF. The page mentions .NET Framework 4.5 or higher, which is a Windows framework. It does not mention Mac support either way.

> **Mac status unconfirmed:** A Microsoft Q&A thread from 2021 says From PDF is not available on Excel for Mac. The accepted answer says PDF is not a supported data type. The thread is locked, so it may be out of date. Check your own Data > Get Data > From File menu.

## Check the numbers before they leave your desk

Every entry needs a check against the source. The fastest check is the total. Add the line amounts with a formula such as =SUM(C2:C40), then compare the result with the printed total. A gap tells you something. It usually points to a missed line, a tax figure or a typo. For more formula help, see [Excel for accountants on Mac](https://www.lazur.app/for/accountants/excel).

- The line amounts add up to the printed subtotal.
- The subtotal plus tax equals the printed total.
- The invoice number has not appeared before for this vendor.
- The dates use one format across the whole sheet.
- The vendor name matches the name in your vendor list.

Duplicate invoice numbers deserve special care. A vendor may resend an invoice, or a second copy may arrive by a different email. A duplicate check takes little time, and it can stop a double payment before it starts.

## Build one template so every invoice lands the same way

Set up one sheet with the same columns for every invoice. Keep the set small. Vendor, invoice number, invoice date, net amount, tax, total, source file name and a checked column cover most needs. Keep the column names identical from month to month.

![Paper invoices spread on a desk, the source for manual data entry from invoices and PDFs](https://images.lazur.app/content-images/problem/manual-data-entry-from-invoices-and-pdfs/manual-data-entry-from-invoices-and-pdfs-2-e0e24f.jpg)

Numbers can hold a checkbox in each row, which makes review easy to track. See [adding a checkbox in Numbers](https://www.lazur.app/how-to/add-a-checkbox-in-numbers) for the steps. Keep one row per invoice. If an invoice has many lines, store the header data in one sheet and the line items in a second sheet. Link the two by invoice number.

## Edge cases that break a simple template

Credit notes show negative amounts. Keep the sign, or your totals will look right when they are not. Record the invoice each credit reverses in its own column. Foreign currency invoices need the exchange rate and its date on the same row.

Multi-page invoices often split a total from its line items. Read the last page before you enter anything. A PDF that holds several invoices needs a separate row for each one. Do not merge them into a single line.

## Mistakes people make with invoice data

- Pasting a whole PDF page into a sheet, then fighting the layout for an hour.
- Trusting an OCR result without looking at the source again.
- Saving files as invoice.pdf so nobody can find the source later.
- Skipping the total check because a batch looks routine.
- Typing a vendor name differently each time, which breaks filters and totals.
- Pasting client invoices into an online tool without checking your firm's rules.

## When a scan or photo is the only copy

Scans and phone photos need extra care. Data from Picture may read a clean scan, but Microsoft's page does not promise handwriting support. OCR is not perfect. This guide did not find an independent test of invoice OCR accuracy, so check every number you pull from an image.

For a single field on a bad scan, type the value by hand. Zoom in on the PDF and read it twice. If you have a second source, such as a vendor statement or a bank line, compare against it.

![Person typing numbers into a spreadsheet during manual data entry from invoices](https://images.lazur.app/content-images/problem/manual-data-entry-from-invoices-and-pdfs/manual-data-entry-from-invoices-and-pdfs-3-55e7d0.jpg)

## Client data rules come before any tool

Invoices often hold client names, bank details and addresses. Before you paste them into any tool, check your employer's rules. Some firms ban outside tools for client files. Others allow approved tools only. If you are not sure, ask before you start.

## How much manual touch is normal in accounts payable

The strongest public numbers on this topic come from accounts payable, not from accountants in practice. Ardent Partners' 2026 metrics, summarized by Basware, compare the strongest AP teams with the rest. The gap is wide. It shows how much manual touch some teams accept. Treat the figures as a sign of the gap, not a target for your firm.

## Where Lazur helps, and where it does not

Lazur is a voice assistant for the Mac. Hold ⌥⌘ and ask about anything on screen. Lazur answers out loud and points at things. It does not click buttons, edit files or operate other apps for you. It will not turn a PDF into a table on its own.

Lazur is most useful as a guide. Ask where Data from Picture lives in Excel, and Lazur draws a circle and a label around the menu on your screen. Ask for steps through a task, and it guides you one click at a time, waiting for each click before the next.

Dictation is a smaller part of the product. Hold fn to dictate clean text at the cursor in any app. Dictating invoice numbers carries risk. Read every number back and check it against the PDF. You can test your own accuracy with the [dictation accuracy checker](https://www.lazur.app/tools/dictation-accuracy-checker).

On privacy, Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer you, and they are not stored. Content is never used to train AI models. A free trial starts when you first open the app, and no credit card is needed. Your firm's client data rules still come first. You can [download Lazur](https://www.lazur.app/download) to try it.

## If you change only one thing

Start with the total check. It costs nothing, and it catches many errors before they reach a report. Once that habit sticks, add the Preview copy method for text PDFs. Ask vendors for exports last, since those depend on other people's answers.

## With Lazur

Lazur is a voice assistant for the Mac that lives in the notch. Hold ⌥ ⌘ and ask; it sees your screen, answers out loud, points at buttons and walks you through apps. Hold fn to dictate. Free for 3 days, then $18/month: https://www.lazur.app/download

- “Where is Data from Picture in Excel?”: Lazur points at the Data menu so you can find Data from Picture yourself. (Points at it)
- “Walk me through copying one column from this PDF in Preview.”: Lazur guides you one click at a time, waiting for each click until the column is copied.
- “Where is Data from Picture in Excel?”: Lazur draws a circle and a label around the Data menu on your screen.
- “What is this number in the Tax column?”: While you hold ⌥⌘, Lazur looks at the screen and answers out loud.
- “Hold fn and dictate a note about this invoice.”: Dictation types clean text at the cursor in any app. Numbers still need a check against the PDF.
- “Draft a note asking this vendor for a CSV export.”: Lazur drafts the text. You read it, edit it and send it yourself.
- “Find which of my vendors list invoice export options.”: Background research runs in Lazur's own Chrome tabs and returns a summary and a report. Check every claim before you act.
- “Remind me Friday to check the invoice folder.”: Lazur adds the reminder to Apple Reminders, one of its everyday voice actions.

## A plan you can start this week

- **Day 1: Ask your top vendors for an export.** Email the vendors who send you the most invoices. Ask for CSV or portal exports. Note who says yes, and who does not reply.
- **Day 2: Set up one template sheet.** Build one sheet with fixed columns and a checked column. Use the same names every month. Save a blank copy and never edit it.
- **Day 3: Test Data from Picture and Preview.** Pick one clean printed invoice and one text PDF. Try both methods on each. Write down which one gave correct values, and which one needed fixing.
- **Day 4: Run one batch with a total check.** Enter one vendor's invoices into the template. Run the SUM check on each invoice. Log every mismatch and its cause.
- **Day 5: Review the week with a colleague.** Ask someone to spot-check a sample. Decide which method stays for next month. Store the working file wherever your firm's client data policy says.

## FAQ

### Can Excel for Mac pull data out of a PDF?

Yes, for some tables. Excel for Microsoft 365 has Data from Picture, which reads a table from a captured image. Power Query's From PDF option may be missing on Mac. A 2021 Microsoft Q&A thread says so, and it is locked, so check the Data menu on your copy.

### Does Data from Picture read handwritten invoices?

Microsoft's help page does not mention handwriting. It asks for cropped, head-on images and lists supported languages. Test one sample first. Type any value the tool cannot read clearly.

### Is copying from Preview faster than typing?

For text PDFs with real columns, it can save time. Use Tools > Text Selection, hold Option for a column, then choose Edit > Copy. Check the pasted columns before you trust them. Scans need typing, because a text selection needs real text.

### What is the fastest way to check an invoice?

Add the line amounts and compare the result with the printed total. Then check the invoice number, vendor name and date. Write the total formula once, and reuse it on every row of the sheet.

### Can Lazur fill in my spreadsheet for me?

No. Lazur points, guides, explains and drafts text. It does not click buttons, edit files or operate other apps for you. You enter the data. Lazur can explain the steps out loud while you work.

### Is it safe to put client invoices into an AI tool?

Check your employer's rules first. Lazur listens and looks at the screen only while you hold the shortcut. Audio and screenshots go to AI providers to answer you and are not stored. Your firm may still ban outside tools for client files.

### Do I need to buy anything to fix this?

No. The fixes in this guide use Preview, Numbers or Excel, and tools you may already have. Data from Picture needs Microsoft 365. Vendor exports depend on the vendor saying yes.

### How do I handle credit notes in a total check?

Enter them as negative amounts and keep the sign in the total formula. Record the invoice each credit reverses in its own column. Check that the net of the invoice and its credit matches what you expect.

### Why does my total still not match the PDF?

Look for a missed line, a tax figure in the wrong column, or a decimal point typed in the wrong place. Recheck against the PDF, not a copy you made earlier. If the gap remains, ask the vendor.

## Sources

1. [Insert data from picture: Microsoft Support](https://support.microsoft.com/en-us/excel/insert-data-from-picture), Microsoft, checked 2026-11-08
2. [Import data from data sources (Power Query): Microsoft Support](https://support.microsoft.com/en-us/excel/import-data-from-data-sources-power-query), Microsoft, checked 2026-11-08
3. [Power Query on Mac, Get File to PDF, Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/5116197/power-query-mac-get-file-pdf), Microsoft Q&A, checked 2026-11-08
4. [Select and copy text in a PDF in Preview on Mac: Apple Support](https://support.apple.com/guide/preview/select-and-copy-text-in-a-pdf-prvw1020/mac), Apple, checked 2026-11-08
5. [Manual Data Entry Costs U.S. Companies $28,500 Per Employee Each Year: Parseur](https://parseur.com/blog/manual-data-entry-report), Parseur (with QuestionPro), checked 2026-11-08
6. [Ardent Partners' Accounts Payable Metrics that Matter in 2026: Basware](https://www.basware.com/en/resources/ardent-partners-accounts-payable-metrics-that-matter-in-2026), Basware (summarizing Ardent Partners), checked 2026-11-08
7. [Accountants and Auditors, Occupational Outlook Handbook](https://www.bls.gov/ooh/business-and-financial/accountants-and-auditors.htm), U.S. Bureau of Labor Statistics, checked 2026-11-08
8. [Illinois CPAs spot numerous issues with accountant retention: Accounting Today](https://www.accountingtoday.com/news/illinois-cpas-spot-numerous-issues-with-accountant-retention), Accounting Today, checked 2026-11-08