Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello @bcheng-ajfmanage.
When importing bills in QuickBooks Online, the CSV file must contain all our mandatory fields (marked as *). See this:
Being able to specify or map classes is a great option to add to the import process. However, the import template doesn't count the class field as one of its mandatory field. As a workaround, you can look for third-party bill importing tool from our app center to be able to do what you want.
Check this link and look for apps that matches your search: https://quickbooks.intuit.com/app/apps/home
I'm also adding some related links about the bills and the local bill import option within QuickBooks Online:
I'm always here if there's anything else you need with QuickBooks import and bills. Just mention me on your replies and posts. Have a nice weekend.
Prepare your Bills data with the following template
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 |
then utilize an importer tool
https://transactionpro.grsm.io/qbo
Utilize the trial version of a backup restore app before importing the Bills data if required.
https://rewindio.grsm.io/quickbooks
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here