1. Go to Analysis > Information Library 
  2. Click to Add a new Ad-hoc query 
  3. Select the source view of Sales Order and click OK. 
  4. In the left column (Browse for Fields In), expand Sales Order Item Payment. Here you will be able to see details about the payments, the user that processed the payments, and the drawer close information. Here are a few suggestions for fields to drag into Include Records Where: 
    InformationField Needed
    Payment DateSales Order Item Payment\Revenue\Date
    Drawer Close DateSales Order Item Payment\Drawer Close\Drawer Close Date
    Drawer StatusSales Order Item Payment\Drawer Close\Status (status will be one of Submitted, Approved, or Deposited)
    UserSales Order Item Payment\Application User\Application User Record (this will allow you to search for a specific user)
  5. Next, to see information about what was in the drawer, we suggest adding the following fields in to Results Fields to Display: 
    InformationField Needed
    Payment Method (Cash, Check, etc.)Sales Order Item Payment\Revenue\Payment Method
    Payment AmountSales Order Item Payment\Amount
    Payment DateSales Order Item Payment\Revenue\Payment Date
    Refund AmountSales Order Item\Refunds\Refund Payment\Amount
    UsernameSales Order Item Payment\Application User\Display Name
    Drawer Close DateSales Order Item Payment\Drawer Close\Drawer Close Date
    Deposited Cash AmountSales Order Item Payment\Drawer Close\Deposited Cash Amount
    Starting Cash AmountSales Order Item Payment\Drawer Close\Starting Cash Amount
    Drawer Status

    Sales Order Item Payment\Drawer Close\Status (status will be one of Submitted, Approved, or Deposited)

  6. Here is a screenshot example of a query that is looking for details on all drawers closed today with a Status of Deposited:
    User-added image
  7. Here is a preview of results: 
    Results Example
  8. You can see there is a row for each sale that was processed through the drawer. While we can only see limited information, you can see what the cashier entered as their Deposited Cash Amount (Ending Cash - Starting Cash). In the example above, the cashier processed $130 in cash transactions, but their deposited cash amount was only $100. This query does not count refunds (only sales), so we can run the Refund Report to see if this user processed any refunds. If they had not processed any refunds, we can assume that their drawer was $30 short.