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...

AR – Posting Error Codes

Accounts Receivable (A/R) Posting Error Codes

Error Code Description
1 Invalid AR ID Property
2 Save without Append (No A/R Detail found)
3 Invalid A/R Class Code Property
4 Invalid Subsystem code in A/R Parameters
5 Missing Required PID Property
6 Missing Required NAID Property
7 Missing Required Cycle Code
8 Missing Required Key ID Or Key Type
9 Missing Required UBID
10 Move Next After EOF
11 Invalid Transaction Type
12 Detail Object Contains Existing Transactions
13 Missing Required CCID Property
14 Missing Required A/R ID Property
15 Missing Subsystem Property
16 Missing Installment
22 Class Code and Transaction Type Incompatible
25 Invalid Fiscal Year
26 Invalid Amount
27 Can’t get a system key index
28 Invalid G/L Distribution Amount
29 Transaction Already Posted
30 Cannot delete because the subsequent transaction is not posted
32 Invalid or Missing PP_ID
33 Invalid or Missing MV_ID
34 Invalid or Missing BT_ID
35 This A/R record is inactive and unavailable
36 No Right of Access

 

 

101-ar-ref-ErrorPostingCodes

 

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 – GL – Accounting Business Rules

Accounts Receivable (A/R) General Ledger (G/L) Accounting Business Rules

Overview

When an AR transaction is posted (confirmed), G/L entries are created for accounting and audit purposes.
For each transaction, a debit and a credit is created.
For each posting, Total Debit = Total Credit

The debit and credit entries generated depend on the nature of the transaction, and on the:

  • Application Module setup
  • AR General Parameter setup
  • AR Class Code Parameter setup and use (specific or default)
  • AR transaction type being processed

G/L Accounting Business Rules Process Schema

The following shows the different processes (basic, interest/penalty breakdown, specific A/R Class and penalty). Click on the thumbnails to enlarge or click here for a printable version.

 

Basic Process
Interest and Penalty Breakdown
Specified Interest & Penalty A/R Class

G/L Accounting Business Rules by AR Transaction Type

 

This table lists the valid G/L Accounts for each transaction type. Click here for a PDF copy.

Transaction Type G/L Accounting
Abatement Accounts Receivable, Revenue, Deferred Revenue
Adjustment Cash, Accounts Receivable, Revenue, Deferred Revenue
Adjusted Bill Cash, Accounts Receivable, Revenue, Deferred Revenue
Charge Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Discount Accounts Receivable, Revenue, Deferred Revenue, Discount
Deposit N / A *
Demand Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Duplicate Payment Cash, Accounts Receivable, Revenue, Deferred Revenue
Fee Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Interest Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Billed / Invoice Cash, Accounts Receivable, Revenue, Deferred Revenue
Miscellaneous Cash Receipt Cash, Accounts Receivable, Revenue, Deferred Revenue
Open Cash Credit Cash, Accounts Receivable
Open Credit Accounts Receivable, Revenue, Deferred Revenue
Over Payment Cash, Accounts Receivable, Revenue, Deferred Revenue
Postdated Payment N / A *
Penalty Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Payment N / A *
Payment Reversal Cash, Accounts Receivable, Revenue, Deferred Revenue
Refund Cash, Accounts Receivable, Revenue, Deferred Revenue
Over & Short Cash, Accounts Receivable, Revenue, Deferred Revenue
Tax Deferral Cash, Accoutns Receivable, Revenue, Deferred Revenue
Transfer to Tax (Interest, Penalty) Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Tax Title Lien Cash, Accounts Receivable, Revenue, Deferred Revenue
Tax Title Lien (Interest) Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Transferred Principal Cash, Accounts Receivable, Revenue, Deferred Revenue
Trans.(Interest, Penalty) Cash, Penalty: Accounts Receivable, Penalty: Revenue, Penalty: Deferred Revenue
Transfer to Tax Cash, Accounts Receivable, Revenue, Deferred Revenue
Sales Tax 1 Cash, Accounts Receivable, Revenue, Deferred Revenue
Sale Tax 2 Cash, Accounts Receivable, Revenue, Deferred Revenue
Voluntary Payment N / A *
Note(s): The Deposit, Postdated Payment, Payment and Voluntary Payment transaction types are not distributed to Govern’s G/L

 

101-ar-GLAccounting-(thumbnail).png 101-ar-TransactionType-(thumbnail).png
AR G/L Accounting Process Schema
(click to enlarge)
AR Transaction Type

 

 

101-ar-ref-GLAccountingRules

 

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 – Transaction Type Rules

A/R – Transaction Type Rules

This table lists the business rules and behavior by transaction type. Click here for the printable FULL format spreadsheet.

Trans Type +/- Sign Reversal Class Code Req’d a/i Affected Column G/L Account DEBIT G/L Account CREDIT Notes
Inv + Yes Yes a Principal A/R Def. revenue or Revenue of trans code
Yes Yes i Credited Def. revenue or Revenue of trans code A/R Trans code
Adj Mcr Td Tt Ttx + Yes Yes a Adj A/R Def. revenue or Revenue of trans code
i Credited Def. revenue or Revenue of trans code A/R of applied record
Ab + Yes Yes a Applied amount in Abated Def.Revenue or Revenue and A/R of trans code A/R of applied record and Revenue of Trans code
Yes i Subtract from Abated A/R and Revenue Def. revenue or Revenue of applied record and A/R of Trans Code Amt. must be ≤ previously entered abatement
Chg Dmd Fee Int Pen Tri, Tti, Ttp + Yes Yes a Charge Demand Fee Interest Penalty Part of Cash Transaction: Cash Otherwise: A/R Part of Cash Transaction: Revenue of trans code. Otherwise: Def. revenue or Revenue of trans code
i Credited_ I Def. revenue or Revenue of trans code A/R of applied record Amt. must be the balance due for the Trans Code Class and Category
The Amt in Paid_I is moved to Credited_I and Paid_I is applied following the rules for a cash transaction.
Pmt Vp + Yes i Paid Cash or Deferred revenue A/R or Revenue of applied record Amount must be zero or positive.
N/A
Pdt + Yes i None None None On the postdated date, a negative pdt and a pmt are created.
i None None None
Dct + Yes i Discount Discount or Deferred revenue A/R or Revenue of applied record Amt. must be ≤ the Principal Balance Due
i Subtract from Discount A/R or Revenue of applied record Discount or Deferred revenue Must be ≤ the total discounted for the specified class.
Dep + Yes Yes a Deposit Cash Revenue of trans code
Yes i None Def. revenue or Revenue of trans code A/R or Revenue of applied record Must equal previously entered deposit
Dup Ovr + Yes Yes a Adj A/R Def. revenue or Revenue of trans code Trans code is system generated
i Credited Def. revenue or Revenue of trans code A/R of applied record Trans code is system generated
Ocr + No a Credited none none Trans code is system generated
Och + No a Paid Cash A/R of Trans code Trans code is system generated
Rev + Negative CC Trans i Subtract from Paid A/R or Revenue of applied record Cash or Deferred Revenue
i Paid Cash or Def revenue A/R or Revenue of applied record Can reverse a rev trans only.
Negative CC Trans Yes i Subtract from Refund Cash A/R of Trans code
Sht + Yes i Credited Def. revenue or Revenue of trans code A/R of applied record Trans code is system generated
a Adj A/R Def. Revenue or Revenue of Trans code Trans code is system generated
Tx1 Tx2 + Yes a Tax1 or Tax2 A/R Def. revenue or Revenue of trans code
Yes i Subtract from Tax1 or Tax2 Def. revenue or Revenue of trans code A/R of Trans code Amt. must be ≤ the previously charged taxes.
Ajb + Yes Yes a Adjusted_Bill_D A/R Def. revenue or Revenue of trans code Trans code is system generated
Yes i Adjusted_Bill_C Def. revenue or Revenue of trans code A/R of applied record Trans code is system generated
lcr + Yes Yes a Applied Amount in Credited Def. revenue or Revenue of trans code A/R of applied record and Revenue of trans code Trans code is system generated
Yes i Subtract from Credited A/R and Revenue Def revenue or Revenue of applied record and A/R of Trans code Trans code is system generated

 

Transaction Type with Optional A/R Class Code Rules

The following rules apply to all transaction types with an optional A/R Class Code:

  • If an A/R Class Code is entered, only the record for that specific class is credited or updated.
  • If the A/R Class Code parameter is left blank, the records for all A/R Class Codes are updated.
  • If the A/R Class Code parameter is left blank, the entered amount must be less than or equal to the balance due for the transaction code and category.

 

101-ar-ref-TransactionRules

 

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...