Skip to main content
December 9, 2019
Solved

Bulk entry for invoices and expences in Quickbooks online

  • December 9, 2019
  • 2 replies
  • 0 views

Is there a way to enter invoice & expenses in batch instead of having to enter everyone individually and save and new?

 

I know I could do it on a spreadsheet and import it but it is time consuming having to make sure all the spellings are the same etc

 

If not is there any hope of it being a feature in the future?

 

Thanks in advance.

Best answer by katherinejoyceO

It is available in the U.S I believe so y not the UK ?  It seems very bizarre


Thanks for joining in, @Birmingham Bookkeeper.

 

To clarify, QuickBooks Online US version can only create and send multiple invoices in QuickBooks Online Advanced

 

For the UK version, the quickest and the best option is to import them at once.

 

Here's how:

 

  1. Go to Settings menu and then select Import data.
  2. Select Invoices, then select Browse and then find and select the spreadsheet of your invoices. 
  3. Select Next.

 

After that, make sure to map your spreadsheet’s column headings to match with QuickBooks fields. 

 

Here's how:

  1. Map the column headers with invoice fields in QuickBooks. Fields with an asterisk (*) are required.
  2. Select Not applicable for any fields not in your spreadsheet. If product or service isn’t added, QuickBooks populates with a generic item called "sales".
  3. Select the date format you used, like DD/MM/YYYY. Note: While importing the invoices, ensure that the invoice dates are in present and past. The invoices with the future dates will not be imported.
  4. Select Exclusive or Inclusive as your tax option. To see this option, set up VAT in QuickBooks.
  5. Click Next.

 

Then, map your tax codes:

  1. Match your VAT codes to those setup in QuickBooks.
  2. Select Next.

 

For further insights, follow the steps shared in this article: Import multiple invoices at once.

 

Get back to us if you have more concerns. We'll be around to guide you.

 

 

2 replies

Fiat Lux - ASIA
December 9, 2019
EmmaPAuthor
December 9, 2019

I was after a way to do it within quickbooks as apose to paying more on top of what I already pay for the program.

June 24, 2022

Two & A Half Years Later Now 2022 Still No Bulk Entry Like Desktop.

No Bulk Delete.

June 24, 2022

Hello there, @Birmingham Bookkeeper.

Letting you create multiple invoices and other transactions one at a time will surely help you do your QuickBooks task smoothly. However, bulk entry and bulk delete are not yet available in QuickBooks Online.

 

We take customer suggestions as opportunities to improve the various features of our products. This helps us improve your experience while using the program. Here's how you can send your feedback to our Product Team.

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Type in your recommendation in the Share your feedback field.
  4. Click Next.
  5. Follow the on-screen instructions to complete the process.
     

I suggest visiting one of our help websites: QuickBooks Help Articles for additional guidance on utilizing QBO to manage your account and the expansion of your firm. 

 

The Community will always have your back if you need anything else in running your business, Birmingham Bookkeeper. Let us know by commenting below.

July 2, 2022

It is available in the U.S I believe so y not the UK ?  It seems very bizarre