FigureLane

Convert receipts and invoices to Excel

Freelancers and sole traders can turn receipts and sales or purchase invoices into one reviewed Excel workbook for their accountant. Upload in Documents, choose Income, Expenses or Mixed, and check the dates, totals, categories and business use against the originals. Download Excel (.xlsx), PDF or a ZIP with originals from Reports. Reports containing income include an income statement.

On this page

Prepare your first report with three documents

Start with one sales invoice and two expense receipts from your freelance or sole-trader business. Keep dates, descriptions, totals, categories and business use open beside the originals, correct uncertain readings, then download your first Excel or PDF from Reports. Check that the output suits your accountant before adding the rest of the month.

Keep clear originals for receipts, purchase invoices and sales invoices. Separate another business's files, and check each extracted date against its original. Choose a currency that matches your records; FigureLane does not convert amounts between currencies.

Choose Expenses for purchases and Income for sales once per upload batch. Use Mixed when they are together, then classify during review. An invoice can be a purchase or a sale: your choice supplies that direction rather than FigureLane guessing from the document type. You can correct individual records or exclude personal items while keeping the originals.

Use the Income and Expenses sections to find the relevant paperwork. The optional Document month filter follows the document date, even when an older receipt is uploaded this month. Choose Date to check for files whose dates still need attention.

What is in the Excel workbook?

The workbook includes financial records, a monthly summary and source links, alongside an income statement when income is included. Keep the original amount, selected category and business portion visible so another person can follow the figures. A rate you explicitly save in business settings can add an optional tax estimate.

  • Revenue and categorised business expenses
  • Profit before tax and monthly totals
  • Record dates, descriptions, signed amounts, currency and review status
  • Business-use percentages, business amounts, notes and source links

Worked example: three documents, no bank statement

Harbour Studio is a fictional sole-trader business preparing September 2026 records in GBP. This example includes an office-supplies receipt, a sales invoice and a phone-and-internet invoice. Download the PDF and Excel reports, source text and CSV below without an account.

The owner has reviewed the sources and chosen the categories and business-use percentages below. The 50% business portion is a fictional example. The preparation remains DRAFT while review is unfinished.

Source and dateChosen record type and categorySigned amount (GBP)Business useBusiness amount (GBP)
Paper & Co receipt, 5 SeptemberExpense · Office supplies-48.00100%-48.00
Harbour Studio sales invoice, 9 SeptemberIncome · Sales and services300.00100%300.00
HomeNet purchase invoice, 14 SeptemberExpense · Phone and internet-40.0050%-20.00

What the totals mean

The records contain GBP 300.00 of income and GBP 88.00 of expenses, a difference of GBP 212.00. Applying the business portions gives GBP 300.00 of business revenue, GBP 68.00 of business expenses and GBP 232.00 of profit before tax.

The income statement uses those business amounts. The reviewed records retain the original totals and business portions for your accountant to check.

  • Import the CSV into Excel, then check that dates and amounts are interpreted correctly.
  • Keep the Source and Note columns so the figures remain understandable.
  • Treat an unresolved direction, amount or match as review work, rather than guessing.
  • When a bank statement contains the same item, confirm its supporting-document match so the item is counted once.

Choose an output you can use

Download PDF for sharing or Excel for further work. Both include the income statement, monthly breakdowns and reviewed records. Expense-only reports and records CSV are available too. Choose a ZIP pack to keep reports and originals together.

The default Uploaded dates range spans the oldest to newest dated financial record across your business. You can also choose a month, calendar year, financial or tax year, or custom dates.

Start with the free sample

Create an account and verify your email to try 10 document uploads total, with no expiry or card required. Starter and Pro provide monthly upload allowances; Advanced is a custom quote. See Pricing for the current plans and checkout availability.

Supported files are PDF, JPG, PNG, CSV and TXT, up to 15 MB per file. Select more than 10 files at once; larger selections upload automatically in batches within your plan allowance. PDFs can contain up to 20 pages, including at most five scanned pages. Extraction needs review; FigureLane does not reproduce the original receipt layout in Excel.

Keep tax estimates separate from conversion

You can save a suggested or custom tax rate in business settings. If set, the income statement labels the resulting tax figure as an estimate. Converting a receipt, choosing a category or assigning a business portion does not establish deductibility or determine the tax actually owed.

Check your business figures

Use your reviewed totals in these free calculators. Each includes its formula, a worked example and downloadable results.

Choose the report range and format in Reports. Fictional example.

Common questions

Do I need to be a bookkeeper to use FigureLane?

No. It is designed for freelancers and sole traders running service businesses, such as consultants, designers and developers. Check the figures against your originals, then share the exported records with your accountant or keep them for yourself.

Will every invoice be treated as income?

No. Review the invoice and choose income, expense or exclusion. FigureLane does not establish whether an invoice has been paid.

Does a category or business percentage decide tax deductibility?

No. They record your preparation choices. FigureLane does not apply tax rules, calculate a liability or submit a return.

Sources

Prepare your own documents