AR General Parameters – Miscellaneous Billing

Accounts Receivable General Parameters – Miscellaneous Billing

Overview

There are administrative options that will control how the Govern System handles charges that are related to Misc. Billing (MB).
The following parameters need to be setup for Miscellaneous Billing:

Bypass MB/LM/SA/ST funds reapplication

There are administrative options that will control how the Govern System handles charges that are related to Misc. Billing (MB), Land Management (LM), Special Assessment (SA), and Self Reported Tax (ST). The Accounts Receivable General Parameters form is used to define settings for all the subsystems that are linked to Govern’s Accounts / Receivable (A/R) subsystem. Open Credit Transactions (OCT) are generated in the system when an amount that is applied to a payment exceeds the payment due. In the Govern system an OCT is in the form of an Open Cash on Hand (OCH), or an Overpayment (OVR). The Bypass MB/LM/SA/ST funds reapplication in the A/R General Parameters form is an option that changes how the system treats the reapplication of OCT’s.

When the Bypass XX funds reapplication option in GovAdmin is selected, the system will now apply the OCT to the account even if an invoice is NOT referenced.
As before, if the invoice is referenced, the OCT amount will be applied to the selected invoice.
When Reapply in the A/R Inquiry form is selected, the No option will apply the OCT to the outstanding balance of an invoice and creates the applicable G/L entries.
Only select the Yes option with the understanding that the OCT will be applied to account, but the OCT reference will be lost; this is consistent with the previous system behavior.

Default Rules of applying OCH

By default, in the A/R Inquiry form, when a payment is made in the system and no invoice number is specified, the Govern system will apply the payment to all outstanding invoices. When an overpayment amount exists as a result of that overpayment, it is recorded in the system as an open credit OCH. When users select the Bypass XX funds reapplication option in GovAdmin, where XX is a related subsystem. When Reapply is selected in the Govern A/R Inquiry form, unless an invoice number is specified, payments will be recorded as an OCH record, and will remain in the system.

NOTE: Invoices must be referenced by their number otherwise the system will not apply the payment.

During Reapply, if the Yes option is selected for Bypass MB funds reapplication, the OCH will be cleared. Any reference to the OCH will be lost and no adjustment will be made to the GL transactions.

A/R Master by Fiscal Year

This can be selected to create a new AR_ID each year for each MB_ID when an Invoice posting occurs. Otherwise, all invoices for each MB_ID will post to the same AR_ID.

Allow payments < Late Charges Due

 

 

103-ar-parm-MB

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR – General Ledger (GL) Parameters

Accounts Receivable (A/R) – General Ledger (G/L) Parameters

Overview

103-ar-parmGLtransaction.png
Accounts Receivable General Ledger Accounts and Transaction

When accounts receivable or cash collection transactions are posted, General Ledger Transactions accounting transactions are generated (debits and credit
An unlimited number of G/L ACCOUNTS can be created and linked to different AR CLASS CODES.s).
You can specify by sub-system or account if the transaction should be generated at the detail or summary level.
For instance, 1 transaction generated for each tax bill posted OR 1 transaction for the total tax bill posting process.

G/L Transaction Parameters

Fiscal Starting Date
The Fiscal Starting Date is required ONLY for the Cayenta G/L Interface. Enter the month, day and year that the new fiscal year begins.

Setup Guidelines

Accountants like to have at least one side (DEBIT or CREDIT) of the transaction at the detail level.
Dictated by the Auditors, Finance Officers or Processes (ex: Summarize G/L transaction when posting the Tax Billing to AR, then reset to Detail for the subsequent partial billings).
In the example below, a separate set of G/L Accounts is setup by:

  • Taxing Authority (county, cities, town’s special districts…)
  • A/R & Collection Type (real property, business tax, delinquency, bankruptcy…)
  • Transaction Type (billing, interest, open cash, open credit, fees, discount ….)

See Hands-on to upload this configuration.

G/L Ledger Distribution

Selecting the Activate G/L Validation option on the A/R General Parameters form in order to use the automatic G/L validation. This determines the G/L accounts for the selected A/R Class, based on the transaction type. Refer to the following document for details.
101-ar-001-AR-GLDistSetup

 

103-ar-parm-GL

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR General Parameters – Specification

Accounts Receivable (A/R) General Parameters – Specification

Overview

please note that the following parameters apply to all sub-systems.

Minimum Balance to Compute Charges, or %

  • Enter the minimum balance, as an amount or percentage, on which late charges, such as interest and penalties, can be applied.
  • For example: If you enter 50%, the minimum payment amount is 50% of the installment due. The user cannot enter less than the calculated amount on the Payment Data Entry form in Govern, unless the Allow Payments < Late Charges Due option at the top of this form, is selected, or if the user has Full Access Rights to the function. – to be validated for CC

Department Used from the Web

  • If you are using the Web portal, select a default department for managing the Web data.

Bill Number Prefix

  • Select this option to use a two-digit prefix for A/R billing. If this option is selected, the Bill Prefix field is displayed on the Govern Tax Posting to A/R batch process.

Use Exact Installment

  • Select this option to prevent collection of the second installment through the Payment Data Entry form before the first has been collected. Otherwise, if the second installment is collected while the first remains outstanding, the second installment payment is registered as the total payment in the database.

Security by Area (Deprecated in 6.0)

  • Select this option to enable the A/R Security form. This from is used to define user access rights to the A/R functions according to subsystem and the value of the selected field. This setting is valid for Govern for Windows only. In Govern.NET, security is managed through the Govern Security Manager (GSM).

Reapplication of Funds

  • The following options are available on the Accounts Receivable General Parameters form for bypassing the reapplication of funds for Land Management (LM), Miscellaneous Billing (MB), Special Assessment (SA), and Self-Reported Tax (ST). When you apply the bypass to an overpayment made on a permit, Miscellaneous billing charge or special assessment project, it is saved as an Open Credit Transaction (OCT). Otherwise, the amount exceeding the payment due is applied to another permit, invoice, project, or Self-Reported Tax period. You are also able to apply the bypass or the reapplication of funds separately to the Miscellaneous Billing, the Land Management, the Special Assessment, and the Self -Reported Tax subsystems, by selecting or deselecting the following options, as applicable. New in 10.8

Use Proportional Distribution (Deprecated in 6.0)

  • Select this option to enable Proportional Distribution for cash collection. With Proportional Distribution, payments are distributed according to the amount owed on each account.
  • For example, if the client pays $100.00 but owes $150.00 for electricity and $50.00 for water, $75.00 is paid towards the electric bill and the remaining $25.00 towards the water bill.

Allow Apply Penalty from A/R Inquiry

  • Select this option to display and enable the Apply Penalty button on the Detail tab of the A/R Inquiry function. With this button, the Govern user can apply penalties on selected accounts directly from the A/R Inquiry function and Cash Collection – to validate

Activate G/L Validation

  • Select Activate G/L Validation if you are using Govern’s General Ledger interface, in order to ensure that valid G/L account types are entered for the A/R class, according to the transaction type selected. When this option is selected, only valid G/L account type fields are enabled on the G/L Distribution Parameters form. New G/L accounts are saved to the AR_PARM_GL_ACCNT table. If you are upgrading to Govern for Windows from an earlier version, the accounts saved to AR_PARM_GL_DISTR are transferred to this table. If you are not connected to a G/L interface database, the Account Type dropdown lists, on the G/L Distribution Parameters form, are populated from the AR_PARM_GL_ACCNT table. – to validate

Bypass Funds Reapplication

  • When the Bypass LM/MB/ST/SA funds reapplication option is selected, unless an invoice number is specified, any payments will be recorded as an Open Credit transaction (OCT). Unless an invoice is referenced, the OCH amount cannot be applied to any invoices in the system. The system will now apply the OCH to a non-referenced invoice when the Bypass LM/MB/ST/SA funds reapplication option is selected. New in 10.8

ACH (PAP) Supported via Payment Plan

  • See ACH Management for more information
  • Select this option to add ACH Preauthorized Payment Support as an option for Payment Plans.

Deposit Number Setup

See A/R Deposit Parameters for the setup information and A/R Deposit Types
Activate Deposit Management

  • Deprecated? in OpenForms 6.0. Deposit is MANDATORY.

Separate Deposit for Credit Card

  • Select to record the credit card payments in a separate deposit number

Auto-Assign Deposit Number

  • See A/R Deposit Parameters for all options

Prevent Override of the Deposit Number

  • Deprecated?

ACH City and Bank Parameters

See A/R ACH Management for more information.
Destination Bank Name

  • Enter the name of the bank that manages your ACH processing

Destination Routing No.

  • Enter the routing number of the bank that manages your ACH processing. This is a unique eight digit number used to identify the financial institution.

Origin Bank Name

  • Enter the name of your regular bank

Origin Routing No.

  • Enter the routing number of this bank

Company ID (City ID)

  • Enter the identification number for the city or company making the deposit, in the Company ID field. Typically, this is the same as the Federal Tax ID.

Bank Account

  • Enter the account number of the bank entered in the Origin Bank Name field. This is a unique eight to seventeen digit number.

File Descriptor

  • A file descriptor field is available in the ACH City and Bank Parameters group in the Accounts Receivable General Parameters form. This is used for specifying a custom ACH string to insert into the header of an ACH file.
  • The File Descriptor string is different for each bank and so should be verified before it is entered. The string that is entered will appear as the first line the ACH file that is generated.

General Sub-systems

The following parameters are common to several subsystems
Link A/R to Names

  • If this option is deselected the A/R is linked by property; if selected the A/R is linked by name. If the A/R is linked by property, the user can perform a search by property or account number when accepting payments or performing an account inquiry. If the A/R is linked by name, the user can also search by name. For some subsystems, this option is disabled and either selected, if the A/R is always linked by name for the subsystem, such as the Motor Vehicle Excise Tax subsystem or deselected, if the subsystem is always linked by property, such as the Special Assessment subsystem.

A/R Master by Fiscal Year

  • If this option is selected, A/R records for the account are saved by fiscal year. For some subsystems, this option is disabled and either selected, if the A/R records for the subsystem are always saved by fiscal year, such as the Tax & Assessment subsystems or deselected, if the A/R records for the subsystem are not saved by fiscal year, such as the Utility Billing subsystem.

Real Property Tax Parameters

Link A/R to Names

  • Select this option to link the A/R to the Primary Name in the Real Property Mailing Index.

A/R Master by Fiscal Year

  • This option is always selected for the Real Property Tax module. A/R records for this module are saved by fiscal year.

A/R Master by Cycle Code

  • Select this option to use A/R Cycle Codes with the Real Property Tax subsystem; such as, county, district and school (Table: VT_USR_ARCYCLE). – Deprecated in 6.0, Cycle Code is mandatory

Over, Short, and Duplicate Method

  • If this option is selected, duplicate and overpayments are handled as follows: The real property tax is paid, leaving a zero balance. A credit is generated for the difference.

Penalty / Int. Breakdown (Batch)

  • See Linking an A/R Class to Penalty and Interest A/R Classes on page 19. – to be validate

Minimum Collection % or $

  • Enter the percentage or amount acceptable for minimum collection. Overrides the amount or percentage entered in the General Section

Collection Year

  • Enter the last year for which you are collecting bills. For example, if you enter 2015, payments cannot be made on bills dated 2014 and before. Typically, this option is used by municipalities that transfer bills to the county, or to another level of government, after a set time has passed.

Personal Property Tax Parameters

Link A/R to Names

  • Select this option to link the A/R to the Business or Occupant Name entered on the Personal Property Assessment Maintenance function.

A/R Master by Fiscal Year

  • This option is always selected for the Personal Property Tax module. A/R records for this module are saved by fiscal year.

A/R Master by Cycle Code

  • You are able to set up the Personal Property Tax subsystem by Cycles, similar to the Real Property Taxation such as, county, district and school (Table: VT_USR_ARCYCLE). – Deprecated in 6.0, Cycle Code is mandatory

Penalty / Int. Breakdown (Batch)

  • See Linking an A/R Class to Penalty and Interest A/R Classes.

Allow Payments < Late Charges Due

  • Select this to allow the collection of payments that are less than the late charges due. When this option is selected, the Minimum Collection % or Amount fields are disabled.

Minimum Collection % or $

  • Enter the percentage or amount acceptable for minimum collection, if applicable.

Other Tax Parameters

For the following subsystems, the Link A/R to Names and A/R Master by Fiscal Year options are disabled and selected.
A/R records for these subsystems are always defined by name and saved by fiscal year.

  • Motor Vehicle Excise Tax
  • Boat Excise Tax
  • Aircraft Excise Tax

Allow Payments < Late Charges Due

  • Select this to allow the collection of payments that are less than the late charges due. When this option is selected, the Minimum Collection % or Amount fields are disabled.

Minimum Collection % or $

  • Enter the percentage or amount acceptable for minimum collection, if applicable.

Utility Billing Parameters

Link A/R to Names

  • Select this option to link the A/R for the Utility Billing subsystem to the Primary Name in the Utility Billing Mailing Index. Otherwise, the A/R is linked by property for this subsystem.

A/R Master by Fiscal Year

  • This option is disabled and deselected. Utility Billing records are not saved by year.

Linking an A/R Class to Penalty and Interest A/R Classes

  • There are three ways in which penalty and interest charges can be handled.
    • Select the Penalty / Interest Breakdown (Batch) to use the Penalty.
      • When this option is selected, the same A/R Class Code is used for the transaction, the penalty, and the interest. However, they are entered with interest (int) and/or penalty (pen) transaction types. For details, see A/R Class CodeProcess MAP on page 415.
      • When a transaction is made, it is automatically divided between the class codes. The penalties and interest are calculated according to the A/R Method selected. You do not need to create separate A/R Class Codes for this transaction type.
    • Deselect the Penalty and Interest Breakdown Batch option to send penalty and interest amounts to separate A/R Class Codes.
      • When this option is deselected, the Link to Interest A/R Class and Link to Penalty A/R Class fields are enabled on the A/R Class Parameters form, under the following conditions:
    • A/R Class Codes for Penalty or Interest Transaction Types exist for the sub-system and an A/R Method is selected for the A/R Class Code.
      • You can link an A/R Class Code for penalty and a code for interest to the selected A/R Class Code. Then, when a payment is received the penalty and interest amounts are automatically sent to the linked A/R Class Codes. If an interest or penalty A/R Class Code is not specified, the first class code found for penalty or interest is used.

No Penalty on Penalty

  • Select this option to prevent charging a penalty on top of an existing penalty. This option is enabled only if the Penalty / Interest Breakdown option is selected. Refer to the Utility Billing guide for more information.
    • For example, the customer owes $50.00 for water billing and $50.00 for sewer billing. The penalty is 1% per month; normally, $1.00 is charged through the Penalty Type class code. However, using the Penalty / Interest Breakdown option, $.50 is charged through a water class code and $.50 through a sewer class code.

Miscellaneous Billing Parameters

For the Miscellaneous Billing.
Link A/R to Names

  • This option is disabled and always selected for the Miscellaneous Billing subsystem. Although you can link a property to a Miscellaneous Billing record, accounts are initially set up by name.

A/R Master by Fiscal Year

  • Select this option to save the miscellaneous billing records by fiscal year.

Web Default Class

  • Select a default AR Class for miscellaneous billing payments made over the Web. A miscellaneous billing is created for subscriptions to the eProfile that are paid over the Web. Refer to the eProfile guide for complete details. Refer to the Miscellaneous Billing guide for more information.

Tax Title Parameters

To be reviewed. Tax Title now part of the Delinquency Module
For the Real Property, Personal Property, and Land Management Tax Title.
Link A/R to Names

  • The Link A/R to Names option for each tax title subsystem is defined by the Link A/R to Names setting for the corresponding subsystem.
    • For example, if Link A/R to Names is selected for the Real Property subsystem, it is automatically selected for the Tax Title (Real Property) subsystem.
  • If these options are selected, the A/R is linked to the following names:
    • Real Property Tax Title: links the A/R to the Primary Index in the Real Property Mailing Index
    • Personal Property Tax Title: links the A/R to the Business or Occupant Name entered on the Personal Property Assessment Maintenance function
    • Land Management Tax Title: links the A/R to the default Link Name Type entered on the Land Management Parameters form.

A/R Master by Fiscal Year

  • This option is always selected for the Tax Title subsystems. A/R records are saved by fiscal year for tax title.

Minimum Collection % or $

  • Enter the percentage or amount acceptable for minimum collection for the tax title subsystems, if applicable. See General section for more information.

Other Parameters

For the Special Assessment, Land Management, Deed, Self-Reported Tax, and Bankruptcy.

Special Assessment Subsystem

The Link A/R to Names and A/R Master by Fiscal Year options are not applicable to the Special Assessment subsystem.
A/R Class Principal

  • Select the default A/R class for the principal from the drop-down list.

A/R Class Interest

  • Select the default A/R class for the interest from the drop-down list.

Land Management Subsystem

Link A/R to Names

  • By default, Accounts Receivable records are created by property for the Land Management subsystem. Select this option to create records by name. Records are defined, according to the type of name, selected on the Default Link Name parameter defined on the Land Management Parameters form, such as, the applicant for a permit record. Refer to the Permit & Inspections guide for details.

A/R Master by Fiscal Year

  • Select this option to save Land Management A/R records by fiscal year. Refer to the Permits guide for more information.

Switch to Voluntary Payment when Payment without A/R

  • In Govern for Windows, users of the Payment Data Entry function may need to make a payment to a Name or Property account that has no open A/R account. In such instances, the Transaction Type must be entered as a Voluntary Payment. If a payment is attempted and the Transaction Type is set to Payment, an error message is generated. When the Switch to Voluntary Payment when Payment without A/R option is selected, any transactions without a valid A/R Account will be automatically changed to a Voluntary Payment transaction type.

Land Management 2 Subsystem

  • When you create A/R Class Codes, you can select Land Management 2 from the Sub-System drop-down list. This is provided as second classification. You can configure separate security for this sub-system. For all other settings, the Land Management options are applicable to both

Deed Information Subsystem

Link A/R to Names

  • By default, Accounts Receivable records are created by property for the Deed Information subsystem. Select this option to create records by name.

A/R Master by Fiscal Year

  • Select this option to save Deed Information AR records by fiscal year. Refer to the Property Control and Mass Appraisal Sales and Comparable Sales guides for more information.

 

Self-Reported Tax Subsystem

Link A/R to Names

  • All Self-Reported Tax records are created by name. This option is disabled for this subsystem.

A/R Master by Fiscal Year

  • Select this option to save the AR records for the Self-Reported Tax subsystem, by fiscal year. Refer to the Self -Reported Tax guide for more information.

A/R Method

Due Nb. of Days

Use when the Apply Due Nb of Days is checked. for compound interest

Apply Due Nb of Days (Compound Interest)

A setup has been added for the standard interest method when using compound interest. In Govern Admin, a new check box called Apply nb. of days due for compound interest has been added that will apply for all standard interest methods.
You can now specify the date to start charging compound interest. New in 10.8 NOTE: The A/R Method forms are used for setting the calculation method for applying penalty and interest charges for the selected A/R Class. Penalty and Interest calculations are based on the effective date and due date of the bill. They can be applied as a one-time charge, or on a daily or weekly basis. Multiple A/R Methods are available. You can define percentages, length of discount period for calculating the interest and penalty.

 

103-ar-parm-General-spec

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR – Refund Reversal Form

Accounts Receivable (A/R) Refund Reversal

Overview

The section describes the Refund Reversal transaction process. This is available for posted refunds only. It can be run if a payment reversal was created in error.

The Refund Reversal form is accessed from a Posted Refund in the Govern A/R Inquiry form. Therefore, before a refund reversal can be created, the following processes must take place:

  • An invoice must be created for the A/R record.
  • The invoice must be Billed and posted.
  • The bill must be paid and the payment must be posted.
  • The payment must be refunded and the refund must be posted.

NOTE: Security options are pending development.

Documentation

101-ar-frm-028 Refund Reversal

Accessing the Refund Reversal Form

Read More...

To access the Refund Reversal form:

  1. Launch Govern.
  2. Open a Profile that includes the A/R Inquiry.
  3. Select the A/R Inquiry form.
  4. Perform a search and select the required name or property record.
  5. Select the required record in the Summary section.
    Details of the record are displayed in the Details section.
  6. Right click on the required Refund in the Details section.
    A context-sensitive menu appears.
  7. Select Refund Reversal.
    The Refund Reversal form appears.
    The following fields are populated with data from the selected refund.

General Information

  • Subsystem
  • Year
  • Bill Number
  • Cycle Code

Detail

  • Date
  • Effective On
  • Amount
  • Interest
  • Total to Refund
  • Class Code: This field can be modified

The following fields can be modified:

  • Invoice No.
  • Check No.
  • Justification Code
  • Deposit Number
  • Notes
  • Payer Information

General Information

Receipt Number

The Receipt Number is automatically generated according to the setup in the Cash Collection Parameters. It comprises a three-digit code that is based on either the Receipt Group or the user ID of the logged-in user. The code is followed by the receipt sequence. This is an eight-digit number that starts with one for each user or receipt group. The number increases by one for each new receipt.

Subsystem
The subsystem for the record or entry selected on the A/R Inquiry form is displayed.

Year
This field displays the fiscal year of the transaction.

Bill Number
This field displays the bill number for the selected record.

Invoice No.
Enter an invoice number for the transaction.

Check No.
Enter a check number in this field, if applicable.

The Check Number is displayed with the record in the A/R Inquiry form under Balance Forward Details.

If the check number is created by the Refunds form in Govern, it is displayed when the transaction is saved.

Cycle Code
This field displays the Cycle Code associated with the record (Table: VT_USR_ ARCYCLE).

It is now mandatory to create A/R Cycle Codes for Real Property and Personal Property tax billing. This is used for tax billing cycles and is linked to the A/R Class Code in GNA. You need to set up at least one Cycle Code, but you can create multiple codes. For example, you could have one cycle for municipal tax and a second for school tax.

Frozen IDs are now created for cycle billing. A new Frozen ID is assigned when you run the Posting to A/R batch process. This is called a Certified Record. It is displayed in the Govern History Panel with the Cycle Code. The first Certified Record is assigned Frozen ID -1, the second -2, the third is assigned -3, and so on if there are multiple cycle codes.

A new Tax Audit record is created for all the parcels included in the batch process. The Entry Code for these records is set to Original. The Frozen ID is updated and a new entry is listed in the History Panel. For further details, refer to the Govern Real Property Tax documentation.

Date
This field displays the entry date for the refund. By default, this is the current date. To change the date, click the calendar beside this field and select a new date.

Effective On
This field displays the date that the transaction becomes effective. To enter a date, click the calendar beside the field and select a new date.

Amount
This field displays the amount of the refund. It cannot be modified.

Interest
This field displays interest accumulated on the amount. It cannot be modified.

Total to Refund
this field displays the total amount to refund. It cannot be modified.

Class Code
This field is automatically populated with the A/R Class Code for the selected refund. The drop-down list contains all the A/R Class Codes that are defined with the Refund Transaction Type or with no specific transaction type. Select a different A/R Class Code from the drop-down list (Table: VT_ USR_AR_CLASS).

From Installment Number
Select the installment period for the refund: first, second, third, fourth installment or total (Table: VT_SY_ INSTALL).

Due Date
Click the calendar icon beside the Due Date field and select the date the refund is due, if applicable.

Discount Date
Click the calendar icon beside the Discount Date field and select the final date for a discount on the refund.

Comment

Justification Code
Select a Justification Code to explain the reason for the refund (Table: VT_USR_ARREASON).

Deposit Number
Depending on the options selected in GNA, deposit numbers can be automatically generated or user-defined.

Automatically generated deposit numbers are composed of one or two of the following fields: date, last deposit, and user ID. This number can be modified if you have the required security permissions.

If Deposit Management is activated, a drop-down list is added to the Deposit Information parameter. This is populated by the deposit numbers created in the Deposit Management form. See Deposit Management on page 203.

Do one of the following:

  • Enter a new deposit number required.
  • Select a deposit number from the drop-down list.

Notes
Enter any notes or comments applicable to the refund.

Payer Information

By default, the Payer information fields display the name of the taxpayer and a code that identifies the type of letter to be issued with the bill.

To modify the payer information:

  1. Click C beside the Payer information field to change the name. This displays the Search screen with the following options:
    By Name ID
    By Tax Payer Account Number
    By Name
    By Phone Number
    From NA_External
  2. Enter the required information on the search screen. Then select the applicable record.
  3. Select a code from the Letter Code field to identify the type of letter the payer receives, such as, duplicate payment, over payment or payment reversal (Table: VT_USR_LETER_C).
  4. Click Save.

 

A/R Inquiry for Refund

The record is displayed on the A/R Inquiry form when the transaction is complete.

The Amount and Payer Name fields under Cash Flow display further details when you hover the mouse over a specific transaction:

 

Related Topics

Accounts Receivable (A/R) Inquiry

Accounts Receivable (AR) – What’s New

 

 

101-ar-frm-028

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR – Lockbox Form

Accounts Receivable (AR) – Lockbox Form

Overview

The Govern OpenForms Lockbox is used to facilitate the data entry of multiple payments:

  • Payments can be processed from a Lockbox file received from a Lockbox service or bank.
  • Entered manually.
  • Scanned and processed from an image file.

Documentation

To view this information as a pdf, click on the following link:
ARLockbox.pdf

For information on processing A/R Lockbox files, see A/R Lockbox Batch Processes

For information about configuring the A/R Lockbox, see Setting Up the A/R Lockbox

The A/R Lockbox is useful because payments received through a government office are cyclical. It

  • Speeds up data entry time.
  • Speeds up time to deposit payments in the organization’s account.
  • Reduces data entry stress during heavy payment periods.

The Govern OpenForms A/R Lockbox solution includes:

  • The A/R Lockbox User Form

Integrates Deposit Management A/R Lockbox Header and A/R Lockbox Details information

  • The A/R Lockbox Batch Process

Provides options for Validating a File, Loading a File, Processing Payments Directly from a File, Processing Payments from a Preloaded File.

 

Read More...

Accessing the A/R Lockbox

To access the A/R Lockbox:

  1. Launch Govern.
  2. Open a Profile that contains the A/R Lockbox form.
  3. Open the A/R Lockbox form.

Adding Lockbox Data Records

The Govern A/R Lockbox can be used for the following:

  • Creating new lockbox records.
  • Loading existing lockbox records.

Creating a New Lockbox Record

To create a new lockbox record:

  1. Launch Govern.
  2. Open a Profile that contains the A/R Lockbox form.
  3. Open the A/R Lockbox form.
  4. Select the Deposit Management tab.
  5. Do one of the following:
  • Click New to create a new deposit number.
  • Select an existing deposit number on the left.

Creating a New Deposit Number for Lockbox Entries

Deposit Management is mandatory for all A/R systems in Govern OpenForms.This includes the Lockbox. The transactions and entries for this application are managed and accessed through Deposit Numbers. These deposit numbers can be created automatically or manually.
If they are created manually, the user can enter a number in the Depsoit Number field or override the number that is automatically generated.
To create a new Deposit Number:

  1. Open the Lockbox form in Govern and select the Deposit Management tab.
  2. Do one of the following:
  3. If your setup includes manual creation of Deposit Numbers, you can override the number that is automatically created and displayed in the Deposit Number field.
    Enter a new deposit number in this field.
  4. If your setup includes automatic creation of Deposit Numbers, a deposit number is automatically created based on the configuration in Accounts Receivable General Parameters form in GNA.
    Enter text to identify the deposit in the Description text box.
    The user name and creation date are automatically entered.
  5. The transaction type is always Payments.
  6. Click Save.

The Summary information is entered through the batch process. This is describe in the following section.

Entering New Lockbox Detail Information

The Lockbox Detail information is associated with a barcode. The first step is to provide the barcode for this form. This can be entered manually or through a search.
To create a new Lockbox Detail record:

  1. Click New.
  2. Select By Barcode (A/R) in the Search window.
  3. Enter a barcode in the Barcode (A/R) field.
  4. Click the ellipsis button beside the Payer Name field and select click one of the following:
    Search to search the database for an existing name or payer account.
    New Name to create a new Name Account for the current record. This is created when you click Save.
    New Payer Name to create a new payer account. This must be created after you click Save.
  5. Enter the amount of the transaction in the Amount field.
  6. Enter a date in the Effective Date field. This is the date that the transaction becomes effective.Tip: To enter the current date, position your cursor in the field and click [Ctrl+T] on your keyboard.
  7. Overwrite the date in the Entry Date field if required. By default, this field displays the current date.
  8. Make a selection from the Payment Type drop-down list. Payment Types are saved in the VTSYSTEM Table: CCTYPE.
  9. Select the Installment; such as, first, second, third, fourth installment or total (Table: VTSYSTEM_INSTALL).

The following are selected as applicable under Transaction Status when the batch process is complete.

  • Load: The transaction is loaded to the database and saved to the tables AR_Lockbox_Detail and AR_Lockbox_Header.
  • Modified: The transaction was modified on the Lockbox user form after it was loaded to the Govern Accounts Receivable A/R tables.Note: Once the batch process is run on the file or on the database tables, the transactions cannot be modified or deleted.
  • Processed: The batch process was run on the transaction and it was saved to Govern Accounts Receivable A/R.
  • Process Preload file(s): Apply payment from Lockbox tables loaded previously in Lockbox table with the selected Batch number not processed from the combo

 

Cash Collection Payment Types (VTSYSTEM_CCTYPE)

The Cash Collection Payment Type options include the following:

American Express, Cash, Credit or Debit Card, Certified check Change, Check, Discover Card, Electronic Fund Transfer,
Master Card, Money Order, Other 1, 2, 3, 4, 5; Payment in Lieu of taxes, Visa, Web ACH, Web Credit Card, Web Debit Card, Web eCheck, Web HPG, Web iCart

 

 

101-ar-frm-036

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR – Installation

Accounts Receivable Installation

Overview

The Govern OpenForms applications required for Accounts Receivable are installed through Govern Deploy EZ, See Deploy EZ.

 

 

101-ar-install

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...

AR OpenForms Reference

Accounts Receivable (A/R) OpenForms Reference

Overview

This information will be posted as it becomes available.

 

101-ar-ofr

 

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this.
Loading...