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 multiple companies, 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, DPS 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.
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 on the General tab of the Accounting System Settings form (Settings > Advanced Accounting > System).

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 DPS. 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 DPS.

Exterior Attributes
No. of Floors
Prop. Manager