Skip to main content
August 7, 2023
Question

Credit Card Purchases & Reconciliation

  • August 7, 2023
  • 1 reply
  • 0 views

How does the credit card reconciliation process work within QB desktop? Currently, we accumulate receipts in a folder for the month by the employee and reconcile each line item against the AmEx credit card statement after the month closes. Then import each of those line items into QB all under "American Express" as a Vendor and pay via ACH. It's a very time-consuming and manual process. I'm wondering if it would be more efficient to utilize the credit card functions within QB to record each transaction as we go. Any advice here or demo/examples would be much appreciated.

1 reply

August 7, 2023

Hello there, @Cwright9. I'd be glad to share some information about how the reconciliation process works in QuickBooks Desktop. 

 

In QuickBooks Desktop, you can streamline the credit card reconciliation process by utilizing the credit card functions within the software. This will allow you to record each transaction as you go, making the reconciliation process more efficient. 

 

Here are the few things that you need to set up before you can manually record your credit card transactions in QuickBooks Desktop: 

 

  • Set up the credit card account: Go to the Chart of Accounts and create a new account for your credit card. Make sure to select the appropriate account type, such as Credit Card.
  • Enter credit card charges: As you make purchases using the credit card, enter each transaction into QuickBooks Desktop. 

 

When everything is set up, you're now ready to use it for reconciliations to make sure the amounts match your real-life bank and credit card statements. QuickBooks will display a list of transactions that have been entered into the software. You now have the ability to match each transaction on the statement with the corresponding transaction in QuickBooks. If the transactions match, mark them as cleared. If there are any discrepancies, investigate and make any necessary adjustments. If everything matches. you know your accounts are balanced and accurate. 

 

I'd be glad to provide you with this article that'll help you learn the reconcile workflow in QuickBooks: Learn the reconcile workflow in QuickBooks.

 

By following these steps, you can record credit card transactions in real time and reconcile them more efficiently within QuickBooks Desktop. This will eliminate the need for double effort and streamline the overall process.

 

Alternatively, we also have the Bank Feeds section in QuickBooks Desktop where you can connect your American Express account. This allows you to automatically import transactions from your credit card statement into QuickBooks. You can then review and categorize the expenses directly within QuickBooks, saving time on manual data entry. Should you want to learn how to set this up, read through this article: Set up or edit bank accounts for Bank Feeds in QuickBooks Desktop.

 

It's great to hear that you're considering QuickBooks Desktop to manage your credit card transactions. Please know that we're here to help you every step of the way. If you have any additional questions or need further assistance, please don't hesitate to hit the Reply button. Our dedicated team is ready to provide the support you need to ensure your credit card transaction management experience is seamless. Keep safe.