Idea: cash sales along with credit sales

[sharpdrivetek]

okay sorry for the initial confusion. to be honest i have never made a cash sales.
i tried the same with a test business and it seems the cash sale transaction is not included in the customer statements report. i guess that is the difficulty you are facing?

i had previously requested on the forum to include all customer related transaction to the customer statement reports. that was mainly for handling deposits. anyway your situation is of similar reason i think.

you can find the topic below.

Including all related transaction in Customer/Supplier Statements

Hello @lubos hope you are doing fine. We have recently encountered a problem with the sales tax authorities regarding the accounts statement mismatch between ours and our customers. the issue is because we are using Special Accounts to manage customer deposits which does not reflect on the Customer Transactions report. recording the deposit directly to the Accounts receivable account affects the Balance due every time an invoice is generated. as per the instructions received from the sales tax…