User Tools

Site Tools


Sidebar

Table of Contents

bankreconciliation:tables:reconciliationlayout:categories

This is an old revision of the document!


Categories

Bank Reconciliation > Tables > Reconciliation Layout > Categories

This tab is used to define the categories (fields) displayed on the Bank Reconciliation page. These categories are used in the reconciliation layout template, which is managed on the Layout tab.

There are two layout type options:

  • The Single Column layout consists of a single column of fields and operations.
  • The Double Column layout consists of two columns of fields and operations; System and Bank.

The Double Column layout is the default.

Default categories

DescriptionStatement Type
Bank Dividends/InterestUser Input Single Entry
Banking Fees/ChargesUser Input Single Entry
Cleared ChecksCleared Checks
Cleared DepositsCleared Deposits
Cleared JVsCleared JVs
Miscellaneous AdjustmentUser Input Single Entry (It is recommended that this field is set up as a Multiple Entry field with a (+) operator.)
Outstanding ChecksOutstanding Checks
Outstanding DepositsOutstanding Deposits
Outstanding Journal EntriesOutstanding JVs
Previous BalanceUser Input Single Entry
Statement Balance BankUser Input Single Entry
Statement Balance SystemUser Input Single Entry
System CashSystem Cash
Unreconciled DifferenceTotal

Add a category:

Click +Add to add a row.

Image

Field Description
DescriptionType the 30-character category description to be displayed in the bank reconciliation layout.
Operator

Click Drop-down Arrow to select the operation to be used for the category description. If the Statement Type field is set to Total, the Operator field must be set to = Equals.

You can select to use a single or double column layout on the Layout tab.

If Double Column is selected, only one bank side category and one system side category can be set to = Equals.

If Single Column is selected, only one category (field) can be set to = Equals.

Statement Type

Click Drop-down Arrow to assign a calculated amount or allow for user entry.

Recon SideSelect the category reconciliation side (Bank or System). This field is only displayed if Double Column is selected and saved on the Layout tab. Refer to Image 1 on this page.
InactiveSelect to exclude the category from the reconciliation layout. If selected, the category is not displayed on the Layout tab.

Click Save.

Note: You can edit field names as needed. For example, the Bank Statement System field can be renamed to Bank Statement Balance.

Other functions and features:

Reset

Click to retrieve data from the last save. If you click Reset, any unsaved changes are lost.

Trashcan Icon

Click to delete a row. The row is shaded red to indicate that it will be deleted when the record is saved.

Click Save.

bankreconciliation/tables/reconciliationlayout/categories.1539891903.txt.gz · Last modified: 2018/10/18 14:45 (external edit)