Solved

Voided checks with bill.com

Forum|Forum|5 years ago
November 19, 2020
4 replies
0 views

Hello, I'm new so any pointers would be appreciated.

We use Quickbooks Online along with bill.com for AP. When a check expires, it is either bill.com or QBO (not sure which one) that goes back to the original date and voids the amount.

For instance, a check is sent on 8/1, it expires after 90 days on about 11/1. From my view, it should be correct to create a JE on 11/1 that reverses the check. Instead, what currently happens is that the original transaction on 8/1 is zeroed out. Unfortunately, this is something that we cannot ignore since we report monthly and it is causing issues with AP. Which one is causing the issue? And is there a way to fix it without having to make manual JEs?

Already tried talking to bill.com customer service and they have not been able to give me a straight answer.

Thanks in advance!

QuickBooks Online

Best answer by Jen_D

I can share some information about this Bill.com concern, @jack78,

In QuickBooks, we do not automatically void transactions. Instead, all actions related to existing entries are to be done manually, like, editing, deleting or voiding. This is because we want to make sure your books and financial report data isn't altered erroneously.

However, in Bill.com, check payments that are not cashed within 90 days will auto-void. You will see this information under Void check service fees section of this article: Voiding bill payments and what to expect (Bill.com)

In relation to this, the article states that the void will sync back to your QuickBooks Online account, and no further action is needed. This is the reason why you're seeing the transactions being zeroed out.

If there are open bills, the bill will show as unpaid after the sync. Please note that Bill.com will not re-debit your account after the auto-void. If you don't need to pay the bill, you can either edit, delete or mark the bill as paid so it is not accidentally paid.

Use the same process of paying the bill to ensure your Accounts Payable balance is fixed.

Let me know if you have any other billing questions or need any help with the software. I'll be more than happy to help you. Have a good one!

Jen_DAnswer

I can share some information about this Bill.com concern, @jack78,

In QuickBooks, we do not automatically void transactions. Instead, all actions related to existing entries are to be done manually, like, editing, deleting or voiding. This is because we want to make sure your books and financial report data isn't altered erroneously.

However, in Bill.com, check payments that are not cashed within 90 days will auto-void. You will see this information under Void check service fees section of this article: Voiding bill payments and what to expect (Bill.com)

In relation to this, the article states that the void will sync back to your QuickBooks Online account, and no further action is needed. This is the reason why you're seeing the transactions being zeroed out.

If there are open bills, the bill will show as unpaid after the sync. Please note that Bill.com will not re-debit your account after the auto-void. If you don't need to pay the bill, you can either edit, delete or mark the bill as paid so it is not accidentally paid.

Use the same process of paying the bill to ensure your Accounts Payable balance is fixed.

Let me know if you have any other billing questions or need any help with the software. I'll be more than happy to help you. Have a good one!

J

jack78Author

Hi, @Jen_D

Thank you for the reply. So, to be clear, this issue of changing the original journal entry for a bill is an issue with bill.com? Would you happen to know if there is a way to prevent this from occurring, other than a manual JE?

AlcaeusF

Hi there, @jack78.

I appreciate you for getting back to us here in the Community. Allow me to chime in for a moment and provide some information about the issue concerning the journal entry.

To answer your question, yes, auto-voided checks for payments not cashed within 90 days are related to Bill.com. Any changes to the information like transactions being zeroed out will also sync the data into our product.

Since the way checks are handled depends on Bill.com, it would be best to reach out to them again. One of them will be able to provide some advice about how to prevent the issue other than a manual JE.

To contact their customer support, you can visit this link: https://www.bill.com/contact-us/.

For additional reference, I've attached a link you can use to learn more about entering a journal entry in QuickBooks: Create a journal entry in QuickBooks Online.

Drop me a reply if I can help you with anything else concerning QuickBooks. Hoping you have a good one.

J

jgenshlea

I can't think of any reasonable justification for voiding a reconciled item. It's a hack, a kluge on the part of bill.com. Given that QB is essentially packaging bill.com in their interface QB does have some ownership. This is bonkers. Every month I have to unvoid voids and create JEs.

The proper work flow for a void is for bill.com to post (using the API) a JE or other instrument that debits checking and credits the A/P. END OF STORY.

TERRIBLE!

E

EJL123

The issue of Bill.com voiding a payment (e.g. for a check that wasn't cashed) in a past reconciled period that causes a "Not Ready to Reconcile" error in Quickbooks in the next period has been a regular cause of frustration and lost time. I am happy to report that I have found the following workaround. It's still annoying to have to do this, but at least it works. Here it is:

1. Let the voided payment stand -- the "void" marks the payment as unpaid in Bill.com (and that's probably why they do it in the first place)

2. Set up a "Bill.com A/P Wash Account" -- this can be set up as a sub-account of Accounts Payable (this only needs to be done the first time)

3. Create a new Adjusting Journal Entry to REVERSE THE VOID on the original date of the voided payment

JE #1 Date 12/14/22	DEBIT	CREDIT
Bill.com A/P Wash Account	$123
Bill.com Money Out Clearing		$123

4. Create another new Adjusting JE to "REVERSE THE REVERSAL" on the date of the actual Refund

JE #2 Date 3/20/23	DEBIT	CREDIT
Bill.com Money Out Clearing	$123
Bill.com A/P Wash Account		$123

Note that these 2 journal entries essentially cancel each other, while moving the reversal to the period in which it actually occurs.

5. Next, go to the Bill.com Money Out Clearing account's Bank Register and on the date of the original payment manually reconcile the "REVERSE THE VOID" item by marking it 'R" - now the Not Ready to Reconcile error should clear

6. Now go ahead and reconcile and the universe should once again be in order

Example-of-QB-entries-to-fix-Bill-com-improperly-voiding-reconciled-payments.pdf

J

jgenshlea

Thanks for the great level of detail of the work-around

My beef though isn't about the work around, I was actually able to figure out the work-around. My beef is with Bill.com for the method in which they void a reconciled item in the first place. It demonstrates a complete lack of knowledge about accounting.

E

EJL123

Yeah, I have the same beef with them. The whole thing is pretty pathetic. I only just figured out the workaround after suffering from this problem for 3 years, so I figured I'd post it in the event that it might help others!

P

PGM1230

Hi, everyone. We've found a workaround for this issue:

(1) Void the check in BILL.com but (this is important): uncheck the box to sync with accounting software so it doesn't sync

(2) Make a JE in your accounting system. We DR Money Out Clearing and CR the original account used to issue the payment, including the name and proper class (if using classes in QB)

(3) Reissue the payment. We usually add "RE" in the invoice name for the reissue so we know it is a reissue.

Hope this works for you?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded