cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
bcmarko
Level 1

Upload expenses from excel, how to categorize and insure they are going into the right chart of accounts category

 
4 Comments 4
LauraAB
QuickBooks Team

Upload expenses from excel, how to categorize and insure they are going into the right chart of accounts category

Hi there bcmarko,

 

I know how simplifying your data entry with options like importing can be useful for managing your books, and I'm glad to see you're being mindful of the way that your expenses need to be categorized as well. I'd be happy to go over the import options for QuickBooks Online as well as categorizing your expenses so you can move forward with your books.

 

QuickBooks Online offers a number of import options, such as for customer invoices, bills from suppliers, and even banking transactions. You can import using CSV files and then map and work with your data as needed to make sure it's entered into your books. At this time, importing an Excel file for expense transactions is not one of the available options using the built-in import feature. To see the full list of options, check out this article: Common questions about importing data to QuickBooks Online

 

That being said, if you're deciding to import your expenses as bills instead, it's important to be mindful of the difference between these transaction types and how they'll impact your books. This article can help with getting to know the ways these transactions differ: What is the difference between bills, cheques, and expenses?

 

If the expenses are from a file from your bank and you're uploading banking transactions, you can use the following two articles to help with formatting, uploading, and managing those transactions.

However, if you're simply hoping to upload the Excel file you created into QuickBooks Online to work with your expenses, I recommend checking out the partner applications that connect with QuickBooks Online. The Apps tab in the program has a variety of options to choose from, and you can review those options to see if there's one that'll meet your needs.

 

Whether you're uploading your transactions or entering the expenses manually, choosing the right category for your accounting in important. The categories available when working with expenses are linked to expense accounts in the chart of accounts, so when you select an account or the accounts for your transaction, you can be sure they're being organized the way you'd like them to be. If you're not seeing an existing account for something you need, you can create one by selecting the New button in the Accounting tab.

 

If you mean to say you're not certain how to categorize your transactions, an accountant would be a great resource. QuickBooks Team members like myself aren't trained in accounting, and can't offer advice on how to organize your books, but an accountant can. The My Accountant tab in QuickBooks Online's left menu is designed to help you connect with an accountant right in the program. You can either invite an accountant you're already working with as a user to your books or you can use the Find a pro to help button to research accountants near you that know the program.

 

I hope this helps! If you'd like to leave feedback about any of what I've mentioned, you can do so by following the steps here: How do I submit feedback? Your comments help the program evolve and grow, so don't hesitate to share your thoughts. I also welcome you to bookmark the QuickBooks Online Feature and Product Updates page to keep on top of new additions to the software.

 

Wishing you the best!

Fiat Lux - ASIA
Level 15

Upload expenses from excel, how to categorize and insure they are going into the right chart of accounts category

@bcmarko 

As an additional option, you may utilize a 3rd party tool to import multi transaction types. e.g Purchase Cash, Bills, Credit Card Charges.

https://transactionpro.grsm.io/qbo

 

SSWap5922
Level 2

Upload expenses from excel, how to categorize and insure they are going into the right chart of accounts category

Has this changed at all, or is still the case that expenses cannot be imported into QBO via its native import feature? I want to pay dividends by simply importing all them as cheques (Dr Dividends Decl and Cr Bank Account)... I'm wondering if I can import as bills and pay them as suppliers (them = shareholders)? Please and thank you.
Jen_D
Moderator

Upload expenses from excel, how to categorize and insure they are going into the right chart of accounts category

Thanks for requesting some information for the QuickBooks Community, @SSWap5922.

 

To share some insights, the entries you can upload for now in QuickBooks Online are as follows:

 

  1. Invoices
  2. Bills
  3. Journal entries

 

Other expense forms are temporarily unavailable for import. For now, yes, you can use bill import option and then pay it manually in the program. Here are some related links to help you record bill payments:

 

 

Please know that you can share your suggestion within the program through sending a product feedback. Follow the steps below in a web browser:

 

  1. Click the Gear icon and choose Feedback.
  2. Enter your suggestion for our engineers on the Feedback box.
  3. Once done, press Next to send it.

 

If you need further help with the processes and features in QBO, please let me know in the comment below. I'll be right here to share some more information about QuickBooks tasks. Have a nice day!

Need to get in touch?

Contact us