Bravo provides you all of the tools that you need to compile your year end numbers for your store. With our comprehensive list of reports, your year end processes should be easy to manage.
This article will go through some of the more helpful year end reports. Click on the links to navigate through the article. Links that open in a new page will be noted.
When compiling End of the Year numbers, you may find the following reports helpful:
- End of the Month Report
- Deposits and Paid Outs Spreadsheet
- Loan Base Report
- Pawn Activity Summary
- Loan Disposition Report
- Supplemental Loan Disposition Report
- Sales Accounting Report
- Sold Inventory Report
To Access any of the above reports, select "Reports" from the Bravo Dashboard:
Then select the appropriate report from the list.
End of the Month Report (full year)
The most useful report for End of the Year reporting is the Bravo End of the Month Report. On this report, you can find details for almost all of the data that you may need. You can find the End of Month report under the "Closing Reports" section of the Reports page in Bravo.
The End of the Month report is typically run once a month at the close of that month's business. Click on the report, and then click "Preview". You should now see the Configuration window. To get data for the full year, you are going to want to run the report from January 1 through December 31:
Click "OK" to run the report.
The first pages of the report will show you a daily summary of your cash movement.
After this section, you can see all of the important tables:
For Example, your Loan Base table shows the net change to your loans base over time:
The column that shows "Month" represents the report as a whole. In this case, it is equal to one full year. You can see that in this store, at the beginning of the year, they had a starting loan base of 23 loans for a total principal of $7,501.79. After one year of transactions, (new loans, redemptions, expirations, etc) the loan base has increased to 95 loans for a total principal of $35,803.75.
You can find similar tables for your Inventory Base, Layaway Deposits and Balance, Repairs, Sales and Consignments.
The last two pages of this report have the most information. The first of these will have the Pawn Activity for the year:
The Pawn Activity page shows:
- New Loans (quantity and cost)
- Buys (quantity and cost)
- Number of Extensions (including interest and fees collected)
- Reactivated loans
- Expired loans
The next page shows Sales Activity:
The Sales Activity page shows:
- Taxable and Non-Taxable Sales (quantity of transactions and gross sales totals)
- Taxable and Non-Taxable Fees (quantity of transactions and gross sales totals)
- Taxable and Non-Taxable Returns (subtracted from overall sales totals)
- Any Consignment sales or returns
- Final redemption figures for both Layaways and Firearm sales
- Overall gross sales
- Cost of Goods Sold
- Net Revenue
For more information on the End of the Month report, please see the article here . (Link opens in new window)
Deposits and Paid Outs Spreadsheet
Another useful report for End of Year accounting is the Deposits and Paid Outs Spreadsheet. You can find this report under the "Closing Reports" section of the "Reports" page of Bravo.
This report will show you the cash that was pulled out of Bravo, whether through a Cash Disbursement (Paid Out) or through a Deposit (Transfer from Bravo to Bank).
Click on the report, and then click "Preview". This will bring up the configuration window. Enter a range of dates. In this case, January 1 through December 31.
Click "OK" to run the report.
The first section of this report will show all Cash Disbursements totaled by type and by month:
You can read this report down, to get the total by month, or across to get the yearly total by type of Disbursement. The Bottom right corner (under the line subtotal) will show the total amount of cash disbursements for all types for the entire reporting range. (In this case one full year).
The next section of this report shows all deposits, or money transferred out of Bravo.
The total at the bottom right of the report is a sum of all money moved out of Bravo for the year.
For more info on the Deposits and Paid Outs Spreadsheet, click here. (Link opens in new window)
Loan Base Report
The Loan Base Report shows all Loan activity for the year. This report is listed under "Loan Reports" in the "Reports" screen of Bravo.
Highlight the report and click "Preview" to see the Configuration screen:
Enter your date range (in this case January 1 through December 31)
The first pages of this report will show the detail by day:
Each day starts with the starting loan base, and then as you move across, you can see the transaction totals and will end with the Ending Loan Base.
The next section is the chart that is included on the End of Month spreadsheet:
The number on the bottom right of this table represents the total loan base as of closing on the last day of the report. For example, this store closed the year with 95 active loans totaling $35,803.75.
For more information on the Loan Base Report, please see the article here . (Link opens in new window)
Pawn Activity Summary
The Pawn Activity Summary gives you a way to see your loans by category. This report is located in the "Loan Reports" section of the "Reports" screen in Bravo.
Highlight this report and click "Preview" to see the configuration screen:
Enter your date range and click "OK". In this case we entered January 1 through December 31.
This report shows loan activity broken out by category:
You can see the total of Loans and Payments, Buys, Renewals, etc by each category type. The report is broken out by Jewelry and General Merchandise.
The second section of the report also shows Interest and Fees:
This gives you another way to see Loan totals for the year.
For more information on this report, please see the article here . (Link opens in new window).
Loan Disposition Report
If you need to get a list of loans that were created during the year, regardless of their current status, you can run the Loan Disposition Report. This report is located in the "Loan Reports" section of the "Reports" screen in Bravo.
Highlight the report and click "Preview" to see the configuration window:
Enter your date range and click "OK". In this case we entered January 1 through December 31.
This report will produce a list of loans that were created (Date Made) during the reporting range. If a list of these loans is needed for your jurisdiction, this is the quickest way to get this information.
This report will include both Loans and Buys.
Supplemental Loan Disposition Report
Similar to the Loan Disposition Report is the Supplemental Loan Disposition Report. However, instead of generating a list of loans created during a range of dates, this will generate a list of loans that were closed during the date range, regardless of when they were created.
This report is located in the "Loan Reports" section of the "Reports" Screen in Bravo.
Highlight the report and click "Preview" to see the configuration window:
Enter the range of dates and click "OK". in this case we entered January 1 through December 31.
This report is showing all loans and buys that closed during the reporting date range. The date created does not matter on this report. This is simply a list of loans closed.
This report will not generate any totals. However, if you need to generate a list of loan numbers that closed (expired, redeemed, renewed, etc) during the year, this is the easiest way to get this information.
This report will include both loans and buys.
Sales Accounting Report
To see your sales numbers at a glance, you can run the Sales Accounting Report.
This report is located in the "Sales Reports" section of the Reporting Screen in Bravo.
Highlight this report and click "Preview" to see the configuration window:
Enter your range of dates and click "OK". In this case we entered January 1 through December 31.
This report will generate your sales totals for the year. The top portion of the report shows the numbers by date:
With this report, you can see your totals for the year of the following:
- Taxable Sales
- Taxable Layaways (Finalized Layaways)
- Taxable Fees
- Non-Taxable Sales
- Non-Taxable Layaways (Finalized Layaways without tax)
- Non-Taxable Fees
- Tax Collected
- Cost of Sales
The report includes the chart that is on the End of Month report. This report can help you verify your overall revenue for the year. More importantly however, this report can help you verify your sales tax numbers at a glance:
The bottom table on this report shows the overall tax collected, accounting for all returns in the process.
Sold Inventory Report
To view a list of inventory sold for the year, you can view the Sold Inventory report.
This report is located in the "Sales Reports" section of the "Reports" screen in Bravo.
Highlight the report and click "Preview" to get the configuration window:
Here you can enter your report configuration preferences:
- Reporting Dates (January 1 through December 31)
- Display Margin
- Percentage (%)
- Currency ($)
- Group By
- Area (Jewelry vs Manufactured Goods)
- Category (Specific category info)
- Location (Store location)
- Associate (Commission Associate for the sale)
- Business Date Sold (Business Date of sales transaction or final layaway payment)
- Omni Channel (Sales channel - ie eBay, Buya, Instagram, etc)
- Sort By (Within Groups)
- Business Date Sold
- Price Sold
- Associate
- Omni Channel
- Include Detail
- Checked - Detail by transaction/item is visible
- Un-checked - totals only
Enter your preferences and click OK.
This first example shows the report grouped by Category with the detail checked:
The second example shows how the report looks with the detail unchecked.
For more information on the Sold Inventory Report, see the article here . (Link opens in New Window)