Solved

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

Forum|Forum|7 years ago
December 11, 2018
7 replies
0 views

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!

QuickBooks Desktop

Best answer by qbteachmt

" 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.

qbteachmtAnswer

" 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.

A

arkvalleyinfoAuthor

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>

I

IntuitBrooks

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

Rustler

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

J

Jeff7

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.

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.
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.
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.
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.

N

netgreen

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!

S

SkinnyRaven

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

BizPro

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,

Sonya808

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

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

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.

Sign up

Login with SSO

Login to the community

Login with SSO