User Tools

Site Tools


Sidebar

Table of Contents

general:totals_reconciliation

❏ Click Totals to display the bank reconciliation total fields as defined on the Categories tab. Based on the Categories tab, some of the fields are automatically calculated and cannot be edited.

The totals are updated as transactions are selected or cleared. The Unreconciled Difference amount is displayed on the Totals header only if the Totals section is collapsed. This allows you to view the updated unreconciled difference amount as transactions are selected and cleared.

If the Totals section is expanded, the unreconciled difference amount is not displayed on the header.

If the Statement Type for a category is set to User Input: Multi Entry on the Tables > Reconciliation Layout > Categories tab, click in the category field to open a multi-entry pop-up window allowing you to add user-defined rows of descriptions and amounts to be included in the total calculations.

  • In the Description field, type a user-defined description for the entry.
  • In the Amount field, type a dollar amount for the entry.
  • Click +Add to add a row. Or, a new row is added when you type a description in an existing row and press TAB.

❏ Click OK. The multi-entry pop-up window closes, and the entered amounts are totaled and displayed in the corresponding category field.

❏ Click Cancel to close the pop-up window without adding additional entries.

❏ Click Trashcan Icon to delete a row.

❏ Click Save As Pending. The Totals are recalculated to include the multi-entry amounts.

❏ If the Statement Type for a category is set to User Input: Single Entry on the Tables > Reconciliation Layout > Categories tab, type the amount in the field.

Total calculations:

Cleared Deposits - Total of cash receipts with the Recon checkbox selected.
Cleared Checks - Total of cash receipts with the Recon checkbox selected.
Cleared JVs - Total of JVs with the Recon checkbox selected.
Banking Fees/Charges - Type the fees/charges from the bank statement.
Previous Balance - Type the beginning/previous balance from the bank statement.
Statement Balance - Type the ending balance from the bank statement.
Bank Dividends/Interest - Type the dividend/interest from the bank statement.
System Cash - The general ledger balance of all cash object/subobject codes associated with the bank account group is displayed.
Outstanding Deposits - Total of cash receipts without the Recon checkbox selected.
Outstanding Checks - Total of checks without the Recon checkbox selected.
Outstanding JVs - Total of JVs without the Recon checkbox selected.
Statement Balance - The ending balance from the bank statement that you entered under the Bank Statement column is displayed.
Miscellaneous Adjustment - Type the additional entries that have not been posted yet.
Unreconciled Difference - The calculated value based on the following formula is displayed: Unreconciled Difference = System Cash + Outstanding Deposits + Outstanding Checks - Statement Balance - Miscellaneous Adjustment



❏ Click System Cash to refresh the system cash totals.

general/totals_reconciliation.txt · Last modified: 2021/03/25 14:07 by emoreno