eZ Account Import FAQ
Here you will find a list of the most frequently asked questions that we receive about eZ Account Import.
What types of online banking export files does eZ Account Import support?
eZ Account Import supports 7 different file formats: .CSV, .XLS, .XLSX, .QIF, .OFX (Money), .QFX (Quicken) and .QBO (QuickBooks®). From Zachary Systems Inc.’s experience, the .OFX, .QFX and .QBO file formats contain the most descriptive information for transactions and should be used, if possible.
What versions of QuickBooks® does eZ Account Import support?
eZ Account Import supports the following QuickBooks versions:
||QuickBooks® Pro, Premier, Enterprise 2012-2017, QuickBooks® Online Edition
||QuickBooks Pro, Premier 2012-2017
||QuickBooks Pro, Premier 2012-2017
Are you required to have Internet access to use eZ Account Import?
You only need Internet access for QuickBooks® Online Edition. However, in order for the application to register, set the activation key and to verify subscriptions, you are required to have Internet access at the time.
How do I know if I have the most current version of eZ Account Import?
When eZ Account Import is open, you can click on the Help menu button in the upper right hand of the window, and select Check for Update. This will launch a window that will tell you whether you have the latest version, and if not, provide a link for downloading the latest version.
Is your software compatible with MAC?
No unfortunately it is not compatible with MAC.
What are the limitations of the trial version?
The trial has full functionality as the purchased product except that you are limited by the number of transactions you can import. You can import up to five (5) transactions per session.
I’ve done a lot of work in the trial version and now I’m ready to purchase. Will I lose all my work?
Unfortunately there is no save button. You will need to restart eZ Account Import so you can input your activation key that is provided when you purchase the product. The aliases, vendors and customers that you added in the trial version will still be accessible after you restart the program, but any other work will be lost.
How many licenses do you get with a yearly subscription?
Each yearly subscription includes two licenses.
How do I purchase additional licenses and how much do they cost?
You can purchase additional licenses by sending an email to email@example.com. Each additional license costs $50 each.
What is included in a yearly subscription?
You will receive two licenses with your yearly subscription, to be used on up to two computers. You will also receive free unlimited support (chat, phone and email) during the subscription period as well as free one-on-one web-based training. A yearly subscription ensures that you are always using the latest and greatest version of our product, as we do one to two major upgrades a year as well as maintenance fixes.
My subscription has expired. How do I renew?
To ensure that there is no service interruption, please renew your subscription by visiting our Buy page and clicking RENEW. Make sure you use the same email address when renewing that you used when you first purchased the product. You will receive a reminder email two weeks prior to your subscription expiration date to renew your subscription.
Is registering required to try the product?
Yes. You are required to provide limited information about yourself and your company to register the product. PLEASE include your valid email address. After purchasing the product, the email entered during registration will be used to send the activation key.
I did not receive an activation key after purchasing eZ Account Import. What do I do?
First, check your email spam folder. If you did not receive an email, you may request a new key through Zachary Systems Inc.’ Web site. Click here to contact Zachary Systems.
What will you do with my registration information?
Connecting to QuickBooks
Why is QuickBooks required to be running?
For security reasons, eZ Account Import requires that QuickBooks® is running when it is launched. This prevents unauthorized access to your sensitive company information.
Why am I receiving the following error? “The application does not have permission to access this QuickBooks® company data file ….”
During the registration process or at some other point, eZ Account Import was denied access to QuickBooks®. To correct this issue perform the following steps:
Going forward, the eZ Account Import will be able to access QuickBooks® for this company file. Note: If you use multiple company files you may be required to perform this procedure on each file.
- Open your company file in QuickBooks®
- Select Edit | Preferences from the QuickBooks® menu
- Select Integrated Applications in the list of preferences on the left hand side of the dialog box.
- Click the Company Preferences tab.
- Highlight eZ Account Import line and click Properties. The Properties dialog box opens.
- Under the Access Rights tab select "Allow this application to read and modify this company file" and de-select Prompt before allowing access.
- Click OK on the Properties dialog box.
- Click OK on the Preferences dialog box.
Why do I need to login into QuickBooks® Online Edition each use of eZ Account Import to get a session ticket?
The session ticket is required to ensure that the person using eZ Account Import has valid access to QuickBooks Online Edition.
Not all of my transactions got imported into QuickBooks.
You are probably running the trial version of the product. The trial version only allows up to 5 transactions per session to be imported into QuickBooks.
I get an error when I import a .qif file that the dates are invalid.
In eZ Account Import, you will need to set the date format for QIF files in the Preferences window. You can access Preferences from the Select Import File window (this is where you select the file you want to import). Simply click on the Tools menu at the top and choose Set Preferences. You can also access the Preferences from the Import Transactions Window (this is the window that you see after you've uploaded your file into eZ Account Import). Again, you can access this from the Tools drop down.
When I upload my .xls or .csv file to eZ Account Import, it says that my file does not contain any transactions.
When you select an .xls or .csv file from the Select Import File window, you will be prompted by a Getting Started with Excel and CSV File pop-up message that will tell you how to format your .xls or .csv columns before importing. Select the ZSI Standard Format Full from the drop down menu if you want the following information imported.
Or you can choose ZSI Standard Format and have the following columns:
- Column 1: Date of Transaction
- Column 2: Amount
- Column 3: RefNo
- Column 4: Payee
- Column 5: Account
- Column 6: Memo
- Column 1: Date of Transaction
- Column 2: Amount
- Column 3: Transaction Number
- Column 4: Transaction Description
When I enter my activation key, I get an error message that says the key is invalid.
Make sure that you have downloaded and purchased the same product.
Can you import .pdfs into eZ Account Import?
No, you can’t import .pdfs into eZ Account Import, but you can copy and paste the information from a .pdf (as long as the file is not an image file) into Excel and save as an .xls, .xlsx or .csv file.
Am I required to import all transactions in an online bank export file?
No. You will be shown all the transactions in the export file and may select which transactions to import into QuickBooks®.
What do the different statuses mean for the Import File Table?
The statuses are explained below:
||The transaction was compared against the data in QuickBooks® and there was not a transaction with the same amount within a week of each other and with the same check number (or one having a blank number).
||The transaction was compared against the data in QuickBooks® and there was a transaction with the same amount, within a week of each other and with the same check number (or one having a blank number).
||The transaction was successfully imported by eZ Account Import into QuickBooks.
||The transaction was compared against the data in QuickBooks and there were two or more transactions with the same amount, within a matching time div and with the same check number (or one having a blank number).
||During the importing of the transaction, there was an error with the data in the transaction.
Can a matched transaction be imported?
Yes. The matching is purely done to help prevent duplicate entries in QuickBooks®. You may still select it for import. Note: A warning message will be shown to ensure the transaction wasn’t accidentally selected, but you may continue to import.
If I import a transaction and later decide I should not have imported it, can I remove the transaction?
Through QuickBooks you may void the transaction. Please refer to QuickBooks help on how to void a transaction.
How do I find out the error associated with a transaction?
Put the cursor over the transaction with the error and an error message will be displayed for that transaction.
How do I know whether the transactions were all imported?
After clicking the Import into QuickBooks button, a dialog box opens specifying the number of transactions attempted to be imported, the number successful imports and the number with errors. Clicking the Status column will sort the transactions in order of status. This is helpful for finding the transactions with errors.
How does the transaction get labeled as an error?
eZ Account Import will verify that the required data is present before attempting to import the transaction. If some data is missing, it will label the transaction as an error. Otherwise, the transaction will be attempted to be added to QuickBooks. QuickBooks will verify that the data is correct for the type of transaction selected for import. If there is error in the data, QuickBooks will provide the error message to eZ Account Import.
Can I split a transaction?
Yes. By right clicking on any transaction, a context menu is displayed. Select the Split menu option and the Split Transaction window will be displayed allowing you to split the transaction across accounts and/or customers.
Why does everything import as a deposit?
If you are importing a .csv file, the amount column needs to be negative for debits and positive for credits (deposits).
I’ve made some changes in QuickBooks while eZ Account Import is open. How do I get the information updated in eZ Account Import?
To refresh the information in the Transactions in QuickBooks Account section of the Import Transactions Window, click Tools in the top navigation and click on Reload QuickBooks Data.
What are Classes and how can I add them?
In QuickBooks, you can create classes that you assign to transactions. This lets you track account balances by department, business office or location, separate properties you own, or any other meaningful breakdown of your business.
In eZ Account Import, you will need to enable Classes in the Preferences window before you can assign them to a transaction. You can access Preferences from the Select Import File window (this is where you select the file you want to import). Simply click on the Tools menu at the top and choose Set Preferences. You can also access the Preferences from the Import Transactions Window (this is the window that you see after you've uploaded your file into eZ Account Import). Again, you can access this from the Tools drop down.
Once the Preferences window is open, click on the "Import" tab. The first option is "Use classes when importing into QuickBooks?" Choose the Yes radio button. You can also set default classes. Go to the "Default Values" tab within Preferences to set default classes.
What are Aliases?
Many times, data provided by your financial institution will not match the names you have created in QuickBooks for Vendors and Customers. Aliases enable you to create a mapping between online banking export file names and the names contained within QuickBooks. This enables you to set up a mapping and, going forward, the online banking data will be pre-populated with QuickBooks names.
Do aliases have to match the online banking data exactly?
No. When you set-up an Alias, you have the option of setting it to match the data exactly or to only contain the word(s) in the Alias. If you specify contain, eZ Account Import will search the whole transaction description and if the defined Alias is found anywhere in the description, the transaction will pre-populate with the Alias’ QuickBooks name.
I want to use eZ Account Import on a new computer. How do I transfer my aliases?
On your old computer, go to C:/ProgramData/Zachary Systems Inc. and copy the Autofill file over to the same directory on your new computer. You may need to enable hidden files/folders if you do not see the Program Data folder. See Microsoft Help for instructions on how to enable hidden files/folders.