This article describes how to access and read the Auction Summary Report in Wavebid.
This article contains the following sections:
Accessing the Report
To access the Auction Summary Report, navigate to the applicable auction from the Dashboard, then select Accounting > Reports > Auction Summary.
The report updates as lots are clerked and payments are made/issued.
The "Data Accurate As Of" date is visible in the top left corner of the report.
To print a copy of the report, click the Print button in the top right corner of the page.
Report Tables
Payment Breakdown Table
This table displays the following values for the current auction:
- Hammer Price: The total hammer price for the auction, as well as the amounts collected and outstanding as of the report date.
- Fees: The total amount charged in fees in the auction, as well as the amounts collected and outstanding as of the report date. For more information about fees, see Fee Management.
- Tax: The total tax charged to bidders, as well as the amounts collected and outstanding as of the report date. For more information, see Applying Tax Codes.
- Buyer's Premium: The total amount charged in Buyer's Premium fees in the auction, as well as the amounts collected and outstanding as of the report date. For more information, see Buyer's Premiums.
- Conv. Fees/Add. CC BP: The total amount charged in convenience/credit card fees in the auction, as well as the amounts collected and outstanding as of the report date. For more information, see the 'Accounting Tab' section in the Auction Settings help article.
- Totals: The total of all the values listed above.
Other Income Table
This table displays the total amount of expenses and commissions charged for the auction.
- Clicking the Billable Expenses link will open the Expense Report. For more information, see Seller Expenses and Credits.
- Clicking the Commission link will open the Seller Summary page. For more information, see Seller Commissions.
Debits Table
This table displays any Overage in Expenses, which includes expenses applied to sellers that exceed the Max Expense amount entered when the seller was checked-in.
- If no Max Expense amounts have been entered for any sellers, the Overage in Expense amount will display as $0. For more information, see Seller Expenses and Credits.
This table also displays Refunds Due, which consists of any overpayments issued as "apply to balance".
- For more information on refunds, see Invoice Refunds and Discounts and Payments.
- A list of refunds recorded for an event can be found on the Reconciliation report.
Totals Table
This table displays the following values for the current auction:
- Auction Total: The total hammer price, fees, premiums, bidder taxes, etc. See the Totals column and row in the Payment Breakdown table above.
- Due to Sellers: The total amount due to sellers. Clicking the Due to Sellers link will open the Seller Summary page.
- Paid to Sellers: The total amount paid to sellers as of the report date. Clicking the Paid to Sellers link will open the Seller Summary page.
- Gross Profit Subtotal: The Auction Total minus the amount Due to Sellers and the amount Paid to Sellers, if applicable.
- Debits Total: The total amount from the Debits table (above).
- Taxes Total: The total amount of taxes due. For more information, see the Tax Summary Report.
- Auction Net: The Gross Profit Subtotal minus the Debits Total and the Taxes Total.
Payment Type Details Table
This table displays the total dollar amount received using each payment method, and the total payments collected as of the report date.
Values in parentheses are outgoing payments, such as refunds. Refunds issued as 'Company Check' will be deducted from the 'Other' total. For more information, see Payments.
Auction Details Table
This table displays the following values for the current auction:
- Total Lots: The total number of lots in the auction.
- Total Photos: The total number of photos, videos, and PDFs added to lots. For more information, see Lot Builder.
- Photos Per Lot: The average number of photos per lot.
- Price Per Lot: The average price per lot. This is the total selling price of all lots divided by the total number of lots (including unsold lots).
- Expense Per Lot: The average expense per lot. This is the total cost of all the expenses for the auction divided by the total number of lots (including unsold lots). For more information, see Seller Expenses and Credits.
- Profit Per Lot: The average profit per lot. This is the Auction Net (see Totals above) divided by the total number of lots (including unsold lots)
Invoices Table
This table displays the total number of invoices in the auction that have been Paid in Full, Partially Paid, and are Unpaid.
For more information on tracking invoice status, see Invoices Page.
For more information on payments, see Payments.
Lots Table
This table displays the total number of lots in the auction that were clerked as either Pass, Reserve Not Met, or House Number. For more information, see Clerking.
Buyer's Premium Breakdown Table
The Buyer's Premium Breakdown table displays the Buyer's Premium totals resulting from the applied BP scale. This section will only appear on the Auction Summary if a Buyer's Premium (BP) scale was applied to the auction. For more information on scales, see Buyer's Premiums.
If the BP was manually altered on any lots or invoices, those premiums will not be reflected in the Buyer's Premium Breakdown table.
If the BP was manually altered, the BP totals listed on the Buyer's Premium Breakdown table will be different from the BP totals listed on the Payment Breakdown table, as the Payment Breakdown table will reflect all Buyer's Premiums applied, regardless of whether they were applied via scale or manually.
- The amount in the Totals column to the left of a percentage is the total Buyer's Premium applied at that rate.
- The amount in the Totals column to the left of the Online Premium Amount displays the amount charged as the Online Premium. For more information relating to online bidders, see Bidder Check-In.
Troubleshooting
Invoice Discrepancies
If there are any discrepancies between Outstanding payments and/or Unpaid invoices when compared to the invoices themselves, the issue may be relating to clerking. Clerking or re-clerking lots without refreshing the invoices can cause discrepancies in reporting.
To resolve:
- Navigate to applicable auction from the Dashboard, then select Accounting > Invoices.
- Click the Refresh button in the top right corner. A pop up window will open.
- Click the Refresh This Page button to continue.
Seller Discrepancies
If there are any discrepancies between the Gross Profit and/or Commission data when compared to the auction totals or seller settlements, confirm that seller codes have been assigned to all sold lots.
To do so:
- Navigate to the applicable auction from the Dashboard, then select Auction > Preview Auction,
- Use the Columns button in the top right corner of the page to ensure the Seller column is visible on the Preview.
- Click on the Seller column header to sort the event by seller code. Lots missing a seller code will then either move to the top or bottom of the lots list.
- Add the correct Seller Code(s) to any sold lots. Once a seller code has been added to the sold lots, the reports should reflect accurate Gross Profit and Commission data.
Related Articles:
0 Comments