Accounting Reports in AcuityLogic BackOffice

Lists the patient balances for all, one, or multiple offices. The report begins with the current date and reports back to the date you enter in the Cutoff Date field.

You can report on all receivables or by the following time spans:

• Age: 0-30 days
• Age: 31-45 days
• Age: 46-60 days
• Age: 61-90 days
• Age: 91-120 days
• Age: Over 120 days

Select the Show AR Summary by Office check box to group balances by office.

You can also generate this report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Shows the amounts entered in the Actual column for each payment type when daily closings are performed in AcuityLogic POS. See Performing a Daily Closing.

You can report on all, one, or multiple offices within the date range you specify.

Note: The report includes only the days that a daily closing was performed in AcuityLogic POS.

Shows the amounts in the Computed column for each payment type when daily closings are performed in AcuityLogic POS. See Performing a Daily Closing.

The report provides the amounts recorded for all offices in your company within the date range you specify.

Shows the style, quantity, order total, and net sales for contact lenses prescribed by each doctor within the date range you specify.

Select the Show Details check box to show additional order information including patient name and order number.

Lists the patients and associated amounts sent to collection in AcuityLogic POS within the date range you specify.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Collections Report (AC134).

Shows the following:

• Which rules each doctor qualified for during the specified time period
• The total dollar amount each doctor is contracted to receive

You must set up doctor pay rules and doctor pay schedules in AcuityLogic Admin before generating this report. See Setting Up Doctor Payments.

Shows the cost of sale information by transaction within the date range you specify. For each transaction, the report provides the item cost, net sale, quantity sold, total cost, and margin amount.

You can report on all, one, or multiple items types for all, one, or multiple offices.

Shows the cost of sale information by office for the selected item type within the date range you specify. For each item, the report provides the item cost and sale price, quantity sold, total cost and sale amount, insurance allowance applied, discount, net sale, margin amount, and margin percentage.

You can report on all, one, or multiple offices.

If your company uses financial groups, you can report on all, one, or multiple financial groups. Select Group by Financial Group to group the details by financial group. See Maintaining Financial Groups.

When generating the report, select the Show Item Summary for ALL Offices check box to show the details for each item combined for the selected offices.

Select the Show Summary for Offices check box to show the details for all items combined for each office selected.

Shows the cost of sale information by transaction for the selected item type within the date range you specify. For each transaction, the report provides the item cost and sale price, quantity sold, total cost and sale amount, insurance allowance applied, discount, net sale, margin amount, and margin percentage.

You can report on all, one, or multiple offices.

If your company uses financial groups, you can report on all, one, or multiple financial groups. Select the Group by Financial Group check box to group the details by financial group.See Maintaining Financial Groups.

Shows information about the coupons used within the date range you specify. For each coupon, the report provides the start and end date, media type, total sale amount, insurance amount, discount, and patient paid amount.

You can report on all, one, or multiple coupons for all, one ,or multiple offices.

Coupons can be set up in AcuityLogic Admin. See Setting Up Coupons.

Lists customer credits that were added or removed within the date range you specify.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Customer Credit Report (AC149).

Gives you a quick view of the sales information by item type within the date range you specify.

You can report on all, one, or multiple offices.

The following options are available when generating the report:

• Summary – provides a summary by product type for all offices selected.
• Group by Office/Sales Category – provides details for each product type by category for each office selected. A total is provided for each office.
• Group by Region/Office/Sales Category – provides details for each product type by category for each office selected. The report is organized by region. A total is provided for each office and each region.
• Full Detail – provides a detailed report.

You can also generate this report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists the patient transactions for the date range you specify.

You can report on all, one, or multiple transaction types for all, one, or multiple offices.

You can also generate this report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists the discounts given on orders by employees for the date range you specify.

You can report on all, one, or multiple discount reasons for all, one, or multiple employees and offices.

When generating the report, select the Page break by Employee check box to show the results for each employee on a separate page.

Select the Exclude Returned Orders check box to exclude returned and partially returned orders from the results.

Shows a summary of the discounts given by employees for the date range you specify. For each employee, the report provides the sale amount, discount amount, and discount percentage.

You can report on all, one, or multiple offices.

Shows the following details for the selected offices for the date range you specify:

• Hours
• Dollars per hour
• Cash sales
• Exams
• Exam fees
• Insurance sales
• Total sales
• Total billed
• Payment
• Insurance payment
• Doctor SPIFF
• Net receipts

Shows details for the frames sold by office for the date range you specify. For each office, the report provide the number of frames sold, total sale amount, average sale amount, standard cost , gross profit, profit per unit, frame inventory amount, and number of turns.

You can report on all or one vendor for all, one, or multiple offices. If you select a vendor, you can report on all, one, or multiple collections.

If your company uses the General Ledger Interface, this report shows the calculated amounts for each office based on GL source and mapping. See Setting Up the General Ledger Interface.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and General Ledger Detail (AC120).

If your company uses the General Ledger Interface, you can generate this report to export general ledger transactions when you close the month in AcuityLogic BackOffice. See Exporting General Ledger Transactions from AcuityLogic.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and General Ledger Summary Report (AC111).

Lists sales by item type for an insurance carrier for the date range you specify. You can select all, one, or multiple plans for the selected carrier. For each item, the report provides the quantity sold, retail amount, net sale, discount, patient pay amount, allowance, copay, and receivable.

You can report on all, one, or multiple offices.

Shows the details and totals for all inventory transactions for one or more offices for the date range you specify.

You can report on frames, accessories, or both (all item types) for all, one, or multiple offices.

You can select the inventory transaction types and inventory quantity types to include in the report.

If your company uses financial groups, you can generate the report for all, one or, multiple financial groups. Select the Group by Financial Group check box to group the value of inventory items in each location by financial group. See Maintaining Financial Groups.

When generating the report, select the Combine Offices check box to show the details and totals for all locations together.

Select the Summary Only check box to omit individual transactions and to show only a total for each transaction type.

Select the Extended Reference check box to include a Reference column in the report that shows the patient or vendor associated with individual transactions. The Extended Reference option is not available if you select the Summary Only option.

Shows the value of system on-hand inventory items for one or more offices for the date you specify.

You can report on frames, accessories, or both (all item types) for all, one, or multiple offices.

If your company uses financial groups, you can generate the report for all, one or, multiple financial groups. Select the Group by Financial Group check box to group the value of inventory items in each location by financial group. See Maintaining Financial Groups.

When generating the report, select the Combine Offices check box to show the value of inventory items in all locations together.

Select the Include In Transit Items check box to include in-transit items in the report. In-transit items are listed after the on-hand items and have their own subtotal.

Select the Group by Office check box to show the value of inventory items by location.

Select the Group by Vendor check box to show the value of inventory items by vendor.

Select the Group by Collection check box to show the value of inventory items by collection.

You can also generate this report from AcuityLogic DC. See Reports in AcuityLogic DC.

Lists the sales for items for all, one, or multiple offices for the date range you specify.

You can report on all item statuses or a specific status. You must select a specific item type (such as Frames, Exams, Plans, and so on). Optionally, you can enter an item number to refine the report further.

Typically, the report is generated for frames. The report lists the frame name, collection, quantity sold, status, and net sales then total in sales. If a frame was bought and returned during the time period in the report, the Quantity column lists 0 for that frame.

For non-frame items, the Collection column contains no data. Eyeglass lenses are split by Base type, Material, Style, and Color/Coat and appear separately on the report.

If your company uses financial groups, you can generate the report for all, one or, multiple financial groups. Select the Group by Financial Group check box to group the value of inventory items in each location by financial group. See Maintaining Financial Groups.

When generating the report, select UPC or Item Number from the Show Optional Columns drop-down list to include either the UPC or item number on the report.

You can also generate this report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists patients that were refunded using the Mail Check option in AcuityLogic POS for the date range you specify.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Mail Check Report (AC131).

The Cost of Goods report shows transaction details for orders placed in the selected office. You can report on a date range or a specific month/year. You can narrow the report by transaction type and select to view a summary. This report exports to a CSV.

Shows payment details for patients with a Member ID set up in their profile. For each payment, the report provides the Member ID, patient name and birth date, payment amount, tax amount, net amount, office ID, and order number.

You can report on all, one, or multiple offices within the date range you specify.

Lists miscellaneous payments entered in AcuityLogic POS for the date range you specify.

You can report on all, one, or multiple miscellaneous payment reasons for all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Miscellaneous Payment Report (AC122).

Summarizes financial information for the date range you specify.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Monthly Business Summary Report (AC101).

Shows the totals recorded during daily closings in AcuityLogic POS by payment source. The report shows the totals for each day a daily closing was performed for the date range you specify.

You can report on all, one, or multiple offices.

Summarizes the totals recorded during daily closings in AcuityLogic POS by payment source for the selected month.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and Monthly Cash Summary Report (AC103).

Lists insurance sales by plan for the date range you specify. For each plan, the report provides the retail amount, discount, allowance, copay, customer amount, receivable, net sale, tax, customer amount, credit, and net AR.

You can report on all, one, or multiple offices.

When generating the report, select the Show Summary for Offices check box to combine the totals for each plan for the entire date range selected.

Lists the daily sales totals within the date range you specify. For each day, the report provides the retail amount, discount, allowance, copay, customer amount, receivable, net sale, tax, payment, credit, collection, and net AR.

You can report on all, one, or multiple offices.

When generating the report, select the Show Summary for Offices check box to combine the daily totals for each office for the date range selected.

Select the Show By Region check box to group offices by region and to show a total for each region.

Select both options to combine the daily totals for each office for the date range selected and to show a total for each region.

You can also generate the Monthly Sales Report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists the sales for two item types for all, one, or multiple offices for the date range you specify.

You can report on all, one, or multiple items for each item type selected. For each item, the report provides the UPC, item name, collection (frames only), number of orders, item quantity, item status, and net sales.

When generating the report, select the AND option to show sales that included both item types and select the OR option to show sales that included either item type.

Shows doctor commissions for eyeglass and contact lens orders for the date range you specify.

The following options are available when generating the report:

• By Doctor Summary – provides a summary for all, one, or multiple doctors.
• By Doctor Detail – provides details by order for one doctor. For each order, the report provides the office, order type, date, order number, system-generated transaction number, patient name, and total.
• By Office – provides a summary for all, one, or multiple offices.
• By Office By Doctor – provides a summary for all, one, or multiple offices and doctors.
• By Office By Doctor Detail – provides details by order for all, one, or multiple offices and doctors. For each order, the report provides the doctor, office, order type, date, order number, system-generated transaction number, patient name, and total.

Shows the gross and net sale totals by doctor for the date range you specify. The report also provides grand totals for gross and net sales.

Lists the customer credit balance for each patient on the date you enter in the Cut Off field.

You can report on all, one, or multiple offices.

Shows daily closing details and overage or shortage totals for the date range you specify.

You can report on all, one, or multiple offices.

When generating the report, select the Show By Region check box to group offices by region and to show totals for each region.

Shows a breakdown of patients by gender and age range for all, one, or multiple offices.

Lists the payments by payment type for the date range you specify. The report results are sorted by payment type (cash, check, Visa, and so on). For each payment, the report provides the payment number, order number, employee that recorded the payment, patient name, and amount.

You can report on all, one, or multiple offices.

You can also generate this report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists payouts recorded during daily closings for the date range you specify.

You can report on all, one, or multiple offices.

Lists net accounts receivable (AR) for the date range your specify.

You can report on all, one, or multiple offices.

For information on using this report to reconcile your monthly transactions, see Understanding Key Financial Reports and POS AR Report (AC150).

Lists the pricing options applied to orders by employees for the date range you specify.

You can report on all, one, or multiple pricing options for all, one, or multiple employees and offices.

When generating the report, select the Page break by Employee check box to show the results for each employee on a separate page.

Lists exams, fittings, and procedures performed by doctors for the date range your specify. For each item, the report provides the item name, office number, quantity, retail, discount, allowance, contractual expense, copay, tax, customer responsibility, net insurance receivable, and net sale.

You can report on all, one, or multiple exams, fittings, or procedures for all, one, or multiple doctors.

When generating the report, select the Page break by Doctor check box to show the results for each doctor on a separate page.

Lists the refunds or adjustments within the date range you specify.

You can report on all, one, or multiple offices.

For refunds, you can filter the report by refund reason and payment type.

For adjustments, you can filter the report by adjustment reason.

The report groups refunds and adjustments by reason and by employee for each office selected. Totals are provided for each employee, refund or adjustment reason, and office.

You can also generate the Refund / Adjustment Report for the office from which you are accessing AcuityLogic POS in the Standard Reports tab in the Reports section.

Lists the adjustments made within the date range you specify.

You can report on all, one, or multiple adjustment reasons for all, one, or, multiple offices.

The report groups adjustments by office and provides a total for each office selected.

Lists sales by insurance plan for the date range you specify.

You can report on all, one, or multiple carriers for all, one, or multiple offices.

When generating the report, select the Show Summary for Offices check box to show the totals for each plan combined for all selected offices.

Shows the sales tax invoiced for the date range you specify. If you use the Multi-Tier Sales Tax Calculator, the report shows the sales tax invoiced for each tax authority.

You can report on all, one, or multiple offices.

When generating the report, select the Group By Office check box to show sales tax invoiced by location.

Select the Show Item Types check box to show sales tax invoiced by item type.

List transaction details for the date range you specify. For each transaction, the report provides the system-generated transaction number, date, transaction type, patient name, insurance, order number, net sales, tax, payments, prepaid (managed care) amount, insurance amount, patient receivable, and gift certificate amount.