|
To display this screen:
In screen BS412S01, click one of the Processing
buttons
In this section
Processing imported data from a downloaded statement
In all cases (all types of Downloaded files) screen BS412S02 will appear when importing data from a downloaded statement.
Screenshot BS412S02-1
This
is a staging screen. The transactions found in the downloaded file are listed but have not been imported at this stage.
Lines beginning with Yes
will process.
Make sure the correct data appears in the appropriate columns.
Do not proceed if the date, amount etc fields appear to be incorrect.
ALSO: Make sure that you have selected the correct Bank to Import your transactions into (this is listed at the top of the screen)
You now have the opportunity to review the transactions and manipulate the transactions to be imported.
Right click in the list for special Multi-select Options.
Use the Exclude or Include buttons as
explained below
Using the Exclude and Include buttons
Note that you
have options to Exclude
any selected transactions from the import, as shown in the screenshot above.
This feature may be useful if you have already manually entered transactions which appear in the data to be imported.
Right click in the list for special Multi-select Options.
The Reverse button
This will change Credits to Debits and
vice-versa.
More info:-
This action is required in VERY rare cases.
In Bank Genie, purchases and other expenditure are entered as Debits.
Payments
and other income are entered as Credits.
Most downloaded files align with this format.
Only one instance has been reported to contradict with this
format.
In such a case, clicking the Reverse button will change your Debits and Credits to the format required in Bank Genie.
The Process button
When you have double checked that you have selected the correct Bank to receive the transactions in the downloaded file, continue with the Import by
clicking the Process button
FEATURES FOR WORKING WITH EXCESSIVE “PaidTo” DATA
The downloaded csv files from some banks have a large amount of
text in the PaidTo field.
This was first reported by a Santander customer. We now have found others.
To cope with this, we developed a special feature in
Bank Genie to allow the customer to edit the downloaded transactions at the “staging” screen (BS412S02).
The user can now edit the PaidTo data in
the individual transactions and abbreviate the PaidTo text to something more meaningful.
Additionally, this edited PaidTo text (and Category selected) is
now saved to a file as a “Preferred” combination.
This Preferred option is then applied in subsequent imports.
You can have multiple
PaidTo/Category combination Preferences for the same value of PaidTo.
You can nominate one of these combinations to be the MAIN preference.
If you have
nominated a MAIN preference, this MAIN Preferred option is then applied in subsequent imports.
The SHOW button related to transactions when PaidTo is too long
Use this button to highlight all transactions with paidto field greater than 40 characters long.
These transactions are profixed with ++
These
transactions should be edited so that the text length does not exceed the maximum allowed in Bank Genie (i.e. 40 characters)
The SHOW button related to There are xx other transactions like this
After clicking on a transaction, use this button to highlight all transactions whose paidto text is EXACTLY the same.
The highlighted transactions
will be changed if you click click the Apply to all like this
button.
Very often, you can see transactions which are very close to being identical but are not highlighted.
If the edited text is CONTAINED in these transactions, they will also be changed when you click the
Apply to all like this button.
The Show Suggestions button
Click this button
to show a list of preferred PAIDTO options and a list of previously used values.
Screen BS412S06 will appear.
Use this when a PaidTo recipient has multiple
categories.
Bank Genie will autocode transactions (when you click a button in screen BS412S01) with the MAIN PaidTo/Category (the most frequent type of
transaction).
If you have previously applied another category to the SAME PaidTo text, then you can quickly select a previously applied combination in screen
BS412S06 and apply to the transaction being edited in BS412S02.
The Apply to THIS button
Click this button to apply the
edited values of PaidTO and Category to the selected (THIS) transaction ONLY
The Apply to all like this button
Click this button
to apply the edited values of PaidTo and Category to all LIKE transactions
i.e. transactions whose imported value of PaidTo is identical to the selected
transaction.
Additionally, If the edited paidto text is CONTAINED in OTHER transactions, the change will also be applied to those transactions.
See
Screenshot
The Reset THIS button
Use this button to Reset the value
of PaidTo to its value before editing.
Applies to the currently selected transaction ONLY
Screens for program BS412
|
