Reports Troubleshooting: Daily Sales and All Transactions Amount Does Not Tally

Introduction

Sometimes, you might find a mismatch in your Daily Sales report and All Transactions report. If this happens, don't worry - try following the steps below first.

Note: Please right click the screenshots below to Open Image in Another Tab and view the larger version.
 

Cancelled Transactions

Step 1.
Open your Daily Sales report and All Transactions report side by side on a spreadsheet program like Excel, Numbers or Google Sheets.

Step 2.
Look for the 'Is_Cancelled' column in the All Transactions report.

Step 3.
First, let's remove all cancelled transactions from your report. Delete the rows of transactions that show True in the 'Is_Cancelled' column.

What this means is if a transaction was cancelled, it would show up as 'True'. If it was not cancelled, it would appear as 'False'.

Step 4.
Highlight the 'Total' column (for ease) and look at the SUM at the bottom of the page.

Step 5.
The numbers should now tally with the Total Sales in the Daily Sales report.

Refunds

For refunds/returns, the method is similar. However, a refunded amount should be converted to a negative value since you're giving cash back to your customers.

Note: Please right click the screenshots below to Open Image in Another Tab and view the larger version.

Step 1.
Open your All Transactions report on a spreadsheet program like Excel, Numbers or Google Sheets.

Step 2.
Find the Transaction Type column in the All Transactions report and look for Returns.

Step 4.
Change the value of the returned amount(s) in the Total column to negative by placing a ' - ' next to the amount(s). Highlight the 'Total' column and look at the SUM at the bottom of the page.

Step 5.
The numbers should now tally with the Total Sales in your Daily Sales report!