Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
L
lindak1119
Level 7
December 7, 2018
Question

Uploading bills

  • December 7, 2018
  • 2 replies
  • 1 view
is there a template I can use to upload the bills.

    2 replies

    K
    KhimG
    Level 7
    December 7, 2018

    Hi there, @smudegowder.

     

    It’s nice to have you in the Community. I’m here to share a few details about uploading bills in QuickBooks Online.

     

    QuickBooks has the option to customize standard templates or create a custom template for you to use. However, you can only import invoice template, not bills.

     

    If you want to import bills transaction into QBO, this option isn’t yet available. I suggest checking out some third-party add-in apps available.

     

    All you need to do is head to the QuickBooks App Center and search for a term like Import Bills. With so many available apps to download, one is sure to be a perfect fit for your business needs.

     

    The other option you have is to manually enter the data to record the vendor bills. To do that, follow the steps below:  
    1.    Go to the Plus (+) icon and select Bill.
    2.    Enter necessary information. 
    3.    Click Save and new. (Screenshots attached)

     

     

     

    While importing bills isn't yet available, I recommend sharing us your insight and opinion by clicking the Gear icon and selecting Feedback. This way, our product team would know what you liked and what we can do to make it better. 

     

    You may also send your feedback by going to the following link: QuickBooks Online Feature Requests. I’ll make sure to do the same thing on my end.

     

    That's it. Please let me know if I can be of additional assistance or should you have any follow up questions. I’ll be here to help. Have a good one!

    B
    BobTheMighty
    April 17, 2019

    I'm shocked that this isn't a standard feature. 

     

    Are there any plans to allow importing of bills any time in the future?

     

    I refuse to pay for a plugin to do this. I don't trust 3rd parties and am horrified by having the additional expense, we already pay a lot for QBO.

      Kristine Mae
      Kristine MaeModerator
      Moderator
      April 17, 2019

      Good day, BobTheMighty.

       

      We're always doing our best to provide the features and services that our customers need. 

       

      At the moment, there is no announcement about adding this feature. Nonetheless, you can check our QuickBooks blog to be informed on our new updates.

       

      I know another company expense can be a sensitive issue. Rest assured, I'll pass along what you've said about importing of bills onto our management team. They will submit this to our software engineers for review.

       

      If you have other concerns, you can visit us anytime. Have a nice day! 

       

      R
      Raj28
      January 8, 2022

      HI, I am standard user and not able to see import bill and Journal entry in Gear ==> Import data ==> Import bill and Journal entry are not reflected.

       

      Please suggest. 

      Fiat Lux - ASIA
      Fiat Lux - ASIA
      Level 14
      January 8, 2022

      @Raj28 

      Prepare your data with the following template

       

      Bills

      RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
      101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
      101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
      101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
      185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125.13           

       

      Journal Entry

      RefNumberTxnDatePrivateNoteIsAdjustmentCurrencyExchangeRateAccountLineAmountLineDescEntityClassLocation
      10101/10/2020Wire TransferFALSE  Savings-50.00Credit Savings   
      10101/10/2020Wire TransferFALSE  Checking50.00Debit Checking   
      10201/10/2020Wire TransferFALSE  Savings200.00Debit Savings   
      10201/10/2020Wire TransferFALSE  Checking-200.00Credit Checking   

       

      then utilize an importer tool

      https://transactionpro.grsm.io/qbo

       

      R
      Raj28
      January 8, 2022

      In import option, Journal entry and bills icon are not reflected. only i am able to see Bank Data, Customers, Vendors, Chart of Accounts, Product and services and invoice (i.e., Journal entry and bill not reflected)

       

       

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement