Accounts Receivable Tab of Project Review Form

Use the Accounts Receivable tab to review information about outstanding project accounts, and to enter or edit comments about project accounts.

Contents

You can also preview an invoice or credit memo on the Preview window.

Fields

Field Description
Client This field displays the name of the project's client. The name is a link that you can click to display that client's information in the Client Info Center.
Address These fields display the client billing address for the project.
Contact These fields display the billing contact and the contact's email address. The contact's name is a link that you can click to display that contact's information in the Contact Info Center. You can also click the email address to create an email message for the contact.
Contact Phone/Fax These fields display the billing contact's phone and FAX numbers.

Invoice Selection Filter Section

Field Description
Status Select a setting to filter invoices for display in the Aged AR grid, based on payment status: All, Unpaid, or Paid in Full. Click Refresh Invoice List to update the invoices in the grid based on your selection.
Time Frame In the first Time Frame field, select one of the following options to select invoices for display in the Aged AR grid, based on invoice date:
  • Period — Display invoices for the job to date, year to date, or current accounting period. Select which of these periods you want in the second Time Frame field.
  • Period Range — Display invoices for a range of accounting periods. Select the beginning and ending periods in the other two Time Frame fields.
  • Date Range — Display invoices for a range of dates. Enter or select the beginning and ending dates in the other two Time Frame fields.
Refresh Invoice List Click this button to update the invoices in the grid based on your selections.

JTD Information Section

Field Description
Billed This field displays the total amount billed for the project for the job to date. The amount in this column does not include taxes, but the Received and Total AR columns do.
Tax Billed This field displays the total tax amount billed for the project for the job to date.
Received This field displays the total amount of payments received for the project for the job to date.
Total AR This field displays the total current accounts receivable amount for the project, including taxes. This amount is a link that you can click to display more information about the invoices on the AR Details dialog box.
Retainer This field displays the retainer balance.

Fields

Field Description
Currency Code If your firm uses the Multicurrency feature, this field displays the billing currency for the project.
Average age of receivables This displays the average number of days it takes for a client to pay invoices in full. This calculation is based on all paid invoices for a client.

Example:

A client has two fully paid invoices:

  • For Invoice 1, you received full payment 22 days after the invoice was issued.
  • For Invoice 2, you received full payment 36 days after the invoice was issued.

Average age of receivables for this client is 29 days (58/2).

Aged AR Grid

This grid lists the invoice balances for a selected project, with corresponding aging data, interest amounts, retainage amounts, and invoice comments. Invoice balances include credit memo amounts.

To determine the aging columns for the grid and select the aging date to use, click AR Options on the Project Review toolbar. Enter these settings on the AR Options dialog box. The settings that you enter on this dialog box are also used for aging invoices on the Invoice Review form in Accounting > Accounts Receivable > Invoice Review.

If Invoice on File is selected for an invoice or credit memo, you can select it and click Preview Invoice to display it in the Preview window. From that window, you can print or email a copy of the invoice or credit memo.

Field Description
View Detail Click this toolbar option to display the Invoice Details dialog box for the selected invoice or credit memo. The dialog box lists invoice and credit memo amounts by invoice section and payments received. When you view the detail for an invoice that has credit memos posted against it, the credit memo line items also display.

If Invoice on File is selected for the invoice or credit memo in the Aged AR grid, you can preview or print the invoice or credit memo. To do so, click the Preview Invoice button on the Invoice Details dialog box.

Preview Invoice If Invoice on File is selected for the invoice or credit memo in the Aged AR grid, click this toolbar option to display the invoice in the Preview window. From this window, you can print the invoice or distribute it by email message. This option is not available if your firm does not have the Billing module.
Last Receipt Click this toolbar option to display the date and amount of the most recent payment received for the selected invoice. This option is not enabled for credit memos.
Comments Click this toolbar option to display the AR Comments dialog box, where you can review and edit AR comments for the selected invoice or credit memo. Your Vision security role must have access to Accounts Receivable comments.
Two settings on the Accounting Tab of Role Security, in Security Configuration, affect this grid:
  • Accounts Receivable Comment Review Access — This option controls whether or not you can see invoice comments.
  • Accounts Receivable Comment Update Access — This option controls whether you can edit your own comments, or those made by other users.
Invoice This field displays the invoice number.
Credit Memo This field displays a credit memo number if the row represents a credit memo. Credit memos display below the invoice to which they apply.
Invoice Date This field displays the date that the invoice or credit memo was entered in the Transaction Center or the invoice date from Interactive Billing.
Total Billed For invoices, this field displays the original invoice amount. For credit memos, this field displays the credit amount (negative).
Balance For invoices, this field displays an invoice's original amount less any payments, less any credit memos, and less any outstanding retainage amounts (because retainage is not considered due at this time). For credit memos, this field is blank.
Aging columns These are the aging columns established on the Aging Options dialog box. Each column shows the receivables that are a certain number of days overdue. For example, if an amount appears in the 31-60 column, then it is between 31 and 60 days overdue.
Total Tax This field displays the total tax amount that is outstanding for the invoice or credited on a credit memo. This column displays only outstanding amounts, not all taxes billed.
Interest This field displays the amount of interest posted for past due invoice amounts.
Retainage This field displays the retainage amount of the invoice not currently due. This amount is affected by retainage amounts entered on credit memos. This column is available if Enable Retainage is selected in Configuration.
Retainer This field displays the amount of the retainer that is applied to the invoice.
Comments A check in this box indicates that comments exist for at least one outstanding invoice or credit memos for the project listed.
Invoice on File A check in this box indicates that the invoice or credit memo is on file in Interactive Billing. On the Invoices on File dialog box in Interactive Billing, you can preview invoices or credit memos on file. From the Preview window, you can print them or distribute them by email message. You cannot preview invoices or credit memos for which no check is displayed in Invoice on File.
Edited A check in this box indicates that the invoice or credit memo was edited manually.