Solved

Voided checks with bill.com

Forum|Forum|5 years ago
November 19, 2020
4 replies
63 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

Level 8

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!

M

Mophetmom

Out of curiosity - how do these questions get marked as solved? does the person asking the question make this determination or does QBO? Because this question shows that's it's solved, but it certainly isn't. Just wondering.

J

JeremiahsInnJLW

Hello, evamath.

I'd like to direct you to the right support for your concern.

Creating journal entries should be the last resort. I recommend reaching out to bill.com to get some advice on how to handle this situation.

Here's a link where you can get their contact information: Contact Us.

Please feel free to comment here again if there's anything else you need. We're always around to help. Keep safe!

Im reading this thread in 2023, having the same issue and really hoping for clear instructions. You suggest contacting Bill.com support, but Bill.com suggests contacting QB for support!?!?! Their first suggestion was to “do what we normally do when a check is voided”, but we would never void a check that cleared the bank or after reconciliation. It looks as though there was a partial fix made so the void no longer automatically syncs to QB. But, it’s still not clear as to what steps we need to take when a payment check is voided on Bill.com, Bill.com refunded the amount to our bank account. It appears we need to reprocess the payment through BDC to get a new check sent out to the vendor. But BDC can’t tell us how this will impact QB or what steps to take. What do I do with the refund BDC deposited into our bank account? What happens when I reprocess the payment in BDC? I’m worried this bill will show up twice, and be paid twice in QB. Does anyone here know what to do?

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

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

Let's get you signed in

Login with SSO