Hello Tiateen,

Thank you for using Community Hub.

I recommend consulting your accountant first to determine the best way to handle this. Once you have their advice, we can guide you through the steps to process it in your software.

Additionally, we offer some fantastic free webinars that run regularly, which could be very helpful for you as a new Sage user. You can find them here.

Best regards,

Annie
Sage UKI

I hate to say it, but it is possible that you may have double counted the sales - when I first started when I am, we had a couple of customers with incorrect balances which I tracked down to not only had they been invoiced (years prior to my investigation, not long after Sage was first used) but when the payment was received (in a similar time) it was posted again to the same income nominal (double counting the sale) instead of posting it against the invoice on the customer; and similar for a credit that was put on their account, but paid directly from the nominal (double counting the credit).

If the cash has been received for the invoices and they are still showing, then the cash received must have gone somewhere - ie the other half of the bank transaction which should have been against the invoice on customer(s).

Your first stage of investigation into clearing these invoices is to find out where the received cash was posted.  You will also need to check where the invoice was posted.

Once you have this information, you (and your accountant) can then decide how to fix the error and we can help with how to implement it in Sage.

Thank you Robert for replying -  the cash sales go through the bank (paid via PDQ) to which the merchant bundles a lot of sales together & posts one whole amount to the bank - it's a pallaver trying to identify which ivoices & how much have been paid against each posted payment to the bank, so initially I was auto selecting cash invoices to off-set against each PDQ bank payment (wrong I know!!) anyhow that's how I've ended up with a load of 'unpaid' cash sales invoices roughly £32000!! - my own fault for being lazy!  I have since emailed my accountant with the problem and awaiting instruction on how to tidy up my mess!!!! (if possible!!)  Thanks again for your help

No help now, but for the future, I recommend setting up a Merchant Bank account. When you get a deposit from the merchant to your bank, make a bank transfer from Merchant Bank to Current Account, this makes statement reconciliation easier, and it allows you to reconcile without having allocated all the receipts. This really takes the pressure off and allows you to process the receipts properly

Do customer receipts, using the Merchant Bank Account. Reconcile this to a zero balance on a regular basis. You will then be able to quickly spot any issues.

I agree!!!  Thank you!!