This article reviews the potential causes in which sales numbers may differ from payment numbers within the same reporting period and how to reconcile the difference.
The most common causes of this are any of the below reasons, or a combination of multiple of them. Check each carefully to find the cause.
- Note that Dollar Credit expenditures are included in the Payments report, but are deducted from your Net Sales figures. To reconcile this, either exclude Dollar Credit payments from your Payments figure, or add them back into your Net Sales figure.
- Look if some invoices haven’t been fully paid for (invoices of status partially_paid). This would cause Sales numbers to be greater than Payment numbers, as the sale is logged with expectation of full payment, but the payment hasn't arrived yet.
- Remember to include all sale categories, including tips, as well as client fees and taxes. Payments contribute toward all these.
- Check to see if some payments/refunds came in for invoices that are logged outside of the period you're running the reports for--this would cause Payments to be different than Sales for that period. Likewise, check to see if some invoices had payments/refunds come in after the period you're running the reports for--this would cause Sales to be different than Payments for that period.