Meridian Help
For owners & accounting

The daily QuickBooks Desktop export

Map your accounts once, then export a daily General Journal file and import it into QuickBooks Desktop without double-posting.

Owners & accounting

If your accountant lives in QuickBooks Desktop, Meridian can hand them a daily General Journal file (IIF) built straight from your ledger — one import a day and the books match, with nothing re-keyed. Map your accounts once, then it's a two-click routine.

Turn it on and map your accounts. Open Settings → QuickBooks Desktop and switch on Enable QuickBooks Desktop export. The mapping grid lists every ledger account under Ledger account, QuickBooks Desktop name, and Status. Type each account's exact QuickBooks name (use a colon path like Income:Parts Revenue for a sub-account), then click Save mappings. Spelling is load-bearing — a name that doesn't match an existing QuickBooks account silently creates a new one on import.

Optional: carry your branch into QuickBooks. If you run multiple locations, switch on Track branch as QuickBooks CLASS so each entry's location lands in QuickBooks class reporting. Leave it off and the class column stays blank.

Map once — every ledger account gets its exact QuickBooks name. An export is blocked until nothing is left Unmapped.

Generate the file. Open Accounting → QBD Export, pick a RangeYesterday, This month to date, Last month, or Custom range — and click Preview. The preview shows the transaction and line counts, the first lines of the file, and any warnings.

Read the preview before you download. Two things block or warn you: any account still unmapped shows a hard warning with a Fix mappings link (the export won't run until it's clean), and if the range overlaps a file you already exported, Meridian warns you by name and date because re-importing double-posts. When the preview is clean, click Download .iif.

The preview counts transactions and lines, flags any unmapped account, and warns when a range overlaps a previous export.

Import into QuickBooks Desktop. In QuickBooks: File → Utilities → Import → IIF Files, then choose the downloaded file. On QuickBooks 2019 and newer a review dialog appears — that's expected, go ahead and confirm.

Import each file exactly once. QuickBooks does not detect duplicates, so a second import of the same file double-posts. Meridian remembers every export in the Recent exports list and warns before you export an overlapping range — only an administrator can override with Export anyway. Each transaction also carries its Meridian reference in the DOCNUM column, so a double-import is easy to spot in the register.

Optional: automate the nightly file. Under Settings → QuickBooks Desktop, switch on Enable nightly export to build yesterday's file automatically each morning and deliver it by In-app notification, Email, or a Synced folder. Use Send test export now to confirm the delivery works before you rely on it.

What happens behind the scenes

This export is one-directional and read-only: Meridian reads your ledger and writes a General Journal file — it never changes your Meridian books, and QuickBooks never writes back. The file carries balanced journal entries (debits equal credits) for the range you picked; importing it posts those same entries into QuickBooks so both systems tell the same story. The account mapping is the whole trick — Meridian's account names and QuickBooks' account names have to line up, which is why an unmapped account is a hard stop. To keep you from posting the same day twice, Meridian fingerprints each export and remembers it, so an overlapping range gets flagged rather than quietly duplicating your numbers.

Troubleshooting

On this page