Difference between revisions of "Bank Reconcile"

From Agency Systems Wiki
Jump to navigation Jump to search
m
(3 intermediate revisions by the same user 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.
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 73: Line 73:
 
#:[[File:Gl-bankrec-create-list-selectcash.png]]
 
#:[[File:Gl-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]].
Line 86: Line 86:
  
 
==== Marking Journal Transactions As Reconciled ====
 
==== Marking Journal 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]], 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.  
 
The line-item for each journal can be hidden from the bank rec screen through a new right-click option.  

Revision as of 14:33, 24 August 2016

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 GL -> Bank Reconcile. (Requires Security System: GL -> Bank Reconcile -> View, Entry, and Edit)

Menu-gl-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 GL -> Bank Reconcile.
  2. Enter the following details: (See bank reconcile fields above)
    • Bank Code
    • Start Date
    • End Date
    • Statement Balance
    Gl-bankrec-create.png
  3. Select Ok. All matching items will be displayed in date order, and can be sorted using the headers.
    Gl-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.

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

Marking Cash Transactions As Reconciled

  1. Select Only Show Cash Transactions to filter the list.
    Gl-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.
    Gl-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.
    Gl-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.
    Gl-bankrec-create-list-selectchecks.png

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

Marking Journal Transactions As Reconciled

Reconciling is matching your Newton data to the Bank. Since the bank does not have records for journal transactions, 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"
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.

Gl-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 GL -> Bank Reconcile.
  2. Select Load a reconcile in progress.
  3. Select the previously stored reconcile, and select Ok.
    Menu-gl-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 GL -> Bank Reconcile.
  2. Select Load a reconcile in progress.
  3. Select the previously stored reconcile, and select Cancel This Item.
    Menu-gl-bankrec-loadinprogress-cancel.png
  4. Select Yes to confirm.
    Menu-gl-bankrec-loadinprogress-cancelyn.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 GL -> Bank Reconcile. Select Other to view additional options.

Menu-gl-bankrec-other.png

Change Default Dates...

  1. Select GL -> 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.
    Menu-gl-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 GL -> Bank Reconcile.
  2. Select Other -> View Reconcile Archive...
  3. Select the previously processed reconcile, and select Report.