Smart Mapping

Every transaction, routed to the right account.

Every transaction routed to the right account — automatically.

Use pre-built templates for standard Shopify setups or build custom routing rules that send transactions to exactly the right accounts — by type, amount, store, or product category.

10,000+

Orders Synced/Minute

8

Pre-Built Platform Templates

100%

Configurable per Store

The problem

Manual mapping breaks your chart of accounts

When transactions aren’t routed to the right accounts, your financials tell the wrong story.

All Shopify revenue lands in a single “Sales” account

Without proper mapping, fees, shipping income, and product revenue pile into the same account. Your P&L is technically populated, but analytically useless.

The same transaction type gets categorized differently every month

Manual categorization means inconsistency. A shipping charge posted to COGS in February becomes an operating expense in March depending on who did the import.

New transaction types silently go to a catch-all account

When a new fee type appears in Shopify, it falls into a generic “Uncategorized” account and nobody notices until the audit — months later.

Before & after

See the difference

Before
With LedgerPort
All revenue in a single “Sales” account — no visibility
Revenue split by type, channel, and product category
Fees mixed with revenue, distorting your gross margin
Processing fees, platform fees, shipping in separate accounts
New transaction types silently miscategorized
Unmatched transactions surface in a review queue — nothing is lost
Recategorize transactions manually after every import
Rules apply automatically — and retroactively if you change them

Benefits

Smart mapping that adapts to your business

Pre-built templates for common setups

Shopify Payments, PayPal, and Stripe templates come configured with the correct accounts for product revenue, returns, shipping income, fees, and deferred revenue out of the box.

Custom rules for your chart of accounts

Route transactions by type, store, amount threshold, or product category. A $5,000 wholesale order can go to a different account than a $50 retail order — automatically.

Review queue for unmatched transactions

Transactions that don't match any rule surface in a review queue — not silently dropped or mapped to a catch-all. You decide how to handle them once, then LedgerPort remembers.

Templates apply instantly and retroactively

Change a mapping rule and apply it retroactively to the last 30 days. No need to manually re-categorize transactions you already synced under the old setup.

How it works

Get started in minutes — no engineering team required.

1

Choose a starting template

Select the pre-built template that matches your payment processor and store type. LedgerPort pre-fills standard accounts — product revenue, fees, refunds, shipping.

2

Customize rules to match your COA

Override any default with your specific account numbers. Add custom rules for edge cases — wholesale orders, specific SKUs, or stores with different revenue recognition.

3

Rules run on every sync

From this point on, every incoming transaction is evaluated against your rules and routed automatically. No manual categorization, no review unless something genuinely doesn’t match.

Supported Integrations

Shopify
WooCommerce
QuickBooks

FAQ

Frequently asked questions

We use a custom chart of accounts. Can LedgerPort map to our specific account numbers?

Yes. Every mapping rule is configurable to your specific account numbers. Start from a template and customize, or build rules from scratch.

What if I want different mapping rules for different stores?

Mapping rules are set per store. Your US Shopify and UK WooCommerce can have entirely different account structures — they never conflict.

What happens to transactions that don’t match any rule?

They appear in a review queue with full transaction context. You assign an account once, and LedgerPort remembers the rule for all future occurrences.

Can I change a mapping rule and apply it to past transactions?

Yes. Rule changes can be applied retroactively to the last 30 days. For older transactions, contact support — we can run a historical reprocess on request.

Map every transaction to the right account.

Start syncing your e-commerce transactions to your accounting software in minutes. No code required.