AugTool Documentation

BankĀ 

The Bank section on the daily report shows any differences between the ledger, receipts and payments and the bank statement figure. These should all balance.

If the Bank accounts do not balance check out the following :

bank/4571f28ede7e953f13ba0328546ea618.jpg

In the below scenario the bank account section in the daily check report itĀ  shows that there are entries that have been imported into the bank account but have not yet been allocated. The amount under Statements is the closing balance of your bank statement.

bank/92356d50ad66964c3f8fc6788274ae5b.jpg

Please note that only once the payment/receipt has been allocated will the amount appear under the ledger and receipt/payments columns.

The following would cause the balance to be out:

Journal entries to the control account

bank/c7e774c3314ae191a94b1e7d22d9d261.jpg
bank/8db09ca65a4147b2967e044f845506f6.jpg

The bank section on the daily check report will show here that the R500.00 has been allocated but that there are receipts/payments to be allocated and that there is still a difference between them

bank/43729dad5bce87138db5f39aa1e2dcab.jpg

The way to correct this would be to reverse the journal entry that was done.Ā  Then process the correct transaction through the correct process -ie correct journal entry, debtors creditors. Also allocate the line entries on the bank statement that have not been allocated.Ā Ā 

Duplicate Bank Entries Imported

If anything changes to the description when you import a bank statement it could duplicate a bank line when importing.

Here there is a space between the Testing oneĀ  and Testing Ā  one which allows both lines to be imported.

bank/adbfb7bbf8d7fb03cc30da032075cd51.jpg

Below is what will reflect on the daily report under the bank section.

bank/5a1ca0c4925b02a9d827f711e86b1374.jpg

The only way to correct this is to check the balance on the bank statement and on the ledger and then see where there has been a duplicate. Go into receipts/payments and then roll back the receipt /payment to draft and delete the allocation. Once this has been done you would need to go into the bank account and delete the line item.

bank/ed0aa75387457a26de45922cf86d7312.jpg
bank/5e6e5ab99c260678f6ff9343cd686cd4.jpg
bank/482c05919d67aa7656db3256c78279c7.jpg

Here the second entry now is not highlighted and can be deleted.

bank/4ca1bf99055ccf102f1ec9d944b20c46.jpg

If you now go back to theĀ  daily check report and look at the bank section, it will now show as in balance

bank/cf05b9efa3ae1cc1c64d2d885120b179.jpg

Please note that only the bank entry lines that have been allocated will reflect. If there are unallocated bank statement lines it will affect this daily report