Difference Between: Payment & sales

We should make sure that the comparison is between net sales with tax in sales report and

net amount in the payment report.

Reasons of the difference:

• Gift cards as gift cards will be counted in the payment report but not in the sales report

For example: Today you sold gift card for 50 SR and Tuna salad for 21 SR

Net sales with tax in Sales report: 21 SR

Net amount in Payment report: 71 SR

• There are some orders paid in one day and closed in another day and there are many cases: 

1- the order received from API (online order) paid and not closed in the same date or you pay the order without closing and close it on another date.

In the day of payment the net amount in Payment report will be more than net sales with tax.

Example: in 20/2 you received an online order paid for 40 SR and you close the order on 21/2.

On 20/2: Net sales with tax: 0 SR , Net amount in payment: 40 SR

On 21/2: Net sales with tax: 40 SR , Net amount in payment: 0 SR

2- the order paid (online order or pay without close) and still active the net amount in payment will be more than net sales with tax

    Example: in 20/2 you paid the order without close for 40 SR

    Net amount in payment: 40 SR , Net sales with tax: 0 SR

Steps to investigate the problem: 

1- let the client export order payment report (orders- export- export order payment) for a long period.

For example: the problem happened in 20/2 ask the client to share the order payment from 19/2 to 23/2 and see the two columns order business date and business date if there is a difference in the date then the order with a difference is paid on a business day and closed on another business date.

2- if all orders have the same order business date and business date then check if there is an active order that paid and still not closed.