Why do sales receipts that are UNPAID show as PAID?

Thanks for visiting the Community, @WestHillsWeb.

In QuickBooks Online (QBO), a sales receipt is used when your customer pays you on the spot for goods or services. This is the reason why they're showing as paid. The option to pull up a report that shows unpaid sales receipt is currently unavailable.

However, based on the information you've shared above, I highly suggest creating an invoice instead. This is used when your customer agrees to pay you later. You can set up terms to indicate how long the customer has to pay. They won't show as paid unless you applied a payment using the Receive Payment option.

You can check out this article for more information about the difference between the two transactions: What is the difference between an invoice and a sales receipt.

Feel free to leave a comment below if you have any additional questions or concerns. I'm more than willing to help. Happy holidays!

Thank you for the reply, but I do not think you fully understand the situation because your answer does not answer my question.

A Sales Receipt is the proper transaction type to use because the customer has agreed to pay a fixed amount on a recurring basis. We therefore set up a Recurring Sales Receipt Template to process the transaction and payment. Their intention and mine is that they be charged AUTOMATICALLY on that day. 

So far as I know, an Invoice will not work for this purpose.

Please review the three situations:

a) The recurring sales receipt template doesn't have a payment method set.
b) The recurring sales receipt template has a payment method set, but doesn't have the "Process Payment" box checked
c) The selected payment method fails when the sales receipt is generated.

Both A and B are mistakes on our part to not ensure the template is properly set. But this does not excuse the fact that THERE WAS NO PAYMENT and therefore THE SALES RECEIPT SHOULD NOT BE MARKED AS PAID. 

So far as C is concerned, failed payments happen in the normal course of business. 

So in all three cases, showing the Sales Receipt as Paid IS NOT CORRECT GAAP ACCOUNTING, and therefore a BUG that must be fixed. 

So here are my three questions again

1. When will Quickbooks fix this VERY OBVIOUS BUG?
2. How can we generate a report of all Sales Receipts that show as PAID but are actually NOT PAID?
3. How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid?

For 1) this is a VERY bad bug that really needs to be fixed. 

For 2) Are you sure you can't think of any creative way to maybe run two different reports that we can correlate in order to find problems like this? Isn't there some Cash Receipts or Payment Methods report we can run to show actual revenue received to compare to billing? Or anything? Please think creatively.

For 3) You didn't answer this question. I now have over dozen of these sales receipts that show as PAID but are not. Assuming that I can get the clients to pay me, HOW DO I CORRECT THIS PROBLEM in  Quickbooks so that the work we've done for the clients show as paid? 

I look forward to solutions to these problems.

Thank you.

-Mark

Thank you for the reply, but I do not think you fully understand the situation because your answer does not answer my question.

A Sales Receipt is the proper transaction type to use because the customer has agreed to pay a fixed amount on a recurring basis. We therefore set up a Recurring Sales Receipt Template to process the transaction and payment. Their intention and mine is that they be charged AUTOMATICALLY on that day. 

So far as I know, an Invoice will not work for this purpose.

Please review the three situations:

a) The recurring sales receipt template doesn't have a payment method set.
b) The recurring sales receipt template has a payment method set, but doesn't have the "Process Payment" box checked
c) The selected payment method fails when the sales receipt is generated.

Both A and B are mistakes on our part to not ensure the template is properly set. But this does not excuse the fact that THERE WAS NO PAYMENT and therefore THE SALES RECEIPT SHOULD NOT BE MARKED AS PAID. 

So far as C is concerned, failed payments happen in the normal course of business. 

So in all three cases, showing the Sales Receipt as Paid IS NOT CORRECT GAAP ACCOUNTING, and therefore a BUG that must be fixed. 

So here are my three questions again

1. When will Quickbooks fix this VERY OBVIOUS BUG?
2. How can we generate a report of all Sales Receipts that show as PAID but are actually NOT PAID?
3. How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid?

For 1) this is a VERY bad bug that really needs to be fixed. 

For 2) Are you sure you can't think of any creative way to maybe run two different reports that we can correlate in order to find problems like this? Isn't there some Cash Receipts or Payment Methods report we can run to show actual revenue received to compare to billing? Or anything? Please think creatively.

For 3) You didn't answer this question. I now have over dozen of these sales receipts that show as PAID but are not. Assuming that I can get the clients to pay me, HOW DO I CORRECT THIS PROBLEM in  Quickbooks so that the work we've done for the clients show as paid? 

I look forward to solutions to these problems.

Thank you.

--Mark

p.s. apologies if this reply posts twice. The first time I submitted it, I got an error. Not sure if it saved. Feel free to delete this if it's a duplicate.

I'd be happy to address your concerns, @WestHillsWeb.

Allow me to chime in about the recurring sales receipt transaction in QuickBooks Online.

Here are the answers to your questions:

1. When will Quickbooks fix this VERY OBVIOUS BUG? - Sales receipt is automatically marked as Paid since this is considered as an actual sale in QuickBooks Online.
2. How can we generate a report of all Sales Receipts that show as PAID but are actually NOT PAID? - This kind of report is unavailable. 
3. How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid? - You may consider using an Invoice transaction for recurring sales that is not an actual sale. 

You can check out is the article given by my colleague above its a great reference about the difference between sales receipt and invoice.

Also, since you have multiple sales receipts, I'd recommend recreating it to an Invoice instead. This is done so that you can track the transaction if the customer checked the sent invoice and if they paid it using the QuickBooks Payments.

To know more about the process, you can check out this article: Take and process payments with QuickBooks Payments.

You're always welcome to get back in the comment section if you have other questions. I'll be here to answer them for you. Take care.

This is the THIRD TIME I AM ASKING THESE QUESTIONS because all of your responses so far HAVE NOT ANSWERED BY QUESTIONS. 

PLEASE DO NOT LET ANYONE BUT A SUPERVISOR ANSWER THIS. And ONLY answer after actually reading all of the questions and replying thoughtfully. I expect more from Intuit and Quickbooks than the sub-par, extremely poor, non-answer responses I have received so far. 

Honestly, I feel like I am talking to a wall here. YOU DID NOT ADDRESS ANY OF THE POINTS I BROUGHT UP IN MY LAST TWO MESSAGES. 

It's as though you see the word "sales receipt" and "not paid" and you automatically paste in your canned "use an invoice" response.  Well, I CAN'T GO BACK IN TIME TO USE AN INVOICE FOR A FAILED PAYMENT ON A SALES RECEIPT!!!

Does that not compute for any of you there at Intuit?  

There is NO OTHER WAY to run automatic payments in Quickbooks Online besides a memorized, recurring Sales Receipt. Invoices do not get paid automatically. CORRECT? 

HERE ARE MY QUESTIONS and your previous non-answers. Please read carefully.

1. When will Quickbooks fix this VERY OBVIOUS BUG? 
   You wrote: Sales receipt is automatically marked as Paid since this is considered as an actual sale in QuickBooks Online.
   WHW: THIS IS NOT AN ANSWER TO MY QUESTION. There NEEDS TO BE A WAY to indicate that a payment on a sales receipt failed. And there needs to be a way to FIX THIS when it happens. When will this be fixed?
2. How can we generate a report of all Sales Receipts that show as PAID but are actually NOT PAID? - You wrote: This kind of report is unavailable. 
   WHW: FINE. There's no report called "Failed Payments for Sales Receipts". But using your "expert" knowledge of Quickbooks, can you think of one or two reports that we could use to get the information someone -- ANYONE -- would need in order to figure out that there are unpaid sales reports? 
3. How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid? -
   You Wrote: You may consider using an Invoice transaction for recurring sales that is not an actual sale. 
   WHW: These ARE ACTUAL SALES!!!! And I cannot go back in time to turn my Sales Receipt into an Invoice. Given your non-answer, WHAT DO YOU SUGGEST I DO? 
   A) Never collect from my client, leaving us unpaid for the services we provided
   B) Take their money, but leave my bookkeeping forever out of balance?
   C) Shut down my company? 
   I would rather it be none of those, but that is what you are suggesting. Could you please instead do this: 
   D) Some other method that allows me to properly accept their payment, account for it properly, and balance my books? I would be OK if this solution involved voiding or deleting transactions, accepting a payment from the client, recreating transactions in some other way or format...or any other solution that is GAAP. 

Please DO NOT REPLY UNLESS YOU ARE A SUPERVISOR OR MANAGER WITH AN ACTUAL ANSWER.

Thank you.

-Mark

I am having the same issue WITH INVOICES!!!  I have invoices showing as paid that have NOT been paid.  I cannot get an answer as to how to clear the payment and save the invoice!!  For some reason the invoice is attaching to an expired estimate.  I pay a lot for QB Online per month and expect ANSWERS/SOLUTIONS rather than CANNED RESPONSES!

Cynthia b.

Hi there, cjbarber1. Thanks for joining the thread.

In QuickBooks Online (QBO), there is a feature that offers automation. It might be, turned on, that is why it marks your invoices as paid. 

Here's how to check:

1. Click the Gear icon at the top.
2. Select Account and Settings.
3. In the left menu, tap Advanced.
4. Hit the Pencil icon in the Automation section.
5. Check if there is a check-mark in the box next to Automatically apply credits.

If yes, then, that is the reason. To turn off, remove the check-mark in the box next to Automatically apply credits. Then, tap Save and Done. 

After that, let's open the created invoice that was marked as paid and delete the applied payment. This way, it'll mark the invoice as unpaid.

1. In the left menu, click Sales.
2. Locate the newly-created invoice.
3. Select on the 1 payment link at the upper right hand above the PAID payment status.
4. Click the date link.
5. On the Receive Payment page, select the invoice.
6. Click More at the bottom.
7. Choose Delete, then choose Yes to confirm.

To learn more about receiving payments and applying credits in QBO, see the below articles:

• Record invoice payments in QuickBooks Online
• Handle a customer credit or overpayment in QuickBooks Online

For future reference, you might find this resource helpful: Record a customer refund in QuickBooks Online. 

Please let me know how it works. I'm always here to help. Have a great day!

MirriamM,

It seems like you know what you're talking about with respect to Invoices. However after nearly 3 months I have yet to receive an answer that applies to my situation with Sales Receipts.

Will you kindly read my initial post...and all the follow up posts by both your colleagues and (a very angry) me...and let me know if you have a solution to my initial three questions?

There has GOT to be a way to fix this problem. 

Thank you.

-Mark

This answer is also NOT AN ANSWER MY QUESTION. 

Please read all the other times I wrote that I cannot use an Invoice in this situation.

These are recurring transactions that need to be processed monthly.

There is NO WAY TO USE AN INVOICE in this situation.

-Mark

I appreciate for getting back to us, WestHillsWeb. Let's work together and figure this out so you can get back on track.

You have created the transactions in QBO that aren't linked to QB Payments. That is why there are sales receipts but no payment generated in your bank. What we can do is link your QBO account to QB Payments and set up recurring payments to get this fixed. You can use this article for the detailed guide on connecting your QuickBooks Payments account to QuickBooks Online.

From your QB Payment account, you can now process recurring payments from your customers depending on the schedule you set using sales receipts. Let me walk you through how:

1. Go to the Gear Icon.
2. Choose Recurring Transactions.
3. Click New.
4. Select Sales Receipt from the Transactions Type drop-down.
5. Hit Ok.
6. Type in the name of the Recurring Transactions.
7. Choose Scheduled from the Type drop-down.
8. Select the name of the customer drop-down and verify the email of the customer.
9. From the Payment Method drop-down, choose Credit Card Type.
   1. Enter your customer's credit card details.
   2. Click Ok.
10. Click Save Template.

To identify the lists of pending sales receipts, you'll have to create a Bank Deposit. Here are the steps:

1. Click the + New button.
2. Select Bank Deposit.
3. From the Account ▼ dropdown, choose the account you want to put the money into.
4. Select the checkbox for each transaction you want to combine.
5. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
6. Select Save and close or Save and new.

If I can be of any additional assistance, do let me know. I'm here to help.

Biggest need is a report for Sales Receipts that are marked as paid that are not. 

We are running into the same issue and understand the frustration.

WestHillsWeb,

So, you are NOT crazy. I am certain that many thousands of businesses have the exact same issue as you. We are one of them. I too do not appreciate robotic answers from well-meaning people. This is a situation where someone that wants to put an "engineer" cap on can too easily just talk past you and it can be very frustrating.

Yes, some engineer/developer set it up to where the ONLY way you can automatically accept recurring payments from a customer is to create a recurring sales receipt. If ANYTHING prevents this payment from being received, it will still mark it as paid. In may case many times, even though I am so thorough and could swear that it was checked, I too have found more than one invoice that was not checked. I remember one particular customer was going to cancel service on account of the bill that they thought was already paid. I should have fired this customer, but decided that I just needed to snap out of the emotion of it and realize that it would be more profitable to just concede this one.

It appears that no one is interested in actually solving this issue. They instead will blindly deny that this is an issue at all and that you need to create invoices instead, etc.

It is an obvious issue/oversight/bug that there is not any sort of alert, marking or safeguard to prevent a sales receipt with no or a failed payment from being marked as paid. If you could collect automatic recurring payments using an invoice where you could set it and forget it with no required interaction with the customer, that would be ok too. As far as I can tell, that is not an option. 

Good luck! Please let me know if you get anywhere.

Chris

Hey guys, im having this issue too. Looks like a few months late to the post.

Best i can figure is that no report is available and you have to check manually on your merchant account transaction list.

Does anyone have an update with a better solution?

Thank you for joining the thread and sharing the steps you've taken so far @Sam1437.

I suggest contacting our Technical Support team for assistance. They can pull up your Merchant account info and investigate this issue for you. Check out this article for the steps: Contact Payments or Point of Sale Support. Please take note of their operating hours, so you know when they're available. 

If you encounter any issues with recurring templates in the future, refer to this article: How to handle a recurring transaction that did not run. 

Tap the Reply button and post a comment below if you have other questions in mind. I'll get back to you as soon as I can. Have a pleasant day!

Was this ever resolved?  I wonder how many other businesses this is happening to but don't know it YET!  We just made the discovery this has happened to our business.  There are over 12 months of recurring transactions for one customer, 9 months on another customer and 2 months on another customer which we haven't been paid for. QBs sent a sales receipt each month (declaring the that the transaction was paid) but none of the transactions made it over to Intuit.  Money owed that never made it to our bank.  The customers all believe they paid as they were sent receipts.  Mind boggling.  There is definitely a bug in this system.  The check boxes are somehow being auto unchecked by QBs software.  There is no other way to explain how one customer's transactions went through Intuit and into our bank for three months and then suddenly stopped. This is a lot of missing money.  How does one go back to a customer after a year went by and tell them they owe for the entire year? 

I appreciate you for sharing your experience with us, Banker.

This issue with the sales receipt showing as paid even if it's not can best be handled by our Technical Support. This requires a thorough investigation to identify the cause and come up with a fix. They're equipped with tools to securely look into your account and check the main cause of this.

Please click this link to reach out to our support: Contact Payments or Point of Sale Support.

I'm looking forward to hearing this being resolved. Let me know if you have other QuickBooks questions and I'll be here to help. Wishing you a good one.

You're a day late and a dollar short.  Been there done that!  Imagine my panic upon the discovery of this bug. I requested a call back when we found this mess.  Have already spoken with someone about the problem.  There's absolutely nothing they could do to help us.  They indicated this is a known bug and that many people have called in with the same issue.  You can't send people receipts for something they haven't paid for. Well I guess you can, you are doing it!  Someone needs to fix this as it's costing small businesses.  The worst part about this is QBs knows this is an issue but doesn't bother to tell any of their customers nor are they bothering to fix the problem.  Had we known there was an issue we could have dealt with it before over a year has past.  Knowing would have caught the last two who fell through this crack.  I just have to say "shame on Quickbooks" for allowing this to continue and keeping it hush.  It's just not right! 

I have never once replied to the literal thousands of posts I've found in QB Support but I felt compelled to here due to the sheer frustration so many of you are experiencing. I can surely relate to the annoyances felt by all of you when you get stock responses by agents just trying to beef up their post count and not actually making an effort to even understand the situation much less provide actual help. 

Anyway! I wanted to say that I am a general manager for a firm who provides bookkeeping and accounting services to business across the country and I deal with this issue with so many of my clients. Two practical solutions to the system Intuit has designed are as follows:

1. If you choose to use sales receipts, I understand this is the preferred method of billing because you as the business owner have control over setting up those recurring payments so this option is most attractive. Card in hand, bill it, get the money! That being said, we end up with this exact problem and the only way to work around this is to check the report manually every month to ensure you've received the deposits you should have against your merchant account charges. 

2. You do have the option to set up recurring invoices. If you enable online payments in your invoice, you can then direct your customer to set up auto pay from the initial invoice. There are some sales concepts at play here which make this a less attractive option of course from the perspective of customer retention but it also makes the unpaid invoices factor much easier to detect than the sales receipt option. There's a video here which explains this: 

I wanted to specifically address the person who was saying that invoices are showing up as paid even though they haven't been. This issue is likely due to payments being received into undeposited funds erroneously or difficulties matching transactions in the bank feed correctly. These are both very common issues and I would suggest watching some videos found from the search terms: "undeposited funds" and "matching from the bank feed in QBO."

Finally, for the problem at hand when you know you have a sales receipt that's showing paid but hasn't been paid, the fix for this is to delete the sales receipt and recreate this as an invoice. If the amount is collectible, the amount lives in your AR as an asset until you receive the payment against your invoice. If the amount is uncollectable, you should create a credit memo (not vendor credit) for the amount of the invoice and categorize that amount to an expense account called "bad debt." Then go to "receive payment" and receive payment against that invoice with the credit memo you've created. This will remove the balance from AR and show the amount is a bad debt that is writing off the uncollectable amount. You can find more information about this if you search "how to write off an invoice in QuickBooks online."

Quickbooks is an incredibly user friendly program that takes sometimes complicated accounting principles and makes them effortless for the lay person to execute. This also has the effect of instilling a false sense of security when it comes to understanding of those principles and that's how we end up with lots of frustration and really messy books. I see this kind of think every day and it's unfortunate that the support professionals here aren't more tuned in to those circumstances. 

I hope I've provided some help! Good luck! 

Tabitha_at_Koda, thank you kindly for your lengthy reply. I am appreciative of the time you spent. However, it also does not answer my question or solve this problem. 

1) Regarding sales receipts, you wrote "the only way to work around this is to check the report manually every month"...but you didn't mention which report. (QB Says it doesn't exist...except...see below.)

2) Invoices won't work for the reasons you state. We need automatic recurring transactions that do not require manual work. It's the simplest thing to do is most other accounting systems...but not QBO.

To recap, here are my situations:

a) The recurring sales receipt template doesn't have a payment method set.
b) The recurring sales receipt template has a payment method set, but doesn't have the "Process Payment" box checked
c) The selected payment method fails when the sales receipt is generated.

A&B are actually the same problem -- no payment is attempted. I do still do not have a solution for these.

C is the more common issue, where the payment fails. And I do think I have a solution.

And here are my questions for either A, B or C:

1) How can we generate a report of all Sales Reciepts that show as PAID but are actually NOT PAID?
2) How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid?

I am as annoyed as ever with Quickbooks for not fixing this VERY BASIC ACCOUNTING PROBLEM. It's bad bookkeeping, bad business, and BAD SOFTWARE.

I do have a partial solution to this for situation C, where the sales receipt payment was attempted but the credit card payment fails.

1) How do you generate a report of failed Sales Receipts? 

Two Answers:

You can get a list of ALL Sales Receipts. The ones that failed stand out in RED. To do this: 

• From the Sales menu, choose "All Sales"
• Click "Filter" and under "Type" choose "Sales Receipts"
• The ones that failed will show a status of "Paid (Payment failed)" in RED.

Here's a better solution: 

• On your Dashboard, in the "Get Things Done" tab (which I think is the default tab), if there are failed transactions, you will see an alert box that says "Alert. Several customer credit card payments were declined. Although the transactions are stamped PAID, the payments failed. To fix: Go to Payment Processing Errors and take the recommended actions." 
• Click the Payment Processing Errors link in the message, and that will take you to a screen called "Credit Card Processing Errors". Or just go here: https://app.qbo.intuit.com/app/masfailures
• All of your failed sales receipts will be listed there.

Hallelujah!

Now, regarding the next question...

2) How can I apply a payment to a Sales Receipt that shows as paid but is not actually paid?

• On the Credit Card Processing Errors screen, you will see an "Edit" button on each line. Click that.
• You will then see the actual sales receipt.
• If you want to try the same credit card again, click the "Process Again" box (below the payment method) and click "Save".
• QB will try again to process the transaction.
• If you want to try a different credit card (ie the client's card expired and they give you new info), click the Payment Method button (just as you did when creating the Sales Receipt template) and enter in new CC information. 
• Once you're done entering the CC information, click the "Process Again" box and click "Save". 

We still do not have a solution for problems A&B (where the payment info was not entered, or the "Process Payment" box was not checked in the template. THIS IS STILL AN OPEN ITEM, and happens to be the problem I am dealing with right now. 

But back to the solution I've just written above...

Why don't any of the support people at Quickbooks know these answers I just listed? In this thread, we are told time after time by QB Support FOR OVER A YEAR that there is no report. But it DOES exist. And those dopey support agents are just too clueless about their own software to know it, or they weren't trained well enough to know better.

I wasted a year on this. I hope the solution helps others. 

And if anyone else can think of a solution to A&B, I would greatly appreciate your writing about it.

Thank you.

-Mark

p.s. I firmly believe that Quickbooks should not hire any support staff who have not been small business owners and actually had to rely on the QBO software to get their job done.

Whoops. Double posted. I would have deleted this post, but there's no option for that.

So I've deleted the duplicate content instead.

-Mark

Ok, not only was this issue blood boiling when I discovered it. Then I found this post of others that were frustrated, namely the poor responses from QB.

45 min later... taking a deep breath as I just found $4,500 not charged from last month alone. Afraid to go look at the previous months.

First things first. Log into your merchant account via Intuit -- https://quickbooks.intuit.com/learn-support/en-us/help-article/security-risk/access-manage-quickbook...

On the top Top menu --> Activity and Reports --> Transactions.

Narrow the date to the interval in which you are checking.

I did all of January 2022.

Now in another screen pull up QB - Sales --> All Sales --> Filter to the same date range that you just used and as a Sales Receipt or Invoice (in my case we only use Sales Receipts). This will give you all the sales receipts that posted.

I exported the QB list and compared it to the merchant account list (as this is the list of ACTUAL payments that went through/or declined). Anything that was a sales receipts but couldn't be found on the merchant list was marked as PAID but it clearly never ran (unless it was cash or paper check it wouldn't have run through the merchant account).

Here was the common denominator - when I clicked into the sales receipt that seemed to be missing from the Merchant Account, the little box that says "I have authorization to process this transaction" was not checked. Even though all the information was input for the payment method AND the amount due said $0 (making me think it was paid).

As soon as I clicked that box, navigated out of the sales receipt and then came back to it it said it was processed. When I clicked on the now linked "Transaction Processed" words the popup window said it was just then!!!!!

SO from your original post...

a) The recurring sales receipt template doesn't have a payment method set. --- you have to have this inserted.
b) The recurring sales receipt template has a payment method set, but doesn't have the "Process Payment" box checked --- YOU HAVE TO CLICK THIS BOX!!!!!
c) The selected payment method fails when the sales receipt is generated. --- Do the above process to find which ones didn't run, if you are doing it quick enough to the original date you were supposed to run it I suppose you could just check that box and it will run. BUT since it sounds like in many cases it has been some inappropriate time after the fact, you probably need to go into the sales receipt and delete it. Then create a new one.... WITH THE CHECK MARK!!

Some other thoughts...

A Moderator posted this...

In QuickBooks Online (QBO), there is a feature that offers automation. It might be, turned on, that is why it marks your invoices as paid. 

Here's how to check:

1. Click the Gear icon at the top.
2. Select Account and Settings.
3. In the left menu, tap Advanced.
4. Hit the Pencil icon in the Automation section.
5. Check if there is a check-mark in the box next to Automatically apply credits.

If yes, then, that is the reason. To turn off, remove the check-mark in the box next to Automatically apply credits. Then, tap Save and Done. 

I went ahead and turned off all those automations for the next couple of weeks to see what happens. Can't surely do any more damage??? haha

Lastly, in the Merchant Account... if you navigate to the "processing tools" menu there is an option to set up recurring transactions for a card or take ACH. Kind of feels more legit buttt who knows.

It seriously seems like all of it came down to the fact that that little box wasn't checked. *sigh*

This is a bug that bites my companies bottom line. I found a way to see which sales were not paid. 

go to your QB merchant services account. Search all your sales transaction for the last year it will only go back a year. Then export all the data to a spreadsheet. The transactions that are credit card sales that say "paid" have not been processed. The ones that went through say paid_payment_success. Good luck this happens to us when we don't close out the sales transaction with the process payment box checked 

Hello Fritz,

I just discovered the exact same issue with one of my customers. Out of all of our recurring sales receipts, we had one that the "Process Credit Card" button was not checked. This customer has not been billed $2533.00 but all the invoices show as Paid. I read your response to this question, and it does not make sense to for what is supposed to be the "best" accounting software to show a transaction as paid when it is not. This is accounting 101 level stuff. Why would Quickbooks not generate a report or a message alerting us of the problem? I only found this out by accident as I was looking for something else. There is absolutely no flags alerting a company that there is a problem. This brings users to question the integrity of other unknowns, and defeats the purpose of using Quickbooks in the first place. 

Your solution of using an invoice instead of a sales receipt as a solution does not work, as the purpose of the recurring sales receipt is to automatically process the payment, which an invoice cannot do (that I am aware of, anyway). That solution simply takes what is supposed to be automated and turns it back into a manual process, which is the opposite reason to use a Sales Receipt. Please have this corrected, as it causes terrible business losses, as well as destroys the integrity of Quickbooks.

I exported the transactions, but didn't see any that said paid_payment_success.  I see PAID, DECLINED, and PROCESSING.  I was looking to see if I could change the columns, maybe I'm missing one.. or something else.... any ideas?