Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
@keaton wrote:
I perform large monthly transactions to investors. These transactions show up in banking as one lump sum as the funds go through a clearing house first and then to the investors. To speed up the bookkeeping, I copy and paste the list of transactions from our clearing house software into a .csv and upload to quickbooks. Then when the large transaction shows up, it is matched to the bills and very easily sorted and cleared. Because I have to keep separate financial statements for each investor, each investor is setup as a class. I have to go back into the bills and add the classes manually. Can it be made possible to upload the classes as well to make this process super smooth and scalable?
Unfortunately, there is no way to import a CSV file with class tracking into QBO Banking tab. You may have noticed there is no mapping field for class or location. It's all Intuit hard-wired and there is no way to customize and expand the fields at this time.
The only option I can think of is to create Bank Rules (Banking > Rules) with Payee, Category, and Class for Money Out transactions. When you import a CSV file, it will match and automatically post to the Register. Make sure to select "Auto-categorise and auto-add at the bottom of the rule.
Hope this helps!
It would be much appreciated if Quickbooks allow for the upload of information to include class. I upload vendor bills with many transactions, and we track all our expense by class. That I upload, and then have to manually go into the transaction to add classes defeats the purpose of upload functionality.
Hi CADUser2023,
Welcome to the Community. It's important to correctly upload your vendor bills to ensure that your books are up to date. Quickbooks Online is great program that gives you the ability to easily track your invoices and expenses. I'd be glad to provide you with information on the possibility of uploading vendor bills with classes.
At this moment, the system only offers the option to manually add classes after manually uploading bills.
If you'd like to include the option to manually upload bills with their classes, I recommend that you send us Feedback by clicking on the Gear icon at the top. This is sent to our Development Team to consider for future updates.
Let me know if you have questions, I'll be happy to help.
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 |
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