If you keep your books in QuickBooks Desktop, you don't have to key each day's ticket sales by hand. The ticket ledger turns a day's sales into one general journal entry that you import as an IIF file.

One-time setup: your account names

QuickBooks matches every line of the file to an account by its exact name, and it does not create missing accounts. Before your first import:

1. Go to Admin → Venues → [your venue] → Settings and find the Accounting → QuickBooks Desktop card.
2. Type each account's name exactly as it appears in your QuickBooks chart of accounts. For a subaccount, use Parent:Child (for example Income:Ticket Sales). Leave a field blank to use the name shown in grey.
3. Optional: set a Class to stamp on every line, a Memo prefix so you can spot these entries in QuickBooks, and a different ticket sales account per event category.
4. Click Save QuickBooks Desktop Accounts.

Then make sure every account exists in QuickBooks (Lists → Chart of Accounts):

| Setting | Default name | Suggested account type | |---|---|---| | Cash | Cash on Hand | Bank or Other Current Asset | | Card sales (clearing) | Stripe Clearing | Bank or Other Current Asset | | Checks and other tenders | Undeposited Funds | Other Current Asset (QuickBooks creates this one for you) | | Gift card liability | Gift Card Liability | Other Current Liability | | Ticket sales | Ticket Sales | Income | | Discounts | Discounts Given | Income (contra) or Expense | | Sales tax | Sales Tax Payable | Other Current Liability | | Merchant fees | Merchant Fees | Expense | | Refunds | Refunds | Income (contra) | | Donations | Donations Income | Income |

If you use QuickBooks' own sales tax feature, ask your accountant whether journal entries should post to its Sales Tax Payable account or to a separate liability account — then enter that name.

Downloading the journal

1. Go to Reports → Ticket ledger and pick the day — Yesterday is the usual choice the next morning.
2. Scroll to QuickBooks Desktop journal under the ledger. It previews the entry: every account with its debit or credit, and a total line showing that debits equal credits.
3. Check it against the day, then click Download QuickBooks journal (IIF). Download CSV of the same journal gives you the same lines as a spreadsheet, if you'd rather copy them in.

For a range longer than one day (for example Last 7 days), the file holds one journal entry per day, each dated that day. A journal covers at most 62 days. The Performance, Tender and Seller filters don't apply to the journal — it always covers every sale on the day.

Importing into QuickBooks Desktop

1. Back up your company file first (File → Back Up Company).
2. Go to File → Utilities → Import → IIF Files and choose the downloaded .iif file.
3. QuickBooks confirms the import. Open Company → Make General Journal Entries (or the register of any account in the entry) to see it. The entry number is NOC- followed by the date, for example NOC-260910 for September 10, 2026.

Import each day once. Importing the same file again adds a second copy of the entry — delete the duplicate in QuickBooks if that happens.

Intuit no longer develops the IIF format, but QuickBooks Desktop still imports it. If your version asks you to confirm the import or a "legacy" format, confirm it.

What each line means

| Line | Debit or credit | What it holds | |---|---|---| | Cash | Debit | Cash taken for tickets and gift cards, less cash refunds given back that day | | Card sales (clearing) | Debit | Card payments for tickets and gift cards, less card refunds — before processing fees | | Checks and other tenders | Debit | Checks and other tenders, less refunds paid back the same way | | Gift card liability | Debit | Gift cards redeemed as payment | | Discounts | Debit | Promo code and other discounts on the day's tickets | | Ticket sales (exchange credit) | Debit | Value carried over from an exchanged ticket, so the exchange isn't counted as a second sale | | Refunds | Debit | Refunds made that day, without the sales tax inside them | | Sales tax (refunded) | Debit | The sales tax given back on those refunds | | Ticket sales | Credit | Ticket revenue before discounts. All-in prices are shown without the fees and tax inside them | | Ticket sales (add-ons) | Credit | Add-ons and small order-level adjustments | | Gift card liability | Credit | Gift cards sold, and refunds credited to a gift card or venue credit | | Sales tax | Credit | Sales tax collected | | Merchant fees | Credit | Service and card fees paid by buyers | | Donations | Credit | Donations added to ticket orders at checkout |

A line that comes to zero is left out.

• Tickets are booked on the day they were sold, at their original amounts.
• Refunds are booked on the day the money went back, whenever the ticket was sold. Refunds made outside Noctern (for example directly in the card processor's dashboard) are not on the journal.
• Comps move no money, so they have no lines. They appear on the ticket ledger only.
• Imported history from your previous ticketing system is already in your books and is never on the journal.
• Processing fees are not on the daily journal. They come off your card payout: when you record the payout, credit the clearing account for the full amount, debit your bank for what arrived, and debit Merchant Fees for the fees withheld. The clearing account then comes back to zero, and Merchant Fees shows what fees really cost you. See Payout reports.

When it doesn't balance

The journal is built so that debits always equal credits. If a day ever doesn't balance, Noctern shows an error instead of a file and names the day — nothing is downloaded, so nothing half-right reaches your books.

1. Open the Ticket ledger for that day and look for a row that doesn't add up (Total paid should equal Unit price − Discount + Fees + Tax on plus-fee pricing + Donation + Other).
2. Contact Noctern support with the day and the order, and hold that day's import until it's fixed. Import the other days as usual.

If QuickBooks itself rejects the file, it is almost always an account name that doesn't exist in your company file, or one that differs by a space or a capital letter. Fix the name in the settings card (or add the account in QuickBooks) and download the file again.