hi and welcome to our training video on how to use bank feeds through the course of this
video you will learn how to use the bank feeds feature in Jim2 to help you speed up
entering creditor and debtor transactions as well as performing bank reconciliations
this feature is available from Jim2 Version 4.4 and onwards
and does not require any additional Jim2 Licensing to use bank feeds you will need to have downloaded
a list of transactions from your bank in .csv format for importing into Jim2. you will also
need to link at least one bank account in your general ledger to the bank that it represents
to set up the account in the general ledger go to accounts general ledger
double click on the bank account you'd like to use for importing and change the drop-down for
the transaction import bank to suit your bank account the entries you see represent a default
for how the sheets from those banks are set out and therefore how they will be imported to Jim2.
there are several options here that cover all major australian banks but if you find that your
bank isn't listed please let us know so now we have our .csv file from our bank and we've set
up our GL account let's take a look at how we can use this feature go to accounts and bank feeds
first we must select the account that is associated with the bank account
now that this is set let's import our .csv file,
click the button in the top left of the screen and select your file from the directory
once it is imported you'll see that the left hand side of the screen
populates with the bank transactions the bottom section will show the matched transactions
and the right hand sign will show unmatched Jim2 transactions
Jim2 will attempt to auto-match as many transactions as it can
using the following hierarchy it will check the card code and name on the account invoice number
contact information and payment number as well as the amount of the transaction
there can be false positives for example a line could contain ATO but this string of letters
could be found inside the name of a card file so you will need to confirm the matches
please note that the date of transaction has to be plus or minus four days
we recommend this process as a daily task to ensure that you can auto-match as much as possible
the transactions that auto-match will move to the bottom of the screen
leaving only unmatched or partially matched items in the left and right parts of the screen
if you find an auto-match that is incorrect simply highlight the match and then click unmatch
to manually make a match select the transaction on the left hand side
and the right hand side and then click match you may find that there are transactions on the bank
side that do not correlate with any transaction on the Jim2 side this may mean that there is not
a transaction yet created on the Jim2 side in the middle section there is a create button this
button will allow you to create transactions while matching to help make the process more efficient
this button will allow you to create the following types of transactions
that is payment creditors refund bank interest bank transfer deposit and general journal
when creating most transactions Jim2 will take you to the relevant section of the program
when creating a debtor's payment or creditors refund however
you will get an additional screen in which you can further attempt to match transactions
this screen will bring all unmatched transactions from Jim2
into view so that you can either search for the correct transaction or add a new payment
the debtors payment and creditors refund screens function in the same way using the tabs
we can search between completed unmatched payments
or if you need to create a prepayment any jobs that have not yet been completed
one of the main differences between these screens is that the debtors payment screen can auto-apply
amounts to unpaid data invoices and you can search by BPay reference
if you're unable to find an existing transaction at this point
you can add a payment by adding a card code
and payment method and then clicking create payment
most information will pre-populate but you will need to make sure that the information
is correct before committing the transaction
there is also an ignore button which will allow you to select a transaction
on the left or right-hand side of the screen to hide the entry
you can still see ignored transactions if you tick the checkbox under it titled show ignored
when you have added as many matches as your time allows
you can click the confirm matches button in the bottom right of the screen if you have the
checkbox ticked to open bank reconciliation after confirming then this will open.
on the bank reconciliation screen if you look for the date that you've performed the matching
you'll see a tick in the reconcile column against each of the entries
click save and that will complete the process
This concludes the training video for bank feeds. Thanks for watching.