Skip to main content
April 30, 2021
Question

credit card reconciliations

  • April 30, 2021
  • 1 reply
  • 0 views

I thought it would make my life easier and I had my client connect all of her personal credit cards that she uses for business so I can reconcile them. Unfortunately it seems like some of the items didn't come through when she linked them and she made some payments out of her personal account. Also some came through as opening equity. How can I fix this? Can I enter the transactions that didn't come through? How can I enter the payments without affecting the business account. I have a mess here...

1 reply

May 2, 2021

Thanks for reaching out to the Community, teg13. I'm here to lend a hand.

 

Yes, you can manually upload your bank transactions to your QuickBooks account. You can go to your bank's website and follow the instructions on how to download them. I've listed our supported file formats below:

  • Comma-Separated Values (CSV)
  • QuickBooks Online (QBO)
  • Quicken (QFX)

Here are the steps in uploading the file:

 

  1. Select Banking from the sidebar menu, then click the Banking tab.
  2. Hit the Upload transactions button.
  3. Click Browse, then choose the file you downloaded from your bank.
  4. Select the account you want to upload the transactions into from the QuickBooks account ▼ drop-down menu, then select Next
  5. Follow the on-screen instructions, then click Next.
  6. When you’re ready, hit Let's go.

Concerning payment, are you trying to pay your business expenses with personal funds? If so, here's how:

 

  1. Select + New.
  2. Select Journal entry.
  3. On the first line, select the expense account for the purchase.
  4. Enter the purchase amount in the Debits column.
  5. On the second line, select Partner's equity or Owner's equity.
  6. Enter the same purchase amount in the Credits column.
  7. Select Save and close.

For more details, you can check this article: Pay for business expenses with personal funds.

 

I've also got you these links for additional reference and guide for future tasks:

 

Lastly, I recommend seeking expert advice from an accountant to ensure your books will be accurate. They can guide you on how to handle transactions and record them correctly in QBO.

 

You can always get back to us if you need more help. We're here to assist.