Miss classified credit card payments resulting in strange negative balance, how to fix?

It's great to hear that you're paying attention to how your transactions are being recorded in QuickBooks Online, Justifun. I'd be happy to help you correct the credit card payment to ensure it's categorized correctly.

You're absolutely right. Credit card payments should be categorized as "Transfers".

Before we proceed, could you confirm if the credit card payment transaction that needs to be modified was downloaded through bank feeds?

If it was, I'll guide you through undoing the transaction so you can categorize it properly.

Here's how to do it:

1. Go to the Transactions menu, then select Bank Transactions.
2. Choose the bank or credit card account where the transaction was downloaded from.
3. Select the Categorized tab and find the transaction you want to change.
4. Click Undo from the Action column.

Once you've completed these steps, the credit card payment transactions will be back in the "For Review" tab, where you can categorize them correctly.

If these transactions were added manually, you can refer to this link on how to edit the transactions accordingly through your QuickBooks register: Find, review, and edit transactions in account registers in QuickBooks Online.

I also recommend consulting with your accountant to ensure the accuracy of your books.

Additionally, I'm also including these resources that will guide you in fixing the account balance discrepancy and running the reconciliation report:

• Fix issues at the end of a reconciliation in QuickBooks Online
• How do I view, print, or export a reconciliation report?

I'll be available on this thread whenever you need additional assistance managing your bank transactions or anything else. Please feel free to provide more details.

Thank you for your reply.

I believe most of them would have been added from automatic bank imports.

I had to manually upload some bank records because quickbooks failed to import some dates.

I "may" have had to add 2 or 3 manually at some point during reconciliation as well.

Is there an easy way to determine which ones i can or cannot fix via your suggested course of action?

Thank you for getting back here in the Community, Justifun. Your provided information is much appreciated. Let me join in this conversation to provide insights in addition to my colleague's response.

You mentioned that you both automatically downloaded and manually imported the bank transactions. With that, you'll need to review and exclude your duplicated bank transactions and compare them to your bank statement for reference. Once you're done, you can now proceed to categorizing your bank transactions. Let me walk you through the process.

Here's how:

1. Navigate to Transactions, then hit Bank transactions.
2. Select the account you want to categorize.
   
3. Go to the For review tab.
4. Click the transaction and tick the Record as transfer then  Add:
   1. Select Add if the suggested category is correct.
   2. Change the category by choosing one from the dropdown or adding a new one.

You can also reach out to your accountant for the accuracy of your financial records, especially when reconciling your account.

I hope this post finds you well, Justifun. Just reply below if you have other concerns regarding your transactions and other QuickBooks tasks. I'll be here to lend a hand at any time.