- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Uploading bills
I'm trying to create a bill that will easily upload into QBO. I need it to include multiple lines of item details. Including product, description, qty, rate, customer/project, and class. Is there a template that I can use?
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Thank you for reaching out regarding creating a bill that will easily upload in QuickBooks Online (QBO), Sflesher. Let me share with you some steps that will help you.
When uploading an image of a bill, you don't need any template. However, there are things to be considered to ensure a successful import. Please check out the pointers I've listed below:
- Make sure the picture is clear and doesn't contain sensitive or personal info, like credit card numbers.
- The supported formats are PDF, JPEG, JPG, GIF, and PNG images. If you have HEIC images from a newer iPhone or iPad, you can convert HEIC images to a compatible format.
- Receipt snap only supports the home currency.
Once you're ready, follow the steps in this article to upload the bill: Upload your receipts and bills to QuickBooks Online.
On the other hand, if you're looking to upload your bill using an Excel file. This functionality is currently unavailable in QBO. You'll want to consider visiting our app market or head to the Apps menu within your QuickBooks company to search for an importer tool. Note that the third-party provider will be the one to provide you with the template to use.
For more details on how to track your expenses, check out this link: Record bills and record the payments.
In addition, Learn how to run basic reports in QuickBooks. Check this article: Run reports in QuickBooks Online.
Feel free to reach out if you need any additional assistance or guidance regarding your bill when uploading with templates. I will be here to answer you. Keep Safe!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
Do you need to import like this one?
| RefNumber | APAccount | Vendor | PrintOnCheckName | TxnDate | DueDate | SalesTerm | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Office Supplies | For Anne | 25.1 | ||||||||||||||||||||
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | Telephone | Phone Cards | 50.25 | ||||||||||||||||||||
| 101 | Staples | ######### | 15/11/2020 | 100 Houston Street | Suite 2000 | San Diego | CA | 12345 | Internal Use | MP3 Player | Blue MP3 Player | 2 | 55 | |||||||||||||||||||
| 185 | Green's Taxi Service | ######### | Net 30 | 1 Main Street | San Diego | CA | 12345 | Transportation | 125.13 |
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
I'm looking to upload a bill on a monthly basis. So the QBO is already setup and we have all of our historical data already uploaded. But we have a sister company that sends us a bill every month for time worked on projects. We detail out the product/service and customer under the item details for each month. I was looking for an easy way to upload that information instead of having to hand key it. The bills are usually 20 plus lines long and hand keying gets tedious.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Other questions
The ability to upload bills every month without manual entry would be great, Sflesher.
QuickBooks Online has a feature that allows you to upload documents of bills. This feature helps extract information from the bill and creates transactions for you to review.
- In your QBO Online account, go to Expenses.
- Select Bills.
- From the Add bill dropdown, select Upload from the computer.
- Drag and drop files into the Upload or select the Upload button to choose files on your computer.
If the bill is the same every month, you can create a recurring bill by following these steps:
- Go to Settings.
- In the Lists column, select Recurring transactions.
- Click New.
- Choose bill for the type of transaction you want to create, and then select OK. Enter a Template name.
- Select a Type: Scheduled, Reminder, or Unscheduled.
I've got a few articles for you that provide tips on managing bills in QBO:
- Enter and manage bills and bill payments.
- Automatically match QuickBooks Online product transactions.
Feel free to return here if you need more help with your bills. I'm always here to make sure you get the correct details about uploading data in QuickBooks.