Bank Reconciliation Screen Field Reference

This screen field reference describes the following:

General tab
Payments tab
Deposits tab
Adjustments tab
Transfers tab
Reconcile Bank Statement tab
Reconcile GL to Bank Statement tab

General tab


Field	Description
Last Reconciliation Date	Displays the date of the last reconciliation. If this is the first time you are reconciling, this field is blank.
Bank Opening Balance	Open 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 Balance	In 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.


Field	Description
Cleared	Select the checkbox if the transaction matches a transaction on your bank statement.
Source Module	Displays the module for the transaction, either Vendors or Employees.
Transaction Number	Displays one of the following: transaction number (for a vendor payment or voided vendor payment) payroll check number (for a payroll check)
Transaction Date	Displays 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 Amount	Displays 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 ID	Displays 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 Name	Displays 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.


Field	Description
Cleared	Select the checkbox if the transaction matches a transaction on your bank statement.
Source Module	Displays Customers, the module for all transactions on this tab.
Deposit ID	Displays one of the following: deposit ID (for a customer receipt or miscellaneous receipt) the code of the payer (for a voided receipt)
Deposit Date	Displays 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 Amount	Displays 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 or Reverse 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.


Field	Description
Cleared	Select the checkbox if the transaction matches a transaction on your bank statement.
Source Module	Displays the module of the transaction.
Adjustment Date	Displays one of the following: adjustment date (for a journal entry) posting date (for other transactions)
Adjustment Amount	Displays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
Description	Displays 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.


Field	Description
Cleared	Select the checkbox if the transaction matches a transaction on your bank statement.
Source Module	Displays the module of the transaction.
Transfer Date	Displays the transfer date of the transaction.
Transfer Amount	Displays the amount of the transaction. A credit amount displays as a negative number.
Description	Displays 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.


Field	Description
Beginning Bank Balance	Displays the opening balance from your bank statement that you entered in the Bank Opening Balance field on the General tab.
Ending Bank Balance	Displays the calculated closing balance. ProContractor determines this value by subtracting the amounts of all transactions marked as Cleared from the beginning bank balance.
Reconciling Difference	Displays 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 Cleared	Displays the total amount of the transactions marked as Cleared on the Payments tab.
Total Adjustments Cleared	Displays the total amount of the transactions marked as Cleared on the Adjustments tab.
Total Deposits Cleared	Displays the total amount of the transactions marked as Cleared on the Deposits tab.
Total Transfers Cleared	Displays 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 Module	Displays the module for the transaction, either Vendors or Employees.
Transaction Number	Displays one of the following: transaction number (for a vendor payment or voided vendor payment) payroll check number (for a payroll check)
Transaction Date	Displays 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 Amount	Displays 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 ID	Displays 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 Name	Displays 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 Module	Displays Customers, the module for all transactions on this tab.
Deposit ID	Displays one of the following: deposit ID (for a cash receipt) the code of the customer (for a voided cash receipt)
Deposit Date	Displays one of the following: transaction date (for a cash receipt) posting date (for a voided cash receipt)
Deposit Amount	Displays 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 Module	Displays the module of the transaction.
Adjustment Date	Displays one of the following: adjustment date (for a journal entry) posting date (for other transactions)
Adjustment Amount	Displays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
Description	Displays 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 Module	Displays the module of the transaction.
Transfer Date	Displays the transfer date of the transaction.
Transfer Amount	Displays the amount of the transaction. A credit amount displays as a negative number.
Description	Displays 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.


Field	Description
GL Balance	Displays the balance of the account as of the date in the Reconciliation Thru Date field
Adjusted GL Balance	Displays 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 Transactions	Displays the total amount of transactions that appear on the Transactions after Reconciliation Thru Date tab.
Reconciling Difference	Displays 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 Outstanding	Displays the total amount of the transactions NOT marked as cleared on the Payments tab.
Total Adjustments Outstanding	Displays the total amount of the transactions NOT marked as cleared on the Adjustments tab.
Total Deposits Outstanding	Displays the total amount of the transactions NOT marked as cleared on the Deposits tab.
Total Transfers Outstanding	Displays 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 Module	Displays the module for the transaction, either Vendors or Employees.
Transaction Number	Displays one of the following: transaction number (for a vendor payment or voided vendor payment) payroll check number (for a payroll check)
Transaction Date	Displays 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 Amount	Displays 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 ID	Displays 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 Name	Displays 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 Module	Displays Customers, the module for all transactions on this tab.
Deposit ID	Displays one of the following: deposit ID (for a cash receipt) the code of the customer (for a voided cash receipt)
Deposit Date	Displays one of the following: transaction date (for a cash receipt) posting date (for a voided cash receipt)
Deposit Amount	Displays 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 Module	Displays the module of the transaction.
Adjustment Date	Displays one of the following: adjustment date (for a journal entry) posting date (for other transactions)
Adjustment Amount	Displays the amount of the journal entry or other transaction. A debit amount displays as a negative number.
Description	Displays 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 Module	Displays the module of the transaction.
Transfer Date	Displays the transfer date of the transaction.
Transfer Amount	Displays the amount of the transaction. A credit amount displays as a negative number.
Description	Displays 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 Module	Displays the module of the transaction.
Transaction Number	Depending 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 Date	Depending on the source module and the type of transaction, displays the transaction date, the posting date, the payroll check date
Posting Date	Displays the posting date of the transaction.
Transaction Amount	Displays the amount of the transaction.
Transaction ID	Displays 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.
Name	Displays 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.

Hilfe für Trimble Produkte