How AI Columns Work

Q: Adding AI Columns

<h1 id="howaicolumnswork">How AI Columns Work</h1> <p>You can add any data field to the <strong>data extractor</strong> that doesn’t exist in the source file (e.g., Invoice Category, Expense Type, GL Code). These appear in your sheet but never need to be present in the uploaded document.</p> <p>Each AI column runs when a document is processed. Common examples of AI column uses:</p> <ul> <li>Classification – “Classify the expense descriptions into the closest of these 4 categories: food, gas, travel, other"</li> <li>Conditional coding – "If status column contains "approved", return 99" to auto-fill a GL code.</li> </ul> <p>${youtube}<a href="6fdbGtOMyXw">Adding AI Columns</a></p>

You can add any data field to the data extractor that doesn’t exist in the source file (e.g., Invoice Category, Expense Type, GL Code). These appear in your sheet but never need to be present in the uploaded document.

Each AI column runs when a document is processed. Common examples of AI column uses:

Classification – “Classify the expense descriptions into the closest of these 4 categories: food, gas, travel, other"
Conditional coding – "If status column contains "approved", return 99" to auto-fill a GL code.

${youtube}Adding AI Columns

Question 2

Managing your subscription

Accepted Answer

You can upgrade, downgrade, or cancel your subscription at any time in the Billing portal.

Cancellations are effective at the end of your current billing cycle. You'll have access to all features until that time, at which point you'll automatically be downgraded to our free plan.

Question 3

Formatting your extracted data

Accepted Answer

Common formatting issues and how to fix them

Zeros at the start of numbers (like UPCs) are not displaying in the spreadsheet

This can generally be solved by changing the formatting settings in the Lido spreadsheet, without needing to re-process any files. Select the cells that you want to reformat, then in the spreadsheet toolbar go to More formats -> Plain.

${youtube}Format leading zeros

Edit output with AI

Lido's Edit with AI functionality can be used to reformat, clean, or sort contents of your spreadsheet. Common examples include reformatting strings into numbers or sorting the extracted spreadsheet output.

To use, simply highlight the entire range of populated spreadsheet cells that you want to edit. Then, in the toolbar click on the Edit with AI icon and type your instructions into the modal. Prompts can be saved and re-used to save time.

Question 4

Pricing

Accepted Answer

Our pricing plans scale based on usage and start at $36/month. Data exporting to Excel and CSV is enabled on all of our paid plans. You can see our latest pricing here: https://www.lido.app/pricing or here: ${frame}

Annual vs. monthly billing

All of our plans are available billed on either a monthly or annual basis. Annual plans are paid upfront and not pro-rated if cancelled before the end of the 1 year period.

We offer a 20% discount on all annual plans, and all page credits for the year are available upfront. For example, our standard plan includes 100 PDF page conversions monthly. With a yearly plan, you would have access to all 1,200 PDF page conversions upfront (12 months x 100 pages) to use throughout the year. This is a great option for companies with variable or seasonal processing requirements.

Changing or canceling your plan

You can upgrade, downgrade, or cancel your plan at any time by yourself in our Billing portal. Cancellations are effective at the end of your current billing cycle. You'll have access to all features until then, at which point you'll be automatically downgraded to the free plan.

Question 5

How to process documents stored in OneDrive

Accepted Answer

**Check out this video!!: ** ${frame}

Question 6

Post-Data Extraction: How to Push Data to Google Sheet

Accepted Answer

**Check out this video!!: **

Frequently Read Articles

Browse All Categories