Unapplied Cash

Make the following menu selections to display this grid:

eFinancials—Accounts Receivable—Transactions—Unapplied Cash

Use this grid to apply Unapplied Cash.  

Fields Lists

A red dot indicates a required field or selection.

ClosedUnapplied Cash Grid Fields

Header

Customer

The customer identification. Use the lookup to select a Customer. This is a required field.

Bank Account

The bank account. Use the lookup to select a Bank Account. This is a required field.

You can remove the default Bank Account from the field to see Unapplied Cash for the selected Customer from other banks.

Include Approved Receipts

Select this option if you want to see Receipts in the grid that contain transactions that have been approved.

Grid

Notes

Clicking on a column label allows you to sort the grid by that column.

Filter Buttons Filter button in column headers allow you to change what appears in the grid.

Grid pagination controls at the bottom of the grid can help you to locate a receipt with unapplied cash.

Apply link

Select the Apply link to apply the unapplied cash for that Receipt. The Unapplied Cash form appears. Refer to Fields list for more information.

Receipt ID

The receipt identification that appears on lists and in reports.

Date

The date of the receipt that appears on lists and in reports.

Status

The status of the Receipt that appears on lists and in reports.

Original Unapplied Cash Amount

The original amount of cash that has not been applied to a Billing and is being held until a decision is made about how to apply the funds using this Unapplied Cash menu item.

Remaining Amount

The remaining amount of Unapplied Cash for this Receipt. Unapplied Cash for a Receipt can be applied in increments.

Description

The description of the Receipt that appears on lists and in reports.

Documents

One of the following icons appears in this column:

No documents are currently stored for the invoice. Click the icon to upload documents for the invoice.

At least one document is currently stored for the invoice. Rest your mouse pointer on the icon to see the number of documents stored. Click the icon to view, add, or delete documents.

For more information, refer to the Documents Tab instructions.

Footer

Company | BatchEntity | Property | Batch (Footer Links) 

Make changes using the Footer Links to use the appropriate combination of Company and Batch. The Receipts with Unapplied Cash for that batch appear in the grid.

Make changes using the Footer Links to select the appropriate combination of Entity, Property, and Batch. The Receipts with Unapplied Cash for that batch appear in the grid.

ClosedUnapplied Cash Form - General Information Fields

Customer ID

The customer identification, which is the same as the source of the Unapplied Cash.

Bank Account ID

The bank account ID, which is the same as the source of the Unapplied Cash.

Job

The Job associated with the Receipt. Click the lookup to select a Job from the Select Job pop-up

Select a Job to filter the Receipts to only show Receipts that contain a line item pointing to that Job. The Job field is restricted to Jobs that exist within the current EntityCompany.

Receipt Date

Defaults to the current system date. Enter the date for the transaction using the electronic calendar  to select a date.

This date is used to calculate discounts. When the Receipt date changes, discounts are recalculated and the discount amounts and extended amounts may be updated.

Accounting Date

Defaults to the current system date. Enter the accounting date for the transaction using the electronic calendar to select a date.  

Description

A user-entered description for the Unapplied Cash that appears on lists and in reports (up to 40 characters).

Reference/Receipt #

Enter a reference number for the Unapplied Cash, if desired.

Unapplied Cash Amount

The system-calculated amount of Unapplied Cash for this Receipt.

Amount

The amount you are applying. When you change the amount, the Remaining Amount to Enter field does not change if you use the Allocate button next to the field. See Allocate button description.

Allocate button

Click the button and the system allocates the value in the Amount field from top down for all billings in the grid. The Receipt Amount in the grid changes, however.

NOTE that there is an Allocate button in the grid that works differently. Refer to Grid Fields, below, for details.

Total Amount Entered

The system-calculated sum of the values in the billing row Receipt Amount fields. This amount cannot exceed the amount in the Unapplied Cash. Amount field.

Remaining Amount to Enter

The difference between the Amount field and the Receipt Amount field in the grid.

Force Discount

When this box is checked, any possible discount is applied to the amounts. This option disregards the Discount Due Date fields.

ClosedReceipt Form - Grid Fields

About Billing Grid Fields

Each row in the grid constitutes a Billing. There are multiple ways to assign Unapplied Cash amounts to Billings. You can enter amount on just the Billing level, or you can expand the Billing to enter amounts on the Billing details.

Restrictions on entering amounts in main grid:

ClosedAbout the Allocate Button

Refer to field descriptions for the Allocate button as well.

If you click the Allocate button on the top of the form, the system allocates that amount from top down for all billings in the grid.

If you click the Allocate button on the billing row, and the amount is zero, the amount changes to the extended amount, and the sub grid becomes populated from top down with that amount.

If you click the Allocate button on a billing row where the amount is non-zero, that amount will be used to allocate instead of the extended amount.

Fields

Billing ID

The Billing identification that appears on lists and in reports.

Due

The Billing due date.

Discount Due

The date that the Billing must be paid in order to receive a discount.

Billing

The transaction date of the Billing.

Billing Amount

The amount of the Billing.

Tax

The amount of tax due on the Billing.

Remaining

The system-calculated amount remaining on the Billing.

Discount

The amount of any discount applicable to the Billing. Changing the Receipt Date in the header may cause the discount amount to be updated.

Extended Amount

The system-calculated extended amount. Changing the Receipt Date in the header may cause the Extended Amount to be updated.

Receipt Amount

The receipt amount for the Billing. Enter the amount to be allocated using the Allocate button in the grid.

Allocate button

If you click the Allocate button on the Billing row, and the amount is zero, the amount changes to the extended amount, and the sub grid becomes populated from top down with that amount.

If you click the Allocate button on a Billing row where the amount is non-zero, that amount will be used to allocate instead of the extended amount.

ClosedReceipt Form - Sub Grid Fields

Click the arrow for a row to see the detail lines for the Billing. When a Billing row has been expanded to show the sub grid, the amounts in the sub grid must add up to the amount on the Billing row.

Seq No

System-generated sequential number that identifies a transaction. You cannot edit this field.

Description

The  read-only billing description.

Billing Amount

The read-only Billing amount.

Tax

The read-only tax amount for the Billing.

Remaining

The system calculated amount remaining to be paid for the Billing.

Discount

The system calculated discount amount associated with the Billing, if any.

Extended Amount

The system calculated extended amount for the Billing.

Receipt Amount

The amount of the receipt to be allocated to this line.

PropertyCompany

The PropertyCompany associated with the Billing.

Job Information

The Job identification associated with the Billing appears if the Track Jobs option is being used.

Procedures

ClosedTo Apply Unapplied Cash

  1. Select eFinancials—Accounts Receivable—Transactions—Unapplied Cash.
  2. In the title bar at the top of the page, verify that the date is correct. If not, change it to date you want to use.
  3. Use the Footer Links to select Company and BatchEntity, Property and Batch for the Unapplied Cash.
  4. In the grid, click Apply for the Receipt you want to work with.

    Or, if you have not selected batch, the Select Batch Tab appears. Use the tab to select or add a batch.
     
  5. Use the field lists to complete the Apply Unapplied Cash form.
  6. Click Save.

Additional Information

ClosedEffect of Permissions

Permissions must be set in the System module to access all Unapplied Cash activities.

Permissions for Unapplied Cash

System module—Security—Users—eFinancials—Accounts Receivable—Unapplied Cash

See Also

Accounts Receivable Introduction