Bank Reconcile - Revision history

Mlively: /* Select Actions when Bank Reconcile Completes... */ removed invalid anchor link

2019-04-24T20:14:29Z

Select Actions when Bank Reconcile Completes...: removed invalid anchor link

Kcrenshaw: /* Process A Bank Reconcile */ forgot to update 1 image

2019-04-24T19:09:44Z

Process A Bank Reconcile: forgot to update 1 image

Kcrenshaw: updated images, text and added details for 'select action' option under 'Other'

2019-04-24T18:31:13Z

updated images, text and added details for 'select action' option under 'Other'

Fshriver at 16:50, 5 March 2019

2019-03-05T16:50:47Z

Mlively at 14:33, 24 August 2016

2016-08-24T14:33:19Z

Mlively: /* Bank Reconcile Fields */

2016-08-24T14:29:44Z

Bank Reconcile Fields

Mlively: /* Marking Journal Transactions As Reconciled */

2014-12-22T16:06:54Z

Marking Journal Transactions As Reconciled

Mlively: /* Marking Cash Transactions As Reconciled */

2014-12-02T21:17:49Z

Marking Cash Transactions As Reconciled

Mlively: /* Marking Cash Transactions As Reconciled */ grammar

2014-12-02T21:16:46Z

Marking Cash Transactions As Reconciled: grammar

Mlively: /* Marking Check Transactions As Reconciled */ added option for hiding journals

2014-12-02T20:04:52Z

Marking Check Transactions As Reconciled: added option for hiding journals

@@ Line 143: / Line 143: @@
 #Select '''Accounting -> Bank Reconcile'''.
 #Select '''Other -> Select Actions when Bank Reconcile Completes...'''
-#Check to enable or disable the different report options.  If '''Save report to archive''' is selected for any option, select the desired '''Archive Folder'''.  ''(The Archive folder is [[#Configure Invoice Reconcile Actions|shared with the invoice reconcile archive folder]].)''
+#Check to enable or disable the different report options.  If '''Save report to archive''' is selected for any option, select the desired '''Archive Folder'''.  ''(The Archive folder is shared with the invoice reconcile archive folder.)''
 #:[[File:Acctg-bankrec-other-action.png]]
 #Select '''OK'''.

@@ Line 64: / Line 64: @@
 After [[#Create A New Bank Reconcile|starting a new bank reconcile]], or [[#Load A Bank Reconcile In Progress|loading an bank reconcile in progress]], the transactions are compared to the bank statement for verification.  Once verified, the transaction amount is included in the '''reconciled bank balance'''.
-[[File:Gl-bankrec-create-list-balance-begin.png]]
+[[File:Acctg-bankrec-create-list-balance-begin.png]]
 ==== Marking Cash Transactions As Reconciled ====

@@ Line 32: / Line 32: @@
 Select '''Accounting -> Bank Reconcile'''.  ''(Requires [[Security System]]: GL -> Bank Reconcile -> View, Entry, and Edit)''
-[[File:Menu-gl-bankrec.png]]
+[[File:acctg-bankrec.png]]
 ==== Bank Reconcile Fields ====
@@ Line 57: / Line 57: @@
 #*'''End Date'''
 #*'''Statement Balance'''
-#:[[File:Gl-bankrec-create.png]]
+#:[[File:acctg-bankrec-create.png]]
 #Select '''Ok'''.  All  matching items will be displayed in date order, and can be sorted using the headers.
-#:[[File:Gl-bankrec-create-list.png]]
+#:[[File:acctg-bankrec-create-list.png]]
 == Process A Bank Reconcile ==
@@ Line 68: / Line 68: @@
 ==== Marking Cash Transactions As Reconciled ====
 #Select '''Only Show Cash Transactions''' to filter the list.
-#:[[File:Gl-bankrec-create-list-onlycash.png]]
+#:[[File:acctg-bankrec-create-list-onlycash.png]]
 #A single [[:Category:Cash|cash transaction]] for each [[Process Daily Cash Deposits With Cash On-Hand Account|daily bank deposit will be displayed]].  In addition, EFT cash received from carriers will also be listed.
 #Select the '''Rec''' checkbox for each cash item that matches the bank statement.  The '''Cash''' totals and the '''Reconciled Bank Balance''' will be automatically updated as each item is selected.
-#:[[File:Gl-bankrec-create-list-selectcash.png]]
+#:[[File:acctg-bankrec-create-list-selectcash.png]]
 If check items are included, continue to: [[#Marking Check Transactions As Reconciled|Marking check transactions as reconciled]].
@@ Line 79: / Line 79: @@
 ==== Marking Check Transactions As Reconciled ====
 #Select '''Only Show Check Transactions''' to filter the list.
-#:[[File:Gl-bankrec-create-list-onlychecks.png]]
+#:[[File:acctg-bankrec-create-list-onlychecks.png]]
 #Select the '''Rec''' checkbox for each check item that matches the bank statement.  The '''Check''' totals and the '''Reconciled Bank Balance''' will be automatically updated as each item is selected.
-#:[[File:Gl-bankrec-create-list-selectchecks.png]]
+#:[[File:acctg-bankrec-create-list-selectchecks.png]]
 If finished, see [[#Perform (Complete) Or Save Progress|Perform (Complete) A Bank Reconcile]].
-==== Marking Journal Transactions As Reconciled ====
+==== Marking Journal and Voucher Transactions As Reconciled ====
-Reconciling is matching your Newton data to the Bank.  Since the bank does not have records for [[Journal Entry|journal transactions]], the journal amounts are automatically included in the reconciled bank balance value.
+Reconciling is matching your Newton data to the Bank.  Since the bank does not have records for [[Journal Entry|journal transactions]] and [[Voucher Transaction|voucher transactions]], these amounts are automatically included in the reconciled bank balance value.
-The line-item for each journal can be hidden from the bank rec screen through a new right-click option.
+The line-item for each journal and voucher can be hidden from the bank rec screen through a new right-click option.
-;Right-Click -> Show -> Deselect "Show Journals"
+;Right-Click -> Show -> Deselect "Show Journals and Vouchers"
-:[[File:bankrec-rightclick-showjournals.png]]
+:[[File:acctg-bankrec-rightclick-showjournals.png]]
 ==== Perform (Complete) Or Save Progress  ====
 After all cash transactions and all check transactions are selected, the '''reconciled bank balance''' should match the '''statement balance''', and the '''difference''' will be displayed as 0.00. Select '''Perform Reconcile''' to complete the bank reconcile.
-[[File:Gl-bankrec-create-list-perform.png]]
+[[File:acctg-bankrec-create-list-perform.png]]
 To run a report for the completed reconcile, see: [[#View Reconcile Archive... (Report For Completed Reconciles)|View Reconcile Archive]].
@@ Line 107: / Line 107: @@
 #Select '''Load a reconcile in progress'''.
 #Select the previously stored reconcile, and select '''Ok'''.
-#:[[File:Menu-gl-bankrec-loadinprogress.png]]
+#:[[File:acctg-bankrec-loadinprogress.png]]
 #The previously stored bank reconcile-in-progress will be displayed. Follow the steps to [[#Process A Bank Reconcile|process the bank reconcile]].
@@ Line 114: / Line 114: @@
 #Select '''Load a reconcile in progress'''.
 #Select the previously stored reconcile, and select '''Cancel This Item'''.
-#:[[File:Menu-gl-bankrec-loadinprogress-cancel.png]]
+#:[[File:acctg-bankrec-loadinprogress-cancel.png]]
 #Select '''Yes''' to confirm.
-#:[[File:Menu-gl-bankrec-loadinprogress-cancelyn.png]]
+#:[[File:acctg-bankrec-loadinprogress-cancelconfirm.png]]
 The stored reconcile-in-progress will be cancelled.  Once cancelled, a [[#Create A New Bank Reconcile|new bank reconcile can be started]] for the same [[Bank Profile|bank]].
@@ Line 123: / Line 123: @@
 Select '''Accounting -> Bank Reconcile'''.  Select '''Other''' to view additional options.
-[[File:Menu-gl-bankrec-other.png]]
+[[File:acctg-bankrec-other.png]]
 ==== Change Default Dates...====
@@ Line 129: / Line 129: @@
 #Select '''Other -> Change Default Dates...'''
 #The [[#Bank Reconcile Fields|default '''Start Date''' and '''End Date''']] can be adjusted with a number of options.  It is recommended to set the '''Start Date''' to the day the agency starting using Agency Systems.
-#:[[File:Menu-gl-bankrec-other-defaultdates.png]]
+#:[[File:acctg-bankrec-other-defaultdates.png]]
 #Select '''OK''' when finished.
@@ Line 138: / Line 138: @@
 #Select '''Other -> View Reconcile Archive...'''
 #Select the previously processed reconcile, and select '''Report'''.

@@ Line 30: / Line 30: @@
 == Bank Reconcile Screen ==
-Select '''GL -> Bank Reconcile'''.  ''(Requires [[Security System]]: GL -> Bank Reconcile -> View, Entry, and Edit)''
+Select '''Accounting -> Bank Reconcile'''.  ''(Requires [[Security System]]: GL -> Bank Reconcile -> View, Entry, and Edit)''
 [[File:Menu-gl-bankrec.png]]
@@ Line 51: / Line 51: @@
 [[Journal Entry|Journal Entries]] cannot be reconciled, and are always included if saved to [[General Ledger Profile|GL - 1100 (Cash in bank)]].  The amounts are included in the reconciled totals.
-#Select '''GL -> Bank Reconcile'''.
+#Select '''Accounting -> Bank Reconcile'''.
 #Enter the following details: ''(See [[#Bank Reconcile Fields|bank reconcile fields above]])''
 #*'''[[Bank Profile|Bank Code]]
@@ Line 104: / Line 104: @@
 == Load Or Cancel A Bank Reconcile In Progress ==
 === Load A Bank Reconcile In Progress ===
-#Select '''GL -> Bank Reconcile'''.
+#Select '''Accounting -> Bank Reconcile'''.
 #Select '''Load a reconcile in progress'''.
 #Select the previously stored reconcile, and select '''Ok'''.
@@ Line 111: / Line 111: @@
 === Cancel A Bank Reconcile In Progress ===
-#Select '''GL -> Bank Reconcile'''.
+#Select '''Accounting -> Bank Reconcile'''.
 #Select '''Load a reconcile in progress'''.
 #Select the previously stored reconcile, and select '''Cancel This Item'''.
@@ Line 121: / Line 121: @@
 == Bank Reconcile Screen - Additional Options==
-Select '''GL -> Bank Reconcile'''.  Select '''Other''' to view additional options.
+Select '''Accounting -> Bank Reconcile'''.  Select '''Other''' to view additional options.
 [[File:Menu-gl-bankrec-other.png]]
 ==== Change Default Dates...====
-#Select '''GL -> Bank Reconcile'''.
+#Select '''Accounting -> Bank Reconcile'''.
 #Select '''Other -> Change Default Dates...'''
 #The [[#Bank Reconcile Fields|default '''Start Date''' and '''End Date''']] can be adjusted with a number of options.  It is recommended to set the '''Start Date''' to the day the agency starting using Agency Systems.
@@ Line 135: / Line 135: @@
 The reconcile archive lists all previously completed bank reconciles.
-#Select '''GL -> Bank Reconcile'''.
+#Select '''Accounting -> Bank Reconcile'''.
 #Select '''Other -> View Reconcile Archive...'''
 #Select the previously processed reconcile, and select '''Report'''.

@@ Line 25: / Line 25: @@
 </tr>
 </table>
-The Newton Bank Reconciliation feature allows you to verify the transactions in your bank accounts against the transactions recorded in Newton. The reconciliation feature itself is straightforward: You can load all transactions within a date range (e.g. a given month), compare the total with your bank statement total for that period, and reconcile the lot as a batch.
+The Newton Bank Reconciliation feature allows you to verify the transactions in your bank accounts against the transactions recorded in Newton. The reconciliation feature is designed to load all unreconciled transactions up to statement end date.  The Newton transactions are compared to the bank statement, and selected as reconciled in a batch once the totals are confirmed.
 [[Process Daily Cash Deposits With Cash On-Hand Account|Daily cash deposits]] will be listed as a single cash receipt, instead of a list of individual payments, matching the daily deposit from the bank statement.

@@ Line 38: / Line 38: @@
 *'''Load a reconcile in progress:''' [[#Load A Bank Reconcile In Progress|Resumes a saved bank reconcile in progress]].
 *'''Bank:''' The [[Bank Profile]] used for the bank reconciliation.
-*'''Start Date:''' The start date for all transactions.  Any transaction prior to the start date will be automatically included in the reconciled bank balance.
+*'''Start Date:''' The start date for all transactions.  Any transaction prior to the start date will be '''automatically included in the reconciled bank balance'''.
-*:It is recommended to set to the start date to the day the agency began using Agency Systems. ''(See [[#Change Default Dates...|Change Default Dates]] to configure the default value.)''
+*:It is recommended to '''set to the start date to the day the agency began using Agency Systems'''. ''(See [[#Change Default Dates...|Change Default Dates]] to configure the default value.)''
 *'''End Date:''' The end date for all transactions.  Any transaction after the end date will not be included in the bank reconcile. ''(See [[#Change Default Dates...|Change Default Dates]] to configure the default value.)''
 *'''Statement Balance:''' The statement balance provided by the bank, as of the End Date.
 == Create A New Bank Reconcile ==

← Older revision		Revision as of 20:04, 2 December 2014
Line 83:		Line 83:

	If finished, see [[#Perform (Complete) Or Save Progress\|Perform (Complete) A Bank Reconcile]].		If finished, see [[#Perform (Complete) Or Save Progress\|Perform (Complete) A Bank Reconcile]].
		+
		+	==== Marking Journal Transactions As Reconciled ====
		+	The journal amounts are automatically included in the reconciled bank balance value.
		+
		+	The line-item for each journal can be hidden from the bank rec screen through a new right-click option.
		+
		+	;Right-Click -> Show -> Deselect "Show Journals"
		+	:[[File:bankrec-rightclick-showjournals.png]]

	==== Perform (Complete) Or Save Progress ====		==== Perform (Complete) Or Save Progress ====