Odoo. Your accounting, in Excel or on the web.
Load your invoices and bills, journal entries, payments and bank lines, your trial balance, your sales and purchase orders, your partners and products into Excel or the web app. Correct a draft, post it, register a payment or reconcile a bank line. Needs Odoo 19 or later, on a plan with access to the external API.
200
rows per page at most, 100 by default — "All results" walks the pages for you
Excel + Web
the same live tables in both
29
Odoo queries available
ODOO RESOURCES
The books you keep every day. One workbook.
Accounting, its reports and its setup, sales, purchases, contacts and the catalogue — read from the external JSON-2 API of Odoo 19 and kept connected to your sheet.
WHAT YOU CAN DO
From the accounting export to a live ledger.
The loop of exporting invoices or journal items, reworking them in a spreadsheet and copying the corrections back by hand disappears. LinkyFlow reads the Odoo API and keeps the sheet connected to the database.
ACCOUNTING
Invoices, bills, journal entries and payments
Load customer invoices and credit notes, vendor bills, refunds and receipts with their state, payment state, partner, dates and totals, then their lines, your journal entries, your payments and the journal items of the ledger. Create a draft invoice or bill, correct its lines, post it, register a payment, cancel it or put it back to draft. An action is offered only when the state of the record allows it. Odoo computes the taxes and the totals.
BANK
Bank lines reconciled with what they settle
Bank Reconciliations shows each bank line with what would reconcile it: the open items it matches, the general accounts it would be booked on, and the entry it would leave. Reading changes nothing. Reconcile a proposed line and its entry is rewritten as Odoo’s own reconciliation does: never a payment, so the money is not booked twice. A wrong reconciliation can be undone. A line in another currency than the company’s is refused: reconcile it in Odoo.
REPORTS
The trial balance and what each partner owes
Trial Balance sums the posted journal items by account, over the period you ask. Partner Balances sums the open receivables and payables by partner, overdue as of a date if you ask. These are Odoo’s sums, never a total LinkyFlow computes.
FILES
The original files of your documents
List the PDF a supplier sent, a scan or a photo held on an invoice, a bill or a journal entry, each with a download link that opens only for you. The PDF Odoo prints of an invoice is not listed. A PDF, JPEG or PNG of up to 4 MB can be attached through the API or ChatGPT: the web app and the add-in have no file picker.
SALES, PURCHASES & CONTACTS
Orders, partners and products
Load quotations and sales orders, requests for quotation and purchase orders with their lines, partners, products and their categories. Create a quotation or a request for quotation with its lines, update it and confirm it. Create and update partners and products: they are archived, never deleted. Sales and Purchase need those apps installed in your database.
3 STEPS · INSTANT SETUP
From install to first export.
STEP 01
~1 min
Open LinkyFlow
Sign in to the LinkyFlow web app, or install the free add-in from AppSource and open it in Excel.
STEP 02
~2 min
Connect Odoo
In Odoo, click your avatar → Preferences → Account Security → New API Key. Name it LinkyFlow, choose Persistent Key if you are an administrator and the longest duration otherwise, then confirm your password. Paste the key and the address of your database. LinkyFlow checks what the key’s user may do and writes nothing to find out.
STEP 03
~30 s
Load and work
Pick Invoices, load — then filter, add formulas, or correct a draft and publish it back to Odoo from the same sheet.
Your Odoo database. Your spreadsheet.
Connect your database and work on its accounting, sales, purchases and contacts in Excel or on the web.
Frequently asked questions
Which versions and plans of Odoo work?
Odoo 19 or later, because LinkyFlow uses its external JSON-2 API. Your database also needs a plan with access to the external API. Odoo’s pricing lists it on the Custom plan, not on One App Free or Standard. LinkyFlow has not been tested on those two plans, or on Odoo.sh, so check your plan before you count on it: where the API is closed, the connection cannot work.
What Odoo data can LinkyFlow access?
The accounting (invoices and their lines and files, journal entries and items, payments, bank lines and their reconciliation), the trial balance and partner balances, the accounting setup (accounts, journals, taxes, payment terms, fiscal positions, currencies and rates, analytic accounts and plans), sales and purchase orders with their lines, partners, products and their categories — 29 queries. Custom fields (x_…) are not read.
Can LinkyFlow write to Odoo?
Yes, from Excel and the web app, with the rights of the key’s user. It creates and updates invoices, journal entries, payments, bank lines, quotations, requests for quotation, partners, products, accounts, analytic accounts and currency rates, and runs 21 actions, such as posting, registering a payment, a credit note or a bank reconciliation. Registering a payment books it in Odoo and moves no money. Every write is read back from Odoo. The =LF.odoo functions only read.
What do I need to connect?
An API key and the address of your database. The key acts as its Odoo user: LinkyFlow reads and writes what that user may, in that user’s default company. A server that holds several databases must choose one from its host name: LinkyFlow does not name a database.
What happens when the API key expires?
Odoo refuses LinkyFlow’s calls until you replace the key, and LinkyFlow cannot renew it: Odoo asks for the user’s password. Choose Persistent Key, or the longest duration Odoo offers. LinkyFlow reads the date at each sync and warns you from 7 days before it, as long as it can tell which key is yours: one key per integration keeps the warning.
How are amounts handled?
As Odoo answers them, in the currency of the document. Odoo computes taxes, totals and reconciliations, never LinkyFlow. The tax of a draft vendor bill can be set to the supplier’s document when Odoo’s rounding differs by at most one cent per product line.
Can ChatGPT or Claude work with my Odoo database?
Yes, through the generic provider tools of MCP: they read the 29 queries and run most writes with the same connection. Nine of them, such as a bank reconciliation, a document put back to draft or a draft removed, are previewed first and run only with the token of that preview. A credit note, a payment put back to draft and deleting a bank line, a payment or an order stay in Excel and the web app. The business tools such as commerce_* do not work on Odoo.
Do LinkyFlow agents run on Odoo?
No. No agent works on Odoo today.