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.

My boss, who is not a bookkeeper, originally set up his Apple credit card as bank (account type) and cash on hand (account type detail). I switched to credit card (type) and credit card (detail) and balance is all kinds of messed up. Any suggestions? Would I need to undo all of the charges and then re-record them again?

Thanks for getting involved with this thread, cjwood82.

To properly identify whether or not you need to undo all of your charges in an account and re-record them, I'd recommend working with an accounting professional. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

Here's how it works:
 

1. Go to our Find a ProAdvisor page.
2. Use the City or ZIP search field to specify a location.
3. Select Find a ProAdvisor.
4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.
   
   

Once you've found an accountant, they can be contacted through their Send a message form:
 

1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.
2. Enter your appropriate info in the Your name, Your email, and Your phone number (optional) fields.
3. Select Send message.

Another great service available through Intuit is QuickBooks Live Expert Assist. Our trained experts can help provide guidance on the best way to manage your books.

If you haven't yet, you can still review the steps shared by my colleagues above, but you'll ultimately want to confirm your best approach with an accounting professional.

I'll be here to help if there's any additional questions. Have an awesome Friday!