Client Receipt inquiry

You enter client receipts to record payment from clients or credit memos to clients. You can apply the payment or memo to a client invoice, or you can enter the amount as a prepayment.

Use this inquiry to see information for your client receipts, such as receipt date, type, and status; breakdown of the amount by labor, expense, and consultant; and deposit bank and date.

If needed, you can add predefined columns and view supplemental information such as the project manager, principal, and billing contact.

Using the inquiry

From the > Reports menu, click Standard Inquiries > Client > Client Receipt.

Audience

Accounting staff

Standard columns

Column

Links to this inquiry

Description

Date range available

Receipt Text

 

The client name, receipt date, and receipt key associated with the receipt

This is used to group detail to obtain a subtotal by receipt.

 

Receipt Type

 

The type of receipt

Examples: Client Receipt, Credit Memo, Miscellaneous Receipt

 

Client

Client

The name of the client associated with the client receipt or credit memo

 

Project ID & Description

Project

The ID and description of the project associated with the client receipt or credit memo

 

Invoice Number

Client Invoice

The ID of the client invoice associated with the client receipt or credit memo

 

Receipt Date

 

The date of the receipt

 

Receipt Method

 

The method of receipt

Examples: Cash, Check, Credit Card, EFT, Wire Transfer

 

Receipt Status

 

The status of the receipt

Examples: Active, Voided

 

Method ID

 

The ID of the receipt as entered in Manage Client Receipts

 

Amount

 

The total amount of the receipt, including amounts for labor, expense, consultants, adjustments, and sales tax

x

Amount Labor

 

The amount of the labor paid by the receipt or credit memo

 

Amount Expense

 

The amount of expenses paid by the receipt or credit memo

 

Amount Consultant

 

The amount of consultant paid by the receipt or credit memo

 

Amount Adjustment

 

The total amount of invoice adjustments paid by the receipt or credit memo

 

Amount Adjustment Labor

 

The amount of invoice adjustments with an activity type of Labor

 

Amount Adjustment Expense

 

The amount of invoice adjustments with an activity type of Expense

 

Amount Adjustment Consultant

 

The amount of invoice adjustments with an activity type of Consultant

 

Reduced Bill

 

Indicates if the credit memo reduces the project billed amount

Applies if the Reduce project billed amount check box is selected for the credit memo on the Manage Client Receipts window.

 

Deposit Bank Name

 

The name of the bank where the receipt is deposited

 

Client Invoice

Client Invoice

A link to the Client Invoice inquiry

The inquiry contains information about the client invoice associated with the receipt or credit memo.

 

Deposit Date

Bank Entry

The date the client receipt was deposited in the bank

x

Predefined columns

You can add predefined columns to this inquiry. These columns are available:

Column

Links to this inquiry

Description

Date range available

Receipt Key

 

The database identifier of the client receipt

 

Method ABA

 

An optional identification for the client receipt

This is the number that you write on the deposit slip for the receipt.

 

Payer

 

The company or person issuing the payment

Applies only to Miscellaneous Receipts.

 

Receipt Company Key

 

Multi-company only. The database identifier of the company associated with the client receipt

 

Receipt Company Name

 

Multi-company only. The name of the company associated with the client receipt

 

Notes

 

Notes entered on the receipt

 

Client Invoice Key

Client Invoice

The database identifier of the client invoice associated with the receipt or credit memo

 

Invoice Date

 

The date of the client invoice paid by the receipt or credit memo

x

Client Key

Client

The database identifier of the client paid by the receipt or credit memo

 

Project Key

Project

The database identifier of the project paid by the receipt or credit memo

 

Project ID

Project

The ID of the project associated with the receipt or credit memo

 

Project Description

Project

The name of the project associated with the receipt or credit memo

 

Project Type Key

Project Type

The database identifier of the project type associated with the receipt or credit memo

 

Project Type

Project Type

The project type associated with the receipt or credit memo

Examples: Residential, Commercial, Interiors

 

Client Type Key

Client Type

The database identifier of the client type associated with the receipt or credit memo

 

Client Type

Client Type

The client type associated with the receipt or credit memo

 

Project Manager Key

Employee

The database identifier of the project manager associated with the receipt or credit memo

 

Project Manager

Employee

The project manager associated with the receipt or credit memo

 

Principal in Charge Key

Employee

The database identifier of the principal in charge associated with the receipt or credit memo

 

Principal in Charge

Employee

The principal in charge associated with the receipt or credit memo

 

Billing Contact Key

Employee

The database identifier of the billing contact associated with the receipt or credit memo

 

Billing Contact

Contact

The billing contact associated with the receipt or credit memo

 

Project Company Key

 

Multi-company only. The database identifier of the company associated with the project

 

Project Company Name

 

Multi-company only. The name of the company associated with the project

 

Deposit Key

Bank Entry

The database identifier of the deposit of the receipt or credit memo

 

Defined links:

Link - Client Invoice

Client Invoice

A link to the Client Invoice inquiry

 

Link - GL Entry- Accrual

GL Entry - Accrual

A link to the GL Entry inquiry

 

Link - GL Entry - Cash

GL Entry - Cash

A link to the GL Entry inquiry with a condition limiting the information to cash entries