Skip to content
English - United States
  • There are no suggestions because the search field is empty.

Sales Accounting

You will learn how Bravo handles sales accounting, including how transactions post to the General Ledger and how to review accounting reports for accuracy.

Last Updated:  4/10/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:

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.

 

Instructions

  • 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.


 

Calculations for the Sales Accounting Report

  • 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.

*Available in April 15, 2025 eBay Tax Paid was added to the Sales Accounting report as highlighted above.

  • 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.

 

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, option 3.