You can get to the bank reconciliation reports from within the Bank Reconciliation program, follow the below steps:
Select a bank, then bottom right click Reports.
Select the report you wish to run if needed enter the bank nominal statement period etc and click Run Report.
The Current statement will show you if your bank is in balance at the moment in time that you run it, this pulls through the nominal bank balance at that point in time and all unreconciled transactions at that time along with the bank balance. This will give you a cashbook balance that then hopefully matches to your nominal TB balance.
Statement status is another good report to point out, this shows any statements where the opening balance does not match the closing balance of the prior report. This is good to use if you have a difference on the current statement.
To investigate discrepancies between statement balances, run the Statement Status report for the relevant bank. Compare the closing balance of the prior statement with the opening balance of the next statement. Verify the earlier statement against the actual bank statement to identify items that were reconciled incorrectly (e.g., an item reconciled that should not have been) and correct the discrepancy accordingly.
Bank reconciliation reports can also be found in Advanced Report Execution, Accounts Standard, Bank Reconciliation. This is where the Retro Bank Rec reports live. If you need to match a previous period bank statement to a TB you would run the report from here in the Retro Period Statements. (When running these ensure you pad out your statement number to six characters so if your statement has 2 numbers eg 34 then press the space bar 4 times then type 34)
Navigate to Advanced Report Execution > Standard Accounts > Bank Reconciliation > Retrospective Reports and select the Period-based folder (not Date-based).
Run the following reports:
Retro Statement (front sheet): Enter the bank nominal (e.g., 9330) and the month-end Statement Number. Use the month-end statement only (not a mid-month statement) and pad the statement number to six characters by inserting leading spaces (e.g., for statement 50, type four spaces then 50).
Unreconciled Items (period-based): Enter the bank nominal and select the period/year. If prompted for a statement number, use the same padded month-end statement number as above. This report lists items unreconciled as of that statement.
You may also find the Nominal Transaction Listing useful if a full cashbook is needed, this is in Advanced report execution, accounts standard, nominal folder. Enter the bank nominal and required periods.
NB
If you are running the Bank rec reports before doing the first Bank Reconciliation then the items won't show on the reconciliation reports.
NB Bank reconciliation in Access Legal Proclaim does not directly affect the nominal ledger or trial balance. The nominal ledger recognizes postings based on the period they are posted, regardless of reconciliation status. Temporary differences may occur when transactions are dated in one month but posted in the next period.