Hi, looking for tips on how-to or work-flow to get line item data on paper receipts into a spread sheet.
I’ve about 60 paper receipts from purchases I made at the local Do-It-Best hardware store, paid by debit card. I believe the store locally owned store. I’ve talked with them, but they didn’t seem to have a way to generate any kind of tabular file such as a csv, but I’m not sure I got an authoritative answer.
From my bank’s website, I have downloaded a CSV of the 60 transactions, and brought them into a spreadsheet. But the data is just the purchase summaries in 60 rows.
What I’d like is the purchase details … the prices and names of the items I bought. Home Depot lets you download such a file if you have a ProExtra account, which is free and available to anyone (create ProX account, enter credit card numbers, their system then populates your account with purchases from the past 25 months iirc)
Anyway, for the task at hand, The easiest way seems to be to start with a copy of the 60-row receipt summary spreadsheet. Duplicate row X to match the number of items on the receipt. Enter the line-item amounts and descriptions.
I’m not a touch typist so that will be a bit onerous. Any ideas on how to speed it up? make it less frustrating? …
I guess one way would be use one or another speech-to-text software. I don’t know of any. It’d need to be hosted on my desktop, preferably under Linux. I wouldn’t use a cloud service.
Or maybe someone knows how to get a CSV from Bo-It-Best corporate?
Or …
If you’ve read to this point, thank you, sorry it is so long.