Accounting Reports

Accounting reports are available in all purchased RepairCenter modules; however, some reports are specific to a particular module. See Accounting Reports Available below.

Accounting reports are primarily accessed from the Reports menu, then from the Accounting tab.

On the Reports > Accounting tab, the Category column indicates whether a report provides information on all jobs or only on the job currently selected on the Whiteboard.

From the list of accounting reports, you can print a wide variety of information on accounts payable, accounts receivable, payroll, time cards, the chart of accounts, and invoicing.

How to

  1. Click the Reports menu .
  2. Select Accounting from the menu list; this takes you to the Accounting tab.
  3. From the list of reports, click on and highlight the report you wish to print.
  4. The available filters and criteria for that specific report appear below the report list; the exception is the date range filter, which appears above the list.
  5. Select the date range for your report, using the Start Date and End Date calendars.
  6. In the area below the report list, define the desired criteria or filter by selecting check boxes, entering information in boxes, or selecting from lists.
  7. To view the report on the screen, click the Print Preview button.
  8. To send the report to your printer, click the Print button.

Use the View Job Listing feature as a shortcut to print reports directly from the Reports menu without returning to the Whiteboard.

  1. Click the Reports menu .
  2. Click General; this takes you to the General tab.
  3. In the bottom section of the tab, click the down arrow next to View Job Listing. The job listing information for all current repair orders appears.
  4. From the General tab, print job-specific reports without having to access the Whiteboard. (See Reports for details.)
  5. To view the report on the screen, click the Print Preview button.
  6. To send the report to your printer, click the Print button.

Reference

The following is a general summary of the accounting reports available, as well as a sample of the columns and fields in the report. A symbol before a report in this list indicates a recommended report; it includes how it should be filtered, as well as the purpose of the report.

  • A/P Posting Status (#161) – This report provides a summary and totals of your shop's accounts payable amounts that have been transferred to accounting, across all jobs, sorted by vendors and invoice numbers. It is available with the Accounting Interface module, which is included in the RepairCenter Essential, Professional, and Premiere Accounting packages.
  • A/P Pre-Posting (#160) – This report provides a summary and totals of your shop's accounts payable amounts that have not been transferred to accounting, across all jobs, sorted by vendors and invoice numbers. It is available with the QuickBooks Interface module, which is included in the RepairCenter QuickStart Accounting package.
  • A/R Aging Detail (#135) – This report provides a summary and totals for outstanding accounts receivable, sorted by date outstanding, and filtered according to date type across all jobs. It is available with the Payments module, which is included in the RepairCenter Essentials, Professional and Premiere packages.
  • A/R Payments Report (#31) – This report provides the amounts paid and amounts due based upon the selected date type, across all jobs. It is available with the Payments module, which is included in the RepairCenter Essentials, Professional and Premiere packages.
  • A/R Post-Posting (#159) – This report provides a summary and totals of your shop's accounts receivable post-posting amounts, across all jobs, sorted by date, insurance companies, and invoice numbers. It is available with the QuickBooks Interface module, which is included in the RepairCenter QuickStart Accounting package.
  • A/R Pre-Posting (#158) – This report provides a summary and totals of the accounts receivable pre-posting amounts for your shop, across all jobs, sorted by date, insurance companies, and invoice numbers. It is available with the QuickBooks Interface module, which is included in the RepairCenter QuickStart Accounting, Essentials, Professional, and Premier packages.

  • Chart of Accounts (#25) – This report presents your Chart of Accounts as they are set within RepairCenter. You may want to print this report to use as a worksheet for comparing it to your accounting system. It is available with all RepairCenter purchased modules. The P column indicates a payroll-related profit center. The T column indicates whether the profit center is taxable. The E column indicates whether the profit center is enabled.

  • Credit Memo Post-Posting (#163) – This report lists the results of the post-posting credit memos to your external accounting system for the selected date range, across all jobs. It is available with the QuickBooks Interface module, which is included in the RepairCenter QuickStart Accounting, Essentials, Professional, and Premiere packages.
  • Credit Memo Pre-Posting (#162) – This report lists the results of the pre-posting credit memos to your external accounting system for the selected date range, across all jobs. It is available with the QuickBooks Interface module, which is included in the RepairCenter QuickStart Accounting, Essentials, Professional, and Premiere packages.
  • Deleted Jobs (#170) – This report provides a list of jobs that have been deleted in RepairCenter. It is available with all RepairCenter purchased modules. The time it was deleted will be shown in the Date column. The Author will be the user logged-in when the repair order was deleted.
  • Employee Time Cards Report (#58) – This report is used to assist in preparing your payroll by showing the total hours, dollars (hourly employees), and profit centers for the selected date range, across all jobs. It is available with the Shop Clock module, which is included in the RepairCenter Premier package.
  • Estimator Payroll Report (#110) –This report provides delivered, closed jobs, by estimator, for the selected date range, across all jobs. It is available with all RepairCenter purchased modules.
  • Final Flag Payroll Report – Classic (#59) – This report displays the final amounts flagged for the selected date range, sorted by technician or profit center, across all jobs. It is available with the Labor Management module, which is included in the RepairCenter Essentials, Professional, and Premiere packages.
  • Invoice (#22) – This report provides an invoice for the customer for the currently highlighted job. It is available with all RepairCenter purchased modules. This report is used as the final bill for the customer. The P column indicates who is responsible for the payment for the line (C = Customer; I = Insurance). It is recommended that the report be filtered with Include Supplement Information, even if there is no supplement. This will add a summary box of all profit center totals on the repair order.
  • Invoices (Payables) by RO (#94) – This report summarizes, by invoice date, RO, and vendor, the invoices on each RO with a total. It is available with the Parts, Sublet, and Services module, which is included in the RepairCenter QuickStart Parts, Essentials, Professional, and Premiere packages.
  • Never Post Invoice and Credit Memo Report - Classic (#168) – This report lists all invoices and credit memos with a “Never Post” status, within the date range, selected across all jobs. It is available with the Parts, Sublet, and Services module, which is included in the RepairCenter QuickStart Parts, Essentials, Professional, and Premiere packages.
  • Payables Evaluation (#140) – This report shows the payables for the jobs in a selected date range, filtered for the date type, selected across all jobs. It is available with the Parts, Sublet, and Services module, which is included in the RepairCenter QuickStart Parts, Essentials, Professional, and Premiere packages.
  • Payment Responsibility Report (#116) - This report shows the amounts and responsible parties for the currently highlighted RO from the Whiteboard. It is available with all RepairCenter purchased modules.
  • Payments (#71) – This report summarizes all of the payments made on the currently highlighted job. It is available with the Payments module, which is included in the RepairCenter Essentials, Professional, and Premiere packages.
  • Sales Journal Report - Classic (#70) – This report shows the customer name, profit center sales dollar, tax amounts, and total sales for each repair order within a selected date range. It is available with all RepairCenter purchased modules.
  • Shop Clock Time Card Report - (#35) – This report is used to assist in preparing your payroll by showing the total hours and dollars (hourly employees) and the profit center for the selected date range, across all jobs. It is available with the Shop Clock module, which is included in the RepairCenter Premiere package. When using Shop Clock, the Start, Stop, and Gap hours print on the report individually, as well as a recap by profit center for the selected pay period.
  • Technician Payroll Report (#49) – This report is used to determine the payroll for your technicians. It is available with the Labor Management module, which is included in the RepairCenter Essentials, Professional, and Premiere packages. This report is always run using your payroll period date range. It is recommended that you filter for employees and include assigned hours. Don't include transferred, and always by Posted Date.
  • Time Cards by RO - Classic (#63) – This report lists the time card entries for the currently highlighted RO from the Whiteboard. It is available with the Shop Clock module, which is included in the RepairCenter Premiere package.
Related Topics Link IconRelated topics