Skip to main content

QuickBooks Desktop export

Use Reports > Accounting > QuickBooks to download journal entries for QuickBooks Desktop. You need Premium. For QuickBooks Online, use the separate QuickBooks Online integration.

Prepare the export​

  1. Configure accounting codes. Each code must match an account in your QuickBooks company file.
  2. Set From and To. The report opens at the start of the current season, with To blank for no end date.
  3. Review the preview of the first five journal entry groups. The download contains every matching group.

QuickBooks report previewing balanced general-journal groups before download.

Entries are selected by their own dates. A deposit and a refund withdrawal are separate groups with their own dates, so they may appear in a different export period from the sale or payment.

Blank codes block the download​

If any included entry has a blank code, the download is blocked. Review the warning, then use Fill Blank Codes on the Ledger. Correct missing settings, review unresolved entries and try the export again. Zero-value entries with blank codes can also block the download.

Filling blank codes doesn't replace an incorrect code already saved on an entry. Changing a setting affects later entries; it doesn't recode earlier entries. Review the file before importing it.

File layout​

Select Download to save accounting-quickbooks.iif. Each journal group starts with a TRNS line, continues with SPL lines and ends with ENDTRNS.

FieldContents
TRNSTYPEGENERAL JOURNAL
DATEMM/DD/YY, using your time zone
ACCNTCurling IO's account code
NAMEJournal entry group ID
MEMOItem description when there is one; blank for payment and deposit groups
AMOUNTDebit positive, credit negative, with two decimal places

Use the group ID to compare the IIF entries with the Ledger CSV. See refunds and corrections if a reversal or separate withdrawal is unexpected.

Import into QuickBooks Desktop​

  1. Back up your company file.
  2. Check the file in a test or backup copy before using it in your live books.
  3. In QuickBooks Desktop, use single-user mode and select File > Utilities > Import > IIF Files.
  4. Select the downloaded IIF file.
  5. Compare the imported accounts, dates, debit and credit signs, journal groups and totals with Curling IO.
  6. Record the date range and journal groups imported. Keep the file with that record.

Downloading doesn't mark entries as exported. Importing the same entries twice can duplicate them in your books. Avoid overlapping imports unless you have checked exactly which entries are new. A refund or scheduled-payment cancellation can rebuild an order's missing sale and payment entries, plus deposits for payments with a deposit date, including Stripe fee lines. These use the original dates, so also check for newly recorded entries in an earlier period.

Use Reconcile your books after importing.