eZ Account Import Support

Import Transactions Window

Import Transactions Window

The Import Transactions window enables users to:

• Review transactions from the online bank export file.
• Compare online bank file transactions versus QuickBooks account transactions.
• Select the transactions to import.
• Import transactions into QuickBooks.

Within the Import Transactions Window, there are two data tables: Transactions in QuickBooks Account table and Transactions in Import File table.

The Transactions in QuickBooks Account table displays transactions contained in QuickBooks for the date range of transactions within the online bank export file. This is a read-only table but it may be sorted on any of the columns by clicking the column header. The data can also be refined by using the QuickBooks Transaction Filter drop down menu. This filter allows you to find matching transactions in the Transactions in Import File table and the Transactions in QuickBooks Account table based on transaction amount or exact match.

The Transactions in Import File table contains all of the transactions in the online bank export file selected. The date, amount and memo are taken directly from the online banking export file. The payee and account may be populated based upon whether the memo field matches an Alias.The status will be Unmatched, Matched or Multi-Matched.

Matches occur when an existing QuickBooks transaction and online bank export transaction meet the following criteria. Note: These are default settings and can be modified using Preferences.

• Amount
• Check Number (if both transactions contain a check number)
• Date within three weeks of each other

By selecting any Matched transaction, the corresponding transaction in the Transactions in QuickBooks Account table becomes highlighted thus enabling comparison of the two transactions.

Note: You may override the Matched transaction and import the transaction.

Within the Transactions in Import File table, you can filter the data by clicking on the Filter Transactions button. This filter sorts data based on date range, status and description.

In order to import a transaction, the account must be selected as well as the Import? check box.

Once all the information has been set for the transactions to be imported, click the Import into QuickBooks button. Clicking Import into QuickBooks prompts eZ Account Import to start going through the list of transactions. For any transactions selected, eZ Account Import will attempt to import the transaction into QuickBooks. If successful, the transaction will be put in the Transactions in QuickBooks Account table and the status will change to Imported. Once each transaction selected has been attempted to be added, the Import Status dialog box opens and shows the number successfully imported transactions and the number with errors. The status column within the Transactions in Import File table will be updated. For transaction with errors, the row will be highlighted in red and the status will be changed to Error. Users may view the specific error message by moving the cursor over the row.

The window contains the following elements:

Element	Description
	File drop down menu
Select New File	Opens the Select Import File window to let you choose a new file
Exit	Exits the application.
	Transaction drop down menu
Add Alias	Opens the Add Alias window with a new form containing the transaction description of the transaction highlighted in the Transactions in Import File table.
Assign Bill/Invoice	Opens the Assign Invoice or Bill window allowing the assigning of an invoice or bill to the transaction.
Split Transactions	Opens the Split Transaction window for splitting the transaction for the transaction highlighted. Enables you to assign a transaction to multiple expense/income accounts.
Clear/Set Match	Sets or Clears Matched or Unmatched transactions in the Status column.
	Tools drop down menu
Add Vendor/Customer	Opens the Add Vendor / Customer window. This window enables the user to create a new vendor or customer within QuickBooks. The fields will automatically populate with information from the transaction highlighted.
Manage Aliases	Opens the Manage Aliases window for creating, editing and deleting aliases.
Set Preferences	Opens the Preferences window that lets you configure how you want transactions imported, matched, default values, and data storage location.
	Help drop down menu
Help Home	Opens a browser and navigates to online help for eZ Account Import.
Check for Updates	Opens a Check for Updates window and checks for new updates of the software.
Registration Information	Opens the Registration window and shows details on application registration.
Audit Log	Opens the Audit Log window and displays the last 30 days of activities.
About Zachary Systems	Opens a browser and navigates to Zachary Systems Home page.
	Transaction in QuickBooks Account table
Transaction in QuickBooks Account table	This table is a read-only table that displays the current transactions within QuickBooks. This includes any transactions successfully imported by clicking the Import into QuickBooks button. The table may be sorted by clicking any of the column headers.
Transaction in QuickBooks Account dropdown menu	Displays the list of QuickBooks bank accounts in QuickBooks allowing changing of the bank account to import the transactions.
QuickBooks Transaction Filter dropdown menu	Filter allows you to find matching transactions in the Transactions in Import File table and the Transactions in QuickBooks Account table based on transaction amount or exact match.
	Transactions in Import File table
Transactions in Import File table	Displays the transactions contained within online bank export file. The following information will always be populated from the online bank export file: Date, Amount, and Memo. The Payee and Account may be selected or can be populated via the Alias grid. Selection of this information is done via drop-down menus with the values coming from QuickBooks. Status is controlled by the application and may be: Unmatched, Matched, Multi-Matched, Imported or Error. The table may be sorted by clicking on column headers for Status, Date, Amount and Description. NOTE: The summary information reflects the currenlty displayed transactions in the online export file so filters will the totals.
Transactions populated field	The number of transactions contained within online bank export file.
Matched Transactions populated field	The number of transactions matched to existing transactions in QuickBooks. By default matches occur if the transaction has the same amount and date within two weeks of each other. This can be modified in the Preferences window.
Credit Transactions populated field	The number of credit transactions contained within online bank export file.
Amount of Credits populated field	The sum of credit transactions contained within online bank export file.
Imported Transactions populated field	The number of transactions that have been successfully added by clicking the Import into QuickBooks button.
Transactions Filtered populated field	Indicates whether the data has been filtered by the Filter Transactions function/button. If the data has not been filtered, “No” will be populated. If the data has been filtered, “Yes” will be populated.
Debit Transactions populated field	The number of debit transactions contained within online bank export file.
Amount of Debits populated field	The sum of debit transactions contained within online bank export file.
Start & End Date populated field	Date range of transactions within the online banking export file.
Select / Deselect All button	Selects/deselects all transactions for import.
Filter Transactions button	Filters the transactions displayed in Transactions in Import File table based on date range, status and description.
Import into QuickBooks button	Will attempt to import all transactions within the Transactions in Import File table that have the check box in the Import? column selected. When the import completes, a dialog box will open and show the results of the import.
	Transactions in Import File context menu
Transactions in Import File Context menu	Context menu is displayed when the user right-clicks on the Transactions in Import File grid.
Alias->Add menu option	Opens the Add Alias window with a new form containing the transaction description of the transaction highlighted in the Transactions in Import File table.
Alias->Edit menu option	Opens the Manage Aliases window for creating, editing and deleting aliases.
Assign Bill/Invoice menu option	Opens the Assign Invoice/Bill window allowing the assigning an invoice or bill to the transaction.
Set/Clear Match menu option	Sets or Clears Matched or Unmatched transactions in the Status column.
Split Transaction menu option	Opens the Split Transaction window for splitting the transaction for the item on which the right-click occurred. Enables you to assign a transaction to multiple expense/income accounts.