Accounts Receivable (A/R) – Cash Balancing Report
Overview
The report code for the Cash Balancing report is: ar-rpt-004.rpt
Click to enlarge.
101-ar-rpt-004-CashBalancingReport
The report code for the Cash Balancing report is: ar-rpt-004.rpt
Click to enlarge.
101-ar-rpt-004-CashBalancingReport
Payment reversal transactions (rev) are adjustments that are used as corrections. They are run typically when NSF checks have been processed or records posted incorrectly
Run the Payment Reversal batch process in order to void a group of payment transactions. This is useful if there are payments that were made in error or that were paid from accounts with insufficient funds (NSF).
For the complete reference guide, see Govern Accounts Receivable.
For the A/R Transaction Rules, see A/R Transaction Rules.
Read More... Payment reversal transactions (rev) are used as corrections. They are run typically when NSF checks have been processed or records posted incorrectly. Payment Reversal transactions can be created individually or in a batch. Both methods create Payment Reversal Transactions, which can be viewed or deleted from the A/R Inquiry form. After generating Payment Reversal transactions, whether individually or in a batch, you need to post them. To post a payment reversal, run the Payment Reversal Posting batch process. See Posting Payment Reversal Transactions. See All posted payment transactions can be reversed, with the following exceptions. The following payment transactions cannot be reversed: For details on transaction types, see Transaction Types To access the Payment Reversal form: The Payment Reversal form is divided into the following sections: Subsystem: The subsystem for the record or entry selected on the A/R Inquiry form is displayed. Date: This field displays the entry date for the payment reversal. By default, this is the current date. To change the date, click the calendar beside this field and select a new date. Justification Code: Select a Justification Code to explain the reason for the payment reversal (Table: VT_USR_ARREASON). Letter Code: Select a Letter Code that identifies the type of letter sent to the payer; for example, D: Duplicate Payment, O: Over Payment, RV: Payment Reversal (Table: VT_USR_LETER_C). 101-ar-frm-026 Payment Reversal Transaction Type
Creating Payment Reversal Transactions
It is faster to generate these transactions in a batch, especially if you have a large volume to process. However, if it is important to note the warnings that are described under the section. Running the Generate Payment Reversal Batch Process.
See Creating a Single Payment Reversal Transaction following this section.
See Generate Payment Reversal Batch Process: 101-ar-bp-041Posting Payment Reversals
Payment Reversal Posting: 101-ar-bp-026 Business Rules for Payment Reversals
Creating a Single Payment Reversal Transaction
Accessing the Payment Reversal Form
General Information
Year: This field displays the fiscal year of the record.
Bill Number: This field displays the bill number for the selected record.
Cycle Code: This field displays the Cycle Code associated with the record (Table: VT_USR_ ARCYCLE).
The Cycle Code is mandatory for the Real Property and Person Property Tax modules. It is used for tax billing cycles and is linked to the A/R Class Code in GNA.Detail
Effective On: By default this field is blank. If an effective date is applicable, click the calendar beside the field and select a new date. For example, you may want to enter the posting date.
Amount: This field displays the amount of the reversal.
Full Payment Reversal: A full payment reversal can be used when there are multiple records associated with a single name. For example, Bob’s Building Supplies owns three properties. Bob has made an overpayment of $10,000.00 on each property for a total of $30,000.00. You can create a full payment reversal to include all properties in the same payment reversal.
Select the Full Payment Reversal option. This displays the total for all property records.Comment
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 security permissions allow.
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.
Do one of the following:
NOTES: Enter any notes or comments applicable to the payment reversal.
Payer Information
Payer’s Name and Address: This field is displays the payer’s name and address.
Click R to remove the displayed name and address record.
Click C to add a different name and address record. This opens the Name Search screen.
Payment transfers are used to transfer posted payments from one account to another. Typically, they are used to correct an error such as a payment made and posted to the wrong account. For example, a client could make a payment intended for a utility bill that is somehow processed on a tax bill. To correct this error, you can create a Payment Transfer.
NOTE: Payment Transfers can be created on posted payments only. |
If you transfer the full amount of the original payment, all the associated discounts and interest are transferred. However, if you transfer only part of the original payment, no discounts or interest are transferred.
When you create a Payment Transfer:
The Payment Transfer (trp) and Payment (pmt) transaction types are the same, as are the Payment Transfer Reversal (rev) and Reversal (rev) types. Separate transaction types can be useful for reviews and reports.
The transaction types are created automatically when the Payment Transfer record is saved. Whether the Payment Transfer (trp) and Payment Transfer Reversal (trr) or Payment (pmt) and Reversal (rev) transaction types are created depends on the setup in GNA.
Read More... For the complete reference guide, see Govern Accounts Receivable. To see the information on this page as a pdf, click on the following link: The Payment Transfer (trp) or Payment (pmt) can be viewed in the Detail section of the A/R Inquiry form when you select the account to which the payment is transferred. In the example, this is the utility account. In the Link To column, you can click on a direct link to the Payment Transfer Reversal (trr) or Reversal (rev) in account from which the original payment was transferred, the tax account in the example. Similarly, the Payment Transfer Reversal (trr) or Reversal (rev) can be viewed in the A/R Inquiry Detail section when you select the tax account. In the Link To column, you can click on a direct link to the Payment Transfer (trp) or Payment (pmt) in the account to which it was transferred. To access the Payment Transfer form: The Payment Transfer form is described in the following sections: The Original Payment Information provides general information about the original payment and includes the following fields: The Transfer Amount section displays details about the transferred payment. To modify the amount of the payment that you are transferring: The amount displayed beside Remaining Balance is automatically updated. Select one of the following options for the destination account; i.e., the account to which you want to transfer the payment: Depending on the options selected in the 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. Do one of the following: Select a Justification Code to explain the reason for the transfer (Table: VT_USR_ARREASON). When this option is not selected, which is the default, both the principal and interest are transferred. Select this option if you are transferring the payment to another system that is external to Govern. With this option, only the Payment Transfer Reversal (trr) or Reversal (rev) transaction is created. The Payment Transfer (trp) or Payment (pmt) transaction is not created. Select this option to transfer the payment to a different account, or barcode, associated with the selected name or tax map number. You can transfer a payment to any account in the Govern A/R system that has a balance. If you are using either the Different Account for Same Name / Tax Map Number or the Selected Accounts option, you can remove any of the listed accounts that you are not using, from the Payment Transfer form. To delete a selected account: If you are transferring the original payment to one or more selected accounts, you can modify the amount transferred to each account. This section describes two scenarios where a payment transfer would not be completed. A Payment Transfer would not be completed if the remaining balance is less than or greater than the amount transferred. The transfer is completed only if the remaining balance is equal to zero, calculated as (Transfer Amount) – (Transfers for all accounts) = 0. Similarly, if the amount transferred to all the selected accounts is less than the amount of the original payment, an error message is displayed.
For the A/R Transaction Rules, see A/R Transaction Rules.
PaymentTransfer.pdfPayment Transfer (trp)
Payment Transfer Reversal (trr)
Accessing the Payment Transfer Form
A context menu is displayed.
Original Payment Information
Subsystem: The subsystem for the record or entry selected on the A/R Inquiry form is displayed. This is the original payment record that will be transferred during this procedure.
Name / Tax Map: This field displays the name or tax map number associated with the account to which the original payment was posted.
Bar Code: This field displays the bar code or A/R ID associated with the original payment.
Year: This field displays the fiscal year of the original payment record.
Cashier ID: This field displays the ID of the cashier who processed the original payment.
Deposit Number: This field displays the deposit number of the original payment.
Amount: This field displays the amount of the original payment.
Entry Date: This field displays the date the original payment was entered.Transfer Amount
Entry Date: This field displays the entry date for the payment transfer, not the original payment. 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 payment transfer is effective. By default this is the effective date of the original payment. To change the default date, click the calendar beside the field and select a new date. For example, you may want to enter the posting date.
Amount: By default, this field displays the full amount of the payment that you are transferring, the original payment. You can modify the amount if you want to transfer only part of the original payment.
Note: If you transfer the full amount of the payment, all discounts and interest are transferred.
If you transfer only part of the original payment, no discounts or interest are transferred.
Transfer Destination
Transfer Options
Deposit Number
Justification Code
Just transfer credit amount
When this option is selected, only the principal is transferred. This option is useful if the penalty and interest are calculated separately. There was a client that had that need.
This applies to full payments, only. For partial payments, the interest is not transferred, only the principal.Out of System
To transfer the payment outside the Govern system:
Different Account for Selected Name or Tax Map Number
To transfer the payment to a different account associated with the same name or property:
All the accounts for the selected name or property are loaded to the form.
Account details include the balance; interest; other amounts, such as discounts and penalties; and the amount to be transferred. These are displayed under the Balance, Interest, Other Charges, and Transfer columns.
By default, the amount displayed in the Transfer Amount text box is used to pay each account that is listed.
The amount that is transferred to a selected account is displayed in the Transfer column. This is subtracted from the total Transfer Amount and the result is displayed in the Remaining Balance text box.(Remaining Balance) = (Total Transfer Amount) – (Transfer per Account)
By default, all accounts, with a balance, that are listed for the selected name or tax map number are displayed.
If multiple accounts are listed, the Transfer Amount is used to pay the amount owing on each one. The final amount is displayed in the Remaining Balance text box.Selected Accounts
To transfer the payment to another account:
The A/R Inquiry Search screen opens.
All selected accounts are displayed in the grid.
The account details include the balance; interest; other amounts, such as discounts and penalties; and the amount to be transferred. These are displayed under the columns: Balance, Interest, Other Charges, and Transfer.
By default, the amount displayed in the Transfer Amount text box is used to pay each account that is listed.
The amount that is transferred to a selected account is displayed in the Transfer column. This is subtracted from the total Transfer Amount and the result is displayed in the Remaining Balance text box.(Remaining Balance) = (Total Transfer Amount) – (Transfer per Account) If multiple accounts are listed, the Transfer Amount is used to pay the amount owing on each one.
The final amount is displayed in the Remaining Balance text box.Removing a Displayed Account
Modifying the Amount Transferred to a Selected Amount
To modify the amount in the Transfer column for an account:
Payment Transfer Troubleshooting
Remaining Balance is Less Than Zero
The transfer column displays the amount to be transferred to the selected account. This amount is subtracted from the Transfer Amount. The result is displayed in the Remaining Balance text box.
If the amount transferred to the selected accounts is greater than the original payment, the Remaining Balance is less than zero and a message is displayed.
Note: The Remaining Balance must be zero in order for the transaction to be completed.Amount Transferred Is Less Than Amount Owed
This could occur if you manually enter an amount in the Transfer text box that is less than the Transfer Amount.
NOTE: The Remaining Balance, must be zero in order for the transaction to be completed.
Accounts Receivable (A/R) Inquiry
Accounts Receivable (AR) – What’s New
101-ar-frm-027
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:
NOTE: Security options are pending development.
101-ar-frm-028 Refund Reversal
Read More... To access the Refund Reversal form: General Information Detail The following fields can be modified: 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 Year Bill Number Invoice No. Check No. 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 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 Effective On Amount Interest Total to Refund Class Code From Installment Number Due Date Discount Date Justification Code Deposit Number 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: Notes 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: 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: Accounts Receivable (A/R) Inquiry Accounts Receivable (AR) – What’s New 101-ar-frm-028
Details of the record are displayed in the Details section.
A context-sensitive menu appears.
The Refund Reversal form appears.
The following fields are populated with data from the selected refund.
General Information
Receipt Number
The subsystem for the record or entry selected on the A/R Inquiry form is displayed.
This field displays the fiscal year of the transaction.
This field displays the bill number for the selected record.
Enter an invoice number for the transaction.
Enter a check number in this field, if applicable.
This field displays the Cycle Code associated with the record (Table: VT_USR_ ARCYCLE).
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.
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.
This field displays the amount of the refund. It cannot be modified.
This field displays interest accumulated on the amount. It cannot be modified.
this field displays the total amount to refund. It cannot be modified.
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).
Select the installment period for the refund: first, second, third, fourth installment or total (Table: VT_SY_ INSTALL).
Click the calendar icon beside the Due Date field and select the date the refund is due, if applicable.
Click the calendar icon beside the Discount Date field and select the final date for a discount on the refund.Comment
Select a Justification Code to explain the reason for the refund (Table: VT_USR_ARREASON).
Depending on the options selected in GNA, deposit numbers can be automatically generated or user-defined.
Enter any notes or comments applicable to the refund.Payer Information
By Name ID
By Tax Payer Account Number
By Name
By Phone Number
From NA_ExternalA/R Inquiry for Refund
Related Topics
The Govern OpenForms Lockbox is used to facilitate the data entry of multiple payments:
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
The Govern OpenForms A/R Lockbox solution includes:
Integrates Deposit Management A/R Lockbox Header and A/R Lockbox Details information
Provides options for Validating a File, Loading a File, Processing Payments Directly from a File, Processing Payments from a Preloaded File.
Read More... To access the A/R Lockbox: The Govern A/R Lockbox can be used for the following: To create a new lockbox record: 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. The Summary information is entered through the batch process. This is describe in the following section. 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. The following are selected as applicable under Transaction Status when the batch process is complete. 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, 101-ar-frm-036 Accessing the A/R Lockbox
Adding Lockbox Data Records
Creating a New Lockbox Record
Creating a New Deposit Number for Lockbox Entries
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:
Enter a new deposit number in this field.
Enter text to identify the deposit in the Description text box.
The user name and creation date are automatically entered.Entering New Lockbox Detail Information
To create a new Lockbox Detail record:
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.
Cash Collection Payment Types (VTSYSTEM_CCTYPE)
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
The Govern OpenForms applications required for Accounts Receivable are installed through Govern Deploy EZ, See Deploy EZ.
101-ar-install
This information will be posted as it becomes available.
101-ar-ofr