HansaManuals

HansaManuals Home   >> Standard ERP   >> Nominal Ledger   >> Reports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Bank Reconciliation

---

The Bank Reconciliation report is one of two reports in the Nominal Ledger that you can use to help with the task of reconciling bank statements, the other being the Account Reconciliation report. Use the Account Reconciliation register to reconcile bank statements.

The Bank Reconciliation report is a list of unreconciled postings to a specified Bank Account from a specified period. An unreconciled posting is one that you have not reconciled to a transaction on your bank statement using the Account Reconciliation register. The report divides the unreconciled postings into three groups: Outstanding Payments; Outstanding Receipts; and Bank Charges. The third group includes all postings that do not fall into the other two groups (e.g. bank interest, transfers between bank accounts, salary payments).

When producing the report, you will enter the closing balance from your last bank statement. The report will display a new balance, calculated from that figure and including the unreconciled postings. This new balance will be compared to the balance for the Bank Account in your database on the last day of the report period. If the two balances are different, the probable reason is that there is still at least one unreconciled posting that you can reconcile with the bank statement.

When printed to screen, the Bank Reconciliation report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on a Sub System Number (e.g. Invoice Number) in the report to open the Nominal Ledger Transaction for that Sub System record. You can then open the Sub System record itself (e.g. the Invoice) by selecting 'Open Subsystem Record' from the Operations menu (Windows/macOS) or Tools menu (iOS/Android).

Period

Paste Special    Reporting Periods setting, System module

Specify the report period. This should be sufficient to include all unreconciled postings to the Bank Account.

Note that a posting to the Bank Account that you made during the report period and that you reconciled after the report period will be treated as unreconciled. The report period may therefore need to have an earlier start date than that of the bank statement you are working from.

Pay Mode

Paste Special     Payment Modes setting, Sales/Purchase Ledger

Enter a Payment Mode: the report will list all unreconciled postings to the Account shown on flip A of this Payment Mode.

The report will be empty if you do not specify a Payment Mode.

Balance

Enter the closing balance from your last bank statement. The report will calculate a new balance that takes the unreconciled postings into account. This new balance is then compared with the current balance for the Account in the Payment Mode specified above.

Values in

If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.

If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.

Reports in the Nominal Ledger:

• Introduction
  

• Definition of Nominal Ledger Reports
  

• Drill-down
  

• The Operations Menu
  

• Account Reconciliation
  

• Accrual Report
  

• Analytical Balance
  

• Analytical Balance (Fiscal purposes)
  

• Balance Sheet
  

• Bank Reconciliation
  

• Bank Statement
  

• Bank Transactions
  

• Base Currency Rate Change
  

• Budget Journal
  

• Cash Flow
  

• Chart of Accounts
  

• Correction List
  

• Corresponding Accounts
  

• Creditors Account
  

• Currency A/C Rate Change
  

• Daily Balances
  

• Debtors Account
  

• Forward Balance Journal
  

• Key Financial Ratios
  

• Liquidity Forecast
  

• Multicurrency Accounts Rate Difference
  

• N/L Accrual Transactions
  

• N/L Transfer, Subsystems
  

• Nominal Ledger
  

• Profit & Loss
  

• Revised Budget Journal
  

• Simulation Journal
  

• Tag/Object Results
  

• Tag/Object/Quantity Results
  

• Tax Account Balances
  

• Tax Calculations
  

• Tax Transactions for Registers
  

• Template Transaction Journal
  

• Test Corresponding Rules
  

• Transaction Journal
  

• Transaction Summary
  

• Trial Balance
  

• VAT Listing
  

• VAT Report
  

• VAT Report Purchases
  

• VAT Report Sales
  

• VAT Transaction Journal
  

• XBRL Report

Go back to:

• Home page for Nominal Ledger manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form