cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
EmmaP
Level 1

Bulk entry for invoices and expences in Quickbooks online

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.

Solved
Best answer July 03, 2022

Accepted Solutions
katherinejoyceO
QuickBooks Team

Bulk entry for invoices and expences in Quickbooks online

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.

 

 

View solution in original post

10 REPLIES 10
Fiat Lux - ASIA
Level 15

Bulk entry for invoices and expences in Quickbooks online

EmmaP
Level 1

Bulk entry for invoices and expences in Quickbooks online

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.

Birmingham Bookkeeper
Level 2

Bulk entry for invoices and expences in Quickbooks online

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

No Bulk Delete.

SarahannC
Moderator

Bulk entry for invoices and expences in Quickbooks online

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.

Birmingham Bookkeeper
Level 2

Bulk entry for invoices and expences in Quickbooks online

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

katherinejoyceO
QuickBooks Team

Bulk entry for invoices and expences in Quickbooks online

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.

 

 

Birmingham Bookkeeper
Level 2

Bulk entry for invoices and expences in Quickbooks online

Please do not say this is solved because it is not. I would like a bulk entry feature like on QuickBooks Desktop or Sage Batch Entry. I would also like a bulk delete. Surely this is not hard to do especially when something similar is available in the U.S

AileneA
Moderator

Bulk entry for invoices and expences in Quickbooks online

Hello, Birmingham Bookkeeper

 

I know how important to have a functionality that can enter a bulk entry and bulk delete feature like QBDT has. While this is unavailable in QuickBooks Online, I'd recommend sending feedback to our Product Development Team. At times, we roll out updates based on the requests that we receive from our customers. Here's how:

 

  1. Sign in to your QBO account.
  2. Go to the Gear icon.
  3. Choose Feedback.
  4. Enter the new features you would like us to add.
  5. Click Next to submit feedback. 

 

In the meantime, you'll want to consider import multiple invoices at once as a workaround.  

 

Here is an article that will help you understand the differences between QBO and QBDT: Product feature comparison for QuickBooks Online and QuickBooks Desktop

 

If you have any other questions, please feel free to let me know, and I'll get back to you as soon as I can.

Tracey2255
Level 1

Bulk entry for invoices and expences in Quickbooks online

We are being forced to move to other software when Desktop ceases. Surely, Quickbooks Online should offer a like for like software. If bulk entry is available in the US, then why not in the UK?

As for this upload, well this is more time consuming when our supplier invoices are generally sent via postal services.

Come on Quickbooks Online, get your act together and provide a software that is fit for purpose. Sending feedback is fruitless!

Tracey

Ashleigh1
QuickBooks Team

Bulk entry for invoices and expences in Quickbooks online

Hello Tracey2255, thanks for share this with us, we appreciate what you are saying and that desktop to online is very different, we have passed this feedback onto the team. 

Need to get in touch?

Contact us