Hi,
Our current account in QB exactly matches the live account details.
BUT QB gives me a list of overdue amounts from a few different clients, that I can see have been paid.
(In terms of changing records, we pay VAT via the flat rate scheme.)

I've tried:
1. Sales Transactions (list of those that are overdue). Action "Receive Payment" and put in the date of the payment. This adds a new payment for that date. It does not link it to the payment already in the reconciled bank account, which then becomes unmatched (live Vs what is in QB goes wrong by the amount of the invoice payment. Looking at the "Bank Account History" I can see 2 x the payment. Due to being on Flat Rate VAT and this being in a period where the return has been made, I can't delete the old one, but I can delete the new one created by this "Receive Payment" and so put the QB Bank balance back to in-line with the real world bank account.
2. Click the C for the payment line, so that it goes blank (so not 'Cleared - Tentatively Reconciled' or 'Reconciled') and then repeated the above step. Same end result of the "amounts due" no longer shows this as being due, but the bank account is no longer reconciled.

How do I fix this ?
I can either have a reconciled QB to live bank account, which includes payments that are't linked to clients, so it says clients owe money they've paid.
OR I can complete the "Receive payment" details for dates that match the bank account, but the QB account balance then doesn't match (reconcile) with the real bank account.

Hopefully I'm doing something silly that is easy to sort out ?

Rory