About Bank Reports

Bank reports include information to assist you in managing your company's bank accounts, setup options, transactions, and in reconciling bank accounts. All transaction reports default to landscape orientation (for both previewing and printing), with the exception of the Reconciliation Status and Reconciliation Posting Journal reports. The Reconciliation Status report and the Reconciliation Posting Journal report use portrait orientation.

Sage HRMS Payroll includes the following bank reports:

Report Name Report Description

Bank Entries Posting Journal

This is a transaction report. A printed record of bank entries that were posted together. This report provides an audit trail of transactions posted using bank services by posting sequence.

Bank Reconciliation

This is a transaction report. Displays the result of the last posted bank reconciliation for each bank included in the report. It explains the difference between the bank statement and your company records.

Banks

This is a setup report. Lists the bank records defined for your company, which includes G/L account and other information about each bank. Print this report after you add, change, or delete bank records.

CheckPayment Register

This is a transaction report. Lists all payments made from a bank account. Use this report to view or print payments made from a particular bank for a specified period of time.

Deposit Register

This is a transaction report. Lists all deposits to a bank account. Use this report to view or print deposits that were made to a bank or a range of banks over a specified period of time.

Deposits Status

This is a transaction report. Lists all deposits (including transfers) that are currently in transit for the bank account being reconciled.

Distribution Codes

This is a setup report. Lists the account distribution codes defined for bank transactions. Print this report after you add, change, or delete distribution codes.

G/L Integration

This is a setup report. Displays the options you selected on the Bank G/L Integration page, including when to create G/L batches (for example, during posting), how to create G/L transactions (for example, by creating a new batch), and whether to consolidate G/L batches.

G/L Transactions

This is a transaction report. Lists the general ledger transactions created from all posted transactions. Use this report as your audit trail for generated general ledger transactions.

Options

This is a setup report. Lists the options you selected on Bank Options page. Print the report after bank setup and when you change bank options. This report displays the transfer adjustment account number, the next posting sequence number, and the next transfer number.

Reconciliation Posting Journal

This is a transaction report. This report is an audit trail of all transactions posted during bank reconciliation. It includes checks and deposits that cleared the bank, as well as entries that Sage HRMS Payroll created to account for clearing differences and bank errors.

Reconciliation Status

This is a transaction report. Lists the status and amounts of all transactions for a bank account.

Transaction Listing

This is a transaction report. Lists all transactions recorded for one bank or for a range of banks.

Transfer Posting Journal

This is a transaction report. This report is an audit trail of all transactions posted during bank transfers. It includes payments and deposits transferred between banks, transfer charges and transfer charge adjustments, as well as tax information (optional).

Withdrawals Status

This is a transaction report. Lists all outstanding checks and transfers from a bank or a range of banks.