Billing Reports

Billing Report

The Billing report lists the net billed, total contract earned, and cash received amounts for each job, including an over- or under-billed amount. Company totals for all jobs appear at the bottom of the report.

1. Select Reports > Job Cost > Billing Reports > Billing.
2. Use the From and To lookup buttons to select the print range. Select Insert >>.
3. Select Print.

Retention Report

The Retention report lists retention withheld, retention billed, and billable retention amounts for open jobs. Retention amount totals for all open jobs appear at the bottom of the report.

1. Select Reports > Job Cost > Billing Reports > Retention.
2. Use the From and To lookup buttons to select the print range. Select Insert >>.
3. Select Print.

Over (Under) Billing Report

The Over (Under) Billing report lists over- or under-billed amounts for all open jobs. The report also includes posted costs, estimated gross profit, revenues earned, and amounts billed to date for each open job.

1. Select Reports > Job Cost > Billing Reports > Over (Under)Billing.
2. Use the From and To lookup buttons to select the print range. Select Insert >>.
3. Select Print.

Unbilled Costs Report

The Unbilled Costs report lists unbilled costs for a job or a range of jobs. This report can only be printed for jobs that have a contract type of Cost Plus and a billing type of Transaction Level or Project Trx Level.

1. Select Reports > Job Cost > Billing Reports > Transaction Level Reports > Unbilled Costs.
2. Use the From and To lookup buttons to select the print range. Select Insert >>.
3. Select Print.

Transaction Detail Report

The Transaction Detail report lists the transactions made in a range of jobs, over a range of dates. When a date range is selected, the report will consider the GL posting date of the transactions being billed, not the GL posting date of the billing invoices. If you do not select a date range, the job transactions will be listed for all dates. If you select a date range but do not select a range of jobs, all job transactions will be listed for that date range. This report can only be printed for jobs that have a contract type of Cost Plus and a billing type of Transaction Level or Project Trx Level.

1. Select Reports > Job Cost > Billing Reports > Transaction Level Reports > Transaction Detail.
2. From the Range drop-down list, select Job Number or Enter Date.
3. Use the From and To lookup buttons to select a range of job numbers or date range. Select Insert >>.
4. Select Print.

Transaction Summary Report

The Transaction Summary report lists summary information of transactions made in a range of jobs, over a range of dates. If you do not select a date range, the job transactions will be listed for all dates. If you select a date range but do not select a range of jobs, all job transactions will be listed for that date range.
This report can only be printed for jobs that have a contract type of Cost Plus and a billing type of Transaction Level or Project Trx Level.

1. Select Reports > Job Cost > Billing Reports > Transaction Level Reports > Transaction Summary.
2. Use the Ranges drop-down list to select a range type.
3. Use the From and To lookup buttons to select the print range. Select Insert >>.
4. If you want to further restrict the range, select the other range type and enter the range.
5. Select Print.

Aged Trial Balance Report

The Aged Trial Balance report is a statement of all the open debit and credit items in a double-entry ledger to show the equality and maturity from an entered date. You can print an Aged Trial Balance report for each job. You must run the receivables aging process routine (Routines > Sales > Aging) before printing the report.

This report will not include closed jobs. If you would like your report to include closed jobs, you can use the SRS Aged Trial Balance report. You must have SRS reports enabled to print the SRS Aged Trial Balance report.

1. Select Reports > Job Cost > Billing Reports > Aged Trial Balance.
2. Enter a Date from which to start aging. Items dated later than the date entered here will not be included on the report.
3. If you want to print the report for a specific project manager, mark the By Manager checkbox and enter the manager.
4. Select a sorting method from the Sort drop-down list. You can sort by job number or customer ID. If you sort by customer ID, the report includes a Retainer column.
5. Select range type from the drop-down list. Use the From and To lookup buttons to select the print range. Select Insert >>.
6. Select Print.