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

Fastest way to cost code expenses?

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!

4 Comments 4
Giovann_G
Moderator

Fastest way to cost code expenses?

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.

 

  1. Click the Banking menu, then select Bank Feeds.
  2. Choose Bank Feeds Center.
  3. Hit Rules in Bank Feeds window.
  4. In the Rules List window, click the Manage Rules dropdown then choose Add New.
  5. In Add Rules Details window, provide a Rule Name.
  6. From the Description dropdown, make a selection and in the Description field, type a word or phrase you want to use as the condition for the rule. If you want to create more conditions, select + button
  7. In the Do This section, make the appropriate selection from the dropdown, and depending on your selection, enter the Payee name or the Account name.
  8. Select Save.

 

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.

Dominick2
Level 1

Fastest way to cost code expenses?

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. 

jamespaul
Moderator

Fastest way to cost code expenses?

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. 

SuperiorGCAZ
Level 3

Fastest way to cost code expenses?

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us