Skip to content

Move files from Ascend into Quickbooks

Ascend software is compatible with Quickbooks. If you want to use Quickbooks for your shop's accounting, you'll need to set up a Quickbooks account first.

After your account is set up, and the Chart of Accounts (COA) is updated, you can add that information to Ascend.

Then you need to into Ascend and set up several areas so they point to the correct General Ledger Account Number from QuickBooks.

Once everything is set up, you can use Ascend's data to maintain your books. 

Ascend's retail accountant team also offers Bookkeeping services for Ascend retailers. Learn more here.  

Exporting IIF Files from Ascend

Ascend creats one IIF file per day, with a summary of that's day information, that is automatically saved in Ascend's  Export folder. The standard naming convention is the database name date.iif (Ex: MyAscend 10-01-2017.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 Seperate files per day.
4. Select OK
5. If a cash deposit was not recorded for the day, you will get a pop-up message.
     a. If you want to create the IIF file with the cash being reported as Cash Over Short, click Yes.
     b. 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.

Importing IIF Files into Quickbooks

1. In Quickbooks, navigate to File > Utilities > Import > IIF Files

2. Select the file you want to import.
3. Once the file is imported, you'll get a popup notifying you. Select OK

Additional Resources

Article: Set up my Quickbooks account

Feedback and Knowledge Base