Accounts Receivable Export

Use the Accounts Receivable Export report to download accounts receivable data to a Microsoft Excel spreadsheet file or other file format. If you use the Multicompany feature, the column headings and account mappings are based on the mappings set up for the company that owns each project.

Contents

Column	Description
Project	This column displays the project number to which the invoice amounts were charged.
Phase	This column displays the phase number to which the invoice amounts were charged.
Task	This column displays the task number to which the invoice amounts were charged.
Invoice	This column displays the invoice number.
Mod/Receipt Description	If Receipt appears in the Invoice column, Vision displays the reference number for the cash receipt in this column. This column may also display the invoice number, the year and month, and the number of postings for the accounting period against which the report is being run.
Invoice Date	This column displays the invoice date or the date of the cash receipt.
Total	This column displays the total amount of the invoice and the total amount of each receipt for that invoice.
Invoice Comment	This column displays invoice comments.
Credit Memo RefNo	If the record is for a credit memo entered in Interactive Billing, this column displays the credit memo number. (The Invoice column displays the number of the invoice to which the credit memo applies.)
Cash Receipt Comment	This column displays cash receipt comments.
Balance	This column displays the balance of the invoices, less any outstanding retainage amounts.
Age 01 - 10	These columns categorize invoice balances by age using the ranges set up in Configuration.
Interest	This column displays the amount of interest posted for past due invoice amounts.
Retainage	This column displays the amount of retainage that is not currently due for payment. This column is available only if Enable Retainage is selected in Configuration.
Unassigned Receipts	This column displays the amount of any unassigned receipts. An unassigned receipt is a cash receipt posted to an invoice for which there is no record in Vision. An invoice number is required if you enter a cash receipt, but the receipt is considered unassigned if there is no corresponding invoice record in Vision.