Bank Reconciliation Screen Field Reference

General tab

FieldDescription
Last Reconciliation DateDisplays the date of the last reconciliation. If this is the first time you are reconciling, this field is blank.
Bank Opening BalanceOpen the bank closing balance from the last reconciliation. If this is the first time you are reconciling, this field displays .00. This value should match the opening balance from your bank statement. If it doesn't, enter the opening balance from your bank statement.
Bank Closing BalanceIn the Bank Closing Balance field, enter the closing balance from your bank statement.

Payments tab

Each row in the grid on the Payments tab is a posted, unreconciled transaction with a transaction date that is no later than the date in the Reconciliation Thru Date field. This can be:

  • a vendor payment or a voided vendor payment from the Vendors module.
  • a payroll check or a voided payroll check from the Employees module.

Review these transactions and compare them to your bank statement. Select the checkbox in the Cleared column for each transaction that matches your bank statement. Select the checkbox in the header of the Cleared column to mark all transactions in the grid.

FieldDescription
ClearedSelect the checkbox if the transaction matches a transaction on your bank statement.
Source ModuleDisplays the module for the transaction, either Vendors or Employees.
Transaction NumberDisplays one of the following:
  • transaction number (for a vendor payment or voided vendor payment)
  • payroll check number (for a payroll check)
Transaction DateDisplays one of the following:
  • transaction date (for a vendor payment)
  • posting date (for a voided vendor payment)
  • check date (for a payroll check)
  • void effective date (for a voided payroll check)
Transaction AmountDisplays one of the following:
  • transaction amount (for a vendor payment or voided vendor payment)
  • payroll check amount (for a payroll check or a voided payroll check)

A voided amount displays as a negative number.

Transaction IDDisplays one of the following:
  • the code of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the code of the employee for the payroll check (for a payroll check or a voided payroll check)
Transaction NameDisplays one of the following:
  • the name of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the name of the employee for the payroll check (for a payroll check or a voided payroll check)

Deposits tab

Each row in the grid on the Deposits tab is a group of posted, unreconciled transactions with a deposit date that is no later than the date in the Reconciliation Thru Date field. These transactions may be customer receipts, miscellaneous receipts, or voided receipts from the Customers module. Customer receipts and miscellaneous receipts are grouped and totaled by deposit ID and deposit date; voided receipts are listed individually.

Review these transactions and compare them to your bank statement. Select the checkbox in the Cleared column for each transaction that matches your bank statement. Select the checkbox in the header of the Cleared column to mark all transactions in the grid.

FieldDescription
ClearedSelect the checkbox if the transaction matches a transaction on your bank statement.
Source ModuleDisplays Customers, the module for all transactions on this tab.
Deposit IDDisplays one of the following:
  • deposit ID (for a customer receipt or miscellaneous receipt)
  • the code of the payer (for a voided receipt)
Deposit DateDisplays one of the following:
  • transaction date (for a customer receipt or miscellaneous receipt)
  • posting date (for a voided receipt)

You may need to add deposit amounts recorded in ProContractor manually in order to compare to the bank statement deposit total.

Deposit AmountDisplays the total amount of the transactions for the row. A voided amount displays as a negative number. Note that customer and miscellaneous receipts are grouped and totaled by deposit ID and deposit date; voided receipts are listed individually.

Adjustments tab

Each row in the grid on the Adjustments tab is a posted, unreconciled transaction with an adjustment date that is no later than the date in the Reconciliation Thru Date field. This can be:
  • a journal entry with a bank transaction type of Adjustment from the Financial module.
  • any transaction that posts to a cash account.

Review these transactions and compare them to your bank statement. You may need to Create a Journal Entry for any transactions, such as bank charges and interest, which appear on your bank statement but not in the grid. Select the checkbox in the Cleared column for each transaction that matches your bank statement. Select the checkbox in the header of the Cleared column to mark all transactions in the grid.

FieldDescription
ClearedSelect the checkbox if the transaction matches a transaction on your bank statement.
Source ModuleDisplays the module of the transaction.
Adjustment DateDisplays one of the following:
  • adjustment date (for a journal entry)
  • posting date (for other transactions)
Adjustment AmountDisplays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
DescriptionDisplays one of the following:
  • description of the transaction (for a journal entry)
  • posting sequence number (for other transactions)

Transfers tab

Each row in the grid on the Transfers tab is a posted, unreconciled transaction with a transfer date that is no later than the date in the Reconciliation Thru Date field. This can be a journal entry with a bank transaction type of Transfer from the Financial module.

Review these transactions and compare them to your bank statement. Select the checkbox in the Cleared column for each transaction that matches your bank statement. Select the checkbox in the header of the Cleared column to mark all transactions in the grid.

Field Description
ClearedSelect the checkbox if the transaction matches a transaction on your bank statement.
Source ModuleDisplays the module of the transaction.
Transfer DateDisplays the transfer date of the transaction.
Transfer AmountDisplays the amount of the transaction. A credit amount displays as a negative number.
DescriptionDisplays the description of the transaction.

Reconcile Bank Statement tab

This tab displays totals and reconciliation information from the other tabs. Any transaction marked as cleared appears in the grids on the sub-tabs and is included in the totals.

Review the totals on the tab.

FieldDescription
Beginning Bank BalanceDisplays the opening balance from your bank statement that you entered in the Bank Opening Balance field on the General tab.
Ending Bank BalanceDisplays the calculated closing balance. ProContractor determines this value by subtracting the amounts of all transactions marked as Cleared from the beginning bank balance.
Reconciling DifferenceDisplays the calculated difference between the ending bank balance and the value in the Bank Closing Balance field on the General tab. If the reconciling difference is .00, you have successfully reconciled the transactions posted in ProContractor with your bank statement.
Total Payments ClearedDisplays the total amount of the transactions marked as Cleared on the Payments tab.
Total Adjustments ClearedDisplays the total amount of the transactions marked as Cleared on the Adjustments tab.
Total Deposits ClearedDisplays the total amount of the transactions marked as Cleared on the Deposits tab.
Total Transfers ClearedDisplays the total amount of the transactions marked as Cleared on the Transfers tab.
Payments sub-tab - Each row in the grid is a posted, unreconciled payment transaction marked as cleared on the Payment tab.
Source ModuleDisplays the module for the transaction, either Vendors or Employees.
Transaction NumberDisplays one of the following:
  • transaction number (for a vendor payment or voided vendor payment)
  • payroll check number (for a payroll check)
Transaction DateDisplays one of the following:
  • transaction date (for a vendor payment)
  • posting date (for a voided vendor payment)
  • check date (for a payroll check)
  • void effective date (for a voided payroll check)
Transaction AmountDisplays one of the following:
  • transaction amount (for a vendor payment or voided vendor payment)
  • payroll check amount (for a payroll check or a voided payroll check)

A voided amount displays as a negative number.

Transaction IDDisplays one of the following:
  • the code of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the code of the employee for the payroll check (for a payroll check or a voided payroll check)
Transaction NameDisplays one of the following:
  • the name of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the name of the employee for the payroll check (for a payroll check or a voided payroll check)
Deposit sub-tab - Each row in the grid is a posted, unreconciled deposit transaction marked as cleared on the Deposit tab.
Source ModuleDisplays Customers, the module for all transactions on this tab.
Deposit IDDisplays one of the following:
  • deposit ID (for a cash receipt)
  • the code of the customer (for a voided cash receipt)
Deposit DateDisplays one of the following:
  • transaction date (for a cash receipt)
  • posting date (for a voided cash receipt)
Deposit AmountDisplays the amount of the cash receipt or voided cash receipt. A voided amount displays as a negative number. Note that cash receipts are grouped and totaled by deposit ID and deposit date; voided cash receipts are listed individually.
Adjustments sub-tab - Each row in the grid is a posted, unreconciled adjustment transaction marked as cleared on the Adjustment tab.
Source ModuleDisplays the module of the transaction.
Adjustment DateDisplays one of the following:
  • adjustment date (for a journal entry)
  • posting date (for other transactions)
Adjustment AmountDisplays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
DescriptionDisplays one of the following:
  • description of the transaction (for a journal entry)
  • posting sequence number (for other transactions)
Transfers sub-tab - Each row in the grid is a posted, unreconciled transfer transaction marked as cleared on the Transfers tab.
Source ModuleDisplays the module of the transaction.
Transfer DateDisplays the transfer date of the transaction.
Transfer AmountDisplays the amount of the transaction. A credit amount displays as a negative number.
DescriptionDisplays the description of the transaction.

Reconcile GL to Bank Statement tab

This tab displays totals and reconciliation information from the other tabs. Any transaction NOT marked as cleared appears in the grids on the sub-tabs and is included in the totals. In addition, the Transactions after Reconciliation Thru Date tab contains transactions where one of the following is true:

  • Transactions where the transaction date is after the date in the Reconciliation Thru Date field and the posting date is no later than the date in the Reconciliation Thru Date field.
  • Transactions which are marked as cleared and where the posting date is after the date in the Reconciliation Thru Date field and the transaction date is no later than the date in the Reconciliation Thru Date field.

Review the totals on the tab to determine that the balance of the account in ProContractor reconciles with the balance shown on your bank statement.

FieldDescription
GL BalanceDisplays the balance of the account as of the date in the Reconciliation Thru Date field
Adjusted GL BalanceDisplays the calculated balance of the account. ProContractor determines this value by adding the amount in the GL Balance field to the amounts of all payments NOT marked as cleared and subtracting the amounts of all deposits, adjustments, and transfers.
Reconciling TransactionsDisplays the total amount of transactions that appear on the Transactions after Reconciliation Thru Date tab.
Reconciling DifferenceDisplays the calculated difference between the amounts in the Bank Closing Balance field on the General tab, the Adjusted GL Balance field on this tab, and the Reconciling Transactions field on this tab. If the reconciling difference is .00, you have successfully reconciled the balance of the account in ProContractor with the balance shown on your bank statement.
Total Payments OutstandingDisplays the total amount of the transactions NOT marked as cleared on the Payments tab.
Total Adjustments OutstandingDisplays the total amount of the transactions NOT marked as cleared on the Adjustments tab.
Total Deposits OutstandingDisplays the total amount of the transactions NOT marked as cleared on the Deposits tab.
Total Transfers OutstandingDisplays the total amount of the transactions NOT marked as cleared on the Transfers tab.
Payments sub-tab - Each row in the grid is a posted, unreconciled payment transaction NOT marked as cleared on the Payment tab.
Source ModuleDisplays the module for the transaction, either Vendors or Employees.
Transaction NumberDisplays one of the following:
  • transaction number (for a vendor payment or voided vendor payment)
  • payroll check number (for a payroll check)
Transaction DateDisplays one of the following:
  • transaction date (for a vendor payment)
  • posting date (for a voided vendor payment)
  • check date (for a payroll check)
  • void effective date (for a voided payroll check)
Transaction AmountDisplays one of the following:
  • transaction amount (for a vendor payment or voided vendor payment)
  • payroll check amount (for a payroll check or a voided payroll check)

A voided amount displays as a negative number.

Transaction IDDisplays one of the following:
  • the code of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the code of the employee for the payroll check (for a payroll check or a voided payroll check)
Transaction NameDisplays one of the following:
  • the name of the vendor for the payment (for a vendor payment or voided vendor payment)
  • the name of the employee for the payroll check (for a payroll check or a voided payroll check)
Deposit sub-tab - Each row in the grid is a posted, unreconciled deposit transaction NOT marked as cleared on the Deposit tab.
Source ModuleDisplays Customers, the module for all transactions on this tab.
Deposit IDDisplays one of the following:
  • deposit ID (for a cash receipt)
  • the code of the customer (for a voided cash receipt)
Deposit DateDisplays one of the following:
  • transaction date (for a cash receipt)
  • posting date (for a voided cash receipt)
Deposit AmountDisplays the amount of the cash receipt or voided cash receipt. A voided amount displays as a negative number. Note that cash receipts are grouped and totaled by deposit ID and deposit date; voided cash receipts are listed individually.
Adjustments sub-tab - Each row in the grid is a posted, unreconciled adjustment transaction NOT marked as cleared on the Adjustment tab.
Source ModuleDisplays the module of the transaction.
Adjustment DateDisplays one of the following:
  • adjustment date (for a journal entry)
  • posting date (for other transactions)
Adjustment AmountDisplays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
DescriptionDisplays one of the following:
  • description of the transaction (for a journal entry)
  • posting sequence number (for other transactions)
Transfers sub-tab - Each row in the grid is a posted, unreconciled transfer transaction NOT marked as cleared on the Transfers tab.
Source ModuleDisplays the module of the transaction.
Transfer DateDisplays the transfer date of the transaction.
Transfer AmountDisplays the amount of the transaction. A credit amount displays as a negative number.
DescriptionDisplays the description of the transaction.
Transactions after Reconciliation Thru Date sub-tab - Each row in the grid is a transaction where one of the following is true:
  • Transactions where the transaction date is after the date in the Reconciliation Thru Date field and the posting date is no later than the date in the Reconciliation Thru Date field.
  • Transactions that are marked as cleared and where the posting date is after the date in the Reconciliation Thru Date field and the transaction date is no later than the date in the Reconciliation Thru Date field.
Source ModuleDisplays the module of the transaction.
Transaction NumberDepending on the source module and the type of transaction, displays the transaction number, the invoice number, or the payroll check number of the transaction. If the transaction is a journal entry, this field is blank.
Transaction DateDepending on the source module and the type of transaction, displays the transaction date, the posting date, the payroll check date
Posting DateDisplays the posting date of the transaction.
Transaction AmountDisplays the amount of the transaction.
Transaction IDDisplays one of the following:
  • the code of the customer (if the source module is Customers)
  • the code for the vendor (if the source module is Vendors)
  • the code for the employee (if the source module is Employees)

If the source module is Financial, this field is blank.

NameDisplays one of the following:
  • the name of the customer (if the source module is Customers)
  • the name for the employee (if the source module is Employees)

If the source module is Financial, this field is blank.