

Choose the export option in the report view and choose to save as Excel.Always make sure your report shows a $0 different at the bottom to ensure everything is correct between the credit and debit columns.
QUICKBOOKS 2015 FOR MAC IMPORT FROM EXCEL HOW TO
To learn more on how to run the report, check out GL Journal Entry Export Report.This report will only allow you to export information for weeks that have already been closed in TempWorks.Run your GL export report for the given time period you wish to export (usually for the last week closed).

If you have worked with TempWorks to create a custom report, make sure to select that report. In order to export your information from Enterprise, you will need to run your GL Journal Entry Export Report.
QUICKBOOKS 2015 FOR MAC IMPORT FROM EXCEL UPDATE
You will want to update your mapping anytime you add or update an account or utilize new adjustments, worker comp codes, or other items that would effect your GL.Įxporting Your Information from Enterprise Check out GL Journal Entry Export Setup Guide for the instructions on how to map your account information in Enterprise. Therefore, in QuickBooks, create a vendor named "TempWorks Sales Tax." This will be the generic vendor record in QuickBooks that we will post all of the sales tax amounts to.īefore you can export to QuickBooks, you will want to map your account information correctly. QuickBooks also requires users to specify a vendor name every time the sales tax payable account is hit. Therefore, in QuickBooks, create a customer named "TempWorks Customer." This will be the generic customer record in QuickBooks that we will post all of the AR journal entries to. QuickBooks requires users to specify a customer name every time the AR account is hit. Since one Journal Entry file from TempWorks can hold multiple Journal Entries, using the backup file will save you from having delete out partially imported files from your productions system. Once you have been able to successfully import into the backup file, then repeat the setup steps you had to take on your backup file on your production file. It may take several tests to get your GL mapping exactly the way you want it. If this is your first time exporting your GL journal entry information, we highly recommend first creating a back up (or several backups) of your QuickBooks company file to use it as a test before updating your current account. Importing to Quickbooks via Transaction Pro Importerīefore You Export information from Enterprise and import it into QuickBooks, please consider the following information.Exporting Your Information from Enterprise.Follow the below steps to properly import your GL information. Users have the ability to import GL journal entry information into QuickBooks by utilizing Transaction Pro Importer.
