Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I use Location (renamed as "Property" in my QBO Settings) to manage a few rental properties. I get a clean P&L by property, but my Balance Sheet gets messed up, splitting my one shared bank account and one credit card into a bunch of different non-zero values for each Property. I'm really not trying to track bank account and credit card per-property, only the loans, escrow balances, etc.
My workaround is to use a Journal Entry to zero it out annually (although I'd prefer better balance sheet accuracy than just annually). The Journal Entry credits and debits the same account but with different Locations set on each line item. I have to manually scour the balance sheet to determine the right amounts to transfer between Locations in order to zero things out. (Perhaps if QBO had a way to exclude an account from Location/Property tracking then these adjustments wouldn't be necessary.)
Alternatively, I could use Classes for per-property accounting. If I do, every transaction line item can be set with a class, but it's also more tedious because every single line item must be set with a class individually. But by doing this, I can make sure the bank account/credit card side of the transaction never gets the property class assigned.
Are there better options?
Hello there, @Blueridge Bookie.
Currently, we can only assign a class to every transaction line item in QuickBooks Online (QBO). I understand how important having this feature working for you and your business. With that, I suggest sending feedback to our developer team. This way, they can do this in future updates.
Here's how:
As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.
Let me know about all of your QuickBooks needs. I'm always happy to help. Have a good one.
What feedback are you suggesting I send?
Classes only apply to line items and not to the transaction header, so this page on Run a balance sheet by class or location indicates that balance sheet by class won't be accurate.
What are you suggesting I submit as feedback?
Balance Sheet by Class has problems and won't be accurate, at least according to the page Run a balance sheet by class or location:
You can’t filter your balance sheet by class since headers aren’t linked to classes. However, you can filter your profit and loss by class since details are linked to classes.
You can, but it wouldn’t be accurate. The headers (example: Accounts Receivable, Accounts Payable) aren’t sorted by the class you assigned them to—they’re under “Not Specified”.
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