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

Fastest way to assign Classes to transactions in a Bank Account Register?

From researching these boards I have discovered that you indeed cannot assign classes in the Downloaded Transactions window. So now I want to know if I can easily assign Classes in the Register Window. Right now all I could figure out is double clicking on the transaction to open the sort of Check window for each transaction and go through each transaction. These are transactions from a credit card but I would also like to do this in the Register for our checking account. We produce events and I would love to assign a class to almost all of our transactions to track expenses per event (I create a new Class for every event). If it's this time consuming to go one by one, I don't see the point for a company doing jobs or events where you have to use Classes to job track to use QB for that purpose. Thanks for any input out there! 

Solved
Best answer December 10, 2018

Best Answers
qbteachmt
Level 15

Fastest way to assign Classes to transactions in a Bank Account Register?

" If it's this time consuming to go one by one, I don't see the point for a company doing jobs or events where you have to use Classes to job track to use QB for that purpose."


A lot of people think the Online Banking is a time-saver. First, that data brings in the Bank's processing date, not your date.

Second, the Online Banking tools are not as robust for details of data entry as the actual program tools.

Third, there is a lot being bypassed if you use Class only for these activities. Job Tracking and use Items gives you a lot more powerful reporting. For instance, Items offer you Qty. If it matters, that is how you can track # of ticket sales, # of meals purchased, etc.


For a NFP, Class would be Program or purposes, and Event would be subclass or Job names. It depends on the organization, of course.

View solution in original post

23 Comments 23
qbteachmt
Level 15

Fastest way to assign Classes to transactions in a Bank Account Register?

" If it's this time consuming to go one by one, I don't see the point for a company doing jobs or events where you have to use Classes to job track to use QB for that purpose."


A lot of people think the Online Banking is a time-saver. First, that data brings in the Bank's processing date, not your date.

Second, the Online Banking tools are not as robust for details of data entry as the actual program tools.

Third, there is a lot being bypassed if you use Class only for these activities. Job Tracking and use Items gives you a lot more powerful reporting. For instance, Items offer you Qty. If it matters, that is how you can track # of ticket sales, # of meals purchased, etc.


For a NFP, Class would be Program or purposes, and Event would be subclass or Job names. It depends on the organization, of course.

MontanaKarl
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

info,  I second what qbteachmt says above.    Classes allow you to view your data in broad strokes, but are not advisable for events...where over time you might have 100's of them.  Customers and Jobs (which can further be filtered by Customer type and Job type) are designed for tracking your events.

For non-profits (NFP), schools, etc., Classes can be used to manage fund accounting.

As qbteachmt says, take a look at the various report options and you'll see some of the benefits of classes vs customers:jobs.  For example, some reports can break out your data with Classes as the columns... and a grand total column on the right... but with customer:job groups and subtotals down the page.  So, just for an illustration supposing that you produce concerts... maybe the Classes would be Hip Hop, Drum and Bass, Classical, and Fundraiser ...  maybe you only use a handful of specific venues... then you might want Classes for each venue, with the customer:job reflecting what happens in the venue.

Anyway... take a look at some of these pages and videos on the QuickBooks for Mac "Little Square" site to see if they give you some good ideas for organizing your data:

<a href="http://www.qblittlesquare.com/2011/06/adding-some-class-use-classes-to-categorize-your-data/" rel="nofollow" target="_blank">http://www.qblittlesquare.com/2011/06/adding-some-class-use-classes-to-categorize-your-data/</a>

<a href="http://www.qblittlesquare.com/getting-paid/customers-and-jobs/" rel="nofollow" target="_blank">http://www.qblittlesquare.com/getting-paid/customers-and-jobs/</a>

<a href="http://www.qblittlesquare.com/2011/05/get-more-insight-with-customer-and-job-types/" rel="nofollow" target="_blank">http://www.qblittlesquare.com/2011/05/get-more-insight-with-customer-and-job-types/</a>
Teri
Level 9

Fastest way to assign Classes to transactions in a Bank Account Register?

I agree, Jobs would definitely work better for Events than Classes.
IntuitBrooks
Level 9

Fastest way to assign Classes to transactions in a Bank Account Register?

In the 2015 version of QuickBooks Mac you can enter class info with the downloaded banking data (in the Download Transaction Window).

Rustler
Level 15

Fastest way to assign Classes to transactions in a Bank Account Register?

in the bank register, click on the transaction then click the split button and assign the class (works in windows, should work in mac)

typically the work flow is
you enter transactions, at that time you select the class
then you match the download transaction to the transaction you entered

Jeff7
Level 2

Fastest way to assign Classes to transactions in a Bank Account Register?

Don't do this in the register window.  It will take forever.  The easiest way is to create a report by class that contains the transactions you're interested in.  A column will appear entitled "Unclassified," which presumably contains the all transactions you want to change.

  1. Double click the number within the account you want to change and a sub-report named "Transaction Detail by Account" will open with all, and only, the unclassified transactions you want.
  2. Double click the first transaction in this report and add the class you want in the box that opens (Deposit, Credit card, Check, etc.).  Highlight this class entry with your mouse and hit Ctrl-C to copy it.  Click save.
  3. Go back to the  "Transaction Detail by Account" report and notice the transaction you changed disappeared (since it's now categorized).  Double click the next transaction in this report and the box will open again.  Hit Ctrl-V in the class field in that box to paste the class.  Click Save.
  4. Repeat this last step until the ""Transaction Detail by Account" report is blank.

I regularly have to do this.  Once you get a rhythm going you can categorize 100 transactions in 5 minutes.  It shouldn't have to be this way but it's actually pretty fast.

I'm happy to read that QB 2015 for Mac added this feature to the Download Transaction Window.  Still won't help with splits, but it's a step forward.

netgreen
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

I've found that the above steps do work, although it is tedious!  Here are some keyboard shortcuts that I've found will speed up the process a little:
When you get to step 3 (you're back in the report with the list of transactions), if you press <Enter> the next transaction will open for you (without having to double-click on it). Click in the "Class" field and press <Ctrl-C> as noted above. Then press <Alt-A> to save the edited transaction, then press <Enter> to accept the changes.
Repeat for each remaining transaction.  This only requires you to do ONE mouse click per transaction (to choose the Class field) and you can do the rest of the steps via your keyboard!
qbteachmt
Level 15

Fastest way to assign Classes to transactions in a Bank Account Register?

This is a Mac topic. I think they have Command keys, not Ctl or Alt. There is a long list of keyboard shortcuts for QB for PC. You don't need to use the mouse for any of it, really, as long as you use the QB keyboard shortcuts and the Windows keyboard shortcuts. Alt A is a Windows "Alt" shortcut used with that letter, for a command where you see the letter A underlined. Ctl C is Windows Copy. etc.
IntuitBrooks
Level 9

Fastest way to assign Classes to transactions in a Bank Account Register?

On the Mac side, you can turn on more keyboard navigation using the Apple Keyboard system preference panel.  This can enable you to tab between buttons like you can do on MS Windows.  You can also assign any menu item in any application to a keyboard shortcut.
SkinnyRaven
Level 8

Fastest way to assign Classes to transactions in a Bank Account Register?

I wouldn't expect it to be any more time consuming than recording any other transaction.

Anonymous
Not applicable

Fastest way to assign Classes to transactions in a Bank Account Register?

Hello, @Connolly Contractors Inc.

 

Thanks for joining the thread. Allow me to chime in and help locate the class tracking box in QuickBooks Mac.

 

If you're referring to the class tracking on your forms, you'll need to set this up on the Transactions preferences first.

 

Here's how:

 

  1. Choose QuickBooks then Preferences.
  2. On the Preferences pane, select Transactions.
  3. Make sure to set the Use class tracking.
  4. When you're done, close the Preferences window.

Setting this up will include a Class field for all transactions. 

 

If you need some help articles in the future, please feel free to check our site: Help articles for QuickBooks Mac.

 

Let me know if you have other questions about managing classes in QuickBooks Mac. I'll be here to help however I can. Have a good one.

BizPro
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

Since you're working in Desktop, why not use Jobs for each new event? Its an easy way to track, you can assign billable items there and pull P&L's my Job to see profitability and all the details for each event.  Best regards,

ExcelReal
Level 2

Fastest way to assign Classes to transactions in a Bank Account Register?

I struggle with getting classes appropriately assigned as well  I own 13 rental properties, each of which are assigned a class.  Each is an individual income unit, and the repairs, utilities, etc. are crucial in reviewing each bottom line.  I'd appreciate knowing the step by step process to most efficiently attaching the class to each transaction (bookkeeping is not my field of expertise).  If it is slow and cumbersome, so be it.  But it is critical to my business.  Thanks!

BizPro
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

You may need to turn on Class Tracking and/or locations/and or Jobs/Projects. You'd find those settings in your Account and/or Company settings depending on which version you are using. Best of success with that.

 

M. Hunnewell

BizPro Financial

[removed]

Sonya808
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

Jan 6-2020.   Another way to do a class entry while working in a register:  Press <Alt+S> keys.  That opens the Edit Transaction window right away with the class column.  You are not alone.  Many of us have this same question.  Intuit support keeps telling us to check back for this feature, class column in the register, to be added.  I don't think that's going to happen any time soon.  It's been over a year since your query was posted. 

JasroV
QuickBooks Team

Fastest way to assign Classes to transactions in a Bank Account Register?

Hi there, @Sonya808.


I appreciate you for sharing a workaround on how to enter a class in the register. The workaround you've provided can help other users who want to add a class in their register.

 

Users like you who share their ideas in the Community is highly appreciated.

 

I'll submit this feature request on your behalf to our product engineers so they'll consider adding the class column in the future.

 

To know about the latest news and release in QuickBooks Desktop (QBDT), you can visit our Product Updates page for reference.

 

You'll also want to visit this article in fixing beginning balances issues in your QBDT.

 

You can get back to us if you need more help with classes in your QBDT. I'll be around to help.

Sonya808
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

Thank  you, JasroV, you're highly appreciated too. 

 

Here's another one for Desktop users:   if Quickbooks chart of accounts doesn't open account registers when you first use it after installation, it may be due to your mouse speed being too fast.   Just slow the mouse speed down in your settings.  The register window will open right up.

BizPro
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

Never have had that problem but if it comes up, for myself or a client user, I'll have the solution. Thank you!

BizPro
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

Hi there rental property owner,

 

From years of experience in income property investment accounting, I understand!

 

The first, simple answer is...when you enter (or modify) an expense, assign it right there and then, when you are in the entry! Even if it comes in from the Bank Fee and you are in QBO For Review.

Open the transaction, edit and assign.

 

For those renting their own properties and even the additional layer of those managing properties for others, we use the Customer/Client field for the Tenant details and use Projects/Jobs, under each tenant instead of Class. I used to use Class in the past for buildings in various locations but then abandoned that for Projects/Jobs...in both Desktop or QBO.

 

For posting to a vacant unit or for Capital Improvements, Create a parent/house account which is basically you. Under that account, you can enter your vacancies or improvements as Projects/Jobs and track your expenses there, giving you clear records.

 

When I have a vacant unit, I create a new Project/Job (using dates to differentiate vacancy period) and post/Job-cost all expenses to that vacant unit. Improvements: Just create a name for it like; 123 Main St / Driveway

 

These methods will provide you with a very clear picture in a P&L of your bottom line by Unit.

 

I was a commercial and multifamily property manager for many years and did the accounting.

With constant flow of turnovers, capital improvements, occupied unit repairs and maintenance, I know very well how important it is to Job Cost all expenses for each unit...even/especially when vacant!

 

Hope some of this is helpful. Let us know if you have additional questions.

~mh

Sonya808
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

You're welcome, BizPro.  I have a feeling your equipment is fast and great.  Mine is somewhat outdated and clunky, I hang onto it longer than I should.

charodie
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

This is crazy, we moved over from QBO and class management is MUCH easier in the online QB. I would love to be able to assign classes to a bank rule like I did in the online as well as to be able to see the class on the check register.

charodie
Level 3

Fastest way to assign Classes to transactions in a Bank Account Register?

PLEASE add the ability to make a bank rule based on what bank account the transaction posts to and add a class. 

So, if account is xyz, then assign to class ABC.

 

 

MaryAnn_E
QuickBooks Team

Fastest way to assign Classes to transactions in a Bank Account Register?

Hi @charodie,

 

At the moment, adding a class feature in a bank rule is unavailable. I’ll take note of this feedback and submit this to our product team. 

 

This way, they can review the request to consider this feature in the future updates of QuickBooks Desktop.

 

 

You can visit our banking and bank feeds in the QuickBooks Desktop page for your reference to check some tips on managing your bank feeds.

 

 

Also, you can visit our blog site to know new updates in QuickBooks.

 

 

If you have further questions about Bank Rules, please let me know. I'm here to help.

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

Need to get in touch?

Contact us