RE: I deleted all the invoices that were showing up in the bank register as duplicate , but when i run a Sales by customer report , customer names showed up but with ZERO sales . And i did run a profit and loss report it did not show any income at all.
Yes, that's because you deleted the invoices.
The issue, which Intuit reps can't seem to comprehend, is likely that you have one or more sales items that are set up to use your Bank account as the account, and which were used on the invoices. This is almost never correct accounting.
Resolve this by editing the item(s) that use the bank account and specify a different account, probably an income account.
Thanks for reaching out to me , Since I did delete the duplicate invoices in Bank Register, now my bank Statement matches .my end balance in my Bank register .
If I recreate the deleted invoices my balance will decrease by the total amount of the invoices .
What version of Quick Books Tool Hub should i down load ? there were different versions
Could you if possible send me the link .
Thanks
@al252 "If I recreate the deleted invoices my balance will decrease by the total amount of the invoices ."
If your bank account balance is decreasing as a result of creating invoices for your customers, your books may need significantly more help than this community can efficiently offer.
Sometimes it is best to reach out to a local accountant, get some boots on the ground.
Thanks Big Red Consulting , The issue was in ITEM settings .I chose the right account and saved it
Now should I reverse the deleted Invoices ?
And would this resolve the Sales By Customer Issue ?
@al252 RE: If I recreate the deleted invoices my balance will decrease by the total amount of the invoices .
If you record an invoice and an entry in your bank account is created, then one or more of the items you used on the invoice is set up to use your bank account. That is the issue you're seeing.
To fix it, edit the items that use the bank account and change them to not use the bank account. That's all you need to do. It's a very easy fix.
@al252 RE: Now should I reverse the deleted Invoices ?
You can't un-delete them. QuickBooks doesn't offer un-delete as an option.
You'll have to enter them again.
Since i did delete the invoices, the total amount of each invoice is transferred into UN-deposited funds , now should i remove the payments from UN- deposited Fund and then create new invoices with correct Item account number?
Invoices won't impact your undeposited funds account - unless you include payment line items on them. Otherwise, only payments received and deposits do that.
If you recorded A/R payments against invoices and then deleted the invoices, and then recreated them again, then edit the payments and select the invoices they should pay.
Since I did delete the PAID Invoices in my BANK Account , amount of each invoice is transferred into UN- Posited funds , and under Account Receivable in chart of accounts it shows total of all the deleted invoices as RECEIVABLE .
Should I delete everything in the Record Deposit window before I recreate new invoices?
Deleting invoices does not impact the Undeposited funds account.
Deleting will change your A/R balance, because invoices are recorded in the A/R account.
Assuming the invoices are real and should not have been deleted (seems so) then record them again and then apply the now-unapplied payments to them by editing the payments and selecting the appropriate invoice to pay.
Thanks Big Red Consulting for guiding me to solve my issues . Now everything is properly fixed and functioning
How ever i have one more issue with a paid invoice .
Can I modify a paid invoice ? I had to use customer's available credit for payment and by mistake i use another check to pay it.
Thanks
i have one more issue with a paid invoice .
Can I modify a paid invoice ? I had to use customer's available credit for payment, and by mistake i use another check to pay it.
Thanks
It's good to have you back here, @al252. Yes, you can modify the paid invoice and apply the available customer's credit to correct it. Let me provide the full information below.
First, you'll need to delete the payment, reverse the invoice to unpaid, and apply the remaining customer credit.
Here's how to delete:
Afterward, proceed to apply the customer credit to the invoice. For detailed steps, check option 3 from this article: Give your customer a credit or refund in QuickBooks Desktop for Windows.
You'll want to personalize email templates. Feel free to check out this article for more details: Create custom email templates in QuickBooks Desktop.
Let me know if you have other queries aside from deleting customer payments. I'll be happy to help you. Have a wonderful day.
Thanks for providing info. I am using Quick Books Pro 2008 .
When I go to customer Payment Window i see UN-Apply Payment , I do not have Payment tab or tool bar showing DELETE..
Yes, that's because your version is ancient. Nearly as old as the hills. And so you have the old user interface from before Intuit messed it up.
To delete most any transaction in QuickBooks, pick Delete... from the Edit menu. Or use the shortcut key combination Ctrl-D - as noted on the Edit menu.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here