Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have spent the last few weeks updating my balance sheet to correctly assign each balance to its respective business/location. I was nearly complete when all of a sudden, hundreds of balances "reset" back to an Unspecified business/location. This is incredibly frustrating since I've worked hard to clean this up over the last week.
The only thing I can think of that caused this is my integration with BNB Tally which parses out Airbnb payments into their respective categories, respectively. But that should only affect the clearing house account. It shouldn't affect credit cards, bank accounts, and more.
So what the heck QB?
Let me help you with assigning each balance to its respective business/location when running the Balance Sheet report, littletree1.
The transactions under not specified business/location are Accounts Receivable, Accounts Payable, or Payroll transactions might have amounts under “Not Specified” because their related transactions (Receive Payment, Pay Bills) can’t be split into different locations.
If this is caused by integrating BNB Tally which parses out Airbnb payments into their respective categories, we can manually divide the transaction based on location (if the related transactions need to be split into different locations). Just in case you are using the QuickBooks Online (QBO) Advance version, we can use the reclassify transactions tool to batch edit transactions. Here's how:
You can check out this article for more details: Reclassify or move multiple transactions in QuickBooks Online Accountant and Advanced. If you are not using the Advance version, we'll need to manually recategorized the transactions.
I've gathered a few articles for additional tips and details about reports and class:
I'm just one post away if you need further assistance with assigning each balance to its business/location. Do you need to customize or modify a report? Let me know and I'll lend a hand again.
So none of the transactions that were linked to BNBTally are A/R, A/P or Payroll. They do affect the Clearing Account by creating an invoice and respective Payment that matches the bank record.
But the changes are across credit cards and bank accounts, some of which are not even related. So I'm very confused.
Unfortunately, I do not have Advanced. Is there a way to reverse the changes and go back to a previous version?
Hello there, littletree1. I can see that you're having challenges with reclassifying your balance sheet in QuickBooks Online.
May I know if you've utilized the bank rule feature? If so, this could be the reason why some of your transactions are categorized as an unspecified category.
If this option is turned on, it will automatically categorize transactions for you. The three criteria that can be specified in a bank rule condition are the transaction date, the transaction amount, and the description of the transaction.
Follow these steps to verify or deactivate this function:
If you require assistance from our Customer Care Team, please ensure to reach out to them during our designated support hours to receive prompt assistance for your concern. You can find more detailed information in the provided article: QuickBooks Online Support.
You can also follow the steps below:
I'm also adding this page for additional help if you need to start fresh your QBO account. If you're a new customer, you can purge your data and start over. If you've used QuickBooks for a while, you need to create a new company. Please refer to this article: Delete your data and start over in QuickBooks Online.
We are still here if you need further guidance with managing your transactions. Ping me by adding a comment below.
Yes, I am slowly cleaning up my books and applying rules when applicable. But that doesn't solve my current issue.
I just finished re-allocating all of my balances to have all that work erased after a simple re-sync with BNBTally. I wish there was a previous version I could go back to before the sync
Hello there, littletree1. I appreciate your troubleshooting efforts to manage your balances. Allow me to share some details about your concern.
Please know that you'll need to manually update the changes in your financial records due to your integration with BNB Tally because the feature reverses the previous balances before the syncing of data is unavailable in QuickBooks.
You'll want to reach out to your accountant to help you with accurate recordkeeping of balances.
Additionally, you can also customize your reports to personalize their data and then memorize it to save the configuration settings.
I'm always here ready to lend a helping hand if you need further assistance with your transactions or balances. I can share the necessary information and references you nee. Have a good one.
Sounds good, thanks
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