Versions Compared

Version Old Version 2 New Version Current
Changes made by

Tom Williams

Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of the Checkbook Reconciliation Inquiry is to view Checkbook Reconciliations. All checkbook reconciliations, both open and posted can be viewed from here.

Software Version: YYYY2020.MM01.DD 13 and newer

Table of Contents
typeflat

Page Header

The Name of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records.

Linked Database Field: ERPx_APVendor.VendorName - List View/Inquiry Field - List View/Inquiry Field For Transfers, this will be the Currency assigned to the 'From Checkbook'. List View/Inquiry Field List View/Inquiry Field

Linked Database Field: ERPx_

ERPx_MFCheckbookTransaction.TransactionStatusSKERPx_MFCheckbookTransaction.TransactionDate 

Linked Database Field: ERPx_MFCheckbookTransaction.TransactionID

Toolbar IconsDescription
Delete

Insert excerpt
Delete - LV
Delete - LV
nopaneltrue

(lightbulb) Deleting a Reconciliation does not impact the general ledger, it just un-assigns the checkbook transactions that were on the reconciliation and removes the reconciliation from history. Users can delete the last reconciliation for a checkbook with no restrictions. However, if a reconciliation is selected for delete, and there are posted reconciliations where the 'Bank Balance as of' occurred after the selected reconciliation, then all those reconciliations must be deleted as well. For example, if you reconcile as of the last day of each month, and your last reconciliation was as of 8/31/19, and you want to delete the 7/31/19 reconciliation, you must select both the 7/31/19 and 8/31/19 reconciliations for deletion.

Excel
Insert excerpt
Excel - Global (old)
Excel - Global (old)
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
Inquiry Criteria

Insert excerpt
Inquiry Criteria - Global
Inquiry Criteria - Global
nopaneltrue

  • Checkbook: a multi-select combo box to limit the data that is returned to one or more selected checkbooks. A blank assumes All.
  • Balances as of From: a text box to enter a starting date for reconciliation transactions. A blank assumes All.
  • Balances as of To: a text box to enter an ending date for reconciliation transactions. A blank assumes All.
  • Include Open Transactions: a Yes/No lookup to identify if the results include Open (unposted) reconciliation transactions. This defaults to "No" but can be changed to "Yes".
Print
Insert excerpt
Print - Global
Print - Global
nopaneltrue
FieldsDescription
Account ID

The ID of the AP Vendor, Fisherman, or Loan the payment was made for. This is only populated for Payment records.

Linked Database Field: ERPx_APVendor.VendorID

Account NameRefresh

Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. 

FieldsDescription
Balance as ofIdentifies the date that the 'Bank Balance' was calculated thru for the reconciliation. This would be the statement date if reconciling from a bank statement. This defaults to blank but is required before any transactions can be added to the Grid. This date must be <= the 'Transaction Cutoff' date but it is not required to be in an open fiscal period.
Checkbook
Insert excerpt
Checkbook
Checkbook
nopaneltrue
Checkbook Amount

A text box to show the amount of the transaction, in the checkbook's currency, displayed in the currency format. This column has a grand total at the bottom. 

Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative.

Linked Database Field: ERPx_MFCheckbookTransaction.Amount

Checkbook Currency

The Currency ID of the Checkbook.

 

Linked Database Field: ERPx_MFCheckbook.CurrencySK

Checkbook Description
Insert excerpt
Checkbook Description -
LV
Checkbook Description -
LV
nopaneltrue
Cleared Amount

The amount that cleared the bank. This is only populated for reconciled transactions. This column has a grand total at the bottom. 

Amounts that DEBIT the Checkbook's Cash Account are displayed as positives and amounts that CREDIT the Checkbook's Cash Account are displayed as negatives. For example, deposits will be displayed as positive and Payments will be displayed as negative.

The 'Cleared Amount' will always match the 'Checkbook Amount' unless the record cleared the bank for a different amount. The 'Cleared Amount' is the Checkbook's Currency amount, formatted in the checkbook's currency.

Linked Database Field: ERPx_MFCheckbookTransaction.ReconciledAmount

Comment

Displays the 'Comment' that was entered on the Transaction.

Linked Database Field: ERPx_MFCheckbookTransaction.Comment

GL Date
Insert excerpt
GL Date - List View/Inquiry FieldGL Date - List View/Inquiry Field
nopaneltrue
GL Period
Insert excerpt
GL Period - List View/Inquiry FieldGL Period - List View/Inquiry Field
nopaneltrue
GL Year
Insert excerpt
GL Year - List View/Inquiry FieldGL Year - List View/Inquiry Field
nopaneltrue
Home Amount

The checkbook or  cleared amount converted to the Home Currency, and displayed in the home currency format, as follows:

  • If the transaction has been reconciled this is the 'Cleared Amount' converted to the Home Currency using the 'Transaction Date'.
  • If the transaction has not been reconciled this is the 'Checkbook Amount' converted to the Home Currency using the 'Transaction Date'.

This column displays a total at the bottom.

Payee Name

The name entered as the Payee on Payments. This is only populated for Payment records. This is most often the value in the 'Check Name' property on the AP Vendor, Fishermen, or Loan account master file.

Linked Database Field: ERPx_MFCheckbookTransaction.PayeeName

Payment SourceIdentifies which Functional Area the payment was made from. Payments made to AP Vendors will have a Payment Source of "Purchasing". Payments made to Fishermen or Loans will have a Source of "Fisherman Accounting".
Reconciled Batch

Identifies the batch that the transaction was reconciled in. Reconciliation Batch ID's are auto-assigned as [YYYYMMDDHHMMSS] the batch was processed. This is only populated for transactions that have been reconciled.

Linked Database Field: ERPx_

Reconciled

A Yes/No value to identify if the transaction has been reconciled. If "Yes" then the transaction has been reconciled, if "No", it has not.

Linked Database Field: ERPx_

Reconciled By

Identify the user that reconciled the batch. This is only populated for transactions that have been reconciled and is formatted to be the user's [User First Name] + [User Last Name]. This is a system assigned value that is not editable by a user.

Linked Database Field: ERPx_

Reconciled Date

Identifies the actual date the transaction was reconciled. This is a system assigned value that is not editable by a user.

Linked Database Field: ERPx_

Reconciled Thru

Identifies the last day of the bank statement being reconciled or the date the transactions were reconciled thru if not from a statement. This is manually entered on the Reconcile transaction.

Linked Database Field: ERPx_

Reconciliation Group

Identifies what group the transactions belong to on the Checkbook Reconciliation transaction. The groups are assigned as follows:

  • Deposit: for Deposits and Transfer "Receipt" transactions
  • Payment: for Checks/ACH payments and Transfer "Sent" transactions
  • Adjustment: for Adjustment transactions

Linked Database Field: ERPx_

Reference

Displays the Reference from the transaction record view. 

Linked Database Field: ERPx_MFCheckbookTransaction.Reference

Source Transaction

A hyperlink that displays the source transaction's Transaction #. This is only populated for Reversal transactions.

Linked Database Field: ERPx_

Status
Insert excerpt
Status - List View/Inquiry FieldStatus - List View/Inquiry Field
nopaneltrue
Trans. Date
Insert excerpt
Doc Date - List View/Inquiry FieldDoc Date - List View/Inquiry Field
nopaneltrue
Transaction
Insert excerpt
Trans. ID - List View/Inquiry FieldTrans. ID - List View/Inquiry Field
nopaneltrue
Transaction Type

A text box to show the type of transaction. The options include:

  • Adjustment: Used to record miscellaneous increases or decreases in the checkbook balance. 
  • Deposit: Used to record deposits to the checkbook.  
  • Payment: Used to record outbound payments from the checkbook. This will have a reference to the 'Payment Type' (e.g. Payment: Check).
  • Transfer: Used to move funds from one checkbook to another. This will have a reference to which side the Transfer is (e.g. Transfer: Sent or Transfer Received). 
  • Reconciliation: Used to reconcile the checkbook balance with the bank's balance 
Linked Database Field: ERPx_MFModuleTransaction.ModuleTransactionSK WHERE ModuleSK = 1 /*System*/Adjustments		Identifies the sum of all the Adjustment transactions that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.
Cleared Deposits

Identifies the sum of all the deposit transactions (Deposits and Transfer: Receipt transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.

Cleared Payments

Identifies the sum of all the payment transactions (Payments and Transfer: Sent transactions) that were included on the reconciliation, in the checkbook's currency, displayed in the currency format.

Created
Insert excerpt
Created
Created
nopaneltrue
Created By
Insert excerpt
Created By
Created By
nopaneltrue
Last Updated
Insert excerpt
Last Updated
Last Updated
nopaneltrue
Last Updated By
Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
Reconcile to BalanceIdentifies the bank balance, in the checkbook's currency, displayed in the currency format that the reconciliation was targeting.
Status

Insert excerpt
Status
Status
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue

Linked Database Field: ERPx_MFCheckbookReconciliation.TransactionID

Related Topics



Expand
titlePage Definitions

Page Definitions


...