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

Integration

  1. Submit an idea for an improvement to the software
  2. Create an Ascend University account
  3. Process Trek warranties
  4. Display my product availability on TrekBikes.com
  5. Accounting for bikes bought on TrekBikes.com (Click & Collect)
  6. Return an item bought on TrekBikes.com
  7. Use the SmartEtailing Direct Mail Customer Export with Ascend
  8. Sign up for text alerts when there's an Ascend service issue
  9. Set up Gift Cards in my shop
  10. Send inventory & pricing information to Locally
  11. Set up a Quickbooks file
  12. Import a chart of accounts into Ascend
  13. Assign your Quickbooks accounts in Ascend
  14. Move files from Ascend into Quickbooks
  15. Ascend recommended practices for QuickBooks®
  16. Join the Ascend Customer Network (ACN) on Yammer
  17. Accessing Dexter from Ascend
  18. Set up Ascend to export (upload) products to an ecommerce (SmartEtailing) website
  19. Set up Ascend to import (download) ecommerce (SmartEtailing) sales
  20. Export (upload) product information to an eCommerce (SmartEtailing) website
  21. Process eCommerce (SmartEtailing) sales
  22. Set up email integration
  23. Help a customer apply for a Trek Card in your store
  24. View availability for Trek products using Order Grids
  25. Get started with Listen360 integration
  26. Listen360 Overview with Ascend
  27. Send purchase and registration information to Bike Index
  28. Register Bikes with Trek during transactions
  29. Selling Trek Project One (P1) bikes
  30. Use the Ascend Retailer Portal on ShareFile
  31. Quality Bicycle Products (QBP) integration
  32. Send bike sale information to Project 529 Garage
  33. Send inventory & pricing information to Bike Exchange

Feedback and Knowledge Base