FAQ: QuickBooks Desktop Integration - Exporting Journal Entries

FAQ: QuickBooks Desktop Integration – Exporting Journal Entries

You can integrate Quickbooks Desktop once you have started with PayTickr and set up your payroll payment options. Read this blog post or download a hi-res PDF for your own records. You can also watch the tutorial video at the bottom of the page.

Exporting Journal Entries

You can export journal entries from QuickBooks to PayTickr in a few simple steps, all from your PayTickr dashboard.

In your PayTickr My Dashboard, select “Payroll” from the “Time and Pay” tab. You can then select “See Payroll Runs”. Enter your filters to select the pay stubs whose data you wish to export to QuickBooks as journal entries. Check off the pay stubs you want to export and then click “Create Journal Entries for Selected Pay Stubs”.

In the dialog that pops up select “QuickBooks Desktop” and click “Next Step.” Use the checkboxes at the top of the screen to combine journal entries that you want combined. Check off “Use same debit/credit…” for the journal entries that will be exported to the same account to avoid typing these accounts multiple times.

Type the name of the journal entry item description (same for both credit and debit entries) and the name of the debit and credit accounts to which the journal entries will be applied. These have been set to sensible defaults but can be customized for your company. You can also modify the posting date if necessary.

Note: Any debit/credit accounts that do not currently exist in your company will be created when the file is imported to QuickBooks.

Ensure “Save changes for next journal entry” is checked off to keep your settings going forward if you wish to do so, and then click “Create Journal Entries”.

In QuickBooks, go to File-> Utilities-> Import-> IIF Files and select the file that was just downloaded to import these journal entries into your QuickBooks company.