HansaManuals

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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Account Reconciliation

---

The Account 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 Bank Reconciliation report. Use the Account Reconciliation register to reconcile bank statements.

The Account Reconciliation report is a list of Transaction rows (i.e. individual account postings) for the report period in date order, showing for each the Account, Transaction Number and Date, Amount in either Base Currency (as selected) and Amount in foreign Currency (where appropriate). You can choose whether the report will list reconciled or unreconciled postings or both. If you choose both, reconciled or unreconciled postings will be shown in separate sections.

You can also produce this report from the 'Account Reconciliation' window, by selecting 'Account Reconciliation Report' from the Operations menu (with 'cog' icon, Windows/macOS) or Tools menu (with 'wrench' icon, iOS/Android). When you produce the report in this way, the specification window will not appear. Instead, the report will be produced for the Account, Tags/Objects and Reconciliation Code that you have entered in the 'Account Reconciliation' window, and the selection of the Reconciled and Unreconciled options will also be taken from the 'Account Reconciliation' window. You should therefore supply this information in the 'Account Reconciliation' window before producing the report.

When printed to screen, the Account Reconciliation report has the Standard ERP Drill-down feature. Click (Windows/macOS) or tap (iOS/Android) on a Transaction Number in the report to open a Nominal Ledger Transaction. If the Nominal Ledger Transaction was created from a Sub System record (e.g. from a Receipt or Payment), you can (subject to access rights) then open the Sub System record by selecting 'Open Subsystem Record' from the Operations or Tools menu.

Period

Paste Special    Reporting Periods setting, System module

The report will list the postings (i.e. the Transaction rows) entered during the period that you specify here. The default value is the first period in the Reporting Periods setting.

Using the Reconciled and Unreconciled options below, you can choose whether reconciled or unreconciled postings or both will be included in the report. For a reconciled posting to appear in the report, you must have entered it and reconciled it during this period. The listing of unreconciled postings will depend on whether you are using the Ignore Period Start Date for Unreconciled Transactions option in the Reconciliation Settings setting. If you are not using this option, an unreconciled posting will appear in the report if you entered it during this period and reconciled it after this period or not reconciled it at all. If you are using this option, the start of the period will be ignored when listing unreconciled postings. All unreconciled postings up to the end of the specified period will be listed.

Accounts

Paste Special    Account register, Nominal Ledger/System module

Range Reporting    Alpha

Use this field to limit the report to Transaction rows posting to a certain Account, or range of Accounts. Usually you will only need to specify your Bank Account(s) or other reconcilable Account here, otherwise the report will be much longer than necessary.

In multi-user systems, you can use Access Groups to prevent the postings to sensitive Accounts such as salary Accounts being listed in this report, depending on the user producing the report. To do this, list the sensitive Accounts in the Block A/Cs field in each Access Group as appropriate.

Tags/Objects

Paste Special    Tag/Object register, Nominal Ledger/System module

Specify a Tag/Object here if you need the report to list Transaction rows with a particular Tag/Object. If you enter a number of Tags/Objects separated by commas, only those Transaction rows with all the Tags/Objects that you have listed will be shown in the report.

Recon. Code, Exclude with Code

If you want to list reconciled Transaction postings with a particular Recon. Code, enter that Recon. Code here. To list all reconciled postings except those with a particular Recon. Code, select the Exclude With Code option as well.

Reconciliation Codes are arbitrary codes that you can use to identify postings that you have reconciled on a particular day or from a particular bank statement. Specifying a Reconciliation Code here will therefore allow you to list those postings if you need to check them at a later date.

This field and check box will have no effect if you are only listing unreconciled postings.

Reconciled

Select this option if you need reconciled postings to be included in the report.

Unreconciled

Select this option if you need unreconciled postings to be included in the report. You must select at least one of the Reconciled and Unreconciled options or the report will be blank.

Show Recon. Comments

When you reconcile each posting, you can mark it with a Reconciliation Code. The Reconciliation Code that you use might be connected to a longer description in the Reconciliation Codes setting. Select this option if you want these longer descriptions to be included in the report.

Values in

If you are using the Dual-Base system, use these options to specify whether the values in the report are to be shown in Base Currency 1 or 2.

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

Print

You can choose to have Descriptions or Tag/Object Codes included in the report. If you choose the

Descriptions option, the Description from each Transaction row will be shown together with the Text from its Transaction header.

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
  

• Income & Expense Book
  

• 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