Austlink Help Centre

Follow

Jiwa Cash Book - Bank Reconciliation

In this article we will be looking at how to complete a bank reconciliation in Jiwa.

 

Bank Reconciliation

The Bank Reconciliation function in Jiwa is not only used to complete your bank reconciliation's the feature also allows you to enter in the following transaction types;

  • General Ledger transactions such as bank fees and charges
  • Debtor receipts and refunds
  • Creditor payments and refunds
  • Opening balance transactions - this transaction type is only used to bring in unpresented transactions into your first Jiwa bank reconciliation

 

A new bank reconciliation can only be created where;

  1. The last bank reconciliation for the nominated account has been Activated, and
  2. The bank reconciliation date is the same of after the most recent reconciliation for the nominated account

 

To begin from the Cash Book module select Bank Reconciliation

 17.jpg

 

From the menu ribbon select New to start a new bank reconciliation

18.jpg

 

Select the General Ledger bank account you wish to reconcile.

You will note that the General Ledger search screen only returns those accounts that have been flagged as bank accounts.

19.jpg

 Enter in the bank statement date that you are reconciling to

1.jpg

Enter in a reference for your bank reconciliation if applicable

2.jpg

Click on the Figures tab and enter in your closing bank statement balance in the 'Bank Statement Closing Balance' field

3.jpg

In the Transactions tab select the transactions that are on the bank statement by ticking the transaction Status check box

4.jpg

 

Adding Transactions to your Bank Reconciliation

Transactions can be entered into Jiwa from within the Bank Reconciliation, these could be bank fees and charges or direct debit payments that have come out of your bank account such as loan repayments.

To add a transactions from within the bank reconciliation move to a blank line on your transactions tab, and click on the select icon on the Type field

10.jpg

Select the type of transaction you want to process.  For bank fees and charges select 'Direct GL Transaction' this will open the direct GL transaction form.

Enter in your details ensuring that you select the correct GST code applicable to the transaction

NOTE.jpg

When entering in your Direct GL Transaction the transaction type is from the perspective of your GL bank account and not the account the transaction is being posted to.

In the example below the bank charge is a credit out of my bank account.  If my entry was for interest received then it would be a debit into my bank account.

 

12.jpg

This transaction will generate the following journal entry, as you can see the credit entry is to the bank account and the expense is taken up as a correctly as a debit entry

13.jpg

Finalising the Bank Reconciliation

Once you have reconciled your transactions check to ensure your reconciled difference is zero

5.jpg

Save your bank reconciliation by selecting the Save icon

6.jpg

When you have completed your reconciliation and no further changes will be made activate your reconciliation by selecting the 'Activate' icon

7.jpg

To print your bank reconciliation report from the printer icon select 'Bank Reconciliation'

8.jpg

9.jpg

 

This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).

To exit full screen just press escape 

 

VideoFullScreen.jpg

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk