Upload Csv File to Credit Karma Investment

half-dozen.16. Importing Transactions from Files

Imported transactions volition generally exist to a specific business relationship in your account tree. In the following this volition be referred to as the import or base account. It may or may not be specified in the information being imported depending on the import format. It is usually the first split of a transaction beingness imported.

All transactions will likewise need to have a destination account for any other splits associated with the tansaction. These may or may non be supplied in the imported data, depending upon the data source and the format of the information. If it is not, GnuCash may exist able to assign an account on the basis of the previous import history by matching infomation in the imported data to data associated with previous account assignments in the importer. The user may always over-ride this automated consignment or where no consignment can be made automatically assign an account manually.

Multi-split data exported from GnuCash in CSV format will unremarkably accept both the import and destination accountsfor transaction splits specified in the data file.

6.sixteen.1. Import Formats

GnuCash allows transactions to be imported in a number of structured formats for the commutation of financial data as well equally in the unstructured CSV format, a plain text tabular format ordinarily used for the import and export of information to and from spreadsheets:

QIF (.qif) Quicken Interchange format - import data from Quicken financial software;
OFX/QFX (.ofx,.qfx) Open Financial commutation format (QXF is an Intuit/Quicken proprietary version of OFX);
CSV (.csv) Comma Separated Values;
MT940 SWIFT MT940 Customer End of Day Statement Message;
MT942 SWIFT MT942 Customer Intra-day Transaction Report;
DTAUS (.DTAUS) Banking data Exchange File;

	Note
	Files using these formats do not necessarily use the file extensions shown above.

These import methods can be accessed from the → sub-menu entry, along with methods for importing other types of data. Select the advisable entry from the → sub-menu to initiate importing transactions.

6.sixteen.2. Import Preference

User preferences set in the Import tab or the Online Cyberbanking tab of the user preferences accessed by → from the menu will affect the importing of transactions from the files described beneath.

vi.16.3. Import QIF

To import data from Quicken®, MS Money®, or other programs that use QIF(Quicken® Interchange Format), you must first export your data to a QIF file. 1 style to exercise this is to consign each account as a split QIF file. An easier fashion, available in Quicken® 98 and across, is to export all accounts at once into a unmarried QIF file. Bank check your program's manual to determine if this option is available.

half-dozen.16.3.one. To import QIF files:

Select → → from the menu to open the QIF Import dialog box illustrated beneath.

Figure 6.3. The Import QIF Files Assistent

Dialog Navigation.The right hand pane will display some or all of the following navigation buttons:

Cancel : Exit the dialog;
Back : Go dorsum to the previous step;
Side by side : Go on to the side by side stride.

The buttons displayed are determined by whether navigation to the destination step is valid from the electric current step.

Import Dialog Steps.The left paw pane lists the steps in the import dialog process. The correct manus pane contains instructions and/or controls for performing the operations in the footstep selected and highlighted in the left hand pane. The import process steps are:

Import of QIF files : Initial informational panel. Click Next to proceed;
Select a QIF file to load : Open a file selection dialog. Navigate to and select the file you lot wish to import and click Import . Then click Adjacent ;
Load QIF files : Click the Start button to load the file. The file volition exist parsed and loaded. If errors or warnings occur you lot may accept to remove the file, edit it and reimport information technology. If there are no errors click Side by side ;
Set a date format for the file : Select a date format (m-d-y or d-m-y) appropriate to the locale of the source of your QIF file. In the Us this is mostly grand-d-y and in Europe d-m-y;
Set the default QIF account proper name : If the QIF file does not specify an account name, enter an account proper name. If importing data from another bookkeeping program you should employ the proper name used in that programme;
QIF files you have loaded : This step allows you to edit the list of files to be imported and to load additional files. To remove a file, click on the row and then click on Unload selected file . To load some other file click the Load another file . When you have all the files you lot wish to import loaded, click Next ;
Accounts and stock holdings : Data console. Click Side by side to proceed;
Match QIF accounts with GnuCash accounts : QIF account names are matched to GnuCash accounts if possible. New GnuCash accounts are created if no matching accounts are found. For stock, the required business relationship structures are too created. Created accounts are indicated by checking the checkbox in the New column. Assigned accounts may be edited past selecting the appropriate the row and clicking on the Change GnuCash Account button to to run the account pick dialog;
Income and Expense categories : Information console. Click Adjacent to go along;
Match QIF categories to GnuCash accounts : QIF categories are matched to GnuCash accounts where possible. New GnuCash accounts are created where no matching GnuCash business relationship is plant. Created accounts are indicated by the checkbox in the New column being checked. If y'all are non certain what changes are needed, it is safe to accept the GnuCash account names. These may be changed later in GnuCash . Assigned accounts may be edited by selecting the appropriate row and clicking on the Change GnuCash Account button to run the account selection dialog;
Payees and Memos : Information folio. Click Next to proceed;
Match payees/memos to GnuCash accounts : QIF payees and memos are matched to GnuCash accounts where possible and new accounts are created where this is not possible again indicated by the checkbox in the New column. The assigned account may be changed past selecting a row and clicking on the Change GnuCash Account push to to run the account selection dialog;
Choose the QIF file currency : Select the required currency from the dropdown list and click on Next to continue;
Tradable commodities : Not withal implemented;
QIF Import : Click on Start to begin the import. GnuCash currently proceeds to the Update your GnuCash accounts tab if the import is successful;
Match existing transactions : Not yet implemented;
Select possible duplicates : Not yet implemented;
Update your GnuCash accounts : Click Employ to complete the import. Depending upon the size of your file, the import might have a few minutes to complete, so a progress bar displays the per centum finished. When the import procedure is complete, GnuCash will return y'all to the main window, which should now display the names of the accounts you imported.

Other features are non currently implemented;
QIF Import Summary : Click on Close to exit the wizard.

6.16.4. Import OFX/QFX

->-> opens a file selection dialog. Navigate to the file you wish to import, select a file with the appropriate extension (.ofx or .qfx), then press the Import button.

GnuCash then opens an Business relationship Choice dialog to select an account in your CoA to match to an account name in the import file. Select the appropriate account from the account tree and printing the OK button. On subsequent import of files from the same source account, the mapped GnuCash account is remembered and the account selection dialog is non displayed.

The generic import transaction matcher dialog is opened adjacent. See the Import Matcher section (mutual to both OFX/QFX and CSV import formats) following the Import CSV department to proceed the import process.

6.sixteen.5. Import CSV

Clicking on ->-> will bring upward the CSV Transaction Import Assistant dialog illustrated below.

Figure 6.4. The CSV Transaction Import Assistant - Introduction

The CSV Transaction import Assistant is largely self explanatory with information panes which draw the functionality.

Dialog Navigation.Each pane displays a selction of the following navigation buttons at the lesser right:

Cancel Leave the CSV Transaction Import Assistant;
Back Return to the previous pace in the assistant;
Side by side Proceed to the next step in the assistant.

The buttons displayed are adamant by the validity of the traget footstep from the electric current footstep.

CSV Import Process Steps.The steps in the CSV import process are listed in the left paw pane with the electric current pace highlighted. Explanatory text and the widgets to setup and carry out the pace are displayed in the right hand pane. The office of the controls in each step is explained below, in the explanatory information in the panes or in tooltips on some controls. The steps in the CSV import process are:

Transaction Import Banana : Introductory information panel. Click Next to continue;
Select File for Import : Display the File option dialog. Navigate to the file you wish to import then click the Next push button;

Import Preview : The Import Preview pane controls ready options for the import of CSV data and provides a preview of the information to be imported.

Figure vi.5. The CSV Import Preview Pane

Import preview Controls

Load and Relieve Settings : One time y'all accept fix all the import parameters, you tin salvage these settings past typing in a setting a unique name in the Load and Salvage Settings Entry combo box and clicking the Save icon but to the right of the box. A previously defined settings group can be retrieved by selecting the appropriate setting group name from the dropdown list activated by the downward arrow at the right end of the text box. This will set up all other settings to the stored values.

The delete/trashcan icon to the right of the Save icon tin be used to remove the saved settings group selected from the drib down list for the box.

The settings group GnuCash Export Settings defines a setting group for used for the export and reimport of GnuCash transaction data - use this if importing data previously exported from GnuCash ;
Account : If the information yous are importing does not specify the source account for the transaction an account can be selected from the drop downwards list will import all transactions to the selected account. Leave blank if your imported information specifies a source business relationship;
File Format :
- Separators : Selecting this radio push will let you to ascertain characters which will exist used to distinguish columns in the input file. The default is comma separated. In countries using the comma as decimal separator the semicolon is common every bit cavalcade separator. Even so spaces, tabs, colons or semicolons or any combination of them may be used to carve up columns in the input file by selecting the appropriate check boxes. You lot may as well ascertain custom separators by typing the required characters into the text box and selecting the Custom checkbox. This may be used in combination with whatever of the predefined separators;
- Fixed-Width : Selecting this radio button will allow you lot to ascertain column boundaries past double clicking at the advisable positions in the sample records displayed in the panel below. Unmarried clicking in a column will narrow, widen or merge the cavalcade.
Multi-split : Selecting this check box allows the splits for a single transaction to exist defined on consecutive lines inside the file with each line defining a single split. If not selected each line is assumed to incorporate the information for a single transaction including one or two splits;
Miscellaneous : The miscellaneous settings allow you to set:
- Encoding : This is ordinarily UTF-8, but may differ for files from other sources;
- Appointment Format : This does not default to the Locale setting and then bank check it matches the information you are importing;
- Currency Format : Select the format of the decimal separator (total stop or comma or other) for the currency if the correct value is not supplied by Locale;
- Leading Lines to Skip : Select the number of header lines to skip in the imported file;^[4]
- Trailing Lines to Skip : Select the number of trailing lines to skip in the import file;^[4]
- Skip alternating lines : Use to skip every second line in the import file.
to lucifer the settings for the file yous are importing. Tooltips may too contain information on the setting and options.

The import panel shows the data being imported equally it is interpreted using the settings chosen to define columns and formats. The dropdown lists in the headers for each column of the import allow you lot to associate a specific column in the imported information with a specific field in the display of a transaction in an business relationship annals. At a minimum to import information, columns in the imported data containing the following data must be specified:

Date : of transaction;
Account : into which transaction is to be imported (or alternatively set the base account as higher up);
Description : of the transaction;
Deposit or Withdrawal : column.

The dropdown list of GnuCash transaction data fields which may be associated with a column of the imported data contains the following:

None : The column is not assigned to a transaction data field and is not imported;
Date : Ensure the appointment format in the cavalcade matches the Miscellaneous date Format Setting;
Num : Transaction Num field - Use for check numbers etc.;
Description ;
Notes ;
Transaction Article ;
Void Reason ;
Action ;
Business relationship : This header should exist matched to a column specifying the source account for a transaction if it is present. Otherwise, set the source account in the Account combo box;
Deposit : Apply this header to a column containing the corporeality of the transaction. Positive amounts in the cavalcade generally correspond an increment in the account residuum and negative amounts a decrease in the residuum (asset accounts: Checking, Savings). In external statements supplied by a banking company for a check or savings business relationship, a credit (Cr) is normally an increase in the account residue and a debit (Dr) a subtract in the account balance. In the banks optics, your savings or checking business relationship is a Liability to them;

If the amount data is in separate columns for debits and credits you will have to apply both this heading and the Withdrawal heading.

Withdrawal : Apply this header to a cavalcade with the corporeality of the transaction where positive amounts in the column stand for a decrease in the account remainder and negative amounts an increment in the residue (e.g. Liability business relationship: credit card).

Where separate columns are used for debits and credit to the account apply it to the opposite to the column to which Deposits is practical;

	Note
	Some experimentation may exist necessary to determine the right allocation of the Eolith and Withdrawal headings.

Price : The price for commodity transactions and/or transactions involving currency commutation;
Memo : Boosted column containing descriptive information relevant to i dissever of a transaction. If in the first line of a multi-split import information technology will apply to the source account. In subsequent lines/splits it is applied to the transfer account defined in that line or allocated to it in the matcher;
Reconciled : Apply to a column indicating the reconciliation condition of the transaction. This more often than not merely applies to information exported from GnuCash ;
Reconcile Date : Apply to a column which specifies the date of reconciliation, more often than not but for GnuCash exported data;
Transfer Activity ;
Transfer Account : This header should be applied to a column which specifies the transfer account for the second divide of a single line import and/or for subsequent splits in multiline exported transactions;
Transfer Memo : Use to a cavalcade with descriptive information relevant to a split to a transfer account specified past Transfer Business relationship ;
Transfer Reconciled : Apply to a column with reconciliation status information relevant to a split to a transfer business relationship specified past Transfer Account ;
Transfer Reconcile Date : Apply to a column containing a reconciliation date relevant to a split to a transfer account previously specified in Transfer Account .

The Skip Errors check box will skip trying to import any rows with errors in matching the columns.

When you are happy with all the import settings, save them if you will use the aforementioned settings again, then press the Next button.

Match Import and GnuCash accounts : This window allows you lot to map the accounts identified in the business relationship columns (Account and Transfer Account) with accounts in the GnuCash account tree (Account name). Double click on a row to bring up a dialog to select the matching GnuCash business relationship. If you lot accept previously imported transactions to this account and business relationship mappings can be matched automatically, this window will non be displayed. When yous have selected a match for all accounts, click on the Next push;
Transaction Data : The Transaction Data panel allows review of data entry settings then far. Clicking Adjacent will perform checks on the data. If there are errors you will exist returned to the Import Preview pane to edit the settings. For no errors you lot proceed to the next step;
Match Transactions : Clicking on Match Transactions will and so bring up the main Import Matcher window. The Import Matcher is described in a separate section;
Import Summary : GnuCash displays a summary of the imported data. Click on the Shut to leave the wizard.

	Circumspection
	Multi-dissever imports of multicurrency transactions and article transactions are experimental and may currently feel some errors. Please experiment and report whatever bugs encountered.

6.sixteen.6. Import MT940 and MT942 SWIFT and DTAUS format files

The SWIFT MT940 format is used for an finish of solar day statement by banks using the SWIFT network for data exchange. MT942 is used for an intra-twenty-four hour period argument in the same system. DTAUS is a format used with 9 track magnetic tapes since 1976 and later with other removable media (floppy disks). DTAUS has not been supported past banks since 1 February 2016.

When you select ->->

from the menu, GnuCash opens a file selection dialog. Navigate to the MT940, MT942 or DTAUS format file you wish to import and so click on the Import button. On the first import of information to a given account specification in the import file, GnuCash volition bring up an business relationship pick dialog to select an advisable business relationship into which to import the transactions in the file. GnuCash will map the account description in the import file onto the selected account and use it for future imports from the same account. The imported transactions will so be displayed in the for review.

vi.16.7. Generic Transaction Import Matcher

half-dozen.sixteen.7.1. Introduction

Figure 6.six. The Generic Transaction Import Matcher Window

The Import Matcher checks whether an imported transaction matches an existing transaction already recorded in GnuCash inside a predefined time window (~+_42 days) for the account into which the transactions are beingness imported. A match probablity is calculated based on the Engagement, Amount, Transaction ID's (if present), Bank check numbers (if nowadays) and the Description and split Memo fields. Exact matches will generate a high match probability and flag a transaction equally matching an existing transaction and therefore not to exist imported. If at that place is a lower quality lucifer to an existing transaction, the imported transaction may be flagged for updating of not-matching information in the GnuCash record of the matching transaction. These decisions can exist overridden by the user.

If no matching transaction can be identified the transaction volition be flagged for import. The matcher will endeavor to assign a transfer business relationship based on matches between tokenized information for previously imported transactions stored in lists associated with the transfer accounts which were assigned to them on import.

If a good match is obtained, the transfer account is assigned and the transaction is flagged every bit ready to import.
If a transfer business relationship cannot be assigned, the transaction will exist flagged for import and manual assignment of the transfer account by the user. By default, if no transfer business relationship is assigned, transactions will be assigned to an Imbalance business relationship on import. This is to bespeak that they need an appropriate account assigned to them.

6.16.7.2. Import Formats

The generic import transaction matcher is invoked when transaction data is imported using whatever of the following import formats:

QIF;
OFX/QXF;
CSV;
MT940;
MT942;
DTAUS.

six.16.7.3. Controls

6.16.seven.3.1. List of Controls

This window has the following

Controls:

List of downloaded transactions : Table containing information from the imported transactions.
Evidence Account column : Checkbox to display the business relationship into which the transactions are being imported. This is the 2nd column labelled Account in the screenshot;
Show Memo cavalcade : Checkbox to display the Memo from the imported transactions after the column labelled Description ;
Show matched data : Checkbox to display the matched transaction which has been already imported or entered into GnuCash . If there is one, this will be a line with a white background (by default) after the imported transaction. This is either the manually selected match if one has been selected or the best possible match otherwise;
Append : Checkbox to indicate that when updating and immigration a matched transaction, the imported Description and Notes are to be appended to the matched transaction Description and Notes respectively, rather than overwriting them. When the OK button is clicked, the country of the checkbox is saved so the next import for that account will automatically default it to the saved country;
Reconcile subsequently match : Checkbox to automatically start the reconciliation process after transactions accept been matched and imported;
Help : Display a popup assistance window;
Cancel : Close this window without importing transaction data;
OK : Close this window importing transaction data;

6.16.7.iii.2. List of downloaded transactions

The List of downloaded transactions has the following columns which display the following information for each of the downloaded transactions:

Columns in "List of Downloaded Transactions"

Date - The engagement supplied with the downloaded transaction;
Account - The import or base account to which the transactions volition be imported (optional come across above);
Amount - The corporeality of the transaction (divide to the import or base business relationship);
Clarification - The description of the transaction;
Memo - The memo for the split to the import or base of operations account of the transaction (optional see higher up);
A - Add - Checkbox which indicates that the transaction is to be imported as a new transaction;
U+C - Update and Clear - Checkbox which indicates that the transaction matches an existing transaction only has some differences and the existing transaction will be updated with the different data;
C - Clear - Checkbox which indicates that the transaction matches an existing transaction and will not be imported;
Info - For transactions which have been matched to an existing transaction, this column displays a bar indicating the quality of the match;
Additional Comments - Shows what is to happen to the transaction and the transfer account if known;

half dozen.16.7.3.iii. Import Status

In addition to the checkboxes, the import status of each transaction is indicated past the background color of the transaction row. The checkbox state, background colors and their meaning are described in Tabular array 6.1, "Import Status of Transactions".

Table 6.1. Import Status of Transactions

Checked Box	Groundwork	Significant
A	Gold	No matches, flagged for input and no transfer account matched – Import every bit a new transaction. Intervention required to select a transfer account.
A	DarkSeaGreen1	No matches detected, flagged for input and a transfer account is matched – Import as a new transaction. Reconciliation status will be set up every bit cleared (c) on import. Intervention is not required.
U+C	DarkSeaGreen1	Matches an existing transaction but not exactly on date and/or corporeality – Intervention non required, import and update. Reconciliation status volition be set every bit cleared (c) on import.
C	DarkSeaGreen1	Matches an existing transaction: – Not to be imported. The existing transaction reconciliation status volition be equally cleared (c) on import. Intervention is not required
	Brown1	Transaction has poor matches and no action was set: – Not to be imported. Intervention required.
	Cornflower Blueish	Row is selected

	Annotation
	The colors illustrated here are the defaults for `GnuCash` specified in gnucash-fallback-310.css. You may experience different colors if the gtk-3.0 CSS files have been modified

Y'all may always intervene manually to

change the import activity by selecting another checkbox (or none) and/or
manually assign a different transfer account

after reviewing the matched transactions and accounts and the automatically selected actions.

Multi row pick is enabled for the listing of downloaded transactions. The following operations can be performed on the list of downloaded transactions:

Click Button1 (see Mouse Buttons) on a row : Select this row (row is displayed with a blue background);
Double-click Button1 on a row : If the transactions is flagged for import (run across below) this will open up an account selection dialog to select a destination/transfer account to be used in the second split of the imported transaction. Yous may create a new business relationship if necessary in this dialog using the New Account push button. If the transaction is flagged as matching an existing transaction either for import or updating, the friction match picker dialog is opened to allow the matched transactions to be examined and a correct match selected;
Ctrl+Button1 on a row : Add the row to a selection of rows (displayed with a blue background) to which a single destination/transfer business relationship may be practical;
Shift+Button1 on a row : Select all rows betwixt the last selected row and this row and add them to the current selection of rows;
Click Button2 in the window : Brandish a popup menu which when clicked in turn opens a dialog to select a single destination/transfer account which volition exist applied to all rows currently selected.

	Important
	Information technology is important to assign a transfer account to each transaction prior to import of the transactions. Otherwise the tokenized data from the imported transaction volition not be appended to the list of tokens for an assigned account for use in hereafter matching of transactions to transfer accounts.

	Notation
	Note that "reconciled" in this context does not mean the same as "reconciled" in the procedure of reconciling an account to an external argument. The reconciliation status of an imported transaction is set to cleared (c) on import of a new transaction. See Setting the reconcile status (R field) of a transaction for details of the values of reconciliation status.

Where a row has been matched to an existing transaction or is to update an existing transaction it will have a DarkSeaGreen background. Double-clicking Button1 on the row will bring upwards the Match Picker dialog which displays detail of the imported. If you, feel the incorrect transfer business relationship has been assigned or the matcher has not produced a valid result, you may change the checkbox pick if you disagree with the matcher decisions and you lot may reassign an assigned transfer account (see below).

Double-clicking Button1 on a row marked as New with a DarkSeaGreen1 background and a transfer business relationship assigned to information technology will bring up the account selection dialog to allow you to choose a different transfer account for the second split.

Double-clicking Button1 on a row marked New with no transfer account matched with a Gold background volition also bring upward the account pick dialog to allow you to assign a suitable transfer account to the transaction.

6.16.7.four. Assign a Destination Business relationship to a Single Transaction

Select the required row by clicking Button1 on it. It is displayed with a Cornflower Blue background color.

Double clicking Button1 on a row will select it and open an Account Pick dialog to allow you to assign a transfer business relationship. Select the desired transfer business relationship in the dialog and click OK . The dialog has a New Business relationship button which will allow you to create a suitable account if in that location is no existing account which can be applied equally the transfer account.The row background will modify to a DarkSeaGreen1 and the assigned destination business relationship will exist displayed in the Info column.

or alternatively, Button1 click on a row to select it followed by a Button2 click to bring up a popup menu then select to brandish the Account Selection dialog, select the destination account and click the OK button.

6.16.7.v. Assign a Destination Account to Multiple Transactions

Sometimes you will have several transactions which can have the same destination business relationship. GnuCash allows yous to select multiple transactions and use the same destination account to all transactions in the pick.

Rows in a choice are displayed with a Cornflower Bluish background.

Merely rows which take the A checkbox checked and either a DarkSeaGreen1 or Gilt background colour can be selected for inclusion in a multiple option. Rows with a Brown1 background or with the U+C or C checkboxes checked cannot be selected in a multiple selection.

To select rows and add rows to a selection either:

Click Button1 on first row and then Ctrl+Button1 on other rows to add together to the choice; or
Click Button1 on first row so Shift+Button1 on another row to select all rows between them.
Rubber banding is besides enabled and so you may likewise hold Button1 and elevate over rows to create a selection. To add more than rows, Ctrl-Button1 and drag over more rows.

so Button2 to brandish a popup menu so select to open up the Account Selection dialog. Select the desired destination account (create a new account if necessary) and click the OK push button in the Account Choice dialog.

half dozen.sixteen.vii.vi. Completing the Import

One time you have assigned destination accounts for all the imported transactions using the to a higher place methods (all row backgrounds will be a light green colour), check that the assigned destination acounts are correct and so press the OK push button at the bottom of Figure 6.six, "The Generic Transaction Import Matcher Window". The transactions selected for import will take their splits added to the selected source and destination accounts.

The tokenized data from the transactions assigned to a given transfer account is stored on exiting from the matcher and is used to lucifer transactions to the appropriate transfer business relationship in futurity imports.

6.16.8. Lucifer Picker

The Match Picker allows you to review and edit existing GnuCash transactions which have been matched to a transaction being imported. Button1 on a row with the C checkbox checked to bring this dialog up.

Figure 6.7. The Friction match Picker Dialog

The top pane of the Match Picker displays details of the first split of the transaction to exist imported. The column labels:

Business relationship
Date
Amount
Description
Memo
Balanced

are the aforementioned and take the same meaning as in Department 6.xvi.7.3.ii, "Listing of downloaded transactions" with the exception of the Counterbalanced cavalcade which gives the amount of the balancing split for the transaction.

The lower pane displays the details of existing GnuCash transactions which friction match this transaction. If no transactions are displayed check the Bear witness Reconciled checkbox at the bottom of the console. The first row in this pane volition unremarkably exist the auto-matched transaction with the best match score. Other rows volition display other existing transactions which might also be matches for the transaction being imported. The columns in this pane are:

Confidence : This column indicateds the confidence of the individual match as both a bar nautical chart and a numerical value. Where the bar extends into the light-green, the match is good. If the bar only extend to the carmine or xanthous setions the quality of match is more than doubtful.
Appointment
Corporeality : If this does not friction match exactly the corporeality of the transaction being imported but otherwise the match is skillful, the amount of the imported transactions is used to update the existing transaction matching information technology.
Clarification
Memo
Reconciled : Indicates the reconciliation status of a matching existing transaction.
Awaiting Action

If yous are not happy with the existing transaction that was auto-matched, Button1 on your preferred match to select it and and then Button1 the OK . The transaction will and then be marked equally a (manual) match in the Info column of the Import Matcher. To go out the dialog without irresolute the machine-friction match Button1 on the Abolish .

6.16.ix. Import Match Editor

The Import Match Editor allows you to edit the data used by GnuCash to automatically assign a transfer business relationship in the Import Matcher. It tin can be used to edit the information used by the Bayesian matcher, the Non-Bayesian matcher and online ID's. To open it select -> from the bill of fare.

Effigy 6.8. The Import Map Editor

The three radio buttons at the top of the dialog select the blazon of information beingness displayed and edited:

Bayesian : The Bayesian matcher matches a transfer or destination business relationship using the frequency of association of a token string with an assigned transfer/destination business relationship in the Import matcher for a specific source account (the account that the first carve up of the imported transactionis directed to);
Non-Bayesian : The Non Bayesian matcher matches the transfer account on the basis of the occurrence of a token string in transactions assigned to a transfer/destination account and does non record the frequency of association. This was the original GnuCash matching process and has now been superceeded past the Bayesian matcher in more recent versions;
OnlineiD : Online ids are specific strings which identify specific accounts in information downloaded from online sources. they may include account numbers and specific instiution identifiers.

The Bayesian matcher information columns are:

Source Account : This is the business relationship into which a transaction has been imported and is unremarkably the first split in an imported tape. It may either be specified in the tape itself or during the import setup for all transactions to be imported. The pointer control at the left of each entry in this column may be used to display all the information used in matching a transfer or destination account for transactions which accept this account as their source split;
Match Cord : This cavalcade displays a specific token cord that has been associated with the allocation of the business relationship in the Mapped to Account Proper name column equally a transfer/destination account for transfers to the Source Account ;
Mapped to Account Name : The business relationship proper name in this column is a GnuCash account proper name which has been allocated as a transfer/destination account in clan with the token string in the Friction match Cord cavalcade;
Count of Lucifer String Usage : This is the number of times the token string in the Friction match String column has occurred in clan with the transfer/destination business relationship specified in the Mapped to Account Name column for transactions imported to GnuCash .

The Non-Bayesian matcher displays the same outset 3 columns every bit the Bayesian matcher having the same usage. It does not shop information on the frequency with which a detail token is associated with the assignement of a given transfer/destination account. It has an additional column which specifies the type of the imported information process in which the assignment occurred.It has the following columns:

Source Account ;
Based on : This identifies the import process in which the Match String was associated with the transfer destination business relationship in the Mapped to Account Name column;
Match Cord ;
Mapped to Business relationship Proper name .

Online ID displays the same columns with the same data every bit the Not-Bayesian matcher.

The Filter textbox at the bottom of the dialog allows filtering of the displayed data matching the entered string in either the Lucifer String column or the Mapped to Account Proper noun column.

The Aggrandize All and Collapse All buttons aggrandize or collapse the data in the other columns for the accounts in the Source Business relationship column.

The Delete button will delete whatever selected rows in the displayed matcher information.

The Shut button closes the Import Match Editor dialog.

huertaphright.blogspot.com

Source: https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html