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

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

 
41 Comments 41
john-pero
Community Champion

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Class assignment is to the detail items in the check, not the bank acvount. Once you turn on Class Tracking the class column will be visible for all line items in checks, sales, invoices, journal entries. Only receipts and invoices allow, at least in desktop, setting the class once for the entire transaction. If the class column is not visible when creating checks then you have not turned the feature, which is only available in Plus,  on yet

csp art
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

the class field  has been removed from  2019 Quickbooks unless you buy plus?

ShiellaGraceA
QuickBooks Team

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hello csp art,


The Class Tracking feature is only available in the Plus and Advanced versions of QuickBooks Online. You can upgrade your subscription so you can use it.

 

Here's how you can upgrade:

  1.  Click Gear and then click Account and Settings.
  2. Click Billing & Subscription.
  3. In the QuickBooks Online section, select Upgrade.
  4. Choose the plan you want, and select Upgrade.
  5. Confirm your payment information and click Save.

You can also visit our website for more information:

You might also want to check our page for tips and recommendations of your future tasks: Income and expenses.

 

Feel free to swing by anytime if you need help with anything else.

ELIVI
Level 2

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

I have the Plus version of QB online.  I have turned on the class function.  I'm able to assign a class to the line of the transaction.  The problem is the balance sheet side is not being assigned a class.  I'm trying to maintain a balance sheet by class.  Is there a way to assign a class to the cash or balance sheet side of the transaction?  (I've had the same issue with A/P and bill payments).

Mark_R
Moderator

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hi there, @ELIVI.

 

Currently, we can only assign classes to Accounts Payable (A/P) by creating a check or an expense transaction, while the bill payments dont.

 

Also, please know that there isn't a specific Balance Sheet report that's showing by class.

 

Here's how you can assign classes to your Accounts Payable (A/P) transactions:

 

  1. Click the + New button, then select Expense or Check.
  2. Choose the payee from the drop-down and the bank account in the Payment account drop-down.
  3. In the Category column, select the Accounts Payable (A/P) account from the drop-down.
  4. Enter the necessary information, then amount.
  5. From the Class drop-down, select which class you want to assign the transaction.
  6. Click Save and close.

Once done, you can now run the Balance Sheet Detail report to see the assigned classes to your A/P transactions.

 

You might want to check out these articles to learn more about class tracking and what specific reports you can run:

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day.

ChrisMeyer
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hi, i can assign a class at the line item level but not the header level. Subsequently my expenses are all tracked by class but not my Checking Balance. How do i enable that class is also tracked for the checking account? 

Rasa-LilaM
QuickBooks Team

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Allow me to chime in and provide some information about the Class feature, ChrisMeyer.


As mentioned by @john-pero, the class assignment is to the detail items in the check. Aside from that, you can also add it to the expense or bill per line item.class12.png The Class feature is a separate field on the sales transactions. However, setting it up to use on bank accounts is unavailable this time. You can consider tracking it manually to get deeper insights into your sales, expenses, or profitability for the account.


Check out the Track your transactions by class guide for future reference. It outlines the complete steps on how to organize your customer and vendor transactions using the feature. Additionally, the Get started with class tracking in QuickBooks Online article provides detailed instructions from the setup process up to creating a budget for each segment.


Feel free to visit the Community if you have questions about QuickBooks. I’m here ready to answer them for you. Enjoy the rest of the day.

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

I am having the same issue as above - I need a way to track restricted funds, at a glance, without diving into the detail.

 

I went through all the work of creating classes, I can run the Statement of Financial Position, but unless I make manual journal entries, none of the bills I pay reduce the correct column - they all end up in uncategorized.

 

If I make a payment against a restricted account, I need it to reduce the restricted amount, and I need to be able to report the current balances to the board.

Is there a way to accomplish this with Quickbooks Online?

Catherine_B
QuickBooks Team

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hello there, ChelleMtoo.

 

I'd like to verify further details about the restricted account you are using so I can sort things out with you. If there are changes made to a transaction, it doesn't affect related transactions. You'll need to open each transaction and assign the class from there. Then, you can run and refers to the report to see updates. 


Aside from that, the posting account affected on the bill is Accounts Payable and it affects the bank account used once its paid and the Accounts Payable account. I'd suggest reaching out to an accountant to help you identify the accounts to be affected when creating a journal entry just not to mess up your books. 

 

You can look into these articles that will help manage your classes and customize reports:

Any additional information about the accounts you used is much appreciated. I'm just around to help you with it. You take care and have a great day!

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

I attached a screenshot to explain what I'm trying to do.

 

Each transaction has a class.  I enter a bill (and assign a class) but when I PAY the bill out of the checking account, I can't find a way to assign the change of money to a class, so it shows as "uncategorized" on the Statement of Financial Position (what would be the Balance Sheet in for-profit organizations).

 

How do I ensure that the bill payment correctly gets assigned to a class to avoid it ending up in uncategorized on the cash account?  It's sales, bill payment, basically EVERY transaction ends up in uncategorized no matter what class the individual transactions are assigned to.

katherinejoyceO
QuickBooks Team

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Thanks for coming back for more support, @ChelleMtoo. Let me chime in and add more insights about what you're trying to achieve today. 

 

As mentioned by my peer @Mark_R, QuickBooks only supports assigning classes to Accounts Payable (A/P) by creating a check or an expense transaction. This is why you're unable to assign the bill payment to a class. 

 

Moreover, QuickBooks doesn't have a specific Balance Sheet report that's showing by class.

 

Should you need to assign classes to your Accounts Payable (A/P) transactions instead, you may follow the steps he outlined above. 

 

For future reference, read through these articles:

 

 

Feel free to message again if you have additional questions. We're always delighted to help. 

 

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Thanks for your response.

 

The balance sheet DOES have the option for classes, it just doesn't report it correctly.

What I need to be able to report to my board is how much of our cash or other assets is restricted to a specific use, and how much is available for general use.  The only thing that comes close is using classes, as far as I can tell, but I'd certainly be open to any other suggestions?

 

If Quickbooks doesn't offer classes on the balance sheet, how can I track and report restricted balances?

 

Thanks.

RenjolynC
QuickBooks Team

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Thanks for getting back here, ChelleMtoo.

 

I have an idea what's going on with the Balance Sheet report. Every transaction is separated into two sections: the header and the detail.

 

The Balance Sheet report only uses the data from the headers, but classes are linked to the details section of a transaction. This is why your transactions are under Not Specified.

 

Instead of using the classes on your checks, you'll want to use the Location tracking option to filter the balance sheet report. Please make sure to enable the option by following these steps:

 

  1. Go to the Gear > Account and settings.
  2. On the left panel, click Advanced.
  3. Scroll down to the Categories section, put a check mark on the Location box.
  4. Click Save and then Done.

Here's a sample screenshot for reference: 

 

 

Once done, open the check you want to add a location by following these steps:

 

  1. On the left panel, click Expenses
  2. Find and open the check from the Expenses tab.
  3. Add a location from the header section.
  4. Click Save and close.

Finally, run the Balance Sheet report by following these steps:

 

  1. Go to Reports on the left panel.
  2. Click the Balance Sheet report under Business overview.
  3. Select the Report period, and from the Display columns by drop-down menu, choose Locations.
  4. Click Run report.

Here's a sample screenshot of what the report looks like:

 

 

I'm also adding this article for more information: Run a balance sheet by class or location.

 

Please let me know in the comments if you need anything else, or if you have other concerns for QuickBooks. I'll be around to help you some more.

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

This is great - I feel like I'm 90% there - but while I can assign a location to checks, I can't find where I can assign a location for paying bills?

 

The bill itself has a location, but again, header/detail being what it is, it's not flowing through to the balance sheet.  

 

How can I assign a location when I'm paying a bill, not just writing a check?  Is there something I can turn on in that screen? Looks like the same situation for receiving payments against open rec'bles.

 

Any more advice?

Thanks so much,

Michelle

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

This is great - I feel like I'm 90% there - but while I can assign a location to checks, I can't find where I can assign a location for paying bills?

 

The bill itself has a location, but again, header/detail being what it is, it's not flowing through to the balance sheet.  

 

How can I assign a location when I'm paying a bill, not just writing a check?  Is there something I can turn on in that screen? Looks like the same situation for receiving payments against open rec'bles.

 

Any more advice?

Thanks so much,

Michelle

MJoy_D
Moderator

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Let me provide some information about adding a location with your transactions, @ChelleMtoo.

 

The location feature in QuicBooks Online (QBO) can only be added to estimates, invoices, expenses, checks and bills. You can't set a location when paying bills or receiving payment.

 

The location that you set for that bill will be carried over when you process bill payment. 

 

Let me help you in customizing the Balance Sheet Report to display the location:

 

  1. Go to the Reports menu and select the Balance Sheet Detail Report.
  2. Set the Accounting method to Cash.
  3. Click the Customize button and expand the Rows/Columns section.
  4. Make sure to put a checkmark on the Location tick box. 
  5. Click Run Report

Also, make sure to add a location on all of your transactions to show the Location column.

 

To learn more about how QuickBooks handles location tracking and generating related-financial reports. Check these articles:

I'm always here if you have any other concerns about your transactions. Keep safe and have a wonderful day!

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hi again - 

 

We're set up as a non-profit, so it's the Statement of Financial Position, but I assume the rest would be the same.

 

I've done as you say, however, even though I put the location in the original bill, the payment is coming up uncategorized on this report.

 

I'm attaching screen grabs so you can see.  The only things left in my "uncategorized" are paid bills, which are all entered to the location (division in this case).

 

Please advise?  I'm not sure where I'm going wrong.

 

Thanks,

Michelle

 

Well, it will only let me do one file at a time.  So I mushed them together best I could.  The bill itself has a location (division) but it's still not specified on my balance sheet.

KlentB
Moderator

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

 

You're on the right track, Michelle.

 

As mentioned above, the location that you set for the bill will be automatically added to the bill payment.

 

Since you've already assigned locations (divisions) to your bills, we'll just have to retrigger the payment to apply the changes that you've made. I'll show you how:

 

  1. Select Reports from the sidebar menu, then choose Statement of Financial Position from the Business Overview section.
  2. Click the Customize button. 
  3. Set the appropriate Report period and Accounting method
  4. Go to Filters, then select the desired location from the Location drop-down menu.
  5. Hit Run Report, then select the amount to open the Transaction Report.
  6. Select the Gear or Gog icon, then add the Location column.
  7. Choose Location from the Group by drop-down menu, then click the bill payment to open it.
  8. Uncheck the bill, then add it again.
  9. Click Save and close to complete the process.

Once done, all the payments in the Total for Not Specified section will be categorized into the appropriate locations (see below).

 

location_tracking_balance_sheet.PNG

 

You'll want to consider memorizing this report to save its current customization settings.

 

Additionally, I encourage running these popular custom reports in QuickBooks Online to get awesome insights about your business.

 

If I can be of any additional assistance, please don't hesitate to insert a comment below. Stay safe and have a pleasant day ahead.

Seabiscuit
Level 3

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Are there any plans to add classes to bill payments and payments received (and any other transaction that omits it right now)? This is a huge problem when we need to run balancing financials by class and its kind of weird that a double entry accounting system would not allow this for all transactions.

john-pero
Community Champion

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.


@Seabiscuit wrote:

Are there any plans to add classes to bill payments and payments received (and any other transaction that omits it right now)? This is a huge problem when we need to run balancing financials by class and its kind of weird that a double entry accounting system would not allow this for all transactions.


You already would have entered the Class in the Bill or Invoice.  Bill Payment and Receive Payment are simply movement of money.  The thing is a bill payment can cover such a wide array of transactions and bills that a single class assignment would rarely be correct.  Each line in a bill and for invoices, an entire invoice (in desktop for certain) can have one class assigned to the entire invoice or you can add a class to each line item.

 

BTW Class is an extra tag, an add-on, and not something recognized as a required or normal part of double=entry bookkeeping

Seabiscuit
Level 3

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Yes, I understand that its not technically an accounting function but it would make sense to allow the ability to assign this tag to both sides of a transactions so that every transaction within a class has an offset. How else would one run a balancing set of financials? (assuming that the accountant was careful to input the same class to each side). Now if I run a balance sheet, it doesn't pick up all transactions in the class because 1/2 of some are not being picked up...

Seabiscuit
Level 3

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

A great example is a deposit. You cannot choose the class on the cash side so, when a balance sheet is run by class, deposits are not included in the cash balance, thus causing the statement to not balance. This is a problem that I am surprised has not been addressed.

ChelleMtoo
Level 1

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

Hello - sorry for the delay in response.

 

This trick works for bill payment now, although I'm not sure why I have to reflash them constantly.

 

But it's not working for deposits.

 

When I book a sale to "undeposited funds" so that I can add them to one deposit, the location is still not flowing through.  I've tried unchecking and rechecking, but it's not helping.

 

Can you help?  I'm so close to being able to do this without a bunch of GJ entries to reclass things.

 

Thanks!

Fiat Lux - ASIA
Level 15

Is there a way to assign a class when writing a check? I can't see how to assign a class to the bank account part of the transaction. It is showing up as Not Specified.

@Seabiscuit 

We may utilize an importer tool to define the Class

https:// transactionpro.grsm.io/qbo

 

Prepare the Deposits data with the following template

RefNumberTxnDatePrivateNoteCurrencyExchangeRateDepositToAccountLocationEntityLineDescLineAmountAccountPaymentMethodPaymentRefNumberClassCashBackAccountCashBackAmountCashBackMemo
112/12/2020 USD Checking RobertDeposit 10Account1Cash     
112/12/2020 USD Checking RobertDeposit 20Account1Check12345    
112/12/2020 USD Checking RobertDeposit 30Account1Cash     
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us