+
Your Shopify COGS journal, ready for QuickBooks Online
Landara costs every Shopify order first-in, first-out (FIFO) and hands you a Dr COGS / Cr Inventory journal for QuickBooks, ready to post. You review it, then Landara posts it to QuickBooks on your command, or hands you a CSV. Import your stock? Freight and customs invoices go to QuickBooks as bills with the document attached, and their cost lands in inventory, not an expense account.
QuickBooks Online has no idea what the stock you sold cost
QuickBooks records the sales Shopify sends it. The cost of goods sold behind them lives in a spreadsheet your store has never seen, and month-end means rebuilding it into a journal entry by hand.
The freight bill arrives late
The forwarder and customs broker bill weeks after the stock lands. By then you have sold units at a cost you did not have yet, and nothing goes back to correct them.
No document linking
QBO treats your PO, freight forwarder bill, and customs broker invoice as separate, unrelated expenses. No way to connect them to a single shipment.
Manual journals for COGS
Getting cost of goods sold into QuickBooks means a Dr COGS / Cr Inventory journal entry rebuilt from a spreadsheet every month, error-prone and impossible to audit months later.
From Shopify order to QuickBooks journal
Shopify counts your stock. Landara costs it, and your books get the result.
Connect
Connect Shopify and QuickBooks. Landara reads orders, fulfilments and stock movements, never customer data.
Cost
Every delivery of stock keeps its own cost, with freight and duty landed in. Each sale draws down the oldest first.
Post the journal
Review the period's Dr COGS / Cr Inventory journal, then post it to QuickBooks on your command, or export a CSV.
Publish bills
Freight and customs invoices go to QBO as bills, coded to inventory. Source documents attached automatically.
What Landara gives you for QuickBooks Online
A cost of goods sold journal Landara posts to QuickBooks on your command, plus original documents as proper accounting records. You control when everything posts. Nothing hits your ledger until you say so.
COGS Journal, Posted On Your Command
Landara produces a period Dr COGS / Cr Inventory journal from your perpetual FIFO (or average) costing, then posts it to QuickBooks for you when you choose, or hands you a CSV. You review first, and nothing posts until you say so.
Bills from Freight Invoices
Each freight invoice creates a bill in QBO with the correct vendor, date, line items, and amounts. Your bookkeeper can approve and pay as normal.
Purchase Orders
Push extracted PO data to QBO as a purchase order. Keeps your QBO records in sync with what you've ordered from suppliers.
Document Attachments
The original PDF is attached to every bill and PO created in QBO via the Attachable entity. Full audit trail without digging through email.
Tax Code Mapping
Configure your default tax codes and GL accounts per cost category. Set once in Settings, applied automatically on every publish.
Vendor Matching
When you enter a supplier name, Landara searches your existing QBO vendors to match. Prevents duplicate vendors from being created.
Token Management
Landara refreshes your QBO connection automatically. If the refresh token expires after 100 days of non-use, you'll see a clear 'Reconnect' prompt.
Published to QuickBooks OnlineBill Created
Pacific Freight Solutions, INV-2024-0847
Date
01/15/2025
Total
$2,849.00
Line Items
Ocean Freight, 40ft Container
Terminal Handling Charge
Customs Clearance
Cargo Insurance
Why a capture tool stops short of COGS
Expense tools (Dext, Lightyear) capture documents and push them to QuickBooks. That's useful, and Landara runs happily beside them. But a capture tool cannot put freight into the cost of your stock, because nothing downstream would ever release it to cost of goods sold.
Landara holds the cost side. Freight and duty land into the cost of the delivery they belong to, that cost is drawn down first-in, first-out as orders ship, and the COGS journal releases it to cost of goods sold in the period the stock actually sold.
So when those bills reach QuickBooks, they are part of a cost that arrives in your COGS at the right time, not an expense in whichever month the invoice happened to turn up.
One-time configuration, then it just works
Connect QuickBooks Online, then map your accounts and tax codes. That's it.
Connect QBO
OAuth login: click 'Connect to QuickBooks', authorize, done. No API keys to manage.
Map Tax Codes
Set default tax codes and GL accounts for products, freight, duty, insurance, clearance, and other costs.
Post
Post each period's COGS journal when you are ready, and publish bills from any shipment with correct codes and attached documents.
Common questions
Landara reads your account list, tax codes, and vendors for mapping and autocomplete. But your documents and cost data flow from Landara to QBO, not the other way around. Landara is the source of truth.
Landara creates a COGS journal entry (Dr COGS / Cr Inventory) each period when you post it, Bills from your freight invoices, and Purchase Orders from your PO documents. Bills and POs include extracted line items and the original document as an attachment.
Yes. Nothing is pushed to QBO until you click the publish button. You review all extracted data, confirm amounts, and then choose to publish. You can also publish documents individually.
When you set a supplier name on a shipment, Landara searches your existing QBO vendors. If a match is found, it links to that vendor. This prevents duplicate vendor records from being created.
Landara uses the QBO Bills and Purchase Orders APIs, which are available on QBO Plus and Advanced plans. Simple Start and Essentials don't support purchase orders, but bill creation works on all plans.
QBO access tokens expire after 60 minutes and are refreshed automatically. If you don't use Landara for 100+ days, the refresh token expires and you'll need to reconnect with one click. Your data in Landara is unaffected.
Pricing is flat and seatless, never per-seat. Posting the FIFO COGS journal and publishing to QuickBooks are available on the COGS plans (from $49/month or $490/year, unlimited team members). The Free plan keeps the full FIFO cost ledger and every report, with CSV export.
“Landara has made it much easier to keep track of my actual product costs. I really like that it takes things like shipping and duties into account instead of just showing the basic cost. Simple app, easy to use, and I’m already getting a much clearer idea of my real margins.”
“I installed Landara because I was getting tired of guessing what my inventory was actually costing me. What I liked most was being able to see the product cost together with things like shipping and duties, I've been trying to keep a closer eye on my margins, so having those costs in one place has made things much easier for me. It didn't take me long to get setup either, which was a nice bonus.”
“I honestly didn’t expect Landara to make this part of my store that much easier. I installed it mainly to get a better handle on my actual product costs, and I was pleasantly surprised by how everything comes together. I’m still exploring it, but so far it’s been really useful and I’m impressed with how it works.”
“I've just started using Landara, and so far I'm impressed with how it handles landed costs. I especially like being able to account for things like freight and duty instead of treating the supplier price as the whole cost. Still exploring the app, but it already looks like it could save me a lot of spreadsheet work.”
Stop rebuilding COGS by hand every month
Connect Shopify and QuickBooks Online. Every order is costed first-in, first-out, the COGS journal is ready to post each period, and freight bills land in inventory. Start free.