Invoice Mapping Accounts Tab of Accounts Receivable Settings

Use the Invoice Mapping Accounts tab to define the implicit posting of invoices to the appropriate accounts receivable accounts and map revenue account postings to report columns on the Office Earnings report and Accounts Receivable Ledger.

Contents

Field	Description
Company	Select the company for which to set up the invoice mapping accounts.
Invoice Account	Enter the account to map or click and select an account on the Account lookup. The account can be a balance sheet account or a revenue account.
AR Account	Enter the accounts receivable account to be debited when invoices are posted to this revenue account. You can enter an account or click and select an account on the Account lookup. If you do not enter an account number, DPS uses the account entered in the Accounts Receivable field on the Accounts tab in Settings > Accounting > Company .
Retainage Account	Enter the deferred retainage account to use for retainage posting. You can enter an account or click to select an account on the Account lookup. This is a temporary holding account for accruing retainage amounts for a project. When you bill retainage for a project, the amount is moved from this account to the Accounts Receivable account entered on the Accounts tab in Settings > Accounting > Company . If retainage is not enabled (on the General tab in Settings > Advanced Accounting > System), this field does not display.
Revenue Category	If you use revenue categories to track multiple unbilled accounts, a Revenue Category column displays in this grid. Enter a revenue category for each billed revenue account. These accounts are used in the Revenue Generation calculation and the invoice posting of unbilled amounts. Records for retainers and taxes do not require a revenue category because they most likely do not post to a revenue account. If you modify the revenue category for these accounts after you run the Revenue Generation process, unexpected results can occur. When you use revenue categories, we recommend that the entries you make in the Revenue Category field and the Project Column in this grid match each other. For example, if you have revenue categories for labor, consultants, and expenses, you should define project columns for only labor, consultants, and expenses. If you have other project columns (such as for add-ons or units) that do not have a corresponding revenue code, the unbilled revenue amount on the Office Earnings and Project Summary reports will be incorrect.
AR Column	Enter the column on the Accounts Receivable Ledger to which postings to this revenue account are mapped when the report is printed. If a revenue account is not mapped to one of these columns, the amount prints in the Other column of the Accounts Receivable Ledger. The AR Column number and the Project Column number do not correspond to one another. You can modify a column number at any time. Modifications are reflected the next time you generate the report.
Project Column	Enter the column on the Office Earnings report to which postings to this revenue account are mapped when the report is printed. If the revenue account is not mapped to one of these columns, the amount prints in the Other Billed column of the Office Earnings report. The AR Column number and the Project Column number do not correspond to one another. You can modify a column number at any time. Modifications are reflected the next time you generate the report.