statement does not match Receive Payment total owing

Quicken for Windows, Version R51.12 Build 27.1.51.12. Windows 10.

For one customer, the statement shows zero, but the invoice Receive payment window shows a small amount due.

How to I get these in sync?

I have already validated the file.

thanks.

Reply to
Taxed and Spent
Loading thread data ...

I'm not sure I have a clear picture of your situation, so I'm just taking a stab at the problem at this point.

The "Receive payment" dialog displays every amount owed for the customer ... but only in the same Invoice account as the invoice receiving the payment. And even if the invoice has been paid in full, its "Receive Payment" dialog will still display all the transactions in that Invoice account that are for amounts owed.

Statements "can" display every transaction for every customer in every invoice account.

So, to start, you'd need to insure that the Statement you're viewing is set to look at the same Customer in the same Invoice account where that specific invoice is recorded, and that the Statement start/end dates cover all the invoices/payments for that customer in that specific Invoice account.

It that doesn't help, see if you can add some details.

For example: What is in the "Type" column in the "Receive payments" dialog for the "small amount due"? Have you looked for any transaction for the same amount as the "small amount due"?

Reply to
John Pollard

Thanks for taking a stab at this.

Yes, same invoice account (there is only one).

Yes, statement is for all dates. I even went way back and way forward to see if there was something odd out there, but no.

Type=Customer invoice

I have looked for the $0.02 elsewhere for this customer, but no luck.

I ran a transaction report for all invoices and payments for this customer, and they balance just like the statement.

Reply to
Taxed and Spent

Does that mean that there is a Customer Invoice showing in the Receive Payment dialog whose amount is $0.02 - but that invoice does not appear anywhere else?

Or that there's an invoice in the Receive Payment dialog whose amount is $0.02 different than the same invoice in Statements?

[Sorry. I don't actually use the Business features in Quicken, but I have tested with them often over the years - at one time I thought I might use them, but never did. Since I'm not tracking any real-world business activities, I have to start from scratch and setup test data based on my understanding of the problem, when trying to track down anomalies reported by others. That also means I need to ask questions that may sound stupid to someone who is running a real business and tracking it in Quicken. If I can get a good picture of a problem, I can try imagining what conditions could cause it, and setup tests to prove/disprove the theory. So far, I can't come up with any theory to explain what I understand you to be experiencing.]
Reply to
John Pollard

Statement shows zero balance.

Unpaid invoice list shows one invoice with $0.02 due.

That invoice shows payment history with $0.02 due.

I am thinking I will delete the one payment per month for 2023 and see if that clears the error, then enter the payments again. Failing that, I may delete the one invoice per month for 2023 and see what happens.

Reply to
Taxed and Spent

well I deleted and reentered payments and an invoice or two, and it is all perfect now. Darn Quicken! Thanks.

Reply to
Taxed and Spent

Glad you got it fixed. It's surprising how often deleting and re-entering transactions "fixes" problems.

Reply to
John Pollard

I am glad my instinct was right, and I could narrow the date range for the fixes. sort of like turning the device off and turning it on again, and voila!

Reply to
Taxed and Spent

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.