Bank Feeds |
Back Top Previous Next |
Bank feeds can be brought in to Jim2 to speed up the bank reconciliation process. Jim2 has the ability to filter transactions by merchant in settlements, can show the total for matched transactions and you can also unmatch a cardfile from a bank feed record.
Currently supported bank feeds:
If your bank is not listed, please contact support@happen.biz to arrange to set it up.
For an introduction to Bank Feeds, copy and paste this link into a browser: https://youtu.be/hKgbrHk07Lg.
Jim2 transaction matches to imported transactions as follows: ▪Auto matching will match by card code, invoice and payment number first. ▪Then by amount. ▪If it cannot match by card code, then by amount, only if there is a record with that amount. ▪The date needs to be plus/minus 4 days from the bank statement date
You can also partially allocate a payment, and the remainder will be saved as a credit/prepayment on the debtor. You can also enter a payment and not allocate to an invoice at all. This will be entered as a prepayment on the debtor account.
Go to Accounts > General Ledger and edit the bank account. Select the Transaction Import Bank name from the dropdown – this will pick up the mapping for the feeds.
On the ribbon go to Tools > Options > Accounts > Bank Feeds and select the Default Payment Types, and whether you would like Jim2 to automatch records after importing the file.
You then need to export your bank feeds from your bank as a CSV file. The resulting file would look something like this image, having the first line as headings line, then entries following that. Any blank or additional lines will need to be removed.
Go to Accounts > Banking > Bank Feeds.
Select the bank account, then click Import and locate the CSV file for importing. The Bank Transactions area will populate with the transactions. The Jim2 Transactions area will display transactions in Jim2 that have not yet been matched.
Explanation of colours Red text has two meanings.
▪When Show Processed is ticked it will mean these have been processed. ▪When Show Ignored is ticked it will mean these have been ignored. Green background means Jim2 has found a match against the transaction. White background means no cardfile found.
There is also the option to click the Auto Match icon to automatically match records after importing the bank feed.
Select a line in Bank Transactions, then find the correct line in Jim2 Transactions, click Match and it will appear in the Matched Transactions in the lower part of the screen. If there is no matching transaction in the Jim2 Transactions area, you will need to either create it or ignore it if you are not able to identify the exact details of the transaction. You will need to create the debtor payment which takes you to the debtor record in edit mode, with the payment already applied to the matched invoice(s), to complete the process.
Blue background in Matched Transactions means that Jim2 has auto-matched the transaction. You will still need to confirm these matches are correct.
If you have made any errors, you can click Unmatch, which will remove the matched transaction, or Unmatch All to remove all the transactions from the Matched Transactions area, so you can start again.
If creating a creditor payment, Jim2 will take you to the Creditor screen to complete the entry.
If the transaction is a receipt and Jim2 is able to match it to an outstanding debtor invoice or debtor record by card code or name, the transaction will have a green background
When entering a debtor payment, Jim2 will take you to the Debtor screen to make the entry.
Create button The Create button is used for creating transactions not already entered in Jim2. This includes bank fees, interest received or charged, bank transfers, and general journals. When selecting a payment/deposit into the bank account, the following is available from the Create button:
Transactions showing with a green background indicate that Jim2 has found a matching cardfile. Those with a white background indicates cardfile not found.
Explanation of areas within the Bank Feeds screen:
Further Information |