Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am a general contractor who is getting started with QuickBooks Desktop Premier Contractor Edition. I've gotten everything set up well enough so far, and am using items to track cost codes on jobs, subcontractor purchase orders, etc. However, what I am having trouble with is my expenses. Say I purchase a door on our credit card. I import the .QBO file from Chase and there is an option to code that expense to a job, but not to an item, it defaults to an expense instead. Is there any way to assign items to bulk imported transactions? The only way that I can see to assign items to expenses is doing it one at a time, which would take so much longer that I really don't even know if I have the time. Even if I could edit them quickly that may be faster, but I cannot figure out how to do that either. Thanks!
Thanks for posting in the Community, Dominick2.
Let me guide you to automatically be assigned items to your imported transactions.
The easiest way to speed up assigning or categorizing the transactions is by creating bank rules. This saves your time since you don't need to manually assign items on each transaction. I'll show you how.
Feel free to check this guide for your reference: Use renaming rules for Bank Feeds.
Also, please visit our Banking and bank feeds page. This contains helpful information to help you manage your bank transactions.
Click the Reply button if you have further questions about bank feeds. I'm always here to help you.
Hello, this lets me categorize it with an account or customer job, but not using an item from my item list, which is how costs are tracked beyond the expense account it is associated with. For example, I have an item for lumber, doors, concrete, etc. that are all under the "Construction Materials" account.
Hello, Dominick.
I'll clarify the details about the Bank Feeds feature and help you categorize and record your transactions.
QuickBooks Desktop's Online Banking feature deals with accounts and customer (or vendors), which is the entire transaction itself. That said, we're unable to use items on the Bank Feeds.
You can record the transactions manually in QuickBooks instead. Then, match them with the uploaded bank records to ensure your data in QuickBooks agrees with your bank statement.
You can create a bill or a check, depending on how the transaction happened in real life.
Simply click the Vendors menu, then select Enter Bills. Add the details of your transactions and ensure to add the items associated with your purchases. You'll also want to record the bill payment after recording it.
Or you can do it through checks by clicking the Banking menu, then selecting Write Checks.
After recording, start matching those transactions from the bank feeds. You don't have to select an account, you would just need to match them directly. You can check this article for the workflow guide: Add and match Bank Feed transactions in QuickBooks Desktop.
Since you also need to track the cost, you can run a report instead of relying on the bank feeds. Simply go to Reports, hover on Vendors & Payables (you can also hover on Purchases), then select a report.
You might want to check this article if you need help building a report to help you track your costs: Understand reports.
Need help getting started in QuickBooks Desktop? Our Help articles can definitely guide you and assist you in navigating around the program. You can learn the ropes from the general articles list page.
Happy to lend a hand again if you need more help familiarizing the basic functions in QuickBooks Desktop. Just add your reply here and I'll get back to you.
I have the same problem. Why does QB not allow the use of items in Bank feeds? This seems like a no brainer to use cost codes for a Construction Company! It is impractical to suggest importing all the credit card & ATM transactions into QB via Feeds or manually! then to go back into the register & manually update each & every transaction to the correct Item! News Flash! Companies use credit cards for everything! Get with the times.
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