Accounts Receivable - Customer Payments

Overview

The Customer Payments screens can be used to perform the following tasks:  

 

Customer payments can be made directly to a regular bank account where they will be treated as a deposit of the customer payment, or they can be made to an Undeposited Funds bank account and selected later to include in a Deposit.

After posting a Customer Payment, the document can be voided which reverses out the effects of the Customer Payments on Invoices (and potentially other Customer Payments).  This has the effect of reinstating the Invoice (and potentially other Customer Payments) as available for inclusion on another payment.

Customer Payments can have one of the following statuses:  INUSE, SUBMITTED, or POSTED.

 

Roles

This screen is available to users having any of the following roles: Administrator, AR User, AR Poster, or AR Viewer.  

License

This screen is available with the Project Financials family of Unanet licenses.

 

 

Topics covered on this help page include:

 

    

You may also be interested in:

      

Search

Using the Customer Payment Search screen, you can refine the list of Customer Payments with which you have interest, by supplying search criteria and clicking on the List tab.  The default selection criteria is configured to return all INUSE Customer Payments for the current month.  

Field Descriptions (click on a link below for additional information):

 


List

The entries included in the resulting List screen will contain any items matching the supplied search criteria.  For those items in the SUBMITTED status, a leading checkbox is available which can be used to initiate a bulk Post action directly from this screen by clicking the Post button.   A number of additional icons are available to facilitate a variety of activities.

Drill Down Note: You can click on the value in the Balance column to view the Customer Payment Balance Details popup report.

 

Note that entries associated with Customer Organizations that do not have a specified Remit To Organization Address will be flagged in this listing.

Field Descriptions (click on a link below for additional information):

 

 

Customer Payment - Balance Details Popup

The Customer Payment - Balance Details Popup report will resemble the following:

 


Add Customer Payment

Clicking on the link (available on the Customer Payment - Search/List screens), will present you with the Customer Payment - Summary screen where you will supply the summary information for a Customer Payment.  Subsequent to providing the summary level information, you will likely want to navigate to the Paid Documents and/or Details options, to indicate to which Invoices a payment is addressing (via Paid Documents screen) and/or directly enter transactions where no Invoice was sent (via Detail screen).  

On this Summary screen, you will enter information regarding the Customer from which you are receiving a payment, the bank account to which the payment will be deposited, the payment amount, the document and post dates, any comments you'd like to associate with the entry and more.

 

Field Descriptions (click on a link below for additional information):

 

 

 


Lookup Invoices

The Lookup Invoices feature allows you to see multiple invoices of the same customer. Keep in mind that when applying payments, they can only be applied to one customer at a time.

Click on the Lookup Invoices button, and you will find there are 4 convenient ways to search for invoices:

1. Customer - when you search by Customer, this field will support the concept of a comma separated list

2. Project - when you search by Project, this field will also support the concept of a comma separated list  

3. Invoice Number - if you remembered the precise Invoice Number, or numbers of multiple invoices (entered separately of course), you can enter them in this field

4. Invoice Amount - if you do a search by Invoice Amount, it must be the exact amount, including exact change

 

Selecting the invoices will auto-populate some of the cells in the screen below (in this case, three of IBM's invoices were checked off in the boxes on the left side. The amounts added up automatically and appeared in the Payment Amount cell).

 

 


Edit Customer Payment - Summary

The Edit Customer Payment screen (which you can get to by navigating to the Summary left menu option after clicking the pencil icon from the Customer Payment list screen), is nearly identical to the Customer Payment Add screen.  On this screen you can modify most fields with the exception of Legal Entity (which can no longer be modified once any Paid Document or Detail line items have been added to this Customer Payment).  This screen also displays the Customer Payment Document # assigned to this Customer Payment.

The Summary menu option will become unavailable once the Customer Payment reaches the POSTED status.

 

Field Descriptions (click on a link below for additional information):

 

 

 


Edit Customer Payment - Paid Documents

This screen will display a list of previously included and potentially includable documents (ie posted Invoices and/or other posted Customer Payments) which may be associated with the current Customer Payment.  From this list you can choose which Invoices this payment will cover and/or which other Customer Payments (having an unapplied amount) this Customer Payment will address.

You can navigate to the Paid Documents screen via the left menu option (once editing a Customer Payment) or directly by clicking the edit pencil icon from the Customer Payment list screen.

The Paid Documents menu option will become unavailable once the Customer Payment reaches the POSTED status.  

 

Header

The information in the 'header' section of the screen will recap the information provided on the document Summary.  

Note the values in the Current Customer Balances area will not change as information is entered in this screen until such time that a Save occurs.  

 

Paid Documents Grid

To indicate that a particular Invoice or Customer Payment is to be included in this Customer Payment document, you must click on the checkbox in the leading column of a desired row (or the checkbox at the top of that column which will toggle all rows on and off).  Once you have checked the leading checkbox, the Payment and Discount fields will become enabled for entry (see field descriptions below for additional details as to when a field may or may not be enabled).  You can choose to use the default suggested Payment and Discount amounts, or provide alternate values.  As values are entered, the column totals and Remaining values will be dynamically updated, as will the Balance in the left side of the Header.

This grid may include two types of entries, CI (Customer Invoices) and/or CP (other Customer Payments).  These documents will be displayed as follows:

 

Potentially Includable documents are:

 

Order
Within the previously included and potentially includable entries, documents will be sorted in the following order:

 

Within these groupings, documents are additionally ordered by Document # descending.

 

Submit/Post Validations

A few noteworthy validations that occur at the time of submittal or posting, include:

 

For a more complete listing of validations, see the Post button description.

 

Field Descriptions (click on a link below for additional information):

 

 

Buttons (click on a link below for additional information):

 

  • Save

  • Save/Next

  • The following buttons will only be enabled when the Summary > Payment Method does not have a Type of System Check

  • Submit/Next

  • Post/Next        (Administrator or AR Poster role required)

 


Edit Customer Payment - Details

This screen is available to enter the detail line items making up a Customer Payment (which you can get to by navigating to the Details left menu option after clicking the pencil icon from the Customer Payment list screen).  The entries on this screen represent transactions where no Invoice has been entered into Unanet and the accounting distribution must be entered along with the payment.  

The Detail menu option will become unavailable once the Customer Payment reaches the POSTED status.  

 

Header

The information in the 'header' section of the screen will recap the information provided on the document Summary.

Note the values in the Current Customer Balances area will not change as information is entered in this screen until such time that a Save occurs.  

 

Details Grid

This section of the Customer Payment Details screen is where you will be entering the individual line items that make up the Customer Payment.

For those Accounts that have been designated as requiring Project information (configured on the Admin >> Setup >> Accounts screen with the Require Project indicator checked), you can also provide additional 'reference' information (such as the project, task, project type, expense type, and possibly person).

 

Customer Payments can be submitted and posted without having any Paid Documents or Details grid entries.

 

Field Descriptions (click on a link below for additional information):

 

 

Buttons (click on a link below for additional information):

 

  • Save

  • Save/Next

  • The following buttons will only be enabled when the Summary > Payment Method does not have a Type of System Check

  • Submit/Next

  • Post/Next        (Administrator or AR Poster role required)

 


Customer Payment Attachments

This screen is available to attach one or more documents to a Customer Payment (which you can get to by navigating to the Attachments left menu option after clicking the pencil icon from the Customer Payment list screen).

Users can add attachments regardless of the Customer Payment status. Only Administrators can delete attachments when the Customer Payment status is Posted.

 

Note: The Unanet Administrator may want to suggest guidelines with regards to what types of files may be acceptable to be used as Customer Payment attachments, particularly in the case where any documents are being scanned and saved as a graphics file. Certain graphics file formats are known to result in much larger files sizes than others and you may want to consider suggesting a specific file type to help control the amount of data being stored in your database.  Generally speaking, jpg and gif files tend to be much smaller than tif and png file formats.

To assist with the management of allowable attachment types and size, the administrator can use the following three properties: Maximum Size Allowed for each attachment  (unanet.attachment.max_size), File Extensions that are Not Allowed  (unanet.attachment.invalid_file_extensions) and File Extensions that are allowed  (unanet.attachment.valid_file_extensions).

 

Using this screen, the user can add, remove or view an attachment.  The Save button will save the changes to the attachment screen and return the user to the Customer Payment Details screen.  The Cancel button will also navigate the user to the Customer Payment Details screen but without saving any changes.  Clicking on the paper clip icon will launch a new window and attempt to display the attachment (assuming your local PC knows what application to execute to view the specific file type).

Field Descriptions (click on a link below for additional information):

 

 

Where can attachments be seen?

The Customer Payment >> List screen will contain a paperclip () icon to indicate attachments exist on a particular Customer Payment.  Clicking on the icon will navigate the user to the Customer Payment >> View screen with the Attachment section expanded.

 

When viewing a Customer Payment that has attachments, the list of attachments will appear in an expandable table under the displayed Customer Payment details as in the example below.  You can click on the paper clip icon () and view the attached document (assuming you have the necessary local software installed to view the particular file type).  This section will only appear if attachments exist.

 


View Customer Payment

This screen is available to view a read-only version of the Customer Payment document (which you can get to by navigating to the View left menu option after clicking the pencil icon from the Customer Payment list screen or by clicking on the view icon on the Customer Payment >> List).  

Once the Customer Payment reaches the POSTED status, this will be the only available menu option.

 

 

An Edit button will appear at the bottom of this screen if all of the following conditions are met:

 

If the Customer Payment had been in a status of SUBMITTED, then clicking on the Edit button will return the status to INUSE.


Post Customer Payment

Roles

This screen is available to users having any of the following roles: Administrator or AR Poster.   Note that AR Posters are limited to posting Customer Payments for the Legal Entities they have access to via Financial Organization Access.

 

Customer Payments can be posted from two screens:

 

The posting process includes the following (not necessarily generated in this order):

  1. Create General Ledger Entries -- GL entries are only generated when posting to the General Ledger (i.e., Post to General Ledger (unanet.financials.post_to_gl) property enabled and the Post to General Ledger Effective Date (unanet.financials.post_to_gl.eff_date) <= document post date).     
    Attributes for the general ledger entry will include (for the individual entries, those attributes that are different than the general entry will be noted):   
  1. Create Unapplied Balance Entries - Unapplied balance entries are only generated when processing Customer Payment Application Documents or regular Customer Payments having a non-zero Balance amount.  These entries are used to allow the system to associate activity against customer payments that have or had outstanding balances.
  2. Create Project Expense Entries --  Project expense entries are only generated when the document has non-zero Detail rows that include project info.  For each of those rows, we will create project expense records (to be available for subsequent Billing Post & Invoicing activities).

 

Validations

While you can save a financial document violating certain rules, you will not be permitted to submit or post the document until they are resolved. If any of the validations fail for any row on the document, the entire document cannot be posted.

Standard financial document validations for each Detail row:

 

      • The sum of Payment, Discount and Write Off cannot exceed the Balance on a Paid Documents row

 

 


Void Customer Payment

Roles

This icon is available to users having any of the following roles: Administrator and AR Poster.  

 

Clicking on the Void icon () in the Customer Payment List will allow you to void a POSTED Customer Payment (generating a negating / voiding Customer Payment, reversing GL and Project Expense entries, etc).   This action does not delete any entries nor will it recalculate any values, but rather creates a set of reversing entries based on the original transactions.  This is true even if attributes referenced in the original documents have subsequently been made inactive, the voided transaction will continue to use those attributes to reflect the reversing values.

Note: If the Allow Users to Unpost Customer Payments  (unanet.financials.allow_customer_payment_unpost) property has been enabled, and the current user has the Administrator role, clicking the Void icon will present a submenu containing two choices:  Void Customer Payment or Unpost Customer Payment.  



When this property is not enabled, clicking the void item will immediately take the user to the Void screen.

 

The posting process includes the following:

  1. Create a "Voiding" Customer Payment -- Clone the document being voided.  The voiding document will be identical to the original document with the following differences:
  1. Create "Reversing" General Ledger Entries -- Reversing GL entries are only generated when posting to the General Ledger (ie Post to General Ledger (unanet.financials.post_to_gl) property enabled and the Post to General Ledger Effective Date (unanet.financials.post_to_gl.eff_date) <= document post date):
      

 

  1. Create Unapplied Balance Entries - Reversing Unapplied balance entries are only generated when voiding Customer Payment Application Documents or Regular Customer Payments having a non-zero Balance amount.

 

  1. Create "Reversing" Project Expense Entries -- Reversing project expense entries are only generated when the document being voided has non-zero Detail rows that include project info. The void process will create reversing project expense transactions that differ form the original transaction only in the sign of the amounts.
  2. Void Associated Application Documents -- If the Customer Payment being voided has Application Documents applied to it, each of those that have not already been voided will also be voided (ie each sent through the void process described above).

 

Validations

 

To void a Customer Payment, you will need to supply values for the following fields and click on the Void button.

 

Field Descriptions (click on a link below for additional information):

 

 

 


Unpost Customer Payment

Unposting a previously posted Customer Payment will permanently erase any evidence of that particular post.  When running an Unpost, there is no audit trail showing that the original post occurred nor will there be any audit trail that an unpost occurred.  In brief, this process will delete journal transactions, general ledger entries (if created) and unmark the originating transactions making them available to participate in another post process.

Roles

This feature is available to users having any of the following roles: Administrator

 

Note: this feature will only be available if the Allow Users to Unpost Customer Payments  (unanet.financials.allow_customer_payment_unpost) property has been enabled.  While AR Posters have access to this screen and can click on the Void icon, only users having the Administrator role will see the option related to Unposting.

 

When enabled, clicking on the Void icon () in the Customer Payment List will present a submenu containing two choices:  Void Customer Payment or Unpost Customer Payment.  

 

The ability to Unpost is allowed under the following conditions:

 


Closed Fiscal Years

 

Posting to Closed Fiscal Year

When posting to or voiding a document from a closed fiscal year, and the document contains details for accounts having account types REVENUE and EXPENSE, where the credits and debits do not cancel each other out (i.e. the delta between the revenues and expenses is not = 0), this process will additionally need to generate an adjustment to the previously recorded RETAINED EARNINGS account for the closed year.  

Note the adjustment will be generated regardless of the existence of the RETAINED EARNINGS account for the year being adjusted.  

The adjusting transaction will have the following attributes:

 

 


Apply Previously Unapplied Balances

Posted Customer Payments that have unapplied balances, will appear in the Customer Payment list with the (Apply Previously Un-Applied Balance) icon.  This icon will only be available on posted Customer Payments having a Balance not equal to zero.  This icon will only appear on original Customer Payment documents, that is, you cannot create an application document on top of another application document.   

Clicking on this icon will create an "application document", which is another Customer Payment document that can be used to designate how all or a portion of an unapplied balance should be handled. You will be placed on the Paid Documents screen in the newly created Customer Payment.  This new document will have the following fields automatically populated with the values from the original document, and they are un-modifiable (ie read-only values):

  
The Post Date and Fiscal Period will default to the values from the original document if the Fiscal Period is still open, otherwise, they will default to today’s date and the fiscal period associated with today’s date, respectively.  The user can optionally change either of these two values to other valid values.
  
Once created, you will submit and post the application document just as you would any other Customer Payment.