Difference between revisions of "Bank Reconcile"

From Agency Systems Wiki
Jump to navigation Jump to search
(→‎Marking Check Transactions As Reconciled: added option for hiding journals)
 
(8 intermediate revisions by 3 users not shown)
Line 25: Line 25:
 
</tr>
 
</tr>
 
</table>
 
</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.
 
[[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.
  
 
== Bank Reconcile Screen ==
 
== 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]]
+
[[File:acctg-bankrec.png]]
  
 
==== Bank Reconcile Fields ====
 
==== Bank Reconcile Fields ====
Line 38: Line 38:
 
*'''Load a reconcile in progress:''' [[#Load A Bank Reconcile In Progress|Resumes a saved bank reconcile in progress]].
 
*'''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.  
 
*'''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.)''
 
*'''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.  
+
*'''Statement Balance:''' The statement balance provided by the bank, as of the End Date.
  
 
== Create A New Bank Reconcile ==
 
== Create A New Bank Reconcile ==
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.  
 
[[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]])''
 
#Enter the following details: ''(See [[#Bank Reconcile Fields|bank reconcile fields above]])''
 
#*'''[[Bank Profile|Bank Code]]
 
#*'''[[Bank Profile|Bank Code]]
Line 57: Line 57:
 
#*'''End Date'''
 
#*'''End Date'''
 
#*'''Statement Balance'''
 
#*'''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.  
 
#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 ==
 
== Process A Bank Reconcile ==
 
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'''.   
 
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 ====
 
==== Marking Cash Transactions As Reconciled ====
 
#Select '''Only Show Cash Transactions''' to filter the list.  
 
#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.  
 
#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.  
 
#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]]
  
Continue to [[#Marking Check Transactions As Reconciled|marking check transactions as reconciled]] if check items are included.
+
If check items are included, continue to: [[#Marking Check Transactions As Reconciled|Marking check transactions as reconciled]].
  
 
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 Check Transactions As Reconciled ====
 
==== Marking Check Transactions As Reconciled ====
 
#Select '''Only Show Check Transactions''' to filter the list.  
 
#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.  
 
#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]].
 
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 ====
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  ====
 
==== 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.
 
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]].  
 
To run a report for the completed reconcile, see: [[#View Reconcile Archive... (Report For Completed Reconciles)|View Reconcile Archive]].  
Line 103: Line 104:
 
== Load Or Cancel A Bank Reconcile In Progress ==
 
== Load Or Cancel A Bank Reconcile In Progress ==
 
=== Load 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 '''Load a reconcile in progress'''.
 
#Select the previously stored reconcile, and select '''Ok'''.  
 
#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]].   
 
#The previously stored bank reconcile-in-progress will be displayed. Follow the steps to [[#Process A Bank Reconcile|process the bank reconcile]].   
  
 
=== Cancel A Bank Reconcile In Progress ===
 
=== Cancel A Bank Reconcile In Progress ===
#Select '''GL -> Bank Reconcile'''.
+
#Select '''Accounting -> Bank Reconcile'''.
 
#Select '''Load a reconcile in progress'''.
 
#Select '''Load a reconcile in progress'''.
 
#Select the previously stored reconcile, and select '''Cancel This Item'''.  
 
#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.  
 
#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]].  
 
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]].  
  
 
== Bank Reconcile Screen - Additional Options==
 
== 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]]
+
[[File:acctg-bankrec-other.png]]
  
 
==== Change Default Dates...====
 
==== Change Default Dates...====
#Select '''GL -> Bank Reconcile'''.   
+
#Select '''Accounting -> Bank Reconcile'''.   
 
#Select '''Other -> Change Default Dates...'''
 
#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.  
 
#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.
 
#Select '''OK''' when finished.
  
Line 134: Line 135:
 
The reconcile archive lists all previously completed bank reconciles.   
 
The reconcile archive lists all previously completed bank reconciles.   
  
#Select '''GL -> Bank Reconcile'''.   
+
#Select '''Accounting -> Bank Reconcile'''.   
 
#Select '''Other -> View Reconcile Archive...'''
 
#Select '''Other -> View Reconcile Archive...'''
 
#Select the previously processed reconcile, and select '''Report'''.
 
#Select the previously processed reconcile, and select '''Report'''.
 +
 +
==== Select Actions when Bank Reconcile Completes...====
 +
 +
#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 shared with the invoice reconcile archive folder.)''
 +
#:[[File:Acctg-bankrec-other-action.png]]
 +
#Select '''OK'''.

Latest revision as of 20:14, 24 April 2019

Related Pages
Related Categories

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.

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.

Bank Reconcile Screen

Select Accounting -> Bank Reconcile. (Requires Security System: GL -> Bank Reconcile -> View, Entry, and Edit)

Acctg-bankrec.png

Bank Reconcile Fields

  • Create a new reconcile: Begins the process of starting a new bank reconcile.
  • Load a 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.
    It is recommended to set to the start date to the day the agency began using Agency Systems. (See 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 to configure the default value.)
  • Statement Balance: The statement balance provided by the bank, as of the End Date.

Create A New Bank Reconcile

The bank reconcile will list the following transactions effective within the specified date range and bank code.

Journal Entries cannot be reconciled, and are always included if saved to GL - 1100 (Cash in bank). The amounts are included in the reconciled totals.

  1. Select Accounting -> Bank Reconcile.
  2. Enter the following details: (See bank reconcile fields above)
    • Bank Code
    • Start Date
    • End Date
    • Statement Balance
    Acctg-bankrec-create.png
  3. Select Ok. All matching items will be displayed in date order, and can be sorted using the headers.
    Acctg-bankrec-create-list.png

Process A Bank Reconcile

After starting a new bank reconcile, or 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.

Acctg-bankrec-create-list-balance-begin.png

Marking Cash Transactions As Reconciled

  1. Select Only Show Cash Transactions to filter the list.
    Acctg-bankrec-create-list-onlycash.png
  2. A single cash transaction for each daily bank deposit will be displayed. In addition, EFT cash received from carriers will also be listed.
  3. 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.
    Acctg-bankrec-create-list-selectcash.png

If check items are included, continue to: Marking check transactions as reconciled.

If finished, see Perform (Complete) A Bank Reconcile.

Marking Check Transactions As Reconciled

  1. Select Only Show Check Transactions to filter the list.
    Acctg-bankrec-create-list-onlychecks.png
  2. 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.
    Acctg-bankrec-create-list-selectchecks.png

If finished, see Perform (Complete) A Bank Reconcile.

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 transactions and voucher transactions, these amounts are automatically included in the reconciled bank balance value.

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 and Vouchers"
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.

Acctg-bankrec-create-list-perform.png

To run a report for the completed reconcile, see: View Reconcile Archive.

To save the progress instead of completing the reconcile, select Save And Exit to save without posting any changes. The bank reconcile can later be resumed by loading a bank reconcile in progress.

Load Or Cancel A Bank Reconcile In Progress

Load A Bank Reconcile In Progress

  1. Select Accounting -> Bank Reconcile.
  2. Select Load a reconcile in progress.
  3. Select the previously stored reconcile, and select Ok.
    Acctg-bankrec-loadinprogress.png
  4. The previously stored bank reconcile-in-progress will be displayed. Follow the steps to process the bank reconcile.

Cancel A Bank Reconcile In Progress

  1. Select Accounting -> Bank Reconcile.
  2. Select Load a reconcile in progress.
  3. Select the previously stored reconcile, and select Cancel This Item.
    Acctg-bankrec-loadinprogress-cancel.png
  4. Select Yes to confirm.
    Acctg-bankrec-loadinprogress-cancelconfirm.png

The stored reconcile-in-progress will be cancelled. Once cancelled, a new bank reconcile can be started for the same bank.

Bank Reconcile Screen - Additional Options

Select Accounting -> Bank Reconcile. Select Other to view additional options.

Acctg-bankrec-other.png

Change Default Dates...

  1. Select Accounting -> Bank Reconcile.
  2. Select Other -> Change Default Dates...
  3. The 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.
    Acctg-bankrec-other-defaultdates.png
  4. Select OK when finished.

View Reconcile Archive... (Report For Completed Reconciles)

The reconcile archive lists all previously completed bank reconciles.

  1. Select Accounting -> Bank Reconcile.
  2. Select Other -> View Reconcile Archive...
  3. Select the previously processed reconcile, and select Report.

Select Actions when Bank Reconcile Completes...

  1. Select Accounting -> Bank Reconcile.
  2. Select Other -> Select Actions when Bank Reconcile Completes...
  3. 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.)
    Acctg-bankrec-other-action.png
  4. Select OK.