cancel
Showing results for 
Search instead for 
Did you mean: 
LAinscough1
Level 1

Bill.com Funds Transfer Journal Entry numbering in QBO

We use bill.com as our payables solution and synch to QuickBooks Online.  We have automatic numbering for Journal Entries in QuickBooks online.  Each day there is payment activity in bill.com it creates a Funds Transfer Journal Entry in QuickBooks online.  It used to synch over and use the next QuickBooks JE number.  Since about mid-February the entry now has a numbering scheme of "BILL mm-dd-yyyy AP" instead of using the next JE number (for example, the next number should be 8542).  Anyone know how to resolve this without editing each JE number every time?

 

I chatted with bill.com who say they don't send numbering information.  I also tried chatting with QBO support and the person gave us and left my conversation

 

Any suggestions would be greatly appreciated.

 

Thank you!

7 Comments 7
Angelyn_T
Moderator

Bill.com Funds Transfer Journal Entry numbering in QBO

I can see how important it is for you to get the correct numbering of your journal entries, @LAinscough1. Let me share some insights about this feature.

 

QuickBooks Online (QBO) simply accepts the data feed by bill.com. In this case, we don't have control of the numbering scheme of the journals posted by bill.com. If you need to change the numbers, you need to modify each manually. I know this may take time especially if you have bulk transactions. As a workaround, you can look for a third-party application that supports the process of editing transaction numbers in batches.

 

Here's how:

 

  1. Sign in to your account.
  2. Go to the Apps menu.
  3. Click on Find apps.

 

On the other hand, I'm adding these articles for more hints while paying bills online in our system:

 

 

Thank you for taking the time to drop a post here in the Community. If you have follow-up questions, let me know by leaving a comment below. I'm always here to help. Have a good one!

LAinscough1
Level 1

Bill.com Funds Transfer Journal Entry numbering in QBO

Thank you for your reply.  Just to clarify, they are not payments.  It is a Journal Entry that credits the checking account and debits the Bill.com Money Out Clearing Account.  It worked until around mid February and then started not picking up the next JE number.

Rasa-LilaM
QuickBooks Team

Bill.com Funds Transfer Journal Entry numbering in QBO

Let's get you connected to the right support that addresses your concern on time, LAinscough1.

 

As previously stated by my colleague, QuickBooks Online (QBO) accepts the data sent by your online bill pay provider. Since the numbering scheme is incorrect, I suggest contacting Bill.com support again for further assistance.  When the issue has been identified, they will assist you in implementing the real-time solution.


You can go over this reference to learn more about managing your bills in the online program and other platforms: Enter and manage bills and bill payments in QuickBooks Online.


Also, the following link contains a list of resources that will show you the steps to handle your accounting activities in QBO: Community guide


Fill me in if you have other questions about bills or concerns about the product. I'd be delighted to answer them for you. Have a good one. 

LAinscough1
Level 1

Bill.com Funds Transfer Journal Entry numbering in QBO

Thanks so much for your reply.  The first bill.com support session I had was unhelpful as they stated they do not send any numbering.  This is not the case as I was finally able to speak with a tech support person at bill.com who said this was a new feature they rolled out because of customer feedback.  It is not an option so I have submitted feedback to them asking them to make it a configuration option, rather than have bill.com dictate what is sent for the numbering.

allisonboom
Level 1

Bill.com Funds Transfer Journal Entry numbering in QBO

I hope they do make this an option because I would prefer that JE's created by an outside source use a different numbering convention. I use my initialsxx for JE's I post and don't want bill.com to use that.  I'd rather have it use billxx so I can easily identify them.

GTygert
Level 2

Bill.com Funds Transfer Journal Entry numbering in QBO

I hate this new feature! I would also like the ability to turn it off. I'm not sure where Bill is picking up the J/E number for mine, but everyone starts with the name of one of our vendors and a random number so I have no choice but to go in and delete it each time! 

 

Is there a place where we set the first J/E number or something?

 

 

JaeAnnC
QuickBooks Team

Bill.com Funds Transfer Journal Entry numbering in QBO

Hello there, @GTygert.

 

Please know that QuickBooks Online (QBO) solely relies on the information provided by the Bill.com app when syncing it with QBO. That said, I recommend reaching out to their customer representative so they can disable the journal entry transaction numbers. They can also assist you in setting the first journal entry number.

 

Moreover, you can schedule a bill payment with QuickBooks Bill Pay to avoid delays in paying your bills.

 

Fill me in if you have other concerns about QBO and Bill.com integration and I'll chime in to answer your queries. Keep safe, and have a great rest of the day.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us