Daily Processes to Download Bank Transactions and Import them to your Cash Book.
Introduction
You can download your bank transactions from your bank and import these to your Cash Book.
Transactions that have been presented at the bank can then be matched to the transactions in your Cash Book, enabling you to reconcile your bank account.
Where previous transactions have been cross referenced, new transactions with the same details can be matched automatically by the system. Anything that has not been matched automatically can then be manually matched and reconciled.
Download Bank Transactions
You can download your cash transactions from either your banking software, or your Internet bank site.
Take care selecting the date to ensure you obtain all transactions up to close of banking yesterday which have not yet appeared on a bank statement.
You can download and process bank transactions on a daily, weekly or monthly basis, according your business requirements.
| Tip: If you have a large volume of transactions, you may prefer to run this process on a daily basis. If you run it less frequently, or miss a day, then the transactions from previous days that have not been processed will be included in the next download. |
Import Bank Transactions
This process imports the transactions that have been presented to your bank, and that you downloaded in the previous step.
Lentune sorts the imported transactions in to date order. e.g. where you import monthly.
Presented bank transactions are imported with date and details from the bank statement so they are easy to identify. The Presented Date shows that they have come from a bank import.
Note: You should not manually add or edit a transaction and enter a value into its Presented Date. This is because the Presented date indicates that the transaction originated from the bank statement.
To import bank transactions:
- Start at Cash Book > Import bank transactions.
- Select the Cash book bank account.
- Select or drag your bank file to the import box.
- Enter the Statement closing date, (usually yesterday's date).
- Enter the Statement closing balance from your import file.
- Enter the Statement number.
Tip: Click Save Defaults to save the Cash book bank account and for the Statement number to update automatically.
- Click Reconcile Bank Statement. This checks that the closing balance you have entered from the import file matches the Cash Book closing balance.
If the Bank closing balance does not match the Cash Book closing balance, you should investigate the cause. This may arise, for example, from a difference in date for an overseas transaction, where the transaction at the bank may appear some days later than the date entered in your Payables or Cash Book. In this occurs, you should change the date of the transaction in the bank file to match the Cash Book transaction date.
Now you will see the transaction from the import file being displayed on the right of the screen.
- Click Upload Bank Transaction Details.
This process creates a Cash Book Statement report that includes the transactions that have been processed.
Next process: Analyse Transactions
The next process is to Analyse the Transactions.
|
Need more help? We’re here! We hope our article was helpful! If you need more info or want to connect, drop us an email at support@lentune.com. Thank you. We love to hear from you! |