IMPORTANT: This article is for QuickBooks (all editions) it is NOT for QuickBooks Online. For QuickBooks Online integration, see Connecting to QuickBooks Online.
In order to import your daily sales and cash receipts data into QuickBooks, follow the steps below.
- Login to Management Toolbox
- From the menu, select Integrations > Accounting > Sales Journal Entry Export for QuickBooks
- Select a group or one or more stores
- Select dates or choose a predefined range (the default is yesterday):
- Click the Generate preview button
- The results will display in the Results panel (the parameters and summary will hide).
Review the results. Look for an Out of Balance warning.
If any store is listed, the journal entries for these stores are not complete. You will need to run the MSR and Revenue reports to identify the cause (you can find these on the Insights > Store Performance menu).
Contact our technical support for assistance. They can add a new MOP (Method of Payment) or code missing/new sales categories for you.
You will also receive a warning if you try to download the file when one or more stores is out of balance.
NOTE: you can show the parameters and summary again by clicking the Parameters pane icon next to the Results panel.
- If needed, select a different download format. The default is CSV (Comma Separated Values). Other options are IIF (typically used with QuickBooks and QuickBooks Enterprise) or TXT.
- Click the Download button to download the file for import.
- Follow the steps for your version of QuickBooks to import the journal entries (file).
For QuickBooks and QuickBooks Enterprise use IIF format and these are the typical steps inside QuickBooks:
- From the QuickBooks File menu, select Utilities then Import and then IIF Files.
- Select the .iif file you downloaded.
- Click Open
If you have any questions or problems, please contact technical support for assistance.
Comments
0 comments
Please sign in to leave a comment.