The End of Day Consolidated Report in Bravo is one of two reports provided that show the daily sales and loan activity for your store. The End of Day Consolidated Report provides the relevant numbers in a reporting format as opposed to the list format of the End of Day Report.
Accessing the Report
To access this report, first select "Reports" from the Bravo Dashboard:
Next select "End of Day - Consolidated" from "Closing Report" on the report screen. Click Preview.
Enter your date into the configuration screen:
You will get a report that looks like this:
There are several options on this page:
- Print the report to the Reports printer as set up in Bravo
- Flip from page to page in the report.
- Zoom in to the report.
- Save the report as one of the formats listed under the drop down menu (**the email icon also saves a file)
- Display the report in a new window.
If you are saving the report, you can choose one of the following file formats:
The Data
The End of Day Consolidated Report is three (3) pages long. The first page is the pawn activity. The second page shows sales activity and closing amounts. The third page shows revenue, layaway activity, and closing amounts by tender as well as transaction totals and cash disbursements.
End of Day - Consolidated: Pawn/Sales Activity
The first page of the end of day consolidated report shows the details of the Pawn Activity. The second page shows the Sales Activity (and the opening and closing amounts by till.) The first two pages of the End of Day Consolidated Report are almost exactly the same as the last two pages of the End of Month report. For more information on the End of Day Month report, see the article here . (Link opens in new window).
Pawn Activity
The Pawn Activity page shows all of the various pawn totals. It is broken out into several sections.
- New Loans, Buys, Trade-Ins, Bought Tickets, Bought Tickets via Inter-Store Transactions (Total Out)
- Renewals, Partial Payments, Extensions, Redemptions (In-Store and Inter-Store) (Total In)
- Reactivated Loans, Expired Buys/Trade-Ins, Expired Loans
The first section details all of the money that your store putout in Pawns/Buys and Trade-Ins for the day:
On this section, you can see the total number of transactions, the Loan/Buy amount Paid out, any up-front fees collected, and a net total paid out. There is a section for all transactions that came in through your store directly, and if you are a multi-store company utilizing inter-store transactions, you can see a separate line of any bought tickets that happened at any other store.
NOTE:
- In-Store transactions are transactions made in that store but also any Web Transactions or MobilePawn Transactions.
- Inter-Store transactions are transactions where a different store in your company took in a payment on a loan/layaway that the customer had at the store running this report.
Example of Inter-Store transaction:
- Customer has a loan at TST, the customer goes over to store TXT (a store in the same company) and makes a payment on their loan at TST. If the store TST were to run the End of Day Consolidated report, they will see a payment made in the Inter-Store section of the Pawn Activity.
The next section shows the pawn payment activity. This is the total amount taken in for Renewals, Partial Payments, Extensions and Redemptions:
In this section, you can see the total number of transactions, payment totals for Renewals, Extensions, Redemptions and Partial Payments. You can see the loan principal involved, the break out of Principal Payment, Interest and Fees, any Miscellaneous Charges and the total collected by type.
If you are a multi-store company and utilizing inter-store transactions, you can see a detail of the transactions that came into your store, as well as the transactions that have come into other stores for your store's loans.
The Bottom line shows the overall total of money taken in.
The last piece of the Pawn Activity Summary shows quantity and totals for all Reactivated Loans, any Expired Buys or Trade-Ins, and for Expired Loans.
Sales Activity
The Sales Activity section of the End of Day Consolidated Report will show a detail of all of the sales taken in for the day.
The first part shows a total of all taxable sales, returns, non-taxable sales and returns, and taxable and non-taxable consignment sales and returns.
You are able to see the total quantity of transactions as well as sales that came in via the web vs the store, and if there were any shipping and fees involved.
The total at the far right represents gross sales for the day.
The above figures do not include layaways or firearms. Because layaways are not considered final sales until the final payment is received and items are picked up, and firearms are not considered final sales until the background check is passed and the item is picked up, these two numbers are broken out to their own section of the report:
Layaway Sale Redemption = all layaways with final payments received and items have been picked up.
Firearm Sale Pickups Redemption = all firearm sales that have been approved by the ATF and the items have been picked up.
The sales total on this line represents all sales INCLUDING layaway and firearm redemption.
Lastly, the report shows the Cost of goods Sold, and Consignment Payables.
By subtracting this amount, you will get the Net Revenue (Profit). There are separate lines to provide visibility to the Sales Tax collected, the Gift Cards sold and any Firearm payments that have been received, but not finalized (Picked-Up)
Sales Tax shown in this section does NOT include Hold Sales or Layaway payments. Only items that have been picked up have the Sales Tax information shown in this section. Use this Sales Tax figure to report on what you collected for sales on this day.
Store Pays Convenience Fee (Internal Charges)
Customer Pays Convenience Fee (External Charges)
This section contains all of the payments made on MobilePawn. The Loan Payments and Loan Renewals will also be in the Pawn Activity section from earlier.
The Customers Active section is showing how many customers made the payments seen in the Mobile Pawn Activity section
This section will only be seen if the store received a Mobile Pawn payment on the day the report was ran.
The MobilePawn Convenience Fees that the customer paid are shown at the very bottom to indicate how much their customer's paid in Convenience Fees that is going to Bravo on the External Charges version. Internal Charges does not have this line as the Convenience Fee is paid by the store.
End of Day - Consolidated: Open/Close Store
Open Store
The open store section of the End of Day Consolidated Report details the expected and actual amount in each till for the store's opening:
There is a line for each till, one for online sales, and a line for the store safe. The expected amounts are populated with the closing amounts from the prior day. The actual amount is the sum of what is entered in during the store and till opening process.
The column labeled over/short will display any variance in the opening figures.
For more information on store opening, see the article here. (Link will open in a new window.)
Close Store
The close store section of the End of Day Consolidated Report details the expected and actual amount in each till for the store's closing:
There is a line for each till, one for online sales, and a line for the store safe. The expected amounts are populated with the closing amounts from the prior day. The actual amount is the sum of what is entered in during the store and till opening process.
In addition to the till totals, there is also a line showing the total transfers from the tills to the safe. The closing total shows the total of all tills and the safe before any money is transferred to the bank.
The Closing Bank Withdrawal/(Deposit) shows any movement between the Bank and the Safe. If money is transferred in it shows as a positive. This is a withdrawal from the bank to the safe. If money is transferred out (such as credit card slips) it shows a a negative. This is a deposit to the bank from the safe.
The column labeled over/short will display any variance in the closing figures.
For more information on store closing, see the article here. (Link will open in a new window.)
End of Day - Consolidated: Page 3
The third and last page of the End of Day Consolidated report shows the Total Net Revenue, Layaway Detail, Repairs, Cash Flow, Closing Tender Count, and Paid Out activity.
Total Net Revenue
This is the total revenue for the store during the course of daily operations across all transactions and a total from the day. This total is the sum of Total Pawn Interest + Pawn Total Fees + Total Pawn Misc Charges + Sales Revenue (Profit) - Surplus Paid Out.
Layaway Detail
The Layaway Detail chart shows the net change over the day to the store's layaway deposits and the layaway balance. The center line shows any layaway credits that are paid out.
The top section consists of the following figures:
- New Layaway Balance
- Total number of and balance amount of New Layaway Payments
- New Layaway Taxes
- Total amount of taxes that have been paid on new layaway payments
- Down Payment
- Total amount collected on payments which were made on a layaway to start the layaway period
- Payments via In-Store Transactions
- The total value collected from payments made on existing layaways that are already in the layaway period collected in the store.
- Payments via Inter-Store Txns
- The total value collected from payments made on existing layaways that are already in the layaway period collected in another store within the company.
- Balance on Expired Layaways
- The total value of Layaways that have gone past the initial layaway period without the total amount of the items price collected through payments during the layaway period.
- Balance on Canceled Layaways
- The total value which would be due to a customer if they came in to collect on layaways that have been cancelled. If the store gives store credit, this would be the credit amount due to a customer.
- Net Change to Layaway Balance
- This is the change in the in the layaway balance due to transactions, expirations, and cancellations = New Layaway Balance + New Layaway Taxes - (Down Payments + Payments + Balance on expired Layaways + Balance on Canceled Layaways)
The center line shows all store layaway credits which have been paid.
The second section consists of the following figures:
- Credits Paid Out
- This is store credit which has been paid out for the cancellation of layaways
- Down Payments
- Total amount collected on payments which were made on a layaway to start the layaway period.
- Payments via In-Store Transactions
- The total value collected from payments made on existing layaways that are already in the layaway period collected in the store.
- Payments via Inter-Store Txns
- The total value collected from payments made on existing layaways that are already in the layaway period collected in another store within the company.
- Redemptions Sale Price
- This is the count of and amount of layaway that have been paid in full by the customer to close out the layaway period. The customer actually takes ownership of the merchandise.
- Redemptions Tax
- This is the amount of sales tax collected on finalized layaways. (When the customer makes the final payment and takes ownership of the merchandise)
- Cancellations
- The count of and amount of items which have been cancelled either by the store or by the customer
- Expirations
- Total number of and amounts of layaways which have passed the designated time period without paying the total layaway amounts.
- Net Change to Layaway Deposits
- This is the change to the deposit amount due to transactions, expirations, and cancellations = Down Payments + Payments - (Redemptions + Cancellations + Expirations).
To learn more about the Layaway Balance Report, click here . (Link opens in new window.)
To learn more about the Layaway Deposit Report, click here . (Link opens in new window.)
Cash Flow
The Cash Flow chart shows the actual flow of tender amounts by transaction type. It shows the total tender In (positive), Out (negative), and Net (total).
This shows activity across all transaction types during your daily store operations. The Cash Flow detail consists of the following figures:
- Today's Opening total
- This is the amount of funds available between the tills and the store safe at the time of opening
- Pawn/Buy
- Amount of money in, out, and net value, across all tenders for pawn/buy transaction types. Total Paid Out (out) and Total of Total Payment (In)
- Regular Sale
- Amount of money in, out, and net across all tenders for retail sales transaction types. (Excludes Layaways and Work Orders/Repairs) Total of all sales (In) and returns (Out). This amount also includes "Sales-to-be" money collected for Hold Sales. Yet this is not a Sale as of this point until it is picked up. Therefore, this number may not match with the actual sales for this day.
- Web Sale Paid Direct
- Amount of money collected on Web Sales where the consumer paid the store directly instead of through the online cart.
- Layaway
- Amount of money in, out and net, across all tenders for Layaway transaction types. Total of Layaway payments (In) and Layaway transactions cancelled (Out). For final Layaway payments, this is layaway payment less tax.
- Repair
- Amount of money in, out, and net, across all tenders, for Repairs. Total of all new work orders, deposits + Pickups (In) and Cancelled Work Orders (Out)
- Consignment
- Amount of money in, out and net across all tenders, for sale of gift cards. Gift Card Sales (In) and Gift Cards Used as Tender (Out).
- Gift Card
- Amount of money collected on new gift card sales (In) and amount of sales where gift card was used as tender (Out)
- Paid Out
- Amount of money out, across all tenders, for miscellaneous expenses (Cash Disbursements)
- MobilePawn payments
- Expired Layaway Credits
- Amount of money paid out for credits on Layaways Expired in the system/
- Sales Tax
- Amount of money in, out, and net across all tenders, for transactions which included sales tax. Sum of Sales Tax collected from sales (In) and returns (Out). For final layaway payments, this is the tax collected part. This amount also includes "Sales Tax-to-be" money collected for Hold Sales. Yet this is not a Sale as of this point until it is picked up. Therefore, this number may not match with the actual sales tax for this day.
- Inter-Store Cash Transfer
- Amount of money, if any, transferred to the store from any other store within the company (In) and the amount of money, if any, transferred from the store to any other store within the company (Out)
- Change Order/Deposit Change Order
- Transferred from bank to safe during the day, Deposit: Total of all tenders transferred from Safe to Bank during the day.
- Inter-Store Pawn/Buy
- Amount of money, if any, collected for loans held by your store through any other store in the company (In) and the amount of money collected by your store for loans held by any other store in the company (Out).
- Inter-Store Layaway
- Amount of money, if any, collected for layaways held by your store through any other store in the company (In) and the amount of money collected by your store for layaways held by any other store in the company (Out).
- Total
- This is a sum total of the Net Column. This should always match the Close Store section: Amount Remaining in Store Actual
Closing Tender Count
The Closing Tender Count chart shows the total expected and actual values at closing per tender type.
The chart is grouped into three tender groups.
The first has Cash, Personal Check, Cashiers Check and Money Order. These are physical tenders taken into your till without going through a merchant account, or through a separate system. These are grouped together and totaled.
The second group has Debit Card, Visa, MasterCard, Discover and American Express. These are all credit cards that would be processed through your merchant services account.
The last group has Gift Card, PayPal, Wire Transfer and System Conversion. These are tender types that are not physically present in the till and are not processed through a merchant account. They are processed by Bravo, PayPal or your Bank. These are grouped together.
The column labeled "Expected" shows the values that Bravo has calculated and expects for each tender type. The column labeled "Actual" shows the actual counts and totals at the end of store closing for each tender type.
Note: As of the 2.4.3.29 version update, "Store Check" and "Web PayPal" do not appear in the Closing Tender Count section of the report because they are not counted at store closing. To learn more about this release, visit the release notes, here . (Link opens in a new window.)
Paid Out
The Paid Out chart simply shows a total of each type of Cash Disbursement made from your tills for the day. If, for example, you made two disbursements for Repairs that were for $25 each, your Replacement/Repairs would show ($50.00).
This will only have values on days when you use Cash Disbursement for miscellaneous expenses. To see a breakdown of these expenses, see the Disbursement Journal. To learn about the Disbursement Journal, please see the article here . (Link opens in new window.)
To learn more about Cash Disbursement, please see the article here . (Link opens in new window.)