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
- 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?.
- Choose the file format for QuickBooks Online or for QuickBooks Desktop.
- Choose one day and press Export.
QuickBooks Online
- In QuickBooks Online, open the import of journal entries (in the settings menu, under importing data).
- Choose the CSV file written by the till.
- Match the columns when QuickBooks asks: journal number, date, account, debits, credits, description.
- Finish the import and open the journal entry to check it.
QuickBooks Desktop
- Make a backup of the company file.
- In QuickBooks Desktop, use the import of IIF files, in the File menu under Utilities, Import.
- 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?
Thank you. Your answer helps us improve the help.