Batch Reconciliation Report

Description

This Batch Reconciliation Report provides detail of all types of transactions in the batch and also the total debit/credit amounts for G/L Accounts that are affected by the each transaction. The primary use of this report is to verify that the ledger transactions that would be created by closing the batch are going to be correct and hence it is available from Batch Profile page as one step (button) of the Batch Close Process. When the batch is not closed, the report shows what ledger transactions are likely to be created. After the batch is closed, it shows the actual ledger transactions in the NetForum ledger table (ac_ledger).

See Batch Processing for more.

Launch Points

• Reports Central: Accounting --> Batch
• Batch Profile Page

Parameters

• Business Unit (required) (Drop-Down List).
• Fiscal Yr (required) (Drop-Down List).
• Period (required) (Drop-Down List).
• Batch (required) (Drop-Down List).
• Sort By (required) (Drop-Down List).

Output

Fields

• Fiscal Year and Period (in page header) — Fiscal Period of the batch
• Batch Code, Close Date, Post Date (in page header) — Indicates status of the batch.
• Business Unit — as Group
  • G/L Account Code — as Group
  • G/L Account Description
    • Transaction Date — Date of the transaction in batch. In most cases it may be same as batch date.
    • Project Code —
    • Transaction Description —
    • Transaction Number — Examples: Invoice Code/Number, Payment Code/Number, Credit Code/Number, Refund Code/Number
    • Purchase Order/Reference Number -
    • Customer Number — netForum Customer ID
    • Customer Name
    • Debit Amount — Debit Amount for the G/L Account as a result of this transaction
    • Credit Amount — Credit Amount for the G/L Account as a result of this transaction

Subtotals/Totals

• Sub Total of Debit and Credit Amounts for G/L Account
• Sub Total of Debit and Credit Amounts for Business Unit
• Total Amount of Invoices in the batch
• Total Amount of Payments in the batch
• Total Amount of Credits in the batch
• Total Amount of Refunds in the batch
• Batch Total Amount and Batch Control Amount
• Batch Total Count and Batch Control Count
• Summary of Credit Card Transactions