Skip to main content
L
LAinscough1
March 30, 2023
Question

Bill.com Funds Transfer Journal Entry numbering in QBO

  • March 30, 2023
  • 1 reply
  • 0 views

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!

1 reply

Angelyn_T
Angelyn_T
March 30, 2023

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!

L
LAinscough1Author
March 30, 2023

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.

R
Rasa-LilaM
March 31, 2023

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. 

Terms & ConditionsAccessibility statement