How do I How can I correct the category rent was charged to for one month only?

lcaiazzo8866 · ‎March 16, 2025

Anonymous · ‎March 16, 2025

Hello there, @lcaiazzo8866.Let's get this done so you can start recategorizing your transactions to the correct account in QuickBooks Online (QBO).

Before we begin, are you referring to recategorizing transactions from your bank account? If so, we can uncategorize this entry from the Transactions tab and place it in the appropriate category. Here's how:

Go to the Transactions menu and navigate to the Bank Transactions tab.
Tap the bank tile where you have categorized these entries.
Click the Categorized tab and select Undo under the Action column. The Categorized tab is where transactions are placed immediately after you've categorized them into a different category.

If you're referring to transactions that were manually added to your chart of accounts, we can follow these steps:

Go to the Gear icon and select Chart of Accounts (COA).
Locate the account where the rent has been added.
Under the Action column, click the View register dropdown.
Find the specific month’s rent transaction and open it.
Tap the transaction and change the category in the Account section.
Click Save.

Additionally, you can refer to this article for further guidelines on categorizing your account to enhance your financial management: Categorize online bank transactions in QuickBooks Online. Then, start reconciling your account to avoid any discrepancies in your books.

I'm always available and ready to assist with banking concerns, @lcaiazzo8866. Just click the Reply button to ask them here. Have a great day!

lcaiazzo8866 · ‎March 16, 2025

Neither one of these works. I am the new Bookkeeper. The old one entered everything. I had to run a profit and loss report for the company and noticed the rent discrepancies On November and December of 2024 and January of 2025. I was able to correct November and January. I have tried everything! Am I missing something here?

lcaiazzo8866 · ‎March 16, 2025

The two categories are 7101 which was pre established by QuickBooks and 7100, which I think they created. The old bookkeeper used 7100 for three months, November and December of 2024 and January of 2025. I was able to correct November and January on the New Expense Page. I entered the Vendor name and it pulled up both November and January. I was able to edit both from there. December did not come up so I was unable to make the change.

Is there a way to view all transactions or run a report? A way to view all transactions in a category?

I also need to view Sales tax transactions 2450, to get totals for the quarter to pay to the state what is due.

Please advise

SheandL · ‎March 16, 2025

Thanks for the additional information, @lcaiazzo8866. To locate transactions in a specific category, navigate to the Expense page and use the Category filter, as QuickBooks doesn't offer a specific report for this. Also, for a detailed analysis of all sales tax-related transactions, consider running the Sales Tax Liability report. I'm here to assist and provide you with step-by-step guidance throughout this process.

Currently, QuickBooks doesn't have a direct report where you can specifically filter a category. With that in mind, we can navigate to the Expense page and filter it. To do so, here's how:

Open your QuickBooks account.
On your left navigation panel, go to Expenses, then select Expenses.
Once there, click the Filter button.
Ensure to filter the correct Status, Delivery method, Date, Payee, and Category.
After that, click Apply.
Find that transaction and in the Category column, click the dropdown and find the correct category to reclassify them.

For reference, please refer to the screenshot below:

Alternatively, you can also pull up the Transaction Detail by Account report as this provides a detailed insight into viewing your expenses by account. To do so, here's how:

Go to the Reports menu.
Type and select the Transaction Detail by Account report.
On the upper right part of your screen, click the Switch to classic view.
Once done, click the Customize button.
Set the Report period.
Go to the Filter section and choose the All Expenses Accounts option in the Distribution Account field.
Click Run report.

Here's a screenshot for reference:

Moreover, to view your sales tax transactions, you can generate the Sales Tax Liability report. It shows the detailed sales tax amount collected and owed to various tax authorities for a specific period. To run this report, please follow the steps below:

Go to the Reports menu.
Type and select the Sales Tax Liability report.
Customize the Report period and the Accounting method.
Click Run report.

For reference, please see this screenshot:

If those December entries are still unavailable after following the steps mentioned, you can consider creating a journal entry to correct the misclassified categories. In this process, I highly recommend contacting an accountant for professional guidance. To do so, here's how:

Open your QBO account.
Go to the + New button, then select Journal entry.
Start by choosing an account from the Account field on the first line. Depending on whether you need to debit or credit this account, input the amount in the appropriate column.
On the following line, select the other account involved in the transaction. If you debited or credited the first account, enter the same amount in the opposite column.
Verify the amounts to ensure that the Credit column on one line matches the Debit column on the other. This confirms that the accounts are balanced.
Once done, click Save and close.

Here's a screenshot for reference:

Additionally, here's an article that you can check for guidance if you need help in ensuring your bank and credit card statement match with each other: Reconcile an account in QuickBooks Online.

If you have any other questions or concerns about this matter, please feel free to post in this forum, lcaiazzo8866. We are always here to help.