I use QBO and bill.com for ach payments to Vendors. How can I keep the dates of when the bill is created from being synced vs the date it is processed or paid?

jspfautz · ‎June 01, 2022

If I post income on May 31 and post a bill for payment on May 31 the bill payment date changes to the date it is processed by bill.com. So income is in May and expenses end up in June How do I fix it ?

Archie_B · ‎June 01, 2022

Thank you for posting in the Community, jspfautz.

I'm here to share some information on how bill.com interacts with QuickBooks Online.

When you pay bills or receive payments through Bill.com, it interacts with both QuickBooks Desktop and QuickBooks Online, eliminating double entering. Changes made in one system will automatically affect the other.

All of your action, such as submitting a new bill or sending a payment, will immediately sync once it's connected. This also saves you time and effort by giving you a clear financial picture.

You can check out this link for more details about the QuickBooks and Bill.com Integration.

If you have any more questions or concerns concerning Bill.com integration, I'm always happy to help. Simply include them in your comment below. Have a wonderful day!

View solution in original post

Archie_B · ‎June 01, 2022

Thank you for posting in the Community, jspfautz.

I'm here to share some information on how bill.com interacts with QuickBooks Online.

When you pay bills or receive payments through Bill.com, it interacts with both QuickBooks Desktop and QuickBooks Online, eliminating double entering. Changes made in one system will automatically affect the other.

All of your action, such as submitting a new bill or sending a payment, will immediately sync once it's connected. This also saves you time and effort by giving you a clear financial picture.

You can check out this link for more details about the QuickBooks and Bill.com Integration.

If you have any more questions or concerns concerning Bill.com integration, I'm always happy to help. Simply include them in your comment below. Have a wonderful day!

Rainflurry · ‎June 01, 2022

@jspfautz

There's not really anything to fix. Assuming you are a cash basis business, if you schedule a payment on May 31, but the check or ACH payment isn't made until June 1, technically, you do not have an expense until June 1 - the date the payment is made, not scheduled. You need to schedule the payment on May 30 if you want it to book on May 31.

jspfautz · ‎June 01, 2022

We are a real estate company. We get commission in as income and then same day pay out realtors. We need income and expense in the same month. Especially important at the end of the year that expenses are expensed they day they are "paid" not when they clear. I can't enter them on the 30 since I don't have the income yet. I can't believe there isn't a "work" around to use the bill "created" date? Thanks !

Rainflurry · ‎June 01, 2022

@jspfautz

I'm not familiar with the Bill.com integration with QB Online. I use Bill.com with QB Desktop and I can change the date of the payment in QB Desktop after Bill.com has posted it. Are you not able to change the date of the payment in QB Online from June 1 to May 31?

jspfautz · ‎June 01, 2022

I will try that in the morning after the items come through the bank feed. Sounds like the only way to fix it... a little "messy" remembering to change them etc but the best solution I've heard so far. Thanks.

Topics

Training

Community

Resources

I use QBO and bill.com for ach payments to Vendors. How can I keep the dates of when the bill is created from being synced vs the date it is processed or paid?