Turn QuickBooks invoice emails into a spreadsheet
When your vendors bill you through QuickBooks, each invoice arrives as an email with the balance and due date. MailQL collects them as rows, so you can see what you owe and when without logging in anywhere.
Free for 25 emails a month.
What each email becomes
| Vendor | Invoice # | Date | Due | Total |
|---|---|---|---|---|
| Smith Refrigeration | 1043 | Oct 1, 2026 | Oct 15, 2026 | $725.00 |
All the columns: Vendor, Invoice #, Date, Due, Total, Items. You can rename, add or remove any of them.
Set it up in two minutes
- Make a mailbox in MailQL and pick Supplier invoices. You get an address like
invoices-k7f3qd@in.mailql.com. - In Gmail, open Settings → See all settings → Forwarding and POP/IMAP and add that address. Confirm it with the code MailQL shows you.
- Search Gmail for
from:(intuit.com) subject:(invoice), choose Create filter, and tick Forward it to your MailQL address. - New QuickBooks invoice emails turn into rows as they arrive. Forward a few old ones by hand to fill the table now.
Good to know
- The vendor is the business that sent the invoice, not QuickBooks.
- Anything MailQL isn't sure of is highlighted for you to check, with the words from the email it came from.
- Download the table as CSV whenever you like, send each new row to a webhook (Zapier and Make included), or ask questions like "how many this month?".
Other emails it reads
supplier invoice emails and PDFsThumbtack lead emailsAngi lead emailsYelp quote requestsBark request emailswebsite contact form submissions
MailQL isn't affiliated with or endorsed by QuickBooks. Names are trademarks of their owners, used here only to say which emails MailQL can read.