Accounts Receivable: Job Status Reports Accounts Receivable: Job Status Reports
The Accounts Receivable Job Status Report is a listing of invoices, progress billings, and receipts entered for each job. The report includes the name of the customer associated with the job, the contract status (including change orders) of the job and the amounts remaining to be billed and to be paid. This report can be useful in determining the cash flow situation on a particular job.
This is accessed through Job Status Report on the Accounts Receivable Reports menu.
Click on any column header to sort the listed items. This will be useful when the list of reports has grown.
Add or Change (button)
To modify the information used in generating the report, press the Add button, or highlight the desired report title and press the Change button. For more information, see Add or Change a Job Status Report.
Press the Delete button and the following screen comes into view. Press the Yes button and the highlighted report will be deleted. If the No button is pressed, the program returns to the previous screen.
To print a report, press the Print button. For more information, see Printing Reports.
Report Description: Receivables Job Status Report
Report Sample: Receivables Job Status Report
Note: If the message "Nothing to Print"comes into view when the Print button is pressed, there are two main causes:
1. There is no information within the selected limits. Remove all limits, then reinsert the limits one at a time. If the report still will not print, insert a new report title.
2. No report title is selected. The report title is used to store the selected limits. A report title must be selected in order for the report to print.
This button closes the program and returns to the main screen.
Help (button)
see How to use help
Add or Change a Job Status Report
To Add or Change a report, press the appropriate button and the following screen will come into view. This screen displays the possible limits that may be set. No limits should be set if a complete listing of every transaction in the Posted Transaction File is desired. Several limits may be set to narrow the list down to a very small range of transactions.
Following is a description of each of the limits. Check the appropriate boxes and enter the desired limits. When all desired limits have been set, press the OK button to save the settings. Press the Cancel button to return to the browse screen without saving the settings.
Report Title
The title of the report. Warning: The title is used to store the selected limits. If no title is entered for the report, the message "Nothing to Print" will come into view when trying to print.
User
Enter the User ID of the report creator.
Lock (check box)
Use this section to limit the report by Job. Use the Range setting to set a range of Job ID numbers. Use the List setting to specify a list of Jobs to be included.
This section allows the selection of the Jobs for which the report should be printed. The number of the first and last Jobs desired should be entered. If information is desired for only one Job, that Job Number should be entered in the From and To fields.
All, Range, List (radio buttons)
Select the All radio button to ignore Job reporting limits. Select Range to enter a range of Jobs in the From and To fields. Select List to report on a list of selected Jobs.
These fields will be available if the Range radio button is selected.
From
Selects the first job in a range or a single job. Enter the number, or press the lookup button and the Job Setup screen comes into view. Highlight the desired job and press the Select button.
To
Selects the last job in a range or a single job. Enter the number or press the lookup button and the Job Setup screen will come into view. Highlight the desired job and press the Select button.
Edit Job List (button)
If the List radio button is selected, this button will be available. The following screen will come into view when the Edit Job List button is pressed.
Use the arrows to move Jobs from the Available list to the Included list. All Jobs in the Included Records section will be included on the report. Use the tabs to sort each section by Job Number or by Job Name.
Retrieve a Saved List / Save This List for Future Use (buttons)
Use these buttons to save the current list of included records for future use, or to retrieve a previously saved list. See Saved Report Limit Lists for more details.
Use this section to limit the report by customer. Use the Range setting to set a range of customer numbers. Use the List setting to specify a list of customers to be included.
All, Range, List (radio buttons)
Select the All radio button to ignore Customer reporting limits. Select Range to enter a range of Customers in the From and To fields. Select List to report on a list of selected Customers.
These fields will be available if the Range radio button is selected.
From
Enter the customer number. Press the lookup button and the Customer Entry screen comes into view. Highlight the desired customer and press the Select button.
To
Enter the customer number. Press the lookup button and the Customer Entry screen comes into view. Highlight the desired customer and press the Select button.
Edit Customer List (button)
Click the Edit Customer List button to add or remove Customers from the list of Customers to be included in the report. The following screen will come into view.
Available Records
All Available Customers that are not included in the list are displayed in these columns.
Included Records
All Included Customers are listed in these columns. Use the arrows to move selected records or all records between the Available and Included areas
Portrait (radio button)
Specifies how the report is positioned on the page when printed. Portrait is the standard. Portrait is printed vertically.
Landscape (radio button)
Specifies how the report is positioned on the page when printed. Landscape is printed horizontally.
Enter the Data types to be included on the listing.
T& M Invoices (check box)
Select this box to include Time and Material Job invoices that were entered through the Trade Invoice entry screen.
Progress Billings (check box)
Select this box to include invoices that were entered through the Progress Billings entry screen.
T& M Billing Receipts (check box)
Select this box to include receipts for Time and Material Job invoices.
Progress Billing Receipts (check box)
Select this box to include receipts for Progress Billings.
Change Orders (check box)
Select this box to include changes to the job contract price.
Report as of
The report will be limited to transactions previous to the date entered here. Enter the date or press the lookup button and a Calendar will come into view. Highlight the desired date and press the OK button.
Start Each Job on a new Page (check box)
To print each job on a separate page, check this box. To print multiple jobs per page, leave the box unchecked.
Include Inactive Jobs (check box)
Select this box to include Inactive Jobs on the Job Status Report.
Include Closed Jobs (check box)
Select this box to include Closed Jobs on the Job Status Report.
Readability Bars (check box)
Select this option to add Readability Bars to the generated Report. Click the color box to select the Readability format. The following screen will come into view.
Select the Readability Bar color or press the Define button to select a Custom Readability Bar color.
Click this button to save the current settings and print the report immediately, without having to return to the Report Title browse window.
Report Description - Receivables Job Status Report
The report heading includes the report title, the date, and the company name as well as all of the set limit information.
Original Contract
This is the amount of the original contract for the job.
Current Contract
This is the amount of the current contract, including all change orders.
Change Orders
This column includes the dates, CO numbers and amounts of any change orders applied to this job to date.
Date
This is the date of the billing whose invoice number is found immediately to the right.
Invoice #
This is the invoice number of the billing transaction.
Amount
This is the amount of the billing transaction
Retained
This is the amount retained against this particular billing.
Received
Entries in this field represent payments received from the customer.
Date Paid
This is the date the payment was made.
Check Number
This is the number of the check used to make the payment.
Totals: Change Orders
This is the total of all of the change orders applied to this job.
Totals: Billed
This is the total amount billed to date.
Totals: Retained
This is the total amount retained to date.
Totals: Received
This is the total amount received from the customer to date.
Current Contract Amount
The current contract amount is the original contract amount minus the total of all change orders applied to the job.
Remaining To Be Billed
This figure represents the total contract amount less the total amount billed to date.
Remaining To Be Paid
This figure represents the total contract amount less the total amount received to date.
Report Sample - Receivables Job Status Report
