Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
emrosenow
Level 1

Batch Invoicing

Hello,

I'm seeking help with batch invoicing using QBO Advanced.  I want to bill 200 school customers for several different products and quantities based on student enrollment for each school.  Not all schools would be billed for the same products or quantities.  I'm assuming I'll need to create/import a spreadsheet and am looking for advice on how best to accomplish this as painlessly as possible:)

 

Thank you for any help!

5 Comments 5
SheandL
QuickBooks Team

Batch Invoicing

That's right, emrosenow. You can create and import a CSV file to accomplish this task seamlessly. 

 

With the Batch invoicing feature in QBO Advanced, you can manually enter up to 30 invoices at once. Since you want to bill 200 school customers, you can use the Import CSV  option to streamline the process. 

 

Take note that you can only upload up to 150 transactions at a time. Hence why, you'll need to make two separate files. Here's how to import your invoice:

 

  1. Select + New.
  2. Select Batch transactions.
  3. Click the Import CSV.
  4. A window will pop up and from there on, click the download this sample CSV, to ensure that you're following the proper format. 
  5. Hit Browse and select the data you've saved.
  6. After that, click Next.
  7. Once the data is in QBO, choose Save and send.

 

Moreover, you can visit this article if you learn how to split estimates into as many invoices as you need. Set up and send progress invoices in QuickBooks Online.

 

If you have further questions about batch invoicing, you can always get back to this post by leaving a reply below. I'm always here to lend a hand.

4Gal
Level 11

Batch Invoicing

@emrosenow 

If you are using QB Payment, you can prepare Inoivce data with the following template

RefNumberCustomerTxnDateDueDateShipDateShipMethodNameTrackingNumSalesTermLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailBillEmailCcBillEmailBccCurrencyExchangeRateDepositToBePrintedToBeEmailedAllowIPNPaymentAllowOnlineCreditCardPaymentAllowOnlineACHPaymentShipAmtShipItemDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y HandheldsPortable Game Player1100  TAX

 

then use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

emrosenow
Level 1

Batch Invoicing

 
emrosenow
Level 1

Batch Invoicing

Thank you for the help!  My challenge will be developing the csv file of the myriad products and order quantities for each of the 200 schools we need to invoice.  Any advice regarding that is welcome!

emrosenow
Level 1

Batch Invoicing

Thank you for your reply.  I'm not using QB payment.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us