Navigation: Transactions > Banking > Bank Transactions > Reconcile Account >

Fields in Reconcile Account

 

 

 

 

                                                                                          

1.Account: This is a previously selected Account. However, a user may still choose another account manually. 

2.Last Reconcile Date:  This is the last Reconciled Bank statement Date

3.Bank Statement Date: The date stated on the current bank statement, which should be after the pre-set Opening Balance Date and after the Last Reconciled Date. Otherwise, a pop up reminder will appear with the following message “Your Bank statement Date must no early than your Opening Balance Date”.

4.Closing Statement Balance: The current balance of the selected account will be selected by default. However, a user may need to amend it manually based on the actual reconciled Calculated Statement Balance to ensure zero Out of Balance.

5.Calculated Statement Balance: Equation of Calculated Statement Balance is the Total Opening Balance + Total Reconciled Debit of Selected Account - Total Reconciled Credit of Selected Account. Zero is set as the default amount, and then calculates after the user's selected transactions  reconciled. 

6.Out Of Balance needs to be a zero balance which is equal to the Closing Statement Balance minus Calculated Statement Balance. Otherwise, reminder of “Your Bank statement’s Balance and your statement balance is out of balance!” will appear.

7.Reference No: This is a system auto-signed and read-only number for current reconciliation transaction.

8.Reference No. in the table: a unique reference number is assigned to each transaction by system.

9.Date: Transaction date as it is.

10.Memo: This is the memo stored in each transaction.

11.Deposits: All Debit transactions in the selected account would be included under Deposits column.

12.Withdrawals: All Credit transactions in the selected account would be included under Withdrawals column.

13.If the user has deleted or modified a reconciled transaction, this transaction will be changed back to unreconciled, and the previous reconcile history will eliminate the modified transaction record and balance itself.

14.A user needs to select at least one transaction to conduct Reconcile Account, the following message will pop up as a reminder “You at least need to select one transaction for this reconcile!”.

 

 

 

Copyright © Q6 Cloud Accounting