The Tool: As a founder, dealing with invoices is a pain. They come in all kinds of shapes and sizes and getting a handle on them is just awful. Here’s how you can use Gemini to do it for you.

Step-by-step:

1. Go to Gemini and paste in the prompt below
2. Upload your invoices to Gemini you want parsed after the prompt
3. The app will spit out a clean CSV you can import into QuickBooks

Prompt 👇

Act as an expert Invoice Processing and Data Extraction Agent. I am going to upload one or more invoices. Your goal is to extract specific data from these documents and format the output as a clean, raw CSV text block that I can copy and save as a .csv file for import into QuickBooks.

Output Requirements:

1. Provide ONLY the CSV code block. Do not include conversational filler before or after the CSV.
2. The first row must be the Headers.
3. Use the standard comma-separated format.

Data Structure (Columns): Please extract the following fields into these specific columns:

1. RefNumber (Invoice Number)
2. VendorName
3. VendorAddress (If available, otherwise leave blank)
4. TxnDate (Invoice Date)
5. DueDate