QuickBooks® Desktop (Standard)
Paymate Acclaim now supports standard/file-based Integration with the QuickBooks® Desktop.
Note: Standard integration is available for all versions of QuickBooks® Desktop. If you have QuickBooks® Desktop versions 2010 up until 2018, a seamless integration is also available. If you have QuickBooks® Online, only file-based/standard integration is available through a separate application.
Prerequisites:
- Have Acclaim installed on the computer
- Have posted the payroll you'd like to export from Acclaim
Solution:
I. Setting Up Your GL Export Interface
- In Acclaim, navigate to Setup > Preferences.
- In the Interfaces section, in the "Accounting" field, select either "Quick Books 2010 Summary (Seamless)" or "Quick Books 2010 Details (Seamless)". If you're not sure what the difference between these two are, see the bottom of this article.
- Click "Save" at the bottom of this window to save your selection.
II. Define Your GL Account Codes
- In Acclaim, navigate to Setup > Departments & Accounts.
- Double-click a department.
- Enter your account number for each payroll category.
- Repeat steps 2 and 3 for each department.
- Click "Save" at the bottom of this window to save your changes.
III. Export Your Payroll / GL Entries
- In Acclaim, navigate to Payroll > Export Payroll.
- In the Parameters tab, verify that all the items here are accurate.
- In the Preferences tab, select whether your entries should be included by the pay period ending date or the cheque date.
- In the Destination section is a field called "Export File Name". This is the field where you identify where your file will be exported in your local computer.
- Click "Export". Your file should now be downloaded to your specified destination. If this is not the computer that has QuickBooks® Desktop installed, transfer this file to the correct computer.
IV. Import Your File to QuickBooks®
- In QuickBooks® Desktop, navigate to File > Import > Import .IIF File.
- You will be given a File Select dialogue box in which you need to select the file you exported.
A video guide is available here:
What is the difference between detailed and summary exports?
If you are using the Detailed export layout, then the interface will create transactions in your "Check" section of QuickBooks® showing the complete check and GL Details.
If you are using the Summary GL export layout, the entire transaction will appear as a single journal entry in QuickBooks®.