Ascend supports QuickBooks integration from both the Ascend app and Ascend HQ. Use this article to learn how to export your accounting data in IIF format from the Ascend app.

For more help and to learn more about Ascend Bookkeeping services, click here. 

Exporting IIF Files from the Ascend app

Ascend creates one IIF file per day. It includes a summary of that's day information and is automatically saved in Ascend's Export folder. The standard naming convention is [database name date] [MM-DD-YYYY].iif.   

Here’s what it might look like in your system:  MyAscendDB 10-10-2023.iif.  

The General Ledger Summary report in Ascend is a close reflection of what is contained in the IIF file.  

1. In Ascend, navigate to File > Export > General Ledge Summary to Quickbooks.
2. Enter your date range (it can be one day or any number of days).
   
3. Do not check the box for Separate files per day.
4. Select OK.
5. If a cash deposit was not recorded for the day, you will get a pop-up message.
   1. If you want to create the IIF file with the cash being reported as Cash Over Short, click Yes.
   2. If you want to omit the day without Cash to Deposit from the report, click No.
      
6. Once the file is created, you'll get a popup notifying you. Select OK.

If you try exporting for one specific day and no records are exported, the store may have been closed that day or there were no transactions that day.

Important Considerations 

• You MUST have QuickBooks actively selected as your Accounting Integrator or the QuickBooks export file types will not be available to you.
• You MUST ensure your QuickBooks and Ascend account configurations are in alignment; consult a tax accountant or bookkeeper for assistance.
• You MUST ensure all necessary QuickBooks accounts are configured within the Ascend app AND force an update for anything that requires a change that would impact any QuickBooks Account configuration (i.e. Categories, Inventory Adjustments, Payment Types, Tax Rates, Export Settings) 
  • If QB Account configurations are missing, the Ascend HQ General Ledger Summary IIF file will export with incorrect data.
  • Validation checks will be in place to fail the file export process and notify the user of which location(s) failed and why.
    • When this happens you will receive an email identifying the location(s) that failed and the data fields missing their accounting configurations
    • If you have some successful location exports and some that fail, you will receive an email containing files for those that were generated (even if combined in a single IIF) AND a separate notification email for those that failed.
• Any Ascend RMS changes you make to Inventory Adjustment Types, Categories, Tax Types, or Payment Types, should automatically be updated on Ascend HQ, though the update could take up to 30 minutes to appear. Any changes you make to your QuickBooks configurations in Ascend RMS related to general Options and/or Export Settings will require a call to Support to “push” those updates to Ascend HQ. 
• While we recommend you use Ascend HQ for IIF exports, you may continue exporting your IIF files from Ascend RMS until these features are turned off.  However, any configuration changes made on Ascend HQ will not be passed over to client, so before doing so please ensure your configuration matches in Ascend RMS.
• If you are scheduling recurring IIF export file generation containing multiple locations within a dealership, you will want to consider time zones across that dealership and choose a delivery time that accounts for the time zone furthest behind.

Importing IIF files into the QuickBooks app

1. In QuickBooks for Desktop, navigate to File > Utilities > Import > IIF Files.
   
    
2. Click to Zoom
3. Select the file you want to import.
4. Once the file is imported, you'll get a popup notifying you. Select OK.

FAQs

Why am I unable to see the Accounting Services Integration Settings Menus in Ascend HQ?

• Your Ascend app user profile MUST have the Bookkeeping - Ascend HQ Permission enabled in the or your user before you will have the Accounting Integrations option available to you.

Why am I unable to configure locations within the Bookkeeping Configuration Tab?

• You MUST assign a QuickBooks Class within Manage Locations prior to setting up any other Bookkeeping Configurations.

Can I configure multiple inputs with the same Ledger Account Number?

• Yes, you can use the same accounts for multiple fields, however, that may not result in a desired outcome when exporting your General Ledger Summary.

Can I configure more than one location at a time?

• No, it is currently not possible to configure all locations simultaneously upon initial setup.

Will the QuickBooks Configuration functionality within the Ascend app continue to be available?

• Yes, you can still manage your QuickBooks configurations in either the Ascend app or Ascend HQ. 

Will the QuickBooks Export IIF functionality within the Ascend app continue to be available?

• While you may still export the IIF from the client, it is being generated from a completely different data source. We recommend choosing a single source for your exports and staying consistent.

Will configuration setting updates sync between Ascend HQ and the Ascend app? 
 

What happens if I am missing a configuration and attempt to export an IIF File?

• It is likely that your General Ledger Summary Export File will NOT be generated, and you will receive a notification with an attachment outlining the reason and the missing configuration(s).

What happens if I export an IIF File for a day that has no accounting data?

• You will receive a notification email with an attachment advising you that no accounting data was available for the selected Date(s).

Am I able to Import my Chart of Accounts IIF Setup File into the Ascend HQ Bookkeeping Configuration Portal?

• No, this functionality is not currently available.

Am I able to Import my Classes IIF Setup File into the Ascend HQ Bookkeeping Configuration Portal?

• No, this functionality is not currently available.
   

KB22-097