|
|
The Projected Receivables Report is intended to be used to look at the date on which payment can be expected to come in from your open A/R items for Jobs.
This report is based on the invoices assigned to Jobs and the shipping and delivery dates for those invoices. It includes all invoice types and therefore is not a direct reflection of the values in the Accounts Receivable of the ledger and should not be compared to those values.
Terms:
The report uses two abbreviations to conserve space in the column headers.
The values from these invoices are grouped on the report into the date and type (PDD or ASD) they currently are.
IMPORTANT: If this report was run on April 2 for the six month period starting March 1 and ending August 31, and then run again on April 9 for the same six month period, the values on the report would have changed. It is important to note that this is a read and discard type of report and should not be used for financial comparisons.
The Settings Tab of the Projected Receivables Report allows the user to select a number of different criteria for the report.
Start Date: The first date used for the invoice and Job look up. Only invoices created after this date will be included in the report, even if a Job has invoices prior to this date.
Months to Report on: This is the number of months after the Start Date to report on.
Customer Balance Due: The Lighting Store option allows for the addition of customer orders to a builder's invoice as long as the customer pays for any amount that exceeds the allowance that the builder has supplied. By default this overage is due and payable eight days prior to the shipping of the goods. This value can be adjusted via this list.
Job Number: A specific Job can be selected here.
Departments: Specific departments can be selected or un-selected here.
Categories: Further selection of categories can be done here.
The Advanced Tab allows for the selection of invoice options.
List All Invoices: This option lists all invoices.
List Invoices for All Customers: This option lists all invoices assigned to a customer.
List Invoices for a Selected Customer: This option allows the user to select which customer to list invoices for.
The report displays the following:
Name: This column contains the name of the customer from which the Receivables will be received. It also includes a Job Number that displays the total for that specific Job and finally a report total on the last line showing the total value for each of the columns.
Month PDD & ASD: These columns are dependant on the Start Date and the Number of Months selected on the Settings Tab. Each month is split into the PDD and ASD amounts for that period of time. These values are totaled in the last three columns.