Financial: Training Guide

Financial: Training Guide

The Financial functional area is used to store and report on all the General Ledger data for the company. The main tasks performed include configuring the chart of accounts, managing checkbook balances, maintaining the fiscal calendar, and entering journal entries. The Financial functional area integrates across all functional areas.

Key Definitions

This section identifies common terms used throughout this Functional Area. This is not intended to be an alphabetized "Glossary of Terms" but is organized in a logical sequence to group similar terms together. The goal is to ensure we use common language that provides context to baseline NorthScope concepts.

Term

Definition

Term

Definition

Fiscal Calendar

Balance Sheet

Income Statement

General Ledger

Control Account

Control Account Types

  1. AP - Broker Balances

  2. FA - Fishermen Balances

  3. FA - Loan/Note Balances

  4. GA - Grower Balances

  5. AP - Vendor Balances

  6. AR - Customer Balances

  7. Checkbook

  8. Retained Earnings

Master Files 

 This section identifies each Master File (including a link to the Page Help), the Parent Folder it is listed under in the menu, and links to related User Guides.

Master File

Parent Folder

Overview

Related User Guide

Master File

Parent Folder

Overview

Related User Guide

Fiscal Periods

Configuration

Fiscal Periods: 

Fiscal Years:  

Areas to Review

  1. Describe what users do from here each month

  2. Describe what users do from here each year 

  3. Describe how these setting impact NorthScope 

Managing the Fiscal Calendar

GL Account Format

Configuration

Areas to Review

  1. Adding Segments and when Segments are added

  2. Identifying the Natural Account and what it means

  3. Adding Segment Values and when Segment Values are added

 

GL Account Class

Configuration

Areas to Review

  1. Describe what an Account Class 'Category' is used for

  2. Describe how the 'Sort' field is used

  3. Describe adding Account Classes

 

GL Accounts

Setup

Areas to Review

  1. Posting Type - Balance Sheet vs Income Statement

  2. Category - Based on the Posting Type

  3. Account Class - Based on the Category

  4. Account - Must follow the Account Segment Setup

  5. Account Description

  6. Control Account Type

  7. Typical Balance

  8. Inactive

  9. Use In Options (GL and AP are used, the others are not)

 

Checkbooks

Setup

Areas to Review

  1. Types of Checkbooks typically setup

  2. Checkbook Currency

  3. Cash Account - Lookup of Active Checkbook Control Accounts

  4. Checkbook Balance - Current Balance of all 'Posted' Checkbook Transactions

  5. Last Reconciled Balance - Balance of last reconciled bank statement

  6. Next Check #

  7. Enable ACH - If yes the ACH Fields must be properly configured including: Next ACH#, Bank, Name on Account, Routing #, and Account #

 

Project Class

Configuration

Areas to Review

  1. Adding Project Classes

 

Projects

Setup

Areas to Review

  1. What these are used for and where these are used in NorthScope

  2. Assigning Project ID's - From the Preference

  3. Project Class

  4. Project Start Date - Required

  5. Project End Date - Not required

  6. Project Budgets

  7. Open to Sales - Not plugged in

  8. Open to Purchasing

  9. Always open to the GL

 

Preferences

Configuration

 

Key Preferences:

  1. Retained Earnings GL Account

 

Transactions

 This section identifies all the Transactions (including a link to the Page Help), an overview of suggested training topics for each, and links to all applicable User Guides.

Transaction

Overview & Training Outline

Related User Guides

Transaction

Overview & Training Outline

Related User Guides

Journal Entry - Manual

Areas to Review

  1. What types of Journal Entries are manually entered

  2. Who makes them

  3. Header Comment

  4. Header Reference

  5. Line Items - GL Accounts

  6. Entering Amounts

  7. Distributing to a Project

  8. Line Comments

  9. Multi-Currency Journal Entries

 

Journal Entry - Accrue & Reverse

Areas to Review

  1. Identify the differences from Manual Journal Entries

  2. Identify examples of Accrue & Reverse Journal Entries 

 

Journal Entry - Reverse/Correct

Areas to Review

  1. Overview of why these are needed

  2. Describe what happens when a Journal Entry is reversed

  3. Describe what happens when a Journal Entry is corrected 

  4. Describe what Type(s) should be Reversed and which should not

 

Checkbook - Adjustment

Areas to Review

  1. Overview of why these are needed

  2. What happens to the General Ledger when these are posted

  3. What happens to the Checkbook Balance when these are posted

  4. How these are Reconciled

 

Checkbook Deposit

Areas to Review

  1. Overview of why these are needed

  2. What happens to the General Ledger when these are posted

  3. What happens to the Checkbook Balance when these are posted

  4. What happens to AR & FA Payment Receipts when these are posted

  5. How these are Reconciled

 

Checkbook Transfer

Areas to Review

  1. Overview of why these are needed

  2. What happens to the General Ledger when these are posted

  3. What happens to the Checkbook Balance when these are posted

  4. How these are Reconciled

 

Checkbook Reconciliation

Areas to Review

  1. Overview of why these are needed

  2. What transactions are Reconciled

  3. What are the requirements to post a Reconciliation

  4. What happens to the Checkbook Balance when Reconciliations are posted

 

Routines

Routine

Overview

Related Page Help

Related User Guides

Routine

Overview

Related Page Help

Related User Guides

Opening / Closing Fiscal Periods

  1. What is an Open Period vs a Closed Period?

  2. When are Periods opened and closed?

  3. What happens when a Period is closed?

    1. Series - Financial

    2. Series - Sales 

    3. Series - Purchasing 

    4. Series - Inventory 

    5. Series - Payroll

  4. What factors determine opening and closing periods?

  5. Who manages this?

 

Month-end Close Procedures

Year-End Close

  1. What is an Open Year vs a Closed Year?

  2. When are Years opened and closed?

  3. What factors determine opening and closing years? 

  4. Who manages this?

  5. What happens when a Year is closed?

 

Year-end Close Procedures

Year-End Reverse

  1. Why you would reverse a Year-end

  2. What happens when you reverse a Year-end

 

 

Inquiries

 This section identifies each of the Inquiries used throughout this Functional Area, listed by Inquiry Type, with an overview for each.

Inquiry Type

Inquiry Name

Overview

Inquiry Type

Inquiry Name

Overview

General Ledger

Journal Entry History

An inquiry that contains a list of all the Journal Entries that hit the General Ledger.

Journal Line History

An inquiry that contains all the Journal Entry Lines from all the Journal Entries that hit the General Ledger. This inquiry can be run from the Inquiries menu or as a drill through from the GL Account Balances inquiry

Balances

GL Account Balances

An inquiry that is run from the GL Account Balances page, that shows all the GL Accounts and their current balances.

GL Account Balances by Period

An inquiry that that shows the balances for one or more GL Accounts by GL Period. This inquiry can be run from the Inquiries menu or as a drill through from the GL Account Balances inquiry.

Checkbook

Checkbook Reconciliation Inquiry

 

Checkbook Register Inquiry

An inquiry that shows each individual payment Payment made from a Checkbook. 

Checkbook Transaction Inquiry

An inquiry that shows all the transactions that impact the Checkbook Balance and will be included on a Reconcile including: Adjustments, Deposits, Transfer: Sent, Transfer: Received, and Payments made. In this inquiry ACH Payments are shown at the 'Batch' level, not by individual payment. 

Other

ACH Batch Inquiry

An inquiry to show each ACH Batch that was created. By default, this inquiry shows ACH Batches that have not had the text file created.

Project Transaction History

An Inquiry to show all the transaction line items that have posted with a Project assigned. This includes AP Invoices, AP Credit Memos, and Journal Entries. 

Reports

 This section identifies each of the Reports that are shipped in this Functional Area. Reports are grouped by Report Type and include the Report Name and the Display Name as well as an overview for each report.

Report Group

Launches From

Report Type

Report Display Name

Overview

Report Group

Launches From

Report Type

Report Display Name

Overview

ACH

Print Dialog

Export Only

ACH File

A text file that contains the details for the bank to issue ACH Payments. This is generated when you are ready to upload the ACH text file to your bank.

Check

ACH Remittance

A report that takes the place of a Check & Check stub for ACH Payments. This is generated, and given to the Fisherman or Vendor, when you issue an ACH Payment.

Transaction Review

ACH Batch Detail Edit

A report that shows the detail payments that make up one or more selected ACH Batches.

Bank Reconciliation

Print Dialog

Transaction Review

Cleared Transactions

A report that identifies all the transactions that are currently assigned to a Reconciliation Transaction. This is typically printed and filed, as backup, with the Bank Statement you just reconciled.

Transaction Review

Outstanding Transactions

A report that identifies all the transactions that are not reconciled and not currently assigned to a Reconciliation Transaction. This is typically printed and filed, as backup, with the Bank Statement you just reconciled.

Transaction Review

Reconciliation Summary

A report that shows the summary totals for each type of reconcile balance. This is typically printed and filed, as backup, with the Bank Statement you just reconciled.

Reports Page

Transaction Review

Outstanding Transactions by Checkbook

A report that identifies all the checkbook transactions that have not been included on a Reconcile transaction. This is typically printed and reviewed when a Reconcile has been completed. This identifies all the transactions that have not cleared the bank. It is also used to determine if the "Checkbooks Cash Account" is in Balance. [GL Balance/Trial Balance] = [Bank Statement Ending Balance] + [Undeposited Receipts] + [Outstanding Deposits] - [Outstanding Payments] + [Outstanding Adjustments].

Transaction Review

Undeposited Receipts

A report that identifies all the Payment Receipts that have been posted but not yet assigned to a Deposit. 

Financial Reports

Reports Page

Transaction Analysis

Trial Balance

Transaction Analysis

Balance Sheet

Transaction Analysis

Income Statement

Journal Entry

Print Dialog

Transaction Review

Journal Entry Edit List

An edit report that shows the details of one or more journal entries.

Reports Page

Transaction Analysis

Ledger Account Detail

A report to show the transaction line item details that make up a GL Account Balance.

Year-End

Reports Page

Transaction Analysis

Beginning Balances

A report that shows all Beginning Balances for every Balance Sheet Account at the start of a new GL Year.

Configuration Sequence

This section identifies a logical sequence for configuring this Functional Area. This is not intended to be a detailed project plan, but rather a simple guide for what need to be configured.

Seq.

Page

Navigation Path

User Guide

Blocked By

Required

Comment

Seq.

Page

Navigation Path

User Guide

Blocked By

Required

Comment

1.

Fiscal Periods

Financial → Configuration → Fiscal Periods

Managing Fiscal Periods

 

Yes

 

2.

GL Account Format

Financial → Configuration → GL Account Format

Configuring your Chart of Accounts

 

Yes

 

3.

GL Account Class

Financial → Configuration → GL Account Class