All Collections
Sales Report
Mismatch Between Total Sales and Payment
Mismatch Between Total Sales and Payment

The difference between Sales and Payment, and the reasons why they are different

Christian Wijaya avatar
Written by Christian Wijaya
Updated over a week ago

Users often differentiate between the Report Detail and Report Payment to view the amount of income received, but there is a difference between the two reports. This difference is because the Report Payment records transactions that have been 'Paid,' while the Report Detail records all Paid and Unpaid transactions.
For more details, you can see the scenarios below:

I. Sales

Sales reports will generally display the total of sales made in a period, for example daily, weekly, monthly, and so on. For example, we make daily sales of 3 transactions with a total nominal value of Rp. 600,000,-. In today's transaction, we did a sale of Rp. 600,000,-, but not in full paid directly, there may be some transactions that are still unpaid, or partially paid.

II. Payments

The Payment itself is the money we receive for sales made in a period, for example daily, weekly, monthly, and so on. Still in the same example, of the 3 sales transactions made, one of them is a sale using the debt / later payment method. For example, there is 1 transaction with a total value of Rp. 200,000,- is Unpaid, then Payments received are only Rp. 400,000,- (less Rp. 200,000,- from total sales).

Example for Unpaid Invoice and Total Sales :

Received Payment Reports show a different number with Total Sales :

This can also be the other way around, the total Payment we receive today is greater than the total Sales. For example, if there was an unpaid transaction yesterday, it is paid today, which will cause a larger difference in Payments than today's sales.

III. Why Sales & Payments Didn't Match?

Of course, there are many reasons why the total Sales and payments are not the same, one of which has been explained above. But the most common reasons why Sales & Payments are not the same are:

  • There are unpaid invoices/debts.

  • There was an invoice payment in the previous period (yesterday, last week, last month)

  • Payments made are inputted by 2 different cashiers (Open Register)

Related Article:



Did this answer your question?