Receipts shown versus actual receipts

1

I have setup columns in Customer Tab. Such as Receipts, Sales Quotes, Sales Orders etc.

The number of receipts shown for a client does not actually match the number of transactions by client in terms of what they have paid!

Since moving to bacs (not cheques) and using bank imports, I have not had any discrepancies for the last three years. The discrepancies are cropping up before that time period where I would commonly deposit multiple cheques from different clients. Those transactions are not showing as receipts for any given client under the Receipts column within the Customer Tab.

It seems to me that the Receipts Column is using the data set in Paid By, rather than the customer within accounts receivable. I suppose that makes sense in one way as accounts receivable is only applicable if you are using invoicing. The problem is that under Paid by, I can only select one contact - at that time I had it set as Various Clients under Other.

What is the correct procedure for this. Going forward this will never be a problem again as bacs and bank imports are really the way to go. Manually entering payments and receipts is error prone, time consuming and cheques have gone the way of the dodo here in the UK. But I would like if possible to fix the older entries where I routinely deposited multiple cheques by different clients at the same time, so the bank import can only show one amount.

2

If you are using accounts receivables, then I’d not use this column in the first place.

The column exists for businesses who do cash sales and don’t use invoices. But still want to track which customer is purchasing. In their case, they will always have 1 receipt = 1 customer.

3

I see. That does make sense. I will leave it as is for the moment and see if I actually use it. I suspect that if I use that column, I am more likely to use it for very recent transactions (which are not affected by this problem).

I think it’s a useful feature if you want to very quickly see what the latest receipts from your clients are.