Inventory Base Report

To see your inventory base, run the Inventory Base Report in Bravo.

First, Select "Reports" from the Bravo Dashboard:

Next, select "Inventory Base" from the list of Inventory Reports:

Once you click "Preview" you will see a pop-up box to configure the report:

Enter a range of dates to view and click OK to see your report.

The first section of the report shows transaction totals by date.

The starting Base is at the left of the report and then you can see the following totals:

• Starting Inventory Base
  • Cost of items in Inventory on the date in question.
  • Qty refers to the quantity of individual items.
• Buys, Bought Loans, Trade-Ins
  • These are values of all Buy tickets, purchased Loan tickets and Trade-Ins for the date.
• Expirations
  • These are all loans that have expired to Inventory
• Returns (Cost of Sales)
  • Value of all returned items
• Vendor Purchase/Return
  • Value of all items purchased from vendor, minus value of all items written off using the "Return to Vendor" write-off reason.
• Transfers In
  • All items transferred in from other stores
• Transfers Out Received
  • All items transferred out that have been received in other stores
• Police Confiscations
  • Items confiscated by the police
• Sales (Cost of Sales)
  • Items sold (COGS)
  • This number can be compared to Cost on the Sales Deep Dive BRP
• Shrinkage
  • Items written off (not confiscated)
• Donations
  • Items donated
• Refined (Cost of Sales)
  • Items sold as part of the scrap refining process
• Reactivated Loans
  • Value of loans that are reactivated
• Cost Adjustments
  • Manual cost adjustments to items
• Voids/Other
  • This value comes up if there is a void that took place and/or as a balance account if something happened in the system that made it so the Ending Inventory Base would be off compared to what the actual cost of items are.
    • EX: The same item got converted to a SKU twice by two different users. The cost of items would go up by the value of one of those items, so the Voids/Other field would compensate to allow the system to still show the accurate Ending Inventory Balance.
• Ending Inventory Base
  • Cost of the items in inventory at the end of the day
  • This number can be compared to Cost on the Active Inventory BRP

The last page of the report shows the overall numbers:

The column called "Day" refers to the last business date of the reporting range.

The column called "Month" refers to the range as a whole.

To get the final number take the starting inventory base number

Note: Any items currently in a Lost or Damaged Event will still be counted on your inventory base.

• Add Buys, Bought Loans, Trade-Ins
• Add Expirations
• Add Returns
• Vendor Purchase/Return (header)
  • Add Vendor Purchase
  • Subtract Vendor Returns
• Add Transfers in
• Subtract Transfers Out
• Subtract Police Confiscations
• Subtract Sales
• Subtract Shrinkage
• Subtract Donations
• Subtract Refined
• Cost Adjustments will be either added or subtracted depending on the number (Add positive numbers and subtract negative numbers)
• Voids/Other will be either added or subtracted depending on the number (Add positive numbers and subtract negative numbers)
• Transfers Out, In Transit will be either added or subtracted depending on the number (Add positive numbers and subtract negative numbers)

This calculation should give you your ending inventory base.

• Transfers Out, In Transit Balance is the Balance as of the End Date of the report of all items that have been transferred out of this store and have yet to be received in the other stores