Sales Accounting

Last Updated:  7/15/2025

The Sales Accounting report displays sales activity and tax collected for a specified date range, giving a quick overview of sales figures and tax liability.

This article guides you on accessing and running the Sales Accounting Report, understanding the numbers, and reconciling the report effectively.

Follow the links below to learn more:

• How to Access and Run the Sales Account Report
• Understanding Sales Accounting Report Calculations
• Reconciling the Sales Accounting Report

The amounts on this report are only updated nightly and will only show amounts for transactions through the previous business date. The current day's business date amounts (i.e. today's) are not included.

How to Access and Run the Sales Account Report

• To access the report, first click Reports from the Bravo Dashboard.
• Find the Sales Report category, select the Sales Accounting report and click on Preview.
• Next enter the date range in the Sales Accounting Report Configuration window and click Ok.

Understanding Sales Accounting Report Calculations

The first section shows a row for each day your store was open during the selected date range.
You’ll see columns for taxable and nontaxable sales, layaways, and fees—plus totals calculated across and down the report.
These numbers give you a clear snapshot of daily performance and sales activity.

• Taxable Sales - This is the total of all sales in Bravo where sales tax was charged.  This total will not include layaways or layaway payments. 
• Taxable Layaway - This is the total of all finalized taxable layaways that have been paid and redeemed.
• Taxable Fees - This is the total of all fees charged on retail sales that are subject to sales tax.
• Total Taxable - This is the total of taxable sales, taxable layaways and taxable fees.
• Nontaxable Sales - This is the total of all sales in Bravo where sales tax was not charged. 
• Nontaxable Layaway - This is the total of all finalized nontaxable layaways that have been paid and redeemed.
• Nontaxable Fees - This is the total of all fees charged on retail sales that are not subject to sales tax.
• Total Nontaxable - This is the total of nontaxable sales, nontaxable layaways, nontaxable fees.
• Total Sales - This is the total of all taxable and nontaxable sales, all fees and layaways.
• Tax Collected - This is the total amount of tax collected on all taxable sales, sale pickups, fees and finalized layaways.
  • Tax collected will not include any Hold Sales that have yet to pickup the item or any Layaways that only received a payment and not a final payment (aka pickup)
• Cost of Sales - This is the cost of goods sold for sales and layaways regardless of tax charged.

The bottom of the report shows the taxes collected and any returns along with any taxes that were returned as well.

The second section displays a breakdown of taxes collected and returned, including any tax collected by eBay for applicable transactions (added in the April 2025 release).
It’s organized by Tax Authority and Tax Group, and includes any tax exemption reasons.
Sales appear in green-tinted columns, returns in red-tinted columns, and totals help you reconcile what was collected versus refunded.

 

• Tax Authority - This is the tax authority that has been configured for the store.
• Tax Group - This will show which taxable group the transactions belong to. 
• Tax Exemption Reason - If a group of transactions is exempt from sales tax collection, the reason for the exemption will show here.
• Sales - This column shows the total sales per group.
• Sales Tax Amount - This is the total tax collected (calculated as: Sales x % tax as assigned per configured Tax Authority.) 
• Sales Tax Exempt Amount - This is the calculated tax amount on exempt transactions. (This amount was not charged to the customer, but is provided for reporting purposes.)
• Returns - Any returns during the reporting range will appear on the appropriate line here.
• Return Tax Amount - If sales tax was refunded on a taxable return, that refunded tax amount is included here.
• Return Tax Exempt Amount - This is the calculated tax amount on exempt returns. (This amount was not refunded to the customer, but is provided for reporting purposes.)
• Total Tax Amount - This is the Sales Tax Amount minus any Return Tax Amount.
• Total Tax Exempt Amount - This is the Sales Tax Exempt Amount minus any Return tax Exempt Amount.

New in July 2025 release
Two new tables now appear at the bottom of the Sales Accounting report when you’ve configured rate components in System Configuration:

Rate Components Table

This table breaks down each configured tax rate into its individual parts—like State, County, Local, and optional Excise taxes. It helps you see exactly how each total tax amount is calculated.

• You can define these components per tax group in System Configuration > Company > Taxes tab.

• The sum of all rate components must equal the total tax rate for that group.

• This breakdown is especially useful for jurisdictions with layered taxes or excise requirements.

Rate Summary Table (Roll-Up Table)

This summary rolls up total tax amounts by tax authority and rate component (e.g., State of Nevada, Clark County, Las Vegas City).

• Lets you easily see how much total tax was collected per jurisdiction

• Groups and totals all tax components automatically

• Still works if no rate components are defined—it’ll just show overall tax totals instead

These enhancements make it easier to prepare and audit sales tax submissions without needing external spreadsheets or manual calculations.

Reconciling the Sales Accounting Report

There are several ways to verify the information contained on the sales accounting report.

• To check the sales numbers, you can run an End of Month report for the same date range.
• The taxable sales figure from the table at the top of the End of Month report:

• The taxable layaway figure can be found on the Layaway Deposits report:

Fees differ in the Sales Accounting report compared to the End of Day Consolidated and End of Month reports. The Sales Accounting report includes the total sale amount of Completed repairs, which are excluded from the Taxable and Nontaxable Fees in the other reports.

The report's bottom section does not account for restocking fees from layaway expiration, which are listed as Nontaxable fees at the top.

*Taxable and Nontaxable Fees may differ from the End of Day - Consolidated and End of Month reports because they include the total sale amount of completed repairs.
*Restocking fees from layaway expiration is not included in the bottom section but are counted as Nontaxable Fees above.
*Numbers in the Sales and Returns column shown in italics indicate out-of-state taxable sales and are not part of the total.

This difference is highlighted in the center of the Sales Accounting Report, between the daily data and Tax Reasons:

 

 

When validating sales tax numbers, keep in mind that changes in the effective tax rate can alter these figures.  (For more information about Configuring the tax rate and tax authority, see the article here .)

• The report's bottom section excludes scrap sales.
• Penny rounding can also impact your calculations. Learn more about it here .
• What if there's a discrepancy between Total Sales in the middle table and Total Sales in the bottom tax section?

 

This seems at first glance to be a problem.  But let's break the number down.

• The Sales figure from the tax table shows $18,741.24.  The total Sales from the top of the report shows $17,180.60.  This store did not have any non-taxable sales to worry about.
• The difference is $1,560.64. (18,741.24 - 17,180.60 = 1,560.64)
• There is a return listed for $1,663.60.  If we subtract the return from the difference we get ($102.96). (1,560.64 - 1,663.60 = -102.96)

Looking back at the report, we can see that $102.96 is equal to the Nontaxable Fees amount.

• The sales figure at the bottom of the report had not yet accounted for the return, and fees were not included in this figure.
• The sales figure at the top of the report included the fees and the return had already been subtracted.
• When there is a difference on these two figures, check for returns, and check for fees that may not have been included in the Tax calculations. 

Scrap Sales

If you have scrap sales that have been completed during the date range on your sales accounting report, these numbers can also cause a discrepancy.

• Take the example below:

• Total sales from the middle portion of the report = $1417.89
  • This number is made of taxable sales, layaways, fees, and nontaxable sales, layaways and fees.
    • 338.19 + 9.70 + 1020 + 50 = 1417.89
• Total sales from the bottom of the report = 613.08
  • This number is made of taxable sales, taxable fees and nontaxable customer sales.
    • 478.38 + 120 + 14.70 = 613.08
  • From this number we need to subtract the return of 145.19.
    • 613.08-145.19 = 467.89
• Take the total sales from the middle portion of the report and subtract the reconciled sales figure from the bottom of the report that now includes the return. 
  • 1417.89 - 467.89 = 950.00
• There is a difference of $950.00.  From the middle portion there is a nontaxable fee of $50.
  • 950 - 50 = 900.
• This still leaves a difference of 900.

If you have a difference that you cannot account for on the sales accounting report, you may need to investigate further. 

• One of the first places that you can look is under scrap sales.
• In this case, there was a scrap bucket sale to a vendor on 2/7 in the amount of $900.00

This $900 sale to a vendor is not subject to tax or tax reporting and is therefore not included on the bottom Sales Tax section of the report.  But this is still a sale for the store, so it is included in the top section of the report.

• If you are unable to reconcile this report, or have further questions, please contact customer support at 888-407-6287.