QuickBooks Tip - How to Handle Bounced Checks Without Affect

Find a Bug in the app, site or forums? Please report it immediately so we can squash it as soon as possible.

QuickBooks Tip - How to Handle Bounced Checks Without Affect

Postby leesmith » Fri Nov 17, 2017 2:32 am

Nobody loves QuickBooks as much as we do, but sometimes the instructions found in QuickBooks Help aren't really the best way to handle a tricky transaction. A good example is that the instructions for how to Handle a bounced check from customer (NSF check) results in duplicate sales on the Sales by Customer reports. Even worse if you happen to have a sales rep assigned to the customer and didn't remove it when you re-invoiced, the bounced check it results in duplicate sales on the Sales by Rep reports.

Here are the instructions for how to handle a bounced check in QuickBooks without affecting your sales reports:

Go to Lists > Chart of Accounts and create a new bank account called "Clearing account".
Go to Lists > Item List and create a new Other Charge item called Bounced Check mapped to the clearing account you created above. Create another Other Charge item called Bounced Check Fees mapped to your bank service fee account.
Go to Customers > Credit Memo/Refund. If you have sales reps, modify the credit memo to include the sales rep box by clicking on the Customize button and checking the Screen box next to Sales Rep. Use the bounced check item you created above and enter the amount of the returned check. The sales rep box doesn't automatically populate so if you have sales reps make sure to enter the rep, otherwise your Sales by Rep report will be overstated.
After you save the credit memo, you'll be given a list of options. Select Give a Refund. Unclick the box next to To be printed, enter the date the check was returned, enter EFT for the check #, and enter something like "check returned NSF" for the Memo.
Go to Customers > Create Invoice and re-invoice the customer. Use the bounced check item you created above and enter the amount of the returned check. The sales rep box should automatically populate. If it doesn't, enter the rep. Use the bounced check fee item you created above to pass on any returned check fees your bank charged you.
We'd love to know what everyone else thinks. Feel free to email your comments to ruth@theQBspecialists.com.

Ruth Perryman is the president of The QB Specialists. She is a Certified Advanced Quickbooks ProAdvisor and an Intuit Solutions Provider, with over 19 years of industry experience including 5 years as a Chief Financial Officer. She has been working with Quickbooks since 1996, and specializes in QuickBooks Enterprise and POS installations and troubleshooting. She also provides virtual controller and CFO services.

If you need additional assistance, please call our QuickBooks technical support line at 888-351-5285. The first ten minutes are absolutely free! Plus receive additional free minutes with every purchase - visit our website for more details.


Support Keyword
Quickbooks Support Number
Quickbooks Support Phone Number
Quickbooks Tech Support Number
Quickbooks Tech Support Phone Number
Quickbooks Technical Support Number
Quickbooks Technical Support Phone Number
Quickbooks Customer Support Number
Quickbooks Customer Support Phone Number
Quickbooks Customer Service Number
Quickbooks Customer Service Phone Number
leesmith
 
Posts: 15
Joined: Thu Nov 16, 2017 4:33 am
uGet Version: 2.0
Operating System: windows
System Architecture: 32bit

Re: QuickBooks Tip - How to Handle Bounced Checks Without Af

Postby psyray » Fri Nov 17, 2017 4:00 am

sucker !!!!
psyray
 
Posts: 2
Joined: Fri Nov 17, 2017 3:53 am
uGet Version: 2.1.6
Operating System: Linux
System Architecture: 64bits
Linux Distro: Ubuntu 17.10 / Ubuntu desktop Xorg


Return to Bug Reports

Who is online

Users browsing this forum: Exabot [Bot] and 2 guests

cron