Tools & solutions
Microsoft Lens Alternative for Expense Reports: A OneDrive Folder Is Not Accounting
Every month, thousands of freelancers and small team managers do the same thing: they open Microsoft Lens, photograph their restaurant receipt, their fuel slip, or their hotel bill, and send everything to a neatly organized OneDrive folder. Fast. Clean. Free. The satisfying feeling of having handled it.
Then comes the end of the quarter. The VAT return deadline approaches. And that's when the OneDrive folder reveals its true nature: it's a silent gallery of images. No amounts come out of it. No broken-down VAT. No expense categories. Just 130 JPEG files opened one by one, for hours, to manually reconstruct what a proper tool would have produced automatically.
This isn't a discipline problem. It's a tool problem.
What Microsoft Lens Actually Does — and What It Doesn't
Microsoft Lens is a remarkably well-designed pocket scanner. It corrects perspective, improves readability, integrates natively into the Microsoft 365 ecosystem, and syncs your documents to OneDrive or SharePoint within seconds. For digitizing a whiteboard in a meeting, archiving a paper contract, or dematerializing a filing cabinet full of administrative documents, it's an excellent tool.
But an expense report is not an archiving document. It's accounting data. And that's where the comparison ends.
Lens's OCR Is Not Accounting-Grade OCR
Microsoft Lens does include text recognition (OCR). It can extract words and figures from a receipt and save them to a Word or OneNote file. But this extraction is raw, unstructured, and above all not accounting-ready. The app cannot distinguish the VAT-inclusive total from the net amount. It doesn't know the VAT rates applicable in France — 20%, 10%, 5.5%, 2.1%. It doesn't identify the expense category: business meal, travel, office supplies, SaaS subscription.
The result: even if Lens "reads" your receipt, the data it produces cannot be injected into accounting software, transmitted to an accountant in a usable format, or integrated into a VAT return. You end up in exactly the same situation as with a shoebox of receipts: you have the documents, but not the data.
OneDrive as a Final Destination: A False Sense of Security
The Lens-to-OneDrive integration is smooth and reassuring. Files are organized, timestamped, accessible from all your devices. It feels comfortable. But comfort and accounting compliance are two very different things.
A fiscal receipt is not just a readable image. In the eyes of the French tax authorities and social security bodies (URSSAF), a receipt must be associable with a precise accounting transaction: a date, a supplier, a net amount, a VAT rate, and an expense category. A JPEG stored in OneDrive is not, by itself, a usable accounting document. It merely shows that a purchase occurred. It doesn't prove its fiscal nature or its deductibility.
The Reality for Office 365 Freelancers at Quarter-End
Let's look at a concrete scenario. You're an independent consultant, operating as a sole trader or through a limited company. You use Microsoft 365 every day. You adopted Lens two years ago because it was the natural tool in that ecosystem. You have a OneDrive folder called "Expenses 2026" with monthly subfolders.
In March, you incurred 43 professional expenses. Client lunches, train tickets, software subscriptions, office supply purchases. Each one was carefully photographed with Lens. At quarter-end, to file your VAT return and prepare the year-end review with your accountant, you need to reconstruct:
- The net amount of each expense
- The applicable VAT rate for each line
- The accounting category (personnel costs, travel expenses, goods purchases…)
- The total reclaimable VAT broken down by rate
With Lens and OneDrive, none of this data is available automatically. You open each image. You read the receipt. You manually type into an Excel spreadsheet. Forty-three times. Then you check. Then you correct the typos. Then you send the file to your accountant, who also has to validate every single line.
This is precisely what's called manual data entry. And it's exactly what modern accounting tools are supposed to eliminate.
The Special Case of Mileage Claims
Things get even more complicated with mileage expenses. The mileage allowance scale set by the French tax authority varies depending on the vehicle's fiscal horsepower rating and the total distance driven during the year. No receipt mentions these figures: they must be calculated, documented, and justified separately.
Lens doesn't handle mileage claims. OneDrive doesn't calculate them either. And without this data properly integrated into the expense report, the freelancer can neither deduct them correctly nor defend them in the event of a URSSAF audit.
Why Microsoft Ecosystem Integration Isn't Enough
It would be unfair to blame Microsoft Lens for not doing something it was never designed to do. It's a document scanning tool, not an expense management application. The problem is that its integration into Office 365 creates an illusion of a complete solution.
Microsoft ecosystem users are accustomed to tools that work seamlessly together: Teams with Outlook, SharePoint with OneDrive, Excel with Power BI. It's therefore natural to assume that Lens + OneDrive equals expense management. This is a category error. Digitizing a document is one step. Accounting for an expense is another, fundamentally different one.
What a Real Accounting OCR Tool Produces
A genuine accounting OCR tool doesn't just read a receipt. It analyzes it. It identifies the VAT-inclusive total, derives the VAT at the applicable rate, calculates the net amount, and assigns the expense to an accounting category. It produces an accounting line — that is, a structured entry with all the fields needed for entry into a general chart of accounts or for export to accounting software.
It also preserves the attached receipt: the image of the ticket is linked to the accounting line, not stored separately in a folder. Your accountant can access both the receipt and its accounting transcription with a single click, without ever opening a OneDrive folder.
That's the difference between archiving and accounting.
CSV Export as the Bridge to Your Accountant
Most accountants work with software that accepts imports in CSV export format or in FEC format (French Accounting Entries File). Lens produces neither. Neither does OneDrive.
A proper expense management tool generates, from the photographed receipts, a structured file ready for import. Sending data to the accountant is then reduced to sending a single file. Not a folder of images. Not a manually filled-in spreadsheet. A clean, structured, compliant file.
The Criteria for a Real Microsoft Lens Alternative for Expense Reports
When looking for a Microsoft Lens alternative for expense reports, the goal is not to find another pocket scanner. It's to find a tool that covers the entire process — from taking the photo to producing the accounting line. Here is what that alternative must absolutely offer.
Automatic VAT Extraction, Broken Down by Rate
This is the most discriminating criterion. In France, multiple VAT rates can coexist on the same receipt. A restaurant bill may combine 10% (food) and 20% (alcohol). A supermarket purchase may mix several rates depending on the products. The tool must be able to identify and separate these rates automatically, without manual intervention.
Expense Categorization
Each expense must be associated with an accounting category: business meals, accommodation, transport, office supplies, phone, subscriptions… This categorization must be automatically proposed by the OCR and confirmable or adjustable with a single gesture. This is what makes it possible to produce a deductible expenses report that's immediately usable.
Mileage Management
The tool must integrate the current mileage allowance scale, allow the user to enter the route, distance, and the vehicle's fiscal horsepower rating, and automatically calculate the amount of the deductible allowance. These expenses must integrate into the same report as all other costs.
Receipt Attached to the Accounting Line
Every accounting line must be linked to the scanned receipt. This link must be permanent and accessible to the accountant. It guarantees traceability in the event of a tax or URSSAF audit.
Export to Accounting Tools
The tool must allow a CSV export or FEC-compatible file for the main accounting software packages (Sage, Cegid, EBP, QuickBooks…). The goal is to reduce the accountant's data entry work to zero.
ScanCompta: The Same Simplicity of Capture, Actionable Accounting Output
This is precisely what [ScanCompta](https://scancompta.eu) offers. You photograph your receipt exactly as you would with Microsoft Lens. The difference happens in the second that follows: instead of creating an image file in a OneDrive folder, ScanCompta analyzes the receipt, extracts the VAT-inclusive total, identifies the applicable VAT rate, calculates the net amount, suggests an expense category, and creates a complete accounting line — with the receipt attached.
At the end of the quarter, you no longer open any images. You export a structured file, readable by your accountant or directly importable into your accounting software. Filing your VAT return takes minutes, not hours. And in the event of a tax or URSSAF audit, every expense is traceable, documented, and justifiable down to the line.
ScanCompta is built for freelancers and small teams who want to keep the simplicity of a quick scan without sacrificing accounting rigor. No training required. No need to change your photo-taking habits. Just a data output that is, finally, usable.
What You Should Take Away
A OneDrive folder filled with Microsoft Lens images is not accounting. It's an archive. The distinction is fundamental, and it has a real cost: hours of manual data entry every quarter, risks of error on recoverable VAT, and a handover to the accountant that looks more like a treasure hunt than a smooth process.
The real Microsoft Lens alternative for expense reports isn't another scanner. It's a tool that transforms every receipt into immediately usable accounting data — with VAT broken down by rate, the expense category, the attached receipt, and an export ready for your accountant. That's exactly what ScanCompta does.
*Legal notice: The tax and accounting information contained in this article is provided for informational purposes only and reflects French regulations in force as of September 10, 2026. It does not constitute personalized tax or legal advice. Consult a certified accountant or tax advisor for any decision relating to your specific situation. VAT rates, mileage allowance scales, and deductibility rules may change. Always verify current figures with official sources (impots.gouv.fr, urssaf.fr).*
The stray-receipt challenge
Curious how the AI handles it? Take a photo of the receipt lying on your desk and test the extraction in 2 seconds, no account needed.
Try the scan live
No account needed. Nothing is stored.
No account needed. Nothing is stored.
Test ScanCompta's OCR with your own receipts
Snap a crumpled receipt, a fuel invoice or a restaurant bill: the AI extracts the date, the amount and the VAT in two seconds. 5 free scans a month, no card required.
About the author
M. Pierre, founder of ScanCompta
M. Pierre is the founder of ScanCompta. A former small-business owner, he has spent over ten years working on expense receipt collection and compliance for French freelancers and small companies.
Learn more about ScanComptaQuestions & comments
A question about this guide? Ask below — I answer personally within one business day.
- J
Julien
If I lose a €9 toll receipt, can I still claim it with just a bank statement?
ScanComptaAuthorYes — for a small amount, a bank statement plus a signed statement is usually accepted. You cannot reclaim VAT without the original receipt though.
- S
Sonia
Do I need to keep the paper receipts after scanning them with your app?
ScanComptaAuthorNo. If the scan is a faithful and durable copy, the digital version is enough. We store everything for 10 years for you. Order of 22 March 2017 on reliable copies