How do I import the journal into QuickBooks?

Export from Settings, Accounting export (daily journal CSV), with the file format for your QuickBooks: a journal-entry CSV for QuickBooks Online, an IIF file for QuickBooks Desktop. Then import the file in QuickBooks with its own import tool. Try one day first.

Prepare

  1. In Settings, Accounting export (daily journal CSV), write next to each kind the account name exactly as it is in your QuickBooks chart of accounts: see How do I export the journal and match it to my chart of accounts?.
  2. Choose the file format for QuickBooks Online or for QuickBooks Desktop.
  3. Choose one day and press Export.

QuickBooks Online

  1. In QuickBooks Online, open the import of journal entries (in the settings menu, under importing data).
  2. Choose the CSV file written by the till.
  3. Match the columns when QuickBooks asks: journal number, date, account, debits, credits, description.
  4. Finish the import and open the journal entry to check it.

QuickBooks Desktop

  1. Make a backup of the company file.
  2. In QuickBooks Desktop, use the import of IIF files, in the File menu under Utilities, Import.
  3. Choose the .iif file written by the till.

Check, then go on

  • Compare the day in QuickBooks with the day’s Z reports: sales, tax, cash, card.
  • If an account was not found, correct its name in the till’s account list and export again.
  • When one day is right, export and import the rest of the period, each day once.

Menu names in QuickBooks change between versions and countries; use Intuit’s own help for the import screens. The link between the till and QuickBooks is a file, not a live connection, and has not been certified by Intuit.

For: Accountant Owner since version 1.0.8

Did this help?

Print this article · Contact support