All Accounting Reports V8

Introduction

Here is a comprehensive list of all accounting reports. There are six subsections for Accounting Reports:

Lookup
Sales
Tax
General Ledger
Customer
Other

Under these folders, there are knowledgebase articles to guide you on what reports are available in RMA. The following articles are organized by folder.

Lookup Folder

Invoice Reprint V8

The Invoice Reprint option allows users to reprint any invoice created on either the desktop or handheld device. To access this feature, go to Reports > Accounting Reports > Lookup > Invoice Reprint.

The Invoice Lookup option enables users to search for a specific invoice using criteria such as invoice number, amount, or P.O. number. To use this feature, navigate to Reports > Accounting Reports > Lookup > Invoice Lookup.

Payment Lookup Report V8

The Payment Lookup option allows users to search for specific payments using criteria such as check number, amount, batch number, and more. To access this feature, go to Reports > Accounting Reports > Lookup > Payment Lookup.

Open Invoices Report V8

The Open Invoices Report allows you to view all of the unpaid invoices within each customer’s account.

Paid Invoices Report V8

The Paid Invoices report, found under Reports > Accounting Reports > Lookup > Paid Invoices, lists all paid invoices on Open Item accounts.

Customer Transactions Report V8

The Customer Transaction Report, available at Reports > Accounting Reports > Lookup > Customer Transaction Report, lists all transactions based on the specified criteria.

Sales Folder

Sales Detail Report V8

The Sales Detail Report, found under Reports > Accounting Reports > Sales > Sales Detail Report, provides detailed product sales figures based on various criteria. This versatile report can generate multiple outputs depending on the sort options selected. It only shows posted amounts and does not include sales tax.

Sales Comparison Report V8

The Sales Comparison Report (Reports > Accounting Reports > Sales > Sales Comparison Report) provides detailed product sales figures based on multiple date ranges and a variety of additional criteria. Use the sort options to provide different styles of reporting, and then choose your filter options and the "Comparison Periods".

Gross Profit Comparison Report V8

The Gross Profit Comparison Report, located at Reports > Accounting Reports > Sales > Gross Profit Comparison Report, displays gross profit comparisons to previous years.

Daily Sales Report V8

The Daily Sales Report allows you to print a sales report for a selected date. The report contains summarized posted totals for the date listed. Navigate to Reports > Accounting Reports > Sales > Daily Sales Report.

Customer Sales by Product Class

The "Customer Sales by Product Class" report provides detailed sales information categorized by product class. Users can customize the report by selecting date ranges, account numbers, major account codes, and customer types.

Payment Summary from History Report V8

This report includes a summary of payments received for the date and route entered. Find this report under Reports > Accounting Reports > Sales > Payment Summary from History.

Cash Received by Employee Report V8

This report includes payments collected by Sales Reps or Drivers. Find this report under Reports > Accounting Reports > Sales > Cash Received by Employee Report. This report is often used to pay commissions based on payment received totals.

Disputed Invoices V8

The Disputed Invoices option allows you to dispute and resolve invoice problems with customers. To access this, go to Transactions > Payments > Disputed Invoices (Alternatively, simply right-click on an invoice listed within the Open Invoices section of a customer’s account to Dispute or Resolve items).

Invoice Discount Report V8

The Invoice Discount Report is designed to give a detailed view of invoice discounts based on the specified filters, helping users analyze sales and customer data effectively. To view this report, navigate to Reports > Accounting Reports > Sales > Invoice Discount Report.

Prepay Quantities Report V8

This report provides detailed information on each customer's Prepay Products, including quantities and associated details.

Sales Summary by Deposit Type Report V8

This report provides the Deposits On-Hand value and previous delivery values for each deposit type, categorized by account.

Sales vs. Returns Report V8

The Sales vs. Returns Report includes detailed sales and product return information that also calculates the percentage of sales vs. returns for the date range entered. Access: Reports > Accounting Reports > Sales > Sales vs. Returns Report.

Weekly Returns Report V8

The Weekly Returns Report includes detailed product return information for any seven day period. Additionally, this report includes product quantities, dollar values, and percentage information. Access: Reports > Accounting Reports > Sales > Weekly Returns Report.

Returns by Reason Report V8

The Returns by Reason Report includes detailed product return information listed per Return Code Reason. Access: Reports > Accounting Reports > Sales > Returns by Reason Report.

Tax Folder

Sales and Tax Report V8

This report provides sales and tax information separated by month, quarter, and year-to-date.

Sales Tax Collected Report V8

This report includes the total amount of taxes collected from your customers. It only reflects items for which payments have been applied to an invoice. Any payments not applied to an invoice will not be reflected in the sales or tax collected within this report. To view the report, navigate to Reports > Accounting Reports > Tax > Sales Tax Collected.

Motor Fuels Tax Report V8

The "Motor Fuel Tax Report" interface shown in the image allows users to generate a report detailing motor fuel tax information.

Asset Tax Report V8

The "Asset Tax Report" interface shown in the image allows users to generate a report detailing tax information related to assets.

General Ledger Folder

Reprint G/L Report V8

This option allows you to generate G/L totals based on the range of dates entered. It also allows you to do a data export for GL transactions.

Customer Folder

Aging Analysis Report V8

This report displays customer balances by the number of days outstanding and identifies the accounts that have fallen behind in payments. Locate this report under Reports > Accounting Reports > Customer > Aging Analysis.

Collections Accounts Report V8

Use this report to view customers that are assigned to a ‘Collections’ type Credit Class Code within Customer Information. The Collections Accounts report can be found under Reports > Accounting Reports > Customer > Collections Accounts.

Returned Checks Report V8

This report includes information regarding unpaid, and paid, returned checks processed through Route Manager. The Returned Checks report can be found under Reports > Accounting Reports > Customer > Returned Checks Report.

Inactive Accounts with Balances Report V8

Use this report to view accounts that are inactive, but have a remaining balance. The Inactive Accounts with Balances report can be found under Reports > Accounting Reports > Customer > Inactive Accounts w/Balances.

Customer Credit Limit Report V8

This report identifies customers that have exceeded their assigned credit limit. The Customer Credit Limit Report can be found under Reports > Accounting Reports > Customer > Customer Credit Limit Report.

Customer Refunds List Report V8

This report includes information regarding customers that have a credit balance and are no longer active. The Customer Refunds List report can be found under Reports > Accounting Reports > Customer > Customer Refunds List.

Consolidated Billing Summary Report V8

This report includes a balance summary of each account assigned to the Consolidated Statement option within Customer Information. The Consolidated Billing Summary report can be found under Reports > Accounting Reports > Customer > Consolidated Billing Summary.

Account Deposits V8

Account Deposits in RMA is a feature that lets you collect money from a customer and hold that as a deposit until they either quit or it is no longer needed to hold the money - perhaps their credit has improved.

Advanced Pricing by Customer V8

This report includes information related to advanced pricing assigned to each customer.

Point Status Report V8

Use this report to view earned points per customer, as part of the Customer Retention Program. The Point Status Report can be found under Reports > Accounting Reports > Customer > Point Status Report.

Top Customer Report V8

This report allows you to view customers that are purchasing a high volume of items from the company. The Top Customer Report can be found under Reports > Accounting Reports > Customer > Top Customer Report.

Top Customer by Geographic Area Report V8

Use this report to display the top customers in each geographic area serviced by your company. The Top Customer by Geographic Area report can be found under Reports > Accounting Reports > Customer > Top Customer by Geographic Area.

Customer Snapshot Report V8

The Customer Snapshot Report will calculate average rent price as well as list all customers and details about them: EQ Install date, Last Delivery, if they are terminated and/or past due and their To Date Revenue.